Luizluca created this task.
Luizluca added projects: PostgreSQL, wikiba.se.
Restricted Application added a subscriber: Aklapper.
Restricted Application added a project: Wikidata.

TASK DESCRIPTION

While installing wikibase, it failed with this error:

Creating wb_changes_subscription table ...[24c8a27fa67b3ebc29b340b1] [no req]   Wikimedia\Rdbms\DBQueryError from line 1457 of /srv/www/mediawiki-1.31.0/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: CREATE TABLE IF NOT EXISTS "wb_changes_subscription" (
 cs_row_id         BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
 cs_entity_id      VARBINARY(255) NOT NULL, -- the ID of the entity subscribed to
 cs_subscriber_id  VARBINARY(255) NOT NULL  -- the ID of the subscriber (e.g. a domain name or database name)
 ) /*$wgDBTableOptions*/

Function: Wikimedia\Rdbms\Database::sourceFile( /srv/www/mediawiki-1.31.0/extensions/Wikibase/repo/includes/Store/Sql/../../../sql/changes_subscription.sql )
Error: 42601 ERROR:  syntax error at or near "AUTO_INCREMENT"
LINHA 2:  cs_row_id         BIGINT NOT NULL PRIMARY KEY AUTO_INCREMEN...

It seems that it does not support PostgreSQL. No single doc mentioned that requirement until I was far into the installation.


TASK DETAIL
https://phabricator.wikimedia.org/T207226

EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Luizluca
Cc: Aklapper, Luizluca, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, saper, aude, Turnstep, scfc, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to