TOPIC:

Upgrade from JEM4.0.0 to 4.1.0 failed.
Error message is "JInstaller：: install ：errorー SQL Incorrect datetime value: '%0000-00-00%' for column 'modified_time' at row 1 ".
Please make fix.
Joomla : 4.3.4
PHP : 8.1.20
Regards,

Hi taksejimo

did you try to update manually or by the Joomla update routine?

From the few information I guess the erro comes from the fact that in JEM 4.1 in the table PREFIX_jem_categories` the field modified_time is set to null if it was like %0000-00-00%

I did upgrade by the Joomla update routine.

Regards,

Hi,

the same at my site, when trying to update from joomla 3 to joomla 4.4 and afterwards upgrading jem from 2.3.6 to 4.1.0

In the database in jem_categories is at row 1 a catname "root" with a modified_time "0000-00-00 00:00:00".
The problem is still there, even if i delete this "root"-row. All other rows have a modified_time like "2023-10-18 15:21:22"

Sorry guys for the long waiting time - I'm also just a vlouteer here and sometimes things are growing over my head.

The problem is that the date entry '0000-00-00 00:00:00' is wrong. It should be NULL. Somehow the conversion did not work during the update.

To solve this issues you will have to touch the database with phpmyadmin or similar.

There find the table 'PREFIX_jem_categories'
Then find the field 'modified_time' - according to your error message its value is '0000-00-00 00:00:00'


Click in the field and select the checkbox 'NULL' (to apply the change make a mouse click outside of the date box)


I hope this solves the issue

Hi,

this doesn't work for me:


The error message: