If I perform an extended search in the archive, it returns the following exception:
<<<
SELECT count(*) FROM `ibf_babble_messages` AS `babble_messages` WHERE messages_room=1 and ( ( FIND_IN_SET(4,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 "%%" and ( )
IPS\Db\Exception: 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 ')' at line 1 (1064)
#0 /home/nginx/domains/mydomain.com/public/system/Db/Select.php(356): IPS\_Db->preparedQuery('/*IPS\\Helpers\\T...', Array, true)
#1 /home/nginx/domains/mydomain.com/public/system/Db/Select.php(418): IPS\Db\_Select->runQuery()
#2 /home/nginx/domains/mydomain.com/public/system/Db/Select.php(339): IPS\Db\_Select->rewind()
#3 /home/nginx/domains/mydomain.com/public/system/Helpers/Table/Db.php(312): IPS\Db\_Select->first()
#4 /home/nginx/domains/mydomain.com/public/system/Helpers/Table/Table.php(466): IPS\Helpers\Table\_Db->getRows(Array)
#5 /home/nginx/domains/mydomain.com/public/applications/babble/sources/Rooms/Rooms.php(231): IPS\Helpers\Table\_Table->__toString()
#6 /home/nginx/domains/mydomain.com/public/applications/babble/modules/front/view/view.php(688): IPS\babble\_Rooms::buildRoomArchive(Object(IPS\babble\Rooms\Room))
#7 /home/nginx/domains/mydomain.com/public/system/Dispatcher/Controller.php(86): IPS\babble\modules\front\view\_view->roomArchive()
#8 /home/nginx/domains/mydomain.com/public/applications/babble/modules/front/view/view.php(255): IPS\Dispatcher\_Controller->execute()
#9 /home/nginx/domains/mydomain.com/public/system/Dispatcher/Dispatcher.php(129): IPS\babble\modules\front\view\_view->execute()
#10 /home/nginx/domains/mydomain.com/public/index.php(13): IPS\_Dispatcher->run()
#11 {main}
>>>
Recommended Comments