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

[mhehm]

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

[ColinM]

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

Colin

[Arno]

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?

[mhehm]

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

[Arno]

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.