|
Sacramento Qigong
|
March 5, 2014 at 2:08 am
Hello,
I had to downgrade to EE3 (from EE4) to take advantage of a particular payment gateway. I was unable to downgrade smoothly, so I deleted the plugin, deleted the database tables associated with EE and reinstalled the plugin.
The plugin activates, and seems fine, but I get this error when entering and saving a new Event.
WordPress database error: [Table ‘db_mysite.qlk2ax_events_prices’ doesn’t exist]
I’ve tried a number of things to reset the DB, but unsure how. I do not currently have any data in my EE3 installation so I could delete and start over if I knew how.
|
|
Dean
|
March 5, 2014 at 5:01 am
Hi,
The easiest and recommended way to downgrade is to revert to a backup of the site prior to the EE4 upgrade.
It sounds like the EE3 tables have not installed correctly. You could try deactivating and reactivating the plugin to see if it will force it, but this may not work.
|
|
Sacramento Qigong
|
March 5, 2014 at 8:36 am
Dean, I wish I could revert to a backup prior to to the EE4 upgrade but I cannot.
And I have tried to deactivate and reactivate and it does not work.
What would be my next steps?
|
|
Sacramento Qigong
|
March 5, 2014 at 8:38 am
I am the developer for this site, and I’m able to make whatever changes needed in the database. I could also restore just specific tables from an old backup, but I’m unable to just drop an entire WP backup on my site and lose all my changes since then.
|
|
Josh
|
March 5, 2014 at 3:56 pm
Hi there,
Sounds like you could restore the tables that had “events” in their name -or- force an “update” by going in to edit the espresso.php file and change the version number where it says 3.1.36.4.P to something like 3.1.36.41.P. You’ll find the plugin version number defined in the plugin header and a few lines later. When you reactivate it that will trigger a database update where it checks for existing tables and creates new ones if they are not there.
|
|
Sacramento Qigong
|
March 9, 2014 at 10:16 pm
Thanks for the reply Josh, I appreciate because I’m almost done with a new website and this was the last piece to solve.
I changed the version # like you suggested – then deactivated the plugin and reactivated it. I did not get any messages regarding the database update, but….I am now able to save Events, so assuming it worked but just didn’t give me a message?
In any case, very happy it’s working now, thank you for the help!!
|
