|
Ross Willits
|
October 3, 2014 at 2:57 pm
Starting recently (unsure exactly when), our Question Groups have all emptied, including required entries such as Participant Name, Address etc.
If I go into Question Groups and choose a group, none of the previously selected questions show as chosen, and nothing saves if I reselect and click Update.
This makes it impossible for anyone to register for anything. What could have happened?
We are using release 3.1.36.6.P, and Word Press version 4.0
This is a critical issue. Please let me know how to proceed.
Thank you,
Ross
|
|
Josh
|
October 3, 2014 at 3:04 pm
Hi Ross,
Can you check to see if the Roles and Permissions add-on is active? If it is active, can you try deactivating it?
|
|
Ross Willits
|
October 3, 2014 at 3:11 pm
It is not active.
|
|
Ross Willits
|
October 3, 2014 at 3:12 pm
Looking at the attendees list, I see that people were able to register through Oct. 1 at 5:50pm (the last successful registration). There are 3 registrations that came in blank this afternoon.
|
|
Ross Willits
|
October 3, 2014 at 3:14 pm
Actually, if I click into the attendee information for one of the people who signed up earlier this week, there is no name, just a long error message string from WordPress. I’ll send you that error message in a moment.
|
|
Ross Willits
|
October 3, 2014 at 3:15 pm
This is what shows up in the Attendee’s screen
Registration Information [ Primary Attendee Record ]
Please Note: Changing the price type will not affect “Attendee Ticket Fees” on the right side of this page. Price changes will need to be updated manually.
Choose a Time:
WordPress database error: [Got error 28 from storage engine]
SELECT q.*, qg.group_name, qg.show_group_description, qg.show_group_name FROM wp_events_question q JOIN wp_events_qst_group_rel qgr on q.id = qgr.question_id JOIN wp_events_qst_group qg on qg.id = qgr.group_id WHERE qgr.group_id in ( 3,8,2,1 ) ORDER BY qg.id, q.id ASC
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) AND attendee_id = 2933’ at line 2]
SELECT question_id,answer FROM wp_events_answer WHERE question_id IN () AND attendee_id = 2933
|
|
Josh
|
October 3, 2014 at 3:20 pm
Hi Ross,
It turns out the “WordPress database error: [Got error 28 from storage engine]” means the disk on your server is full.
The last time this was reported by another Event Espresso customer it turned out that they had months worth of full site backups stored on the server. They moved those off the server and that fixed it. You may also need to contact your host if you’ve got no where to free up space to see if they can give you more space, and they may need to run a database repair on the affected tables.
|
|
Ross Willits
|
October 3, 2014 at 3:21 pm
Ah.
Thank you. I’ll check with our ISP
|
|
Ross Willits
|
October 3, 2014 at 3:48 pm
I just got off the phone with the ISP, and you were right, we were out of space. I have had them increase our space allotment, and we’re set on that score, but things are still not working right.
I restored from a backup from last week, and I’m still seeing the error. Is there a way that I can open the database files to see if there are bad records?
|
|
Lorenzo Orlando Caum
|
October 3, 2014 at 5:10 pm
Hi,
Could you post the latest errors that are occurring?
https://eventespresso.com/topic/question-groups-empty-and-cannot-repopulate/#post-121357
—
Lorenzo
|
|
Ross Willits
|
October 3, 2014 at 5:17 pm
The error that shows up in the attendee record is exactly the same, and I still cannot populate the Question Groups
|
|
Josh
|
October 3, 2014 at 5:22 pm
Hi Ross,
This sounds like your host will need to run a database repair on the affected tables.
|
|
Ross Willits
|
October 3, 2014 at 5:24 pm
I’ll call them.
Thanks
|
|
Lorenzo Orlando Caum
|
October 4, 2014 at 2:46 pm
Hi,
Please keep us updating. If you are seeing any errors on the database, then your webhost should be able to help you resolve these.
If you are seeing errors specific to Event Espresso that are not related to the database, then please post a couple of them here so we can continue troubleshooting this issue.
—
Lorenzo
|
|
Ross Willits
|
October 4, 2014 at 2:55 pm
Thank you.
Our host is working on an issue so I will have access to MyPhpAdmin. On Monday I’ll be able to repair the database I hope.
Which tables should I look for to fix the Question Groups?
Thank you.
|
|
Lorenzo Orlando Caum
|
October 5, 2014 at 8:10 pm
wp_events_qst_group
wp_events_qst_group_rel
wp_events_question
—
Lorenzo
|
|
Ross Willits
|
October 5, 2014 at 8:13 pm
Perfect. Thank you.
I’ll check in again once I’ve rebuilt the database.
R
|
|
Ross Willits
|
October 7, 2014 at 2:58 pm
Database tables rebuilt. All is working normally now.
Thank you for your help.
|
|
Lorenzo Orlando Caum
|
October 7, 2014 at 4:05 pm
Great! We’ll go ahead and mark this as resolved. If you need help with anything else, just create a new support post through our support forums:
https://eventespresso.com/support/forums/
—
Lorenzo
|
