Fresh install SMF 2.0.4, Ubuntu, Nginx, Postgresql 9.1.8

[xekon]

Fresh install SMF 2.0.4

local machine: Ubuntu, Nginx, Postgresql 9.1.8, PHP Version 5.4.6-1ubuntu1.2

If there is any other information I can provide, please let me know.

Code Select Expand


Your settings have now been saved and the database has been populated with all the data required to get your forum up and running. Summary of population:

Created 63 tables.
Inserted 912 rows.
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-...
^
Line #738: ERROR: syntax error at or near "s"
LINE 2: ..._holidays (title, event_date) VALUES ('Valentine\'s Day', '0...
^
Line #739: ERROR: syntax error at or near "s"
LINE 2: ...olidays (title, event_date) VALUES ('St. Patrick\'s Day', '0...
^
Line #744: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #745: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #746: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #747: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #748: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #749: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #750: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #751: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #752: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #753: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #754: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Mother\'s Day', '2...
^
Line #755: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #756: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #757: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #758: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #759: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #760: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #761: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #762: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #763: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #764: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #765: ERROR: syntax error at or near "s"
LINE 2: ...dar_holidays (title, event_date) VALUES ('Father\'s Day', '2...
^
Line #2302: ERROR: syntax error at or near "("
LINE 2: ...e, description, smiley_order, hidden) VALUES (':\'(', 'cry.g...
^
Click "Continue" to progress to the admin account creation page.


[emanuele]

Hello xekon and welcome around!

Yes, it's a known bug.
http://www.simplemachines.org/community/index.php?topic=458191.0
The proper fix is to replace all the

Code Select Expand

\' (slash+single quote) with

Code Select Expand

'' (two single quotes) in the install.sql file, for example:

Code Select Expand

INSERT INTO {$db_prefix}calendar_holidays (title, event_date) VALUES ('New Year\'s', '0004-01-01');

should be:

Code Select Expand

INSERT INTO {$db_prefix}calendar_holidays (title, event_date) VALUES ('New Year''s', '0004-01-01');


* emanuele wants an "inlinecode" bbcode.

[Arantor]

(You can use tt for that )

I would wonder how many more bugs there are like that lurking for later versions of PGSQL than SMF 2.0 was originally developed on.

[emanuele]

(tt has (almost) no styling )

Well, like that one in particular I think not many (postgre switched to the "correct" SQL way of escaping quotes in 9.1), so 9.1+ is completely broken, but that's just one case.

More in general, Postgre-specific (or at least non-mysql-specific) query-related bugs...several I think.
That I know of and that have been fixed (or not) here and there:
* login with nicks containing "special" chars (not yet fixed anywhere),
* several cases of "AND 1" (or "AND 0") that should be "AND 1=1" (or "AND 1=0") (I think I fixed all of these in 2.1 code...I hope),
* some FIND_IN_SET (or it was something else? Don't remember) that return 'f' or 't' instead of a numeric true (1) or false (0) (these should be fixed),
* some issues with postgre case-sensitivity when registering (not fixed yet and it *should* be fixed, keep forgetting even if it is tracked...).

And I suspect there is more.

[Oldiesmann]

(You can use tt for that )

I would wonder how many more bugs there are like that lurking for later versions of PGSQL than SMF 2.0 was originally developed on.

Most of the Postgres-related bugs are things that got overlooked rather than an issue with a newer version of Postgres.

[xekon]

what about this line in install_2-0_postgresql.sql:

after doing the replace all in my file and reinstalling it appears to be the only error

Edit, figured it out, when you replace \' to '' dont do it to the line below

Code Select Expand


INSERT INTO {$db_prefix}smileys (code, filename, description, smiley_order, hidden) VALUES (':-\\', 'undecided.gif', '{$default_undecided_smiley}', 13, 0);


[emanuele]

Arg, yes I forgot about that one!
Yes, you don't have to replace it, if I remember correctly you have to change it to:

Code Select Expand

INSERT INTO {$db_prefix}smileys (code, filename, description, smiley_order, hidden) VALUES (':-\', 'undecided.gif', '{$default_undecided_smiley}', 13, 0);
but I may be wrong...and anyway the worst that can happen is that the :-\ smiley requires a :-\\. (if you enable the custom smileys)

[xekon]

Leaving the line as it originally is ':-\\' worked on my forum. undecided smiley still works when you type ':-\'

[emanuele]

If you don't have custom smileys enabled is normal because the default smiles are hard-coded into the code itself.
Enabling custom smileys though it will probably fail and require the double slash. Well, not a big issue, you can change the code at any time from the admin interface if you need it.

[xekon]

ahh gotcha, cool thanks!