XF 2.0 MySQL fetch error [2014]: Commands out of sync

KSA

Well-known member
Im getting this error on my board and not sure what it is and how to fix it.

Any idea


XF\Db\Exception
: MySQL fetch error [2014]: Commands out of sync; you can't run this command now in src/XF/Db/AbstractStatement.php at line 212
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 134
  3. XF\Db\Mysqli\Statement->fetchRowValues() in src/XF/Db/AbstractStatement.php at line 88
  4. XF\Db\AbstractStatement->fetchAliasGrouped() in src/XF/Mvc/Entity/Finder.php at line 1165
  5. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 36
  6. XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/QAForums/XF/Pub/Controller/Thread.php at line 41
  7. ThemeHouse\QAForums\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
  8. XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
  9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
  10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
  11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
  12. XF\App->run() in src/XF.php at line 328
  13. XF::runApp() in index.php at line 13
 
I disabled all add-on and still getting same error

XF\Db\Exception: MySQL fetch error [2014]: Commands out of sync; you can't run this command now in src/XF/Db/AbstractStatement.php at line 212
  1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
  2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 134
  3. XF\Db\Mysqli\Statement->fetchRowValues() in src/XF/Db/AbstractStatement.php at line 88
  4. XF\Db\AbstractStatement->fetchAliasGrouped() in src/XF/Mvc/Entity/Finder.php at line 1165
  5. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 36
  6. XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
  7. XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
  8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
  9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
  10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
  11. XF\App->run() in src/XF.php at line 328
  12. XF::runApp() in index.php at line 13
 
I have run into this a few times in as many days now.

Usually this is throwing an error that isn't being reported by an older version of MySQL so it throws this generic error instead.

Updating to something such as MariaDB 10.x+ usually provides a more helpful output.
 
Top Bottom