Category edit > Incorrect datetime value: '0000-00-00 00:00:00' for 'checked_out_time'

[ConceptBR]

Hello community,

Unfortunately, we have had a problem editing categories since upgrading from Joomla 3 to Joomla 4 in combination with Phoca Gallery 4. When trying to save a category an error message appears:
" ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 00:00:00' for column 'checked_out_time"

We have already adapted the MySQL database with regard to the “sqlmode” so that it accepts the 0000-00-00 values. However, Joomla 4 sends "STRICT_TRANS_TABLES" in the MySQLiDriver driver as SqlMode, which then leads to the error message described in combination with PhocaGallery.

In the meantime, we have commented out the "STRICT_TRANS_TABLES" mode from the Joomla MySQL driver and now editing the categories in Phoca Gallery works again. However, there is apparently still a need for a FIX in Phoca Gallery so that no 0000-00-00 values are tried to be set in the 'checked_out_time' column or in general.

Is the error described known?

Best regards

P.S Of course we use the latest version 4 of Phoca Gallery. Even a test update to Phoca Gallery 5 in combination with Joomla 4 did not bring any improvement.

[Jan]

Hi, did you migrate Phoca Gallery the right way, so all columns get new format:

https://www.phoca.cz/documentation/86-j ... o-joomla-4

Jan

[ConceptBR]

Hi Jan,

thank you for your response.
i imported the data (images and database) after the Joomla 4 upgrade. I also truncated the documented tables but i don't see any table structure migration in the guide?

Best regards

Jürgen

[Jan]

When you visit the Joomla administration - Extensions - Manage - Database - can you see there Phoca Cart so the system can update the database?

Jan

[ConceptBR]

Hi Jan,

no there are no problems and i also tried the "FIX"-Button before my first post here.

Shown Databaseversion of Phoca is 4.3.14

Best regards

[Jan]

Hi, then I think, you need to fix the column directly in the database by your needs

Jan

[ConceptBR]

Hi,

is there any template database structure i can compare with?

Best regards

[Jan]

Hi,

you can see in this file:
administrator/components/com_phocagallery/install/sql/mysql/install.utf8.sql
which structure is installed. Be aware, when e.g. column is created in database table by sql query, the query does not include default value set by database.
Jan

[ConceptBR]

Thank you!