|
Alex Ryall
|
December 16, 2013 at 4:31 am
I am experiencing the same problem as this resolved thread here https://eventespresso.com/topic/doubled-system-questions/
I can get into phpMyAdmin but I don’t know how to delete all the questions from there. Any guidance would be much appreciated.
Thanks
Alex
|
|
Tony
|
December 16, 2013 at 5:18 am
Hi Alex,
Have you created many custom questions?
You should be able to drop the questions table, deactivate ee and re-activate again, that should then re-create the questions table.
Make sure you have a backup of the Database before making ANY changes.
|
|
Alex Ryall
|
December 16, 2013 at 5:22 am
Yes about 30 of them so dropping the table isn’t ideal but I guess I will have to. Sorry I am not very familiar with navigating around phpMyAdmin, what is the name of the event espresso questions table? And is it as simple as DROP TABLE table_name; ?
Thanks
Alex
|
|
Tony
|
December 16, 2013 at 5:52 am
Before doing any more, can you confirm you have a full database backup?
It is important you backup the database, without it, nothing works. So if something goes wrong you’ll be started from fresh without it.
Depending on your phpMyadmin version it may look different but here are the steps to follow.
http://codex.wordpress.org/Backing_Up_Your_Database
|
|
Alex Ryall
|
December 16, 2013 at 6:01 am
I backed it up a few hours ago in preparation for this
|
|
Tony
|
December 16, 2013 at 7:18 am
The database table will be *prefix*_events_question
So generally speaking by default it would be wp_events_question
Find the WP database, open it up so you are under ‘Structure’ and can see all the DB tables. Click the checkbox next to wp_events_question then at the bottom select ‘Drop’ within the dropdown http://d.pr/i/cV5l phpMyAdmin will the confirm.
That does basically runs
DROP TABLE wp_events_question;
Use the gui if unsure, that’s why its there 😉
You can attempt to remove the duplicate questions from the table in a similar way, open the questions table, click the check marks next to the duplicate questions and delete them. (questions with ID 1 – 10 are default, leave them as is, they are required) however I’m not sure how well that will work.
|
|
Alex Ryall
|
December 16, 2013 at 7:41 am
I don’t know if I’m going mad but the tables in phpMyAdmin look completely different to when I last went in there. What am I seeing here? http://oi41.tinypic.com/2q32hvn.jpg
Thanks
Alex
|
|
Tony
|
December 16, 2013 at 7:51 am
That’s the information_schema database, you should NOT edit that at all.
Think of that as the master database.
You should only be editing the WordPress database. If you are not 100% sure, contact your server administrator and ask them to drop the table for you.
|
|
Alex Ryall
|
December 16, 2013 at 9:13 am
I managed to get into the database and deleted the questions. Which plugin should I be disabling and re-enabling to get the default questions back? I tried Event Espresso and it didn’t work.
|
|
Josh
|
December 16, 2013 at 3:02 pm
Event Espresso will run the table update scripts when it updates to a new version. You can simulate an update by:
1) De-activate Event Espresso
2) Open the espresso.php file in an editor
3) Change the version number set ~ lines 9 & 34. For example, if it’s on 3.1.36.1.P, you can change it to 3.1.36.11.P.
4) Save the changes to espresso.php
5) Re-activate Event Espresso.
|
