Request to enhance database structure

[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

[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

[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 ?

[Jan]

Hi, yes, this works for new installations. When updating, this needs to be changed manually direclty in database.

Jan