EX1064 Что-то пошло не так. Пожалуйста, попробуйте еще раз.

12 ноября 2021

Привет всем. Получаю эту ошибку Статистика - Форум - Новые темы - Solved Topics By Forum

Скрытый текст

Журналы системы

SELECT SQL_BIG_RESULT DATE_FORMAT( CONVERT_TZ( FROM_UNIXTIME( IFNULL( solved_date, 0 ) ), @@session.time_zone, 'Europe/Moscow' ), '%Y-%c' ) AS time_as_alias, , forum_id FROM `core_solved_index`  LEFT JOIN `forums_topics` ON comment_class='\IPS\forums\Topic\Post' and core_solved_index.item_id=forums_topics.tid WHERE ( state NOT IN('link','merged') ) AND ( approved NOT IN(-2,-3) ) AND solved_date>0 AND solved_date>1628974702 AND solved_date<1636750702 GROUP BY `time_as_alias`,`forum_id` ORDER BY time_as_alias ASC
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 ' forum_id FROM `core_solved_index`  LEFT JOIN `forums_topics` ON comment_class=?' at line 1 (1064)
#0 /www/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*_www::...', Array, true)
#1 /www/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /www/system/Helpers/Chart/Database.php(322): IPS\Db\_Select->rewind()
#3 /www/system/Helpers/Chart/Database.php(548): IPS\Helpers\Chart\_Database->compileForOutput()
#4 /www/system/Helpers/Chart/Dynamic.php(489): IPS\Helpers\Chart\_Database->getOutput()
#5 /www/applications/forums/modules/admin/stats/topics.php(193): IPS\Helpers\Chart\_Dynamic->__toString()
#6 /www/system/Dispatcher/Controller.php(101): IPS\forums\modules\admin\stats\_topics->manage()
#7 /www/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#8 /www/admin/index.php(13): IPS\_Dispatcher->run()
#9 {main}

Трассировка

#0 /www/init.php(1004): IPS\_Log::log('SELECT SQL_BIG_...', 'uncaught_except...')
#1 /www/system/Helpers/Chart/Dynamic.php(517): IPS\IPS::exceptionHandler(Object(IPS\Db\Exception))
#2 /www/applications/forums/modules/admin/stats/topics.php(193): IPS\Helpers\Chart\_Dynamic->__toString()
#3 /www/system/Dispatcher/Controller.php(101): IPS\forums\modules\admin\stats\_topics->manage()
#4 /www/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#5 /www/admin/index.php(13): IPS\_Dispatcher->run()
#6 {main}

Где проблема? :stena: