Author: wwwwolf
Description:
I have an already existing Semantic MediaWiki site in PostgreSQL. When I upgraded to SMW 1.5.4, there were luckily no schema changes, because the "Initialise or upgrade tables" process fails.
Here's the bizarre error message that the software spits out - apparently, someone's being oddly specific about quotes, and PostgreSQL has a problem with that:
Setting up standard database configuration for SMW ...
Selected storage engine is "SMWSQLStore2" (or an extension thereof)
Checking table smw_ids ...
Table already exists, checking structure ...
Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "\"
LINE 6: case when a.attnotnull THEN \'NO\'::text else \'YES\'::tex...
^ in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 580
I use MediaWiki 1.15.5-1 (Debian packaged version), PHP 5.2.6 and PostgreSQL 8.4.2.
Version: unspecified
Severity: normal