Support

Home Forums Event Espresso Premium MySQL error on Payment Page

MySQL error on Payment Page

Posted: October 24, 2012 at 4:44 pm

Viewing 2 reply threads


Nick Putman

October 24, 2012 at 4:44 pm

Hi,

For some reason I am seeing a MySQL error message on my payment page:

If you click on the ‘Register for this Event’ link on the following page:

http://soteriabrighton.co.uk/ai1ec_event/soteria-in-the-pub-with-robert-whitaker/

and then book someone on to the event you will see that when you get to the payment page there is an error:

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_session = ‘043b00e4a299f8a554fcda8cbabc71f8-508840b003dcd0.07298571’ at line 5]
SELECT id, fname, lname, email, address, city, state, zip, event_id, registration_id, (SELECT count( id ) FROM wp_events_attendee WHERE attendee_session = ‘043b00e4a299f8a554fcda8cbabc71f8-508840b003dcd0.07298571’ ) AS quantity FROM wp_events_attendee WHERE event_id = AND attendee_session = ‘043b00e4a299f8a554fcda8cbabc71f8-508840b003dcd0.07298571’ LIMIT 1

Could someone help fix this?

Thanks,

Nick


Sidney Harrell

October 24, 2012 at 7:35 pm

I’m not seeing that error on the payment page. I’m just getting the paypal button. The error you posted indicates that it’s not getting an event id when it goes to run that query. Is there anything special that you have to do to get the error?


Nick Putman

October 26, 2012 at 5:23 am

Thanks for letting me know Sidney – the issue appears to have evaporated at my end too.

Nick

Viewing 2 reply threads

The support post ‘MySQL error on Payment Page’ 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.

Event Espresso