Support

Home Forums Event Espresso Premium SQL error on Event Update

SQL error on Event Update

Posted: November 9, 2012 at 2:28 pm


oxtal

November 9, 2012 at 2:28 pm

Hi Guys,
I just update to Version 3.1.28.2.P and i get this SQL error when a updated an existing event :

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 ‘Admission’)’ at line 1]
INSERT INTO wp_cabareteastmanevents_prices (event_id, event_cost, surcharge, surcharge_type, price_type, member_price, member_price_type) VALUES (’28’, ‘17.00’, ‘3.00’, ‘flat_rate’, ‘General Admission’, ‘17.00’, ‘Membres d’Admission’)

Thanks


Josh

  • Support Staff

November 9, 2012 at 2:47 pm

Hi there,

Can you try this?

Under members pricing, you can remove the single quote from:
Membres d’Admission

Then update the event.

After you update the event, you can type the single quote back in.

We’ve added better data sanitization to this release, but older data that’s been entered wouldn’t have been properly entered in this case.


oxtal

November 10, 2012 at 2:30 pm

Perfect it work!

«Membres d’Admission» came from the event_espresso-fr_FR file.
I Changed it for «Admision des membres» witch make more sence any way 😉

Best regards


Gen Gelinas

November 20, 2012 at 9:00 pm

I have something similar when I update an existing event:

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 ‘Admission’)’ at line 1]
SELECT id FROM th1nl_icl_strings WHERE context=’WordPress’ AND value=’WordPress database error %1$s for query %2$s made by %3$s’

I don’t know if it’s related, but the registration form on the front end doesn’t show confirmations anymoer nor send confirmation emails.


Gen Gelinas

November 20, 2012 at 9:31 pm

When I create a new event, the error is different:

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 ‘Admission’)’ at line 1]
SELECT id FROM th1nl_icl_strings WHERE context=’WordPress’ AND value=’WordPress database error %1$s for query %2$s made by %3$s’

Une erreur s’est produite. L’évènement n’a pas été enregistré, veuillez recommencer.

WordPress database error: []
SELECT id FROM th1nl_icl_strings WHERE context=’WordPress’ AND value=’WordPress database error %1$s for query %2$s made by %3$s’

Help!


Josh

  • Support Staff

November 21, 2012 at 7:47 am

Hi Gen,

We’ll need access to the site to investigate further. If it is possible, please send FTP and WordPress admin level log in credentials via the contact form on this page: https://eventespresso.com/contact/

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


Gen Gelinas

November 21, 2012 at 8:37 pm

I had to restore my DB and files to their versions of 3 days ago and I won’t reimplement updates until mid-December, after my events are done with for the year. I’ll get back to you when I upgrade again and if the problem appears again. Thanks.

The support post ‘SQL error on Event Update’ 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