help to better help you:

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

Update 4.3.2 to 4.3.3 crashed

Re: Update 4.3.2 to 4.3.3 crashed

1 year 1 month ago
#32760
I'm sorry but your SQL scripts contain errors:

ALTER TABLE `yjm2s_jem_events`
ADD COLUMN `publish_up` datetime NOT NULL DEFAULT “0000-00-00 00:00:00” AFTER `modified`;

ALTER TABLE `yjm2s_jem_events`
ADD COLUMN `publish_down` datetime NOT NULL DEFAULT “0000-00-00 00:00:00” AFTER `publish_up`;
Correct Approach:
In my previous post, I outlined two steps in the following order:

First, execute the script located at:
administrator/components/com_jem/sql/updates/mysql/4.3.3.sql
(This is automatically run during JEM's update from v4.3.2 to v4.3.3.)

Second, manually run this query in phpMyAdmin:

UPDATE `xxxxx_jem_events` SET publish_up = created;
(Replace xxxxx with your Joomla database prefix.)

Why This Matters:
The 4.3.3.sql file contains multiple schema changes that must run before the UPDATE query.

The default value “0000-00-00 00:00:00” for DATETIME fields is invalid in modern MySQL/MariaDB and will cause errors. Use NULL instead.

Recommended Solutions:
Option 1: Clean Update from JEM 4.3.2
Restore a backup of JEM 4.3.2 in your Joomla 4.4.13 environment.

Enable maximum debug mode in Joomla (Global Configuration → System → Debug Settings).

Update to JEM 4.3.3 and monitor the installation logs for errors.

Option 2: Manually Apply Fixes
Re-run the 4.3.3.sql script line by line in phpMyAdmin:

Replace #__ with your database prefix (e.g., yjm2s_).

Change all “0000-00-00 00:00:00” defaults to NULL for DATETIME fields.

I hope that this explication helps you to resolve the issue.
At the end of the day, computing and technology, like Joomla and JEM are here to help the end user and make our lives a little easier. Help us to be better.

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

Time to create page: 0.587 seconds