https://bugzilla.wikimedia.org/show_bug.cgi?id=36204
Web browser: ---
Bug #: 36204
Summary: Postgresql 8.4.11: LiquidThreads not installed.
Product: MediaWiki extensions
Version: unspecified
Platform: PC
OS/Version: Linux
Status: NEW
Severity: blocker
Priority: Unprioritized
Component: LiquidThreads
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Classification: Unclassified
Mobile Platform: ---
Hello
We have mediawiki 1.18.2 and LiquidThreads 2.0. When you run update.php get the
error:
Creating thread table ... PHP Warning: pg_query (): Query failed: ERROR: syntax
error at or near "("
LINE 2: thread_id int (8) unsigned NOT NULL PRIMARY KEY auto_increme ...
^ In / var / www / test / includes / db /
DatabasePostgres.php on line 253
A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE" thread "(
thread_id int (8) unsigned NOT NULL PRIMARY KEY auto_increment,
thread_root int (8) unsigned UNIQUE NOT NULL,
thread_ancestor int (8) unsigned NOT NULL,
thread_parent int (8) unsigned NULL,
thread_summary_page int (8) unsigned NULL,
thread_subject varchar (255) NULL,
thread_author_id int unsigned NULL,
thread_author_name varchar (255) NULL,
thread_modified char (14) binary NOT NULL default'',
thread_created char (14) binary NOT NULL default'',
thread_editedness int (1) NOT NULL default 0,
thread_article_namespace int NOT NULL,
thread_article_title varchar (255) binary NOT NULL,
thread_article_id int (8) unsigned NOT NULL,
thread_type int (4) unsigned NOT NULL default 0,
thread_sortkey varchar (255) NOT NULL default'',
thread_replies int (8) DEFAULT -1,
thread_signature TINYBLOB NULL,
UNIQUE (thread_root)
) / * $ WgDBTableOptions * /
"
from within function "DatabaseBase :: sourceFile (/ var / www / test /
extensions / LiquidThreads / lqt.sql)".
Database returned error "1: ERROR: syntax error at or near" ("
LINE 2: thread_id int (8) unsigned NOT NULL PRIMARY KEY auto_increme ...
^ "
Change the name lqt.pg.sql to lqt.sql, run update.php:
Creating thread table ... ok
... Thread_history table already exists.
Creating thread_pending_relationship table ... PHP Warning: pg_query (): Query
failed: ERROR: syntax error at or near "unsigned"
LINE 2: tpr_thread int unsigned NOT NULL,
^ In / var / www / test / includes / db /
DatabasePostgres.php on line 253
A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE" thread_pending_relationship "(
tpr_thread int unsigned NOT NULL,
tpr_relationship varbinary (64) NOT NULL,
tpr_title varbinary (255) NOT NULL,
tpr_type varbinary (32) NOT NULL,
PRIMARY KEY (tpr_thread, tpr_relationship)
) / * $ WgDBTableOptions * /
"
from within function "DatabaseBase :: sourceFile (/ var / www / test /
extensions / LiquidThreads / schema-changes /
thread_pending_relationship.sql)".
Database returned error "1: ERROR: syntax error at or near" unsigned "
LINE 2: tpr_thread int unsigned NOT NULL,
^ "
--
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
