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
On 11 Dec 2020, at 15:56, Skh sourav Halder skhsouravhalder@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
On Fri, Dec 11, 2020 at 10:56 AM Skh sourav Halder skhsouravhalder@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
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%A...
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@gmail.com wrote:
On Fri, Dec 11, 2020 at 10:56 AM Skh sourav Halder skhsouravhalder@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
On Fri, Dec 11, 2020 at 2:48 PM Skh sourav Halder skhsouravhalder@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
On 11 Dec 2020, at 19:49, Skh sourav Halder skhsouravhalder@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
mediawiki-l@lists.wikimedia.org