Support

Home Forums Multiple Event Registration Add-on SQL syntax error

SQL syntax error

Posted: October 1, 2012 at 1:05 pm


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: https://eventespresso.com/contact/

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


Josh

  • Support Staff

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:
https://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!

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.

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