Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-sales domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the better-click-to-tweet domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-amazon domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the pue-stats domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the wordpress-seo domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/staging-poc/public_html/wp-includes/functions.php on line 6114
MySQL error on Payment Page | Event Espresso - Staging Server

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

  • Support Staff

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 - Staging Server