Mailing List Archive

database problem
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
Re: database problem [ In reply to ]
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
Re: database problem [ In reply to ]
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
Re: database problem [ In reply to ]
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%A6%A7%E0%A6%BE%E0%A6%A8_%E0%A6%AA%E0%A6%BE%E0%A6%A4%E0%A6%BE


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
>
Re: database problem [ In reply to ]
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

_______________________________________________
MediaWiki-l mailing list
To unsubscribe, go to:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Re: database problem [ In reply to ]
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