https://bugzilla.wikimedia.org/show_bug.cgi?id=26202
Summary: Install/Upgrade fails due to syntax error in
PostgreSQL
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Normal
Component: Semantic MediaWiki
AssignedTo: mar...@semantic-mediawiki.org
ReportedBy: wwww...@iki.fi
CC: jeroen_ded...@yahoo.com
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.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
