https://bugzilla.wikimedia.org/show_bug.cgi?id=23671
Summary: Syntax mismatch in postgresql update script
Product: MediaWiki extensions
Version: any
Platform: All
OS/Version: All
Status: NEW
Severity: blocker
Priority: Normal
Component: FlaggedRevs
AssignedTo: [email protected]
ReportedBy: [email protected]
In install procedure of the extension :
http://www.mediawiki.org/wiki/Extension:FlaggedRevs#Setup
Point 7
# \i FlaggedRevs.pg.sql
# psql:FlaggedRevs.pg.sql:24: ERREUR: erreur de syntaxe sur ou près de «
UNSIGNED »
LINE 2: fpp_page_id INTEGER UNSIGNED NOT NULL,
Fix : replace Integer unsigned by BIGINT as suggested here :
http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL#Data Types
CREATE TABLE flaggedpage_pending (
fpp_page_id BIGINT NOT NULL,
fpp_quality INTEGER NOT NULL,
fpp_rev_id BIGINT NOT NULL,
fpp_pending_since TIMESTAMPTZ NULL,
PRIMARY KEY (fpp_page_id,fpp_quality)
);
--
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
