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
SQL syntax error | Event Espresso - Staging Server

Support

Home › Forums › Multiple Event Registration › SQL syntax error

SQL syntax error

Posted: October 1, 2012 at 1:05 pm

Viewing 4 reply threads


Mareisha Winters

October 1, 2012 at 1:05 pm

Hello,

I am using the Multi Event Registration plug-in (http://www.culturalcompetencemastery.com/draft/pricing-and-registration/). When I test my registrations and click the “Confirm and go to payment” button I get this 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 = ‘olbvi5tg4li3onpjcn8qo4bmk0-5069c7ee9581c8.89364550′ LIMI’ at line 5]
SELECT id, fname, lname, email, address, city, state, zip, event_id, registration_id, (SELECT count( id ) FROM wp_wi9vnt_events_attendee WHERE attendee_session = ‘olbvi5tg4li3onpjcn8qo4bmk0-5069c7ee9581c8.89364550’ ) AS quantity FROM wp_wi9vnt_events_attendee WHERE event_id = AND attendee_session = ‘olbvi5tg4li3onpjcn8qo4bmk0-5069c7ee9581c8.89364550’ LIMIT 1


Seth Shoultes

  • Support Staff

    •

October 1, 2012 at 1:12 pm

Please send WordPress admin level log in credentials via the contact form on this page: http://staging.eventespresso.com/contact/

Select the “I am sending login info as requested” department form.


Josh

October 1, 2012 at 1:20 pm

Hi there,

So on this page:
http://www.culturalcompetencemastery.com/draft/pricing-and-registration/

where there are the two “Register Now! Click Here” buttons, what is the shortcode that is being used to generate these add to cart buttons? It does not look like there is an event ID included. There needs to be an event ID when using this shortcode on a page. There are a few examples of how to use this shortcode here:
http://staging.eventespresso.com/wiki/shortcodes-template-variables/#add-to-cart


Mareisha Winters

October 1, 2012 at 1:28 pm

Hi Josh,
First – thank you for your quick reply!
The shortcode I am using is: [ESPRESSO_CART_LINK anchor=”” direct_to_cart=1 moving_to_cart=”Redirecting to cart…”]

I updated to this after your suggestion above and am still getting the error after I click on confirm and go to payment: [ESPRESSO_CART_LINK event_id=”2″ anchor=”” direct_to_cart=1 moving_to_cart=”Redirecting to cart…”]


Mareisha Winters

October 1, 2012 at 3:34 pm

Hi, it seems like it’s fixed! I shut everything down and restarted and do not have the error anymore. Not sure if it was the fix above or if you all did something. Either way, thanks!
Viewing 4 reply threads

The support post ‘SQL syntax error’ 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.

Status: closed

Updated by Mareisha Winters 12 years, 3 months ago ago

Topic Tags

Notifications

This topic is: resolved
Event Espresso - Staging Server