Support

Home Forums Pre-Sales Before purchase question – compability database sql syntax error.

Before purchase question – compability database sql syntax error.

Posted: December 17, 2012 at 6:25 pm


fresatura

December 17, 2012 at 6:25 pm

Hello,
Studying your documentation event espresso would perfectly match my needs. I installed the Lite version but would like to purchase. I tested via your recommended “Event Espresso Requirements Check”Plugin and it

“Passed with warnings….”

However I tried to built up an event and ended with the following 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 ‘Admission’)’ at line 1]
INSERT INTO wp_events_prices (event_id, event_cost, surcharge, surcharge_type, price_type, member_price, member_price_type) VALUES (‘1’, ‘0.00’, ”, ‘flat_rate’, ‘General Admission’, ‘0.00’, ‘Membres d’Admission’)”

No other plugin is activated but it does not seem to matter.Is this an issue that will pass away with the purchased version or is it simlpy not compatible with my system? Thank you very much in advance for your answer


Dean

December 18, 2012 at 1:01 am

Hi Fresatura,

I will get this passed to the developers as I believe it is a known error with the translation files, the code does not like the extra ‘ in d’Admission. This should have been fixed in the premium version already.


fresatura

December 18, 2012 at 1:58 am

Thank you very much for your quick answer. Yes, french language is a source of stumbling blocks….So, I will await the answer of your developpers.


Dean

December 18, 2012 at 2:19 am

In the short term, you could amend the language files using a program like Poedit to remove the apostrophes – not ideal but should get you going again.

The support post ‘Before purchase question – compability database 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.

Event Espresso