Page MenuHomePhabricator

Activating FlaggedRevs in the MediaWiki installer causes database error: Error: 1146 Table 'flaggedpages' doesn't exist
Open, HighPublicBUG REPORT

Description

If FlaggedRevs is selected in the MediaWiki installer, the wiki will be unusable due to database errors. Running maintenance/update.php fixes this, but a new user setting up MediaWiki wouldn't necessarily know to do this right after a fresh install.


Version: 1.23.0
Severity: major

Details

Reference
bz60512

Event Timeline

bzimport raised the priority of this task from to High.Nov 22 2014, 3:08 AM
bzimport set Reference to bz60512.
bzimport added a subscriber: Unknown Object (MLST).

(In reply to comment #0)

If FlaggedRevs is selected in the MediaWiki installer, the wiki will be
unusable due to database errors. Running maintenance/update.php fixes this,
but
a new user setting up MediaWiki wouldn't necessarily know to do this right
after a fresh install.

Sounds more like an installer problem than a flagged revs problem. Changing component

(In reply to comment #0)

If FlaggedRevs is selected in the MediaWiki installer, the wiki will be
unusable due to database errors.

What kind of errors? Any examples? Which MediaWiki version (1.22.1?)?

Git master of both core and FlaggedRevs, and the errors were that (some of?) the tables didn't get created.

(In reply to comment #1)

(In reply to comment #0)

If FlaggedRevs is selected in the MediaWiki installer, the wiki will be
unusable due to database errors. Running maintenance/update.php fixes this,
but
a new user setting up MediaWiki wouldn't necessarily know to do this right
after a fresh install.

Sounds more like an installer problem than a flagged revs problem. Changing
component

The installer sets up the tables for AbuseFilter fine, so I'm pretty sure it's an issue with FlaggedRevs not hooking something it's supposed to hook.

Jackmcbarn: Exact errors still very welcome as it would help investigating.

During the install, in the text box under "Creating tables for enabled extensions...", nothing appears for FlaggedRevs. When the wiki is entered, the following appears:
A database query error has occurred. This may indicate a bug in the software.

Query:
SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,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 = 'Main_Page' LIMIT 1
Function: FlaggableWikiPage::pageData
Error: 1146 Table 'my_wiki.flaggedpages' doesn't exist (localhost)

Backtrace:

#0 C:\xampp\htdocs\core\includes\db\Database.php(1091): DatabaseBase->reportQueryError('Table 'my_wiki....', 1146, 'SELECT page_id...', 'FlaggableWikiPa...', false)
#1 C:\xampp\htdocs\core\includes\db\Database.php(1558): DatabaseBase->query('SELECT page_id...', 'FlaggableWikiPa...')
#2 C:\xampp\htdocs\core\includes\db\Database.php(1647): DatabaseBase->select(Array, Array, Array, 'FlaggableWikiPa...', Array, Array)
#3 C:\xampp\htdocs\core\extensions\FlaggedRevs\backend\FlaggableWikiPage.php(366): DatabaseBase->selectRow(Array, Array, Array, 'FlaggableWikiPa...', Array, Array)
#4 C:\xampp\htdocs\core\includes\WikiPage.php(330): FlaggableWikiPage->pageData(Object(DatabaseMysqli), Array, Array)
#5 C:\xampp\htdocs\core\extensions\FlaggedRevs\backend\FlaggableWikiPage.php(382): WikiPage->pageDataFromTitle(Object(DatabaseMysqli), Object(Title))
#6 C:\xampp\htdocs\core\extensions\FlaggedRevs\backend\FlaggableWikiPage.php(272): FlaggableWikiPage->loadPageData()
#7 C:\xampp\htdocs\core\extensions\FlaggedRevs\frontend\FlaggedRevsUI.hooks.php(211): FlaggableWikiPage->getStableRev()
#8 [internal function]: FlaggedRevsUIHooks::overrideRedirect(Object(Title), Object(WebRequest), false, false, Object(Article))
#9 C:\xampp\htdocs\core\includes\Hooks.php(206): call_user_func_array('FlaggedRevsUIHo...', Array)
#10 C:\xampp\htdocs\core\includes\GlobalFunctions.php(4008): Hooks::run('InitializeArtic...', Array, NULL)
#11 C:\xampp\htdocs\core\includes\Wiki.php(358): wfRunHooks('InitializeArtic...', Array)
#12 C:\xampp\htdocs\core\includes\Wiki.php(289): MediaWiki->initializeArticle()
#13 C:\xampp\htdocs\core\includes\Wiki.php(586): MediaWiki->performRequest()
#14 C:\xampp\htdocs\core\includes\Wiki.php(447): MediaWiki->main()
#15 C:\xampp\htdocs\core\index.php(49): MediaWiki->run()
#16 {main}

Aklapper renamed this task from Activating FlaggedRevs in the MediaWiki installer causes database error to Activating FlaggedRevs in the MediaWiki installer causes database error: Error: 1146 Table 'flaggedpages' doesn't exist.Jul 23 2015, 9:07 PM
Aklapper set Security to None.
Aklapper changed the subtype of this task from "Task" to "Bug Report".Feb 15 2022, 9:39 PM
Aklapper removed a subscriber: wikibugs-l-list.