|
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
|
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
|
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.
|
