# A webserver or web hosting account running on any major Operating System with support for PHP
# A SQL database system, one of:
* MySQL 3.23 or above (MySQLi supported)
* PostgreSQL 7.x
* SQLite
* Firebird 1.5+/Interbase 7.1+
* MS SQL Server 2000 or above (directly or via ODBC)
* Oracle
clicking the "View new posts | View your posts" Links generates a sql error.
Clicking "View new posts" produces this error
General Error
SQL ERROR [ mysql ]
You have an error in your SQL syntax near ')) ORDER BY t.topic_last_post_time DESC LIMIT 1001' at line 5 [1064]
SQL
SELECT DISTINCT t.topic_last_post_time, p.topic_id FROM phpbb_topics t, phpbb_posts p WHERE p.post_time > 1150803667 AND t.topic_id = p.topic_id AND (p.post_approved = 1 OR p.forum_id NOT IN ()) ORDER BY t.topic_last_post_time DESC LIMIT 1001
BACKTRACE
FILE: includes/db/mysql.php
LINE: 104
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 152
CALL: dbal_mysql->sql_query()
FILE: search.php
LINE: 378
CALL: dbal_mysql->sql_query_limit()
Clicking "View your posts" produces this error
General Error
SQL ERROR [ mysql ]
You have an error in your SQL syntax near ')) ORDER BY t.topic_last_post_time DESC' at line 9 [1064]
SQL
SELECT t.*, f.forum_id, f.forum_name, tp.topic_posted, tt.mark_time, ft.mark_time as f_mark_time FROM phpbb_topics t LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) LEFT JOIN phpbb_topics_posted tp ON (tp.user_id = 2 AND t.topic_id = tp.topic_id) LEFT JOIN phpbb_topics_track tt ON (tt.user_id = 2 AND t.topic_id = tt.topic_id) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) WHERE t.topic_id IN (3, 1, 2) AND (t.topic_approved = 1 OR t.forum_id NOT IN ()) ORDER BY t.topic_last_post_time DESC
BACKTRACE
FILE: includes/db/mysql.php
LINE: 104
CALL: dbal->sql_error()
FILE: search.php
LINE: 547
CALL: dbal_mysql->sql_query()
