|
Hervé Jungblut
|
January 25, 2013 at 2:05 am
Hi there,
i’ve got an error when updating events :
Full message :
[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_events_prices (event_id, event_cost, surcharge, surcharge_type, price_type, member_price, member_price_type) VALUES (‘3’, ‘0.00’, ‘0.00’, ‘flat_rate’, ‘Admision des membres’, ‘0.00’, ‘Membres d’Admission’)
I’ve check this Topic, but it doesn’t fix my issue
https://eventespresso.com/topic/sql-error-on-event-update/
any help appreciated !
d.
|
|
Josh
|
January 25, 2013 at 3:41 pm
HI Hervé,
The error indicates that the single quote in “Membres d’Admission” is causing the error. Can you try removing that singe quote?
|
|
Hervé Jungblut
|
February 1, 2013 at 3:42 am
Hi Josh,
i’ve tried to remove the single Quote “General Admission”‘
But when i save the error is still there, and the single quote is back.
See : http://cl.ly/image/3f0M073k202s
Thanks !
d.
|
|
Chris Reynolds
|
February 4, 2013 at 1:26 pm
Hervé —
Do you have WP User Integration active? If so, if you deactivate it do you still get the error?
|
|
Hervé Jungblut
|
February 5, 2013 at 9:05 am
Hi Chris,
I haven’t install WP User Integration (you mean the add-on i guess ? ).
See : http://cl.ly/image/2m1E0426071o
I can give you access to the website. If it can help finding the issue.
Thanks !
d.
|
|
Chris Reynolds
|
February 5, 2013 at 1:55 pm
I asked about the WP User Integration add-on because that “Membres d’Admission” string is for member pricing, so it shouldn’t be causing issues if you don’t have any member pricing.
I do notice that you have an older version of Event Espresso. What happens if you update the plugin?
|
