Author: yackushevas
Description:
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,
^ "
Version: unspecified
Severity: critical
OS: Linux
Platform: PC