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

3 weeks 6 days 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.

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

Time to create page: 3.303 seconds