help to better help you:

Please: add always Joomla / JEM version and details to your posts, so we can try to reproduce your issue!

Error when saving an event

Error when saving an event

1 year 8 months ago - 1 year 8 months ago
#30537
When saving an event that I'm adding or editing I get an error "Save failed with the following error: Data too long for column 'author_ip' at row 1". The error goes away when I disable IPv6. Is there check placed on this column that only accommodates IPv4 numbers?

This is JEM 4.0.0 on Joomla 4.3.2./PHP 8.0. The upgrade to Joomla4 was done in February 2023, way before 2.3.6 was released. Therefore the upgrade to JEM 4.0.0 was done starting from JEM 2.3.5.
Last edit: 1 year 8 months ago by rpbikker.

Please Log in or Create an account to join the conversation.

Re: Error when saving an event

1 year 8 months ago
#30538
When saving an event that I'm adding or editing I get an error "Save failed with the following error: Data too long for column 'author_ip' at row 1". The error goes away when I disable IPv6. Is there check placed on this column that only accommodates IPv4 numbers?
Thank you for reporting. At the moment the max length for the column 'author_ip' is 15 (IPv4) but IPv6 needs 39.

As quick fix;
in phpmyadmin use the SQL command
Code:
ALTER TABLE xxxx_jem_events MODIFY author_ip varchar(39);
with "xxxx" being your DB prefix.
And then check again.
This is JEM 4.0.0 on Joomla 4.3.2./PHP 8.0. The upgrade to Joomla4 was done in February 2023, way before 2.3.6 was released. Therefore the upgrade to JEM 4.0.0 was done starting from JEM 2.3.5.
The difference between JEM 2.3.5 and 2.3.6 is minimal, it is mainly the update information.
The following user(s) said Thank You: rpbikker

Please Log in or Create an account to join the conversation.

Re: Error when saving an event

1 year 8 months ago - 1 year 8 months ago
#30539
Yep, that seems to work.

Thank you for releasing JEM 4.0.0!
Last edit: 1 year 8 months ago by rpbikker.

Please Log in or Create an account to join the conversation.

Time to create page: 0.611 seconds