What version of phpBB are you using? phpBB 3.2.0
What is your board's URL? http://localhost
Who do you host your board with? Offline server for testing purposes
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.0.8
What styles do you currently have installed? prosilver
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? I have a local copy of my forum installed for testing purposes as I am looking into upgrading my forum from v3.0.8 to 3.2. I downloaded the full v3.2 package and used the Update Database Only option. Everything seems to be working fine other than when I try to view a forum and I get the error listed further below.
Please describe your problem. I get the following error when I try to view a forum page (i.e. viewforum.php):
Code: Select all
General Error
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 50' at line 4 [1064]
SQL
SELECT t.topic_id FROM (phpbb_topics t) WHERE t.forum_id = 22 AND t.topic_type IN (0, 1) AND 1 = 1 ORDER BY t.topic_type DESC, ASC LIMIT 50
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
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: 654
CALL: phpbb\db\driver\factory->sql_query_limit()