after updating a board from phpbb 3.0 to phpbb 3.1 and later to phpbb 3.2
I get this error by clicking on any forum (if instead I click on a topic, it works correctly):
Code: Select all
[phpBB Debug] PHP Notice: in file [ROOT]/viewforum.php on line 627: Undefined index: b
[phpBB Debug] PHP Notice: in file [ROOT]/viewforum.php on line 633: Undefined index: b
SQL ERROR [ mysqli ]
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 'ASC LIMIT 20' at line 4 [1064]
SQL
SELECT t.topic_id FROM (phpbb_topics t) WHERE t.forum_id = 206 AND t.topic_type IN (0, 1) AND (t.topic_visibility = 1) ORDER BY t.topic_type DESC, ASC LIMIT 20
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()
FILE: [ROOT]/viewforum.php
LINE: 695
CALL: phpbb\db\driver\factory->sql_query_limit()