Not a bug XF\Db\InvalidQueryException: MySQL statement prepare error

[tr1cky]

Affected version

2.0.9

Hello,

since upgrading to 2.0.9 I get the following error:

• XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's a%' GROUP BY thread.thread_id ORDER BY thread.post_date DESC LIMIT 30' at line 3
• src/XF/Db/AbstractStatement.php:212

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(96): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT thre...', Array)
#5 src/addons/XenCentral/Feedback/Repository/Tools.php(70): XF\Db\AbstractAdapter->fetchAll('\n\t\t\tSELECT thre...')
#6 src/addons/XenCentral/Feedback/Pub/Controller/Main.php(489): XenCentral\Feedback\Repository\Tools->getThreadSuggestions('Zecjy's a', Array)
#7 src/XF/Mvc/Dispatcher.php(249): XenCentral\Feedback\Pub\Controller\Main->actionSuggestThread(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XenCentral\\Feed...', 'SuggestThread', 'html', Object(XF\Mvc\ParameterBag), 'xcfs', Object(XenCentral\Feedback\Pub\Controller\Main), NULL)
#9 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#11 src/XF.php(328): XF\App->run()
#12 index.php(13): XF::runApp('XF\\Pub\\App')
#13 {main}

 

[Chris D]

The faulty code seems to be within an add-on. Certainly, XenCentral Feedback is mentioned but the specific code that is being run is "SuggestThread"? Not sure if that's actually that add-on or another, but I'd start there with your troubleshooting.