Last modified: 2010-05-26 18:08:37 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T25671, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 23671 - Syntax mismatch in postgresql update script
Syntax mismatch in postgresql update script
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
FlaggedRevs (Other open bugs)
unspecified
All All
: Normal blocker (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-05-26 15:53 UTC by nicolas_albert
Modified: 2010-05-26 18:08 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description nicolas_albert 2010-05-26 15:53:07 UTC
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)
);
Comment 1 Aaron Schulz 2010-05-26 18:08:37 UTC
Done in r66928

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links