Install on Postgres fails, invalid SQL used when populating tables

Started by avaluedcustomer, January 26, 2014, 04:32:47 AM

Previous topic - Next topic

avaluedcustomer

Hello,

I wanted to install SimpleMachine using Postgres (9.3.2) but the installer fails with the following message:


Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of your database software.

Technical information about the queries:

    Line #736: ERROR: syntax error at or near "s"
    LINE 4: ...r_holidays (title, event_date) VALUES ('New Year\'s', '0004-...

The above is invalid SQL because single quotes need to be escaped using another single quote, not using a backslash:

So the SQL should read something like this:

.. VALUES ('New Year''s', '0004-...

I'm using SimpleMachines 2.0.7.

Is this a known bug? How can I fix the SQL that is being used?



emanuele

Hello avaluedcustomer,

yes it's a known bug and the fix is to replace all the \' in the sql file to '' (well, not exactly all of them but most).


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

shentino


Oldiesmann

We'll try to get it fixed in the next version of 2.0 if that happens, otherwise it'll be fixed for 2.1.
Michael Eshom
Christian Metal Fans

Advertisement: