Page MenuHomeMiraheze

DB error after updating permissions
Closed, ResolvedPublic

Description

So I was messing around with ManageWiki because I'm trying to improve it's documentation page https://meta.miraheze.org/wiki/ManageWiki. I temporarily set all users (group *) to not be tracked trough Matomo (permission noanalytics) and since that I get the error below on all pages:

Database error
A database query error has occurred. This may indicate a bug in the software.
[6e112fb964a201f6b8fbb072] 2018-11-03 04:32:16: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

Tried to change things back but with no luck.

Event Timeline

Unknown Object (User) triaged this task as Low priority.Nov 3 2018, 04:48
Unknown Object (User) created this task.
Unknown Object (User) removed Paladox as the assignee of this task.Nov 3 2018, 04:48
Unknown Object (User) added a subscriber: Paladox.

Fixed, it was caused by:

Wikimedia\Rdbms\DBQueryError from line 1457 of /srv/mediawiki/w/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_id,page_namespace,page_title,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_links_updated,page_latest,page_len,page_content_model,fpc_override,fpc_level,fpc_expiry,fp_pending_since,fp_stable,fp_reviewed  FROM `page` LEFT JOIN `flaggedpages` ON ((fp_page_id = page_id)) LEFT JOIN `flaggedpage_config` ON ((fpc_page_id = page_id))   WHERE page_namespace = '0' AND page_title = 'Página_principal'  LIMIT 1  
Function: FlaggableWikiPage::pageData
Error: 1146 Table 'psiconautawiki.flaggedpages' doesn't exist (xxx)

#0 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1427): Wikimedia\Rdbms\Database->makeQueryException(string, integer, string, string)
#1 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1200): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)
#2 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1653): Wikimedia\Rdbms\Database->query(string, string)
#3 /srv/mediawiki/w/includes/libs/rdbms/database/Database.php(1730): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)
#4 /srv/mediawiki/w/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(376): Wikimedia\Rdbms\Database->selectRow(array, array, array, string, array, array)
#5 /srv/mediawiki/w/includes/page/WikiPage.php(400): FlaggableWikiPage->pageData(Wikimedia\Rdbms\DatabaseMysqli, array, array)
#6 /srv/mediawiki/w/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(395): WikiPage->pageDataFromTitle(Wikimedia\Rdbms\DatabaseMysqli, Title)
#7 /srv/mediawiki/w/extensions/FlaggedRevs/backend/FlaggableWikiPage.php(284): FlaggableWikiPage->loadPageData()
#8 /srv/mediawiki/w/extensions/FlaggedRevs/frontend/FlaggedRevsUI.hooks.php(221): FlaggableWikiPage->getStableRev()
#9 /srv/mediawiki/w/includes/Hooks.php(177): FlaggedRevsUIHooks::overrideRedirect(Title, WebRequest, boolean, boolean, Article)
#10 /srv/mediawiki/w/includes/Hooks.php(205): Hooks::callHook(string, array, array, NULL)
#11 /srv/mediawiki/w/includes/MediaWiki.php(422): Hooks::run(string, array)
#12 /srv/mediawiki/w/includes/MediaWiki.php(292): MediaWiki->initializeArticle()
#13 /srv/mediawiki/w/includes/MediaWiki.php(861): MediaWiki->performRequest()
#14 /srv/mediawiki/w/includes/MediaWiki.php(524): MediaWiki->main()
#15 /srv/mediawiki/w/index.php(42): MediaWiki->run()
#16 {main}
Paladox claimed this task.