Topic on Project:Support desk

I've already posted about this error but now I've this detailed error while installing the GlobalBlocking extension and I've followed everything mentioned in Extension:GlobalBlocking but facing this problem can anyone help

Database error

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 https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug 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}

When you login/register, it is running a check by the user against the global blocking table.

Access denied for user '36900384_a'@'192.168.0.%' to database 'globalblocking'

User 36900384_an accessing via '192.168.0.%' cannot read or write to the globalblocking table. You'll have to fix that, it is a database configuration problem.

Ok it's a database configuration problem but how can I fix this can you give me little bit idea.

It's not really a MediaWiki issue and very much depends on how your server is setup. I'm assuming that access to other tables works ?

https://www.google.com/search?q=mysql+granting+permissions+to+a+table

Stack overflow should have lots of answers as well.

It should be noted, that access denied might literally mean access denied, but in many setups you will get the same error if you simply forgot to create the database.

This was solved by making some changes in database but now another problem has been shown to me.

This problem has gone but now I've another problem like this 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 https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug 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 sounds like you changed the mediawiki db name ($wgDBname) to your globalblocking db, which would be the wrong thing to do.

So what should I do.