Print Page - 1406 - Data too long for column 'log_ip' at row 1 with ip6 users on jdownloads 4.0.45

Title: 1406 - Data too long for column 'log_ip' at row 1 with ip6 users on jdownloads 4.0.45
Post by: mhehm on 14.10.2024 23:47:59

When downloading a file (any file) I get the above error.
The problem is solved by disabling "Activate log function for Downloads" (but that can not be a good solution ;) )
I Tried making the log_ip-field bigger (VARCHAR 250 instead of 50 just to be sure) and that also did the trick (might be a better solution) ...

This is a new Joomla! 5.1.4 installation with jDownloads Version 4.0.45 pre beta PHP version 8.2

Title: Re:cron and special char
Post by: ColinM on 15.10.2024 11:10:23

Hi
Tanks for the input. I have added request to make as 256 characters.

Colin

Title: Re: 1406 - Data too long for column 'log_ip' at row 1 with ip6 users on jdownloads 4.0.45
Post by: Arno on 08.11.2024 18:23:34

Hi mhehm,
I would be interested to know what kind of data is to be stored in the field.
Could you take a look at the database?

Title: Re: 1406 - Data too long for column 'log_ip' at row 1 with ip6 users on jdownloads 4.0.45
Post by: mhehm on 08.11.2024 18:49:48

Hi, this is an example:
2a02:6b67:e621:d000:1c3e:a596:545e:e81, 2a02:6b67:e621:d000:1c3e:a596:545e:e81

another:
2a01:cb19:8a4d:a600:656c:459e:85ec:b944, 2a01:cb19:8a4d:a600:656c:459e:85ec:b944

Title: Re: 1406 - Data too long for column 'log_ip' at row 1 on jdownloads 4.0.45 - [Fixed in 4.0.46]
Post by: Arno on 08.11.2024 19:38:05

Thanks for the fast example. ;)

There seems to be an error somewhere. This is because an attempt is being made to save the IP (IPv6) twice.

I therefore need to revise the IP query to prevent this. This will be included in the next update next week.

Thank you.

jDownloads Support Forum

jDownloads for Joomla 4.x and 5.x => jDownloads 4.0 => Bugs! => Topic started by: mhehm on 14.10.2024 23:47:59