Addshore created this task.
Addshore added a project: Wikidata.
Herald added a subscriber: Aklapper.

TASK DESCRIPTION

When installing a new wiki, enabling wikibase and running update.php I get the following:

Creating wb_property_info table ...done.
Populating wb_property_info
[c9b64565b4ed9b87f56943c3] [no req]   Wikimedia\Rdbms\DBQueryError from line 1233 of /var/www/mediawiki/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: SELECT  page_title,page_id  FROM `page` LEFT JOIN `wb_property_info` ON ((CONCAT('P',pi_property_id) = page_title))   WHERE (page_id > 1) AND (page_namespace = ) AND (pi_property_id IS NULL)  ORDER BY page_id ASC LIMIT 100   FOR UPDATE
Function: Wikibase\PropertyInfoTableBuilder::rebuildPropertyInfo
Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (pi_property_id IS NULL)  ORDER BY page_id ASC LIMIT 100
  FOR UPDATE' at line 1 (db-master)

Backtrace:
#0 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(1044): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#1 /var/www/mediawiki/includes/libs/rdbms/database/Database.php(1428): Wikimedia\Rdbms\Database->query(string, string)
#2 /var/www/mediawiki/extensions/Wikibase/repo/includes/Store/Sql/PropertyInfoTableBuilder.php(177): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#3 /var/www/mediawiki/extensions/Wikibase/repo/includes/Store/Sql/DatabaseSchemaUpdater.php(210): Wikibase\PropertyInfoTableBuilder->rebuildPropertyInfo()
#4 /var/www/mediawiki/includes/installer/DatabaseUpdater.php(482): Wikibase\Repo\Store\Sql\DatabaseSchemaUpdater::rebuildPropertyInfo(MysqlUpdater)
#5 /var/www/mediawiki/includes/installer/DatabaseUpdater.php(450): DatabaseUpdater->runUpdates(array, boolean)
#6 /var/www/mediawiki/maintenance/update.php(200): DatabaseUpdater->doUpdates(array)
#7 /var/www/mediawiki/maintenance/doMaintenance.php(94): UpdateMediaWiki->execute()
#8 /var/www/mediawiki/maintenance/update.php(245): require_once(string)
#9 {main}

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

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

To: Addshore
Cc: Addshore, Aklapper, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to