help to better help you:

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

Upgrading from Jem 3.0.4 to JEM 2.2.x

Upgrading from Jem 3.0.4 to JEM 2.2.x

7 years 2 weeks ago
#24633
The site I have inherited is using JEM 3.0.4 which appears to be a dead end product. I want to upgrade it to current version of JEM but obviously that isn't considered a viable upgrade path by Joomla because of the backwards version numbers.

I tried uninstalling and reinstalling ( on a local dev copy of the site ) but that stopped my existing events showing and when I went to the events listing page in the administration section it just gives me the following message:
An error has occurred.
1054 Unknown column 'status' in 'field list'

I couldn't find anything about making this change- what is the right way to get from a 3.0.x JEM to a 2.2.x version?

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

Re: Upgrading from Jem 3.0.4 to JEM 2.2.x

6 years 11 months ago - 6 years 11 months ago
#24698
So in the absence of anyone able to help, I figured some of it out myself. To get the data showing I needed to make the following SQL queries:
Code:
alter table MYDB_jem_register ADD COLUMN `status` tinyint(3) NOT NULL default '1', ADD COLUMN `comment` varchar(255) DEFAULT '', ADD KEY `idx_event_status` (`event`,`status`); alter table MYDB_jem_events ADD COLUMN `unregistra_until` int(11) NOT NULL default '0', CHANGE column `recurrence_interval` `recurrence_number` int(2) NOT NULL default '0';

"MYDB" is the name of the Joomla database, obviously enough. That changed them enough that they now match the basic JEM 2.2 formatting and I can see my event data.
Last edit: 6 years 11 months ago by breakfast.

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

Re: Upgrading from Jem 3.0.4 to JEM 2.2.x

6 years 11 months ago
#24709
Hi, I tried your query but it didn't work to me... And I keep on having this same issue.
I asked my internet provider to delete every single table referring to JEM but it didn't work either... I don't know what to do in order to have JEM installed

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

Re: Upgrading from Jem 3.0.4 to JEM 2.2.x

6 years 11 months ago
#24710
if you have a testsite, you can install JEM 2.2.2 with the examples then you export events, venues categories and catevents. They will be the examples, how you need the files to import. when I changed back to JEM 2 I made it this way and had no problems! But this was years ago!

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

Re: Upgrading from Jem 3.0.4 to JEM 2.2.x

6 years 11 months ago
#24711
Let me understand it better.
On my main site I cannot install JEM, but I can install it on a different website I use for testing (I have it).
Then I should create a few events and else there and then export to a file and import (how?) this file into my official main site... did I understand it right?

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

Re: Upgrading from Jem 3.0.4 to JEM 2.2.x

6 years 11 months ago
#24712
please consult the help for import/export in JEM backend.
in backend there is a menu point for that. Export will go in csv files.study thesetables and adapt the exported files from JEM 3 according to the JEM 2. The import should work.

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

Time to create page: 0.528 seconds