https://bugzilla.wikimedia.org/show_bug.cgi?id=30678
Web browser: ---
Bug #: 30678
Summary: maintenance/update.php fails with syntax error on a
PostgreSQL database
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: ArticleFeedback
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: sam.halli...@gmail.com
CC: krinklem...@gmail.com, roan.katt...@gmail.com
Classification: Unclassified
When attempting to run the maintenance/update.php script on mediawiki 1.17.0
and the latest SVN of all the ArticleFeedback dependencies, I see the following
error (even if I run the script several times)
Creating click_tracking table...PHP Warning: pg_query(): Query failed: ERROR:
syntax error at or near "NOT"
LINE 1: ...Tracking/patches/ClickTracking.sql ) */ TABLE IF NOT EXISTS...
^ in
/path/to/includes/db/DatabasePostgres.php on line 237
A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE IF NOT EXISTS click_tracking (
action_time char(14) NOT NULL,
session_id varbinary(255) NOT NULL,
is_logged_in tinyint NOT NULL,
user_total_contribs integer,
user_contribs_span1 integer,
user_contribs_span2 integer,
user_contribs_span3 integer,
namespace integer NOT NULL,
event_id integer NOT NULL,
additional_info varbinary(255)
) /*$wgDBTableOptions*/
"
from within function "DatabaseBase::sourceFile(
/path/to/extensions/ClickTracking/patches/ClickTracking.sql )".
Database returned error "1: ERROR: syntax error at or near "NOT"
LINE 1: ...Tracking/patches/ClickTracking.sql ) */ TABLE IF NOT EXISTS...
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
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
