database problem - MediaWiki-l - lists.wikimedia.org

List overview All Threads
Download

database problem

keep sending mail list

1.35 update problem

Skh sourav Halder

11 Dec 2020 11 Dec '20

3:55 p.m.

Wikimedia\Rdbms\DBQueryError from line 1699 of /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/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? How do I update the database

Attachments:

attachment.htm (text/html — 631 bytes)

Reply

Show replies by thread

Jonathan M

11 Dec 11 Dec

4:17 p.m.

On 11 Dec 2020, at 15:56, Skh sourav Halder <skhsouravhalder(a)gmail.com> wrote:

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? How do I update the database

There are some suggestions on obtaining useful error messages here: <https://m.mediawiki.org/wiki/Manual:How_to_debug> This is about the update.php script to run during the MediaWiki upgrade process: <https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script> Best wishes Jonathan

Reply

Jeffrey Walton

6:25 p.m.

On Fri, Dec 11, 2020 at 10:56 AM Skh sourav Halder <skhsouravhalder(a)gmail.com> wrote:

Wikimedia\Rdbms\DBQueryError from line 1699 of /home/skhsblsb/bn.gyaanipedia.co.in/wiki/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? How do I update the database

As Jonathan suggested, it sounds like update.php needs to be run. The script is located in the maintenance/ folder. In case you don't have a procedure to update a Mediawiki installation, here's the process we use on a free/open source software project: https://github.com/weidai11/website/blob/master/mediawiki/wiki-upgrade.txt. I've never had a Mediawiki upgrade or migration go sideways by following the instructions. We have not performed a Mediawiki 1.35 migration yet. We are in a holding pattern because of the PHP 7.3.19 requirement. CentOS 7 only provides PHP 7.3.11. We are waiting for relief from either Mediawiki (lower PHP requirements) or CentOS (provide an updated PHP). Jeff

Reply

Skh sourav Halder

7:48 p.m.

My problem /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/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? Error 1146: Table 'skhsblsb_mw19390.mwrj_abuse_filter_action' doesn't exist (localhost) Function: AbuseFilterHooks::fetchAllTags Query: SELECT afa_parameters FROM `mwrj_abuse_filter_action` INNER JOIN `mwrj_abuse_filter` ON ((afa_filter=af_id)) WHERE afa_consequence = 'tag' AND af_deleted = 0 Backtrace: #0 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/rdbms/database/Database.php(1683): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string) #1 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/rdbms/database/Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string) #2 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/rdbms/database/Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean) #3 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/rdbms/database/Database.php(1907): Wikimedia\Rdbms\Database->query(string, string, integer) #4 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, string, array, string, array, array) #5 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/rdbms/database/DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call(string, array) #6 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/extensions/AbuseFilter/includes/AbuseFilterHooks.php(415): Wikimedia\Rdbms\DBConnRef->select(array, string, array, string, array, array) #7 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/objectcache/wancache/WANObjectCache.php(1529): AbuseFilterHooks::{closure}(boolean, integer, array, NULL, array) #8 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/objectcache/wancache/WANObjectCache.php(1376): WANObjectCache->fetchOrRegenerate(string, integer, Closure, array, array) #9 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/extensions/AbuseFilter/includes/AbuseFilterHooks.php(443): WANObjectCache->getWithSetCallback(string, integer, Closure) #10 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/extensions/AbuseFilter/includes/AbuseFilterHooks.php(453): AbuseFilterHooks::fetchAllTags(array, boolean) #11 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/HookContainer/HookContainer.php(320): AbuseFilterHooks::onListDefinedTags(array) #12 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/HookContainer/HookContainer.php(131): MediaWiki\HookContainer\HookContainer->callLegacyHook(string, array, array, array) #13 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/HookContainer/HookRunner.php(2387): MediaWiki\HookContainer\HookContainer->run(string, array) #14 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/changetags/ChangeTags.php(1548): MediaWiki\HookContainer\HookRunner->onListDefinedTags(array) #15 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/objectcache/wancache/WANObjectCache.php(1529): ChangeTags::{closure}(boolean, integer, array, NULL, array) #16 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/libs/objectcache/wancache/WANObjectCache.php(1376): WANObjectCache->fetchOrRegenerate(string, integer, Closure, array, array) #17 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/changetags/ChangeTags.php(1552): WANObjectCache->getWithSetCallback(string, integer, Closure, array) #18 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/changetags/ChangeTags.php(1483): ChangeTags::listSoftwareDefinedTags() #19 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/changetags/ChangeTags.php(931): ChangeTags::listDefinedTags() #20 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/htmlform/fields/HTMLTagFilter.php(30): ChangeTags::buildTagFilterSelector(NULL, boolean, RequestContext) #21 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/htmlform/HTMLForm.php(1718): HTMLTagFilter->getOOUI(NULL) #22 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/htmlform/HTMLForm.php(1735): HTMLForm->displaySection(array, string, string, boolean) #23 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/htmlform/HTMLForm.php(1311): HTMLForm->displaySection(array, string) #24 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/htmlform/OOUIHTMLForm.php(287): HTMLForm->getBody() #25 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/htmlform/HTMLForm.php(1091): OOUIHTMLForm->getBody() #26 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/specials/SpecialContributions.php(708): HTMLForm->getHTML(boolean) #27 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/specials/SpecialContributions.php(234): SpecialContributions->getForm(array) #28 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/specialpage/SpecialPage.php(600): SpecialContributions->execute(string) #29 /home/skhsblsb/ bn.gyaanipedia.co.in/wiki/includes/specialpage/SpecialPageFactory.php(635): SpecialPage->run(string) #30 /home/skhsblsb/bn.gyaanipedia.co.in/wiki/includes/MediaWiki.php(307): MediaWiki\SpecialPage\SpecialPageFactory->executePath(Title, RequestContext) #31 /home/skhsblsb/bn.gyaanipedia.co.in/wiki/includes/MediaWiki.php(940): MediaWiki->performRequest() #32 /home/skhsblsb/bn.gyaanipedia.co.in/wiki/includes/MediaWiki.php(543): MediaWiki->main() #33 /home/skhsblsb/bn.gyaanipedia.co.in/wiki/index.php(53): MediaWiki->run() #34 /home/skhsblsb/bn.gyaanipedia.co.in/wiki/index.php(46): wfIndexMain() #35 {main} My wiki link https://bn.gyaanipedia.co.in/wiki/index.php/%E0%A6%AA%E0%A7%8D%E0%A6%B0%E0%… I have a little trouble understanding this solution problem. It is better to explain where to go in a folder or hosting with a video or a picture On Sat, Dec 12, 2020, 12:26 AM Jeffrey Walton <noloader(a)gmail.com wrote:

On Fri, Dec 11, 2020 at 10:56 AM Skh sourav Halder <skhsouravhalder(a)gmail.com> wrote:

Wikimedia\Rdbms\DBQueryError from line 1699 of /home/skhsblsb/

bn.gyaanipedia.co.in/wiki/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?

How do I update the database

As Jonathan suggested, it sounds like update.php needs to be run. The script is located in the maintenance/ folder. In case you don't have a procedure to update a Mediawiki installation, here's the process we use on a free/open source software project: https://github.com/weidai11/website/blob/master/mediawiki/wiki-upgrade.txt . I've never had a Mediawiki upgrade or migration go sideways by following the instructions. We have not performed a Mediawiki 1.35 migration yet. We are in a holding pattern because of the PHP 7.3.19 requirement. CentOS 7 only provides PHP 7.3.11. We are waiting for relief from either Mediawiki (lower PHP requirements) or CentOS (provide an updated PHP). Jeff _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Reply

Jeffrey Walton

8:13 p.m.

On Fri, Dec 11, 2020 at 2:48 PM Skh sourav Halder <skhsouravhalder(a)gmail.com> wrote:

My problem /home/skhsblsb/bn.gyaanipedia.co.in/wiki/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?

You need to state all the steps you performed that led to the error. Or, you can try following Jonathan's advice. Jeff

Reply

Jonathan M

10:20 p.m.

On 11 Dec 2020, at 19:49, Skh sourav Halder <skhsouravhalder(a)gmail.com> wrote:

Error 1146: Table 'skhsblsb_mw19390.mwrj_abuse_filter_action' doesn't exist (localhost) Function: AbuseFilterHooks::fetchAllTags Query: SELECT afa_parameters FROM `mwrj_abuse_filter_action` INNER JOIN `mwrj_abuse_filter` ON ((afa_filter=af_id)) WHERE afa_consequence = 'tag' AND af_deleted = 0

Here is what I would try. Remove the AbuseFilter extension. To to this, comment out the line in LocalSettings.php referring to it. See if that stops the error from appearing. If it does, then install the extension from scratch by following the instructions to the letter. There is a bullet point on <https://www.mediawiki.org/wiki/Extension:AbuseFilter#Installation> saying “Run the update script which will automatically create the necessary database tables that this extension needs.” Best wishes Jonathan

Reply

1242

days inactive

1242

days old

mediawiki-l@lists.wikimedia.org

Manage subscription

5 comments

3 participants

tags (0)

participants (3)

Jeffrey Walton
Jonathan M
Skh sourav Halder