[SOLVED] Backend events error

Hi,
Till the version 2.3.17 all worked fine.
Now I removed JEM version 2.3.17 by deinstalling. I didn't remove the data in the database.
Next I installed JEM 4.0rc1. The installation worked perfect.
After choosing in the backend 'events' and/or 'add events' this error message appears: 1054 Unknown column 'places' in 'field list'.
Venues, Categories and Groups are working well.
How to solve this?

Jan Wessels

Joomla 4.3.2 is installed.

To upgrade JEM from 2.3.6 or up to 4.0rc1, you don't need to uninstall JEM 2.3.6 or up.
Only install the new version 4.0rc1I and the installation script upgrade the JEM tables too.
If you uninstall JEM and don't delete the tables, Joomla doesn't detect any JEM version, and install JEM as new instal, but there are JEM tables, don't overwrite (neither upgrade).

Okay, I've replaced a backup and updated JEM 2.3.7 with version 4.0rc1. I still get the error message from my first post.

I have installed 2.3.17 and update to 4.0rc1, and it works.

We try to discover the technical reason, so, we know if there is bug or not:

In your backup with JEM 2.3.17, and before to update, you can run this line in your mysql console or your phpMyAdmin (replace xxxx for your Joomla prefix of the tables):

SELECT s.version_id FROM xxxxx_schemas as s
WHERE `extension_id` = (SELECT e.extension_id FROM xxxxx_extensions as e WHERE e.name LIKE 'com_jem')

Before update, It should return: 2.3.17, is it right?

If you update JEM 2.3.7 with version 4.0rc1 and run SELECT again, it should return 4.0b4, is it right?

I tested it at my test website. You find the results (with print screens) in the pdf-file which is attached.
Hope you can help me.

Thanks, with JEM 2.3.17, the sql script should return 2.3.17....and you have 4.0b4. This is the error. In this Joomla, JEM 2.3.17 was installed (squema value was 2.3.17) , after it was installed JEM 4.0rc1 and the squema change to 4.0b....but after JEM 2.3.17 have been installed again and the squema value don't change, the previous version isn't overwrite, because 4.0b > 2.3.17

You need to restore the right value 2.3.17 in the squema in Joomla database. Run this in mysql:

UPDATE xxxxx_schemas as s SET s.version_id ='2.3.17'
WHERE s.extension_id = (SELECT e.extension_id FROM xxxxx_extensions as e WHERE e.name LIKE 'com_jem')

And install JEM v.4.0rc1