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

4 months 2 hours ago
#32753
You need a space before SET, run this line:
UPDATE `yjm2s_jem_events` SET publish_up = created;
Do you see the events?
The following user(s) said Thank You: ketchup

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

Re: Update 4.3.2 to 4.3.3 crashed

4 months 1 hour ago
#32754
perhaps an other thing: when you import events in a new installed joomla with JEM, then it is possible, that the admin ID has changed. Then the frontend doesn't show events, because a new ID has perhaps not the rights. Please compare in backend the creator IDs.
The following user(s) said Thank You: ketchup

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

Re: Update 4.3.2 to 4.3.3 crashed

3 months 4 weeks ago
#32755
You need a space before SET, run this line:
UPDATE `yjm2s_jem_events` SET publish_up = created;
Do you see the events?

I have send the sql line again with the missing space, but I get the same error message. #1054 - Unbekanntes Tabellenfeld 'publish_up' in field list 
The fields "publish_up" and perhaps "publish_down" are missing.

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

Re: Update 4.3.2 to 4.3.3 crashed

3 months 4 weeks ago
#32756
Its very strange. I can't  publish a new event as administrator. I get Es ist ein Problem aufgetreten. Der Server lieferte ein "500 - Whoops, looks like something went wrong."

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

Re: Update 4.3.2 to 4.3.3 crashed

3 months 4 weeks ago
#32757
I will install the last backup from version 4.3.2. This works fine.

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

Re: Update 4.3.2 to 4.3.3 crashed

3 months 4 weeks ago - 3 months 4 weeks ago
#32758
Thank you very much for all the tips!

I have now done the following: 
1. Restored the backup of the CMS with version 4.3.2.
2. Using phpMyAdmin, added the fields ‘publish_up’ and ‘publish_down’ to the table `yjm2s_jem_events` with 
ALTER TABLE `yjm2s_jem_events` 
ADD COLUMN `publish_up` datetime NOT NULL DEFAULT “0000-00-00 00:00:00” AFTER `modified`;.

3. Did the same for ‘publish_down’
ALTER TABLE `yjm2s_jem_events` 
ADD COLUMN `publish_down` datetime NOT NULL DEFAULT “0000-00-00 00:00:00” AFTER `publish_up`; 
4. Then updated from version 4.3.2 to 4.3.3. Aborted with error message. JEM still reports version 4.3.2 .
5. Then called up Joomla database maintenance. Two problems were reported with JEM. After repair, no error messages were displayed in JEM.
6. Then tried again to update to version 4.3.3. Surprise: this time there was no error message and the update worked. JEM reports the latest version, the manifest version is also 4.3.3 
 
7. At first glance, everything looked fine. The current events are displayed in the frontend as they should be   
....  but ...
8. I cannot create new events. The display shown in the screenshot appears:
 
 
Last edit: 3 months 4 weeks ago by ketchup.

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

Time to create page: 0.434 seconds