Media Wiki Extension:GlobalBlocking Error

Website URL

http://nepalpedia.great-site.net

Error Message

Hello, I was trying to install MediaWiki GlobalBlocking extension and I followed everything mentioned in the Installation but after I tried to access the site says me an long error how can I solve this provlem.

Other Information

(other information and details relevant to your question)

This is the error message
A database query error has occurred. This may indicate a bug in the software.

[Zpi2C5daueiOxm068PXApgAAABo] /index.php?title=Special:UserLogin&returnto=Main+Page&returntoquery=i%3D1 Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your applicationā€™s database schema updater after upgrading or after adding a new extension?

Please see Manual:Upgrading - MediaWiki and Manual:How to debug - MediaWiki for more information.

Error 1044: Access denied for user ā€˜36900384_aā€™@ā€˜192.168.0.%ā€™ to database ā€˜globalblockingā€™
Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain
Query: USE globalblocking

Backtrace:

from /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/Database.php(1236)
#0 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/Database.php(1220): Wikimedia\Rdbms\Database->getQueryException(string, integer, string, string)
#1 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/Database.php(1194): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)
#2 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/DatabaseMySQL.php(202): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string)
#3 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/Database.php(1543): Wikimedia\Rdbms\DatabaseMySQL->doSelectDomain(Wikimedia\Rdbms\DatabaseDomain)
#4 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/loadbalancer/LoadBalancer.php(922): Wikimedia\Rdbms\Database->selectDomain(Wikimedia\Rdbms\DatabaseDomain)
#5 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/loadbalancer/LoadBalancer.php(801): Wikimedia\Rdbms\LoadBalancer->reuseOrOpenConnectionForNewRef(integer, Wikimedia\Rdbms\DatabaseDomain, integer)
#6 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/loadbalancer/LoadBalancer.php(793): Wikimedia\Rdbms\LoadBalancer->getServerConnection(integer, string, integer)
#7 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/DBConnRef.php(99): Wikimedia\Rdbms\LoadBalancer->getConnectionInternal(integer, string, string, integer)
#8 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/DBConnRef.php(117): Wikimedia\Rdbms\DBConnRef->ensureConnection()
#9 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/rdbms/database/DBConnRef.php(538): Wikimedia\Rdbms\DBConnRef->__call(string, array)
#10 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/extensions/GlobalBlocking/includes/GlobalBlocking.php(313): Wikimedia\Rdbms\DBConnRef->anyString()
#11 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/extensions/GlobalBlocking/includes/GlobalBlocking.php(287): MediaWiki\Extension\GlobalBlocking\GlobalBlocking::getRangeCondition(string)
#12 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/extensions/GlobalBlocking/includes/GlobalBlocking.php(121): MediaWiki\Extension\GlobalBlocking\GlobalBlocking::getGlobalBlockingBlock(string, boolean)
#13 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/extensions/GlobalBlocking/includes/GlobalBlocking.php(38): MediaWiki\Extension\GlobalBlocking\GlobalBlocking::getUserBlockDetails(MediaWiki\User\User, string)
#14 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/extensions/GlobalBlocking/includes/GlobalBlockingHooks.php(102): MediaWiki\Extension\GlobalBlocking\GlobalBlocking::getUserBlock(MediaWiki\User\User, string)
#15 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/HookContainer/HookContainer.php(161): MediaWiki\Extension\GlobalBlocking\GlobalBlockingHooks->onGetUserBlock(MediaWiki\User\User, string, NULL)
#16 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/HookContainer/HookRunner.php(1962): MediaWiki\HookContainer\HookContainer->run(string, array)
#17 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/block/BlockManager.php(186): MediaWiki\HookContainer\HookRunner->onGetUserBlock(MediaWiki\User\User, string, NULL)
#18 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/user/User.php(1406): MediaWiki\Block\BlockManager->getUserBlock(MediaWiki\User\User, MediaWiki\Request\WebRequest, boolean, boolean)
#19 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/user/User.php(1507): MediaWiki\User\User->getBlockedStatus(boolean, boolean)
#20 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/user/PasswordReset.php(349): MediaWiki\User\User->getBlock()
#21 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/user/PasswordReset.php(154): MediaWiki\User\PasswordReset->isBlocked(MediaWiki\User\User)
#22 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/user/PasswordReset.php(124): MediaWiki\User\PasswordReset->computeIsAllowed(MediaWiki\User\User)
#23 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/libs/MapCacheLRU.php(271): MediaWiki\User\PasswordReset->MediaWiki\User{closure}()
#24 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/user/PasswordReset.php(121): MapCacheLRU->getWithSetCallback(string, Closure)
#25 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/LoginSignupSpecialPage.php(1082): MediaWiki\User\PasswordReset->isAllowed(MediaWiki\User\User)
#26 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/LoginSignupSpecialPage.php(757): MediaWiki\SpecialPage\LoginSignupSpecialPage->getFieldDefinitions(array)
#27 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/AuthManagerSpecialPage.php(695): MediaWiki\SpecialPage\LoginSignupSpecialPage->onAuthChangeFormFields(array, array, array, string)
#28 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/LoginSignupSpecialPage.php(708): MediaWiki\SpecialPage\AuthManagerSpecialPage->fieldInfoToFormDescriptor(array, array, string)
#29 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/AuthManagerSpecialPage.php(434): MediaWiki\SpecialPage\LoginSignupSpecialPage->getAuthForm(array, string)
#30 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/LoginSignupSpecialPage.php(337): MediaWiki\SpecialPage\AuthManagerSpecialPage->trySubmit()
#31 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/SpecialPage.php(727): MediaWiki\SpecialPage\LoginSignupSpecialPage->execute(NULL)
#32 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/specialpage/SpecialPageFactory.php(1621): MediaWiki\SpecialPage\SpecialPage->run(NULL)
#33 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/MediaWiki.php(357): MediaWiki\SpecialPage\SpecialPageFactory->executePath(string, RequestContext)
#34 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/MediaWiki.php(960): MediaWiki->performRequest()
#35 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/includes/MediaWiki.php(613): MediaWiki->main()
#36 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/index.php(50): MediaWiki->run()
#37 /home/vol15_5/infinityfree.com/if0_36900384/nepalpedia.great-site.net/htdocs/index.php(46): wfIndexMain()
#38 {main}

Please read

2 Likes

It seems that the GlobalBlocking extension assumes that there is a separate database available, called globalblocking. However, note that:

  • Any database you have has a name thatā€™s prefixed with your account username, so you can have a database if0_36900384_globalblocking, but not just globalblocking.
  • Any database must be created through our panel, itā€™s not possible to create databases from your own code.

I have very little experience with MediaWiki, and I have never heard of this extension, so I canā€™t tell you exactly what you need to do to make this work. But I would assume that the GlobalBlocking extension has some setting somewhere to determine which database to use.

In the mean time, you should be able to disable the extension on your website so you can access it while figuring out how to set it up properly. I think extension in MediaWiki can be disabled by editing the LocalSettings.php file.

3 Likes

The above mentioned problems by you I donā€™t have any of the problems you mentioned.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Website URL

http://nepalpedia.great-site.net/

Error Message

As Iā€™ve already presented problem here and after that I tried to find solution of this problem so I found that it could be because of not granting required permissions for the database globalblocking that I created so how can I grant or check the permissions.

Other Information

A database query error has occurred. This may indicate a bug in the software.

[ZqL81IaLlLGPQ01JYt0l7QAAAAk] /index.php?title=Special:UserLogin&returnto=Special%3AGlobalBlockList Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your applicationā€™s database schema updater after upgrading or after adding a new extension?

Please see Manual:Upgrading - MediaWiki and Manual:How to debug - MediaWiki for more information.

Error 1044: Access denied for user ā€˜36900384_aā€™@ā€˜192.168.0.%ā€™ to database ā€˜globalblockingā€™

Function: Wikimedia\Rdbms\DatabaseMySQL::doSelectDomain

Query: USE globalblocking

Wrong. Donā€™t attempt to use the Softaculous generated accounts, they only have access to 1 database, which is the main database MediaWiki is using right now. Please use if0_36900384 and your hosting account password instead.

Also wrong. You just donā€™t have that database. If you created a database ā€œcalledā€ globalblocking, then it is actually if0_36900384_globalblocking. Using just globalblocking then wonā€™t work.

2 Likes

As you told I replaced in Local settings.php but after that Iā€™ve this problem whatā€™s this now
MediaWiki internal error.

Original exception: [ZqODYk6fQHQg5OQmWuIAhQAAAAs] / Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your applicationā€™s database schema updater after upgrading or after adding a new extension?

Please see Manual:Upgrading - MediaWiki and Manual:How to debug - MediaWiki for more information.

Error 1146: Table ā€˜if0_36900384_globalblocking.mwfm_l10n_cacheā€™ doesnā€™t exist
Function: LCStoreDB::get
Query: SELECT lc_value FROM mwfm_l10n_cache WHERE lc_lang = ā€˜enā€™ AND lc_key = ā€˜depsā€™ LIMIT 1

This is a different issue. It says a table doesnā€™t exist, which means that the connection is successful and the configuration is correct.

However, the table is for some reason, missing. Iā€™m willing to suspect that it was missing because the installation if GlobalBlocking isnā€™t successful, due to something like queries being too big.

As for the solution, I donā€™t exactly know. Iā€™m not familiar with MediaWiki, you probably wanted to seek help from MediaWiki or the extension instead.

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.