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
Error in your SQL syntax | Event Espresso - Staging Server

Support

Home › Forums › Event Espresso Premium › Error in your SQL syntax

Error in your SQL syntax

Posted: January 25, 2013 at 2:05 am

Viewing 5 reply threads


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
http://staging.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

  • Support Staff

    •

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

  • Support Staff

    •

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?
Viewing 5 reply threads

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

The original Forum description...

Status: closed

Updated by Chris Reynolds 11 years, 11 months ago ago

Topic Tags

Tagged: 

Notifications

This topic is: not resolved
Event Espresso - Staging Server