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
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.
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 agoThank you for reporting. At the moment the max length for the column 'author_ip' is 15 (IPv4) but IPv6 needs 39.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?
As quick fix;
in phpmyadmin use the SQL command
Code:
ALTER TABLE xxxx_jem_events MODIFY author_ip varchar(39);
And then check again.
The difference between JEM 2.3.5 and 2.3.6 is minimal, it is mainly the update information.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 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
Yep, that seems to work.
Thank you for releasing JEM 4.0.0!
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