Support

Home Forums Event Espresso Premium Group Registration Still Causing SQL Warnings

Group Registration Still Causing SQL Warnings

Posted: July 3, 2012 at 11:35 pm


Sven Rafferty

July 3, 2012 at 11:35 pm

I posted that I was having a SQL error previously and was told that 3.1.24.1 would fix it. Nope. Still exists. See below.

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 q.id ASC’ at line 7]
SELECT q.*, qg.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 () ORDER BY 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 ‘) ORDER BY q.id ASC’ at line 7]
SELECT q.*, qg.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 () ORDER BY q.id ASC


Josh

  • Support Staff

July 5, 2012 at 6:58 am

Hi Sven,

Try re-saving the questions and question groups. Then head over to the event editor and verify that the correct questions for the primary and additional attendees are selected (there should be check boxes checked off for each question group selected). Then update the event.


Sven Rafferty

July 5, 2012 at 6:10 pm

He shots, he scores! That fixed it. Thank you, Josh.

The support post ‘Group Registration Still Causing SQL Warnings’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Do NOT follow this link or you will be banned from the site!
[i]
[i]