XF 2.1 DROP command denied to user

I've got an error in my admin CP that indicates the mysql user must have a DROP table command available. Before I activate that I want to make sure this requirement is a legit part of maintaining the forums and not some script kiddie trying to ruin my life.

Thanks for your help!

-----------------------------------------------------------------
  • XF\Db\InvalidQueryException: MySQL query error [1142]: DROP command denied to user 'xxxxxx'@'lxxxxx.com' for table 'xf_mg_media_view'
  • src/XF/Db/AbstractStatement.php:217
  • Generated by: Unknown account
  • Jan 2, 2022 at 4:30 PM

Stack trace​

TRUNCATE TABLE xf_mg_media_view
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1142, '42000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1142, '42000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(355): XF\Db\AbstractAdapter->query('TRUNCATE TABLE ...')
#4 src/addons/XFMG/Repository/Media.php(391): XF\Db\AbstractAdapter->emptyTable('xf_mg_media_vie...')
#5 src/addons/XFMG/Cron/Views.php(13): XFMG\Repository\Media->batchUpdateMediaViews()
#6 [internal function]: XFMG\Cron\Views::runViewUpdate(Object(XF\Entity\CronEntry))
#7 src/XF/Job/Cron.php(35): call_user_func(Array, Object(XF\Entity\CronEntry))
#8 src/XF/Job/Manager.php(253): XF\Job\Cron->run(G)
#9 src/XF/Job/Manager.php(195): XF\Job\Manager->runJobInternal(Array, G)
#10 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#11 job.php(42): XF\Job\Manager->runQueue(false, 8)
#12 {main}
 
Top