Phoca Forum

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.

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

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

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

Jan

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

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

Jan

Hi,

is there any template database structure i can compare with?

Best regards

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

Thank you!