Error type "uncaught_exception" happens when searching in Babble...
SELECT count(*) FROM `babble_messages` WHERE messages_room=1 and ( ( ( FIND_IN_SET(7,messages_perms) OR FIND_IN_SET(11,messages_perms) OR FIND_IN_SET(12,messages_perms) ) ) OR messages_perms="*" ) and messages_announcement !=1 and messages_is_pm = 0 and ( messages_muted=2 OR ( messages_muted=1 and messages_member=5 ) ) and messages_msg LIKE "%x%" and ( )
IPS\Db\Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 (1064)
#0 /home/x/public_html/x/system/Db/Select.php(346): IPS\_Db->preparedQuery('SELECT count(*)...', Array)
#1 /home/x/public_html/x/system/Db/Select.php(402): IPS\Db\_Select->runQuery()
#2 /home/x/public_html/x/system/Db/Select.php(329): IPS\Db\_Select->rewind()
#3 /home/x/public_html/x/system/Helpers/Table/Db.php(279): IPS\Db\_Select->first()
#4 /home/x/public_html/x/system/Helpers/Table/Table.php(424): IPS\Helpers\Table\_Db->getRows(Array)
#5 /home/x/public_html/x/applications/babble/sources/Rooms/Rooms.php(231): IPS\Helpers\Table\_Table->__toString()
#6 /home/x/public_html/x/applications/babble/modules/front/view/view.php(688): IPS\babble\_Rooms::buildRoomArchive(Object(IPS\babble\Rooms\Room))
#7 [internal function]: IPS\babble\modules\front\view\_view->roomArchive()
#8 /home/x/public_html/x/system/Dispatcher/Controller.php(85): call_user_func(Array)
#9 /home/x/public_html/x/applications/babble/modules/front/view/view.php(255): IPS\Dispatcher\_Controller->execute()
#10 /home/x/public_html/x/system/Dispatcher/Dispatcher.php(129): IPS\babble\modules\front\view\_view->execute()
#11 /home/x/public_html/x/index.php(13): IPS\_Dispatcher->run()
#12 {main}
#0 /home/x/public_html/x/init.php(498): IPS\_Log::log('SELECT count(*)...', 'uncaught_except...')
#1 /home/x/public_html/x/system/Helpers/Table/Table.php(477): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 /home/x/public_html/x/applications/babble/sources/Rooms/Rooms.php(231): IPS\Helpers\Table\_Table->__toString()
#3 /home/x/public_html/x/applications/babble/modules/front/view/view.php(688): IPS\babble\_Rooms::buildRoomArchive(Object(IPS\babble\Rooms\Room))
#4 [internal function]: IPS\babble\modules\front\view\_view->roomArchive()
#5 /home/x/public_html/x/system/Dispatcher/Controller.php(85): call_user_func(Array)
#6 /home/x/public_html/x/applications/babble/modules/front/view/view.php(255): IPS\Dispatcher\_Controller->execute()
#7 /home/x/public_html/x/system/Dispatcher/Dispatcher.php(129): IPS\babble\modules\front\view\_view->execute()
#8 /home/x/public_html/x/index.php(13): IPS\_Dispatcher->run()
Recommended Comments