Page 1 of 1

Request to enhance database structure

Posted: 11 Jun 2023, 12:15
by sirkai
Hi, I just enabled IP logging and found a bug when it tries to store the ip.
Errormessage: Data too long for column ‘ip’ at row 1

The table that stores the logs has a varchar(20) for the IP which is too short. I changed it to 50 and it now works.
That should be fixed with next update.

Regards, Kai

Re: Request to enhance database structure

Posted: 12 Jun 2023, 14:30
by Jan
Hi, which version of Phoca Download do you use? It has varchar(50) as default:

https://github.com/PhocaCz/PhocaDownloa ... 8.sql#L220

Jan

Re: Request to enhance database structure

Posted: 12 Jun 2023, 23:40
by sirkai
Using 4.0.6 here already. New install probably works. Maybe the update from 20 to 50 failed at some point in the past ?

Re: Request to enhance database structure

Posted: 13 Jun 2023, 12:22
by Jan
Hi, yes, this works for new installations. When updating, this needs to be changed manually direclty in database.

Jan