|
thinkbiglearnsmart
|
March 14, 2022 at 10:26 am
We’ve begun seeing this error when Updating Record on an Attendee
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 ‘) ORDER BY qg.id, q.id ASC’ at line 1]
SELECT q.*, q.id AS q_id, qg.group_name, qg.show_group_description, qg.show_group_name FROM wpxy_events_question q JOIN wpxy_events_qst_group_rel qgr on q.id = qgr.question_id JOIN wpxy_events_qst_group qg on qg.id = qgr.group_id WHERE qgr.group_id in ( ) ORDER BY qg.id, q.id ASC
Screenshot: https://prnt.sc/7DC4Q8rSWouj
|
|
thinkbiglearnsmart
|
March 14, 2022 at 10:51 am
We were able to narrow this down to being a result of disabling the Event Espresso Permissions plugin. Now that it’s back on, things are working again. However, now some of the attendee records are corrupted without any personal information (https://prnt.sc/imjSD7m96QAz). Is there a way to retrieve this data?
|
|
Tony
|
March 15, 2022 at 7:07 am
Hi there,
If the data has been overwriting with nothing then it will no longer be within the database.
Do you have a database backup from before those attendee attendees were updated?
If you don’t have your own your host may do automatic updates (usually daily or weekly) and I’d recommend downloading that locally to your machine now before it’s overwritten with the next backup.
How many records now have missing data?
|
