Page 1 of 1

Forums Error

PostPosted: Tue Jan 30, 2007 3:03 am
Author: DjPorkchop
Your phpBB Version: 2.0.
phpBB Type: Standard phpBB
MODs: No
Your knowledge: Beginner
Board URL: http://www.mweva.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
Installed Power Metal


What was done to try to solve the problem?
Restored my files and DB and made sure Powermetal wasnt to be found, tried to edit a file and still the same issue. Powermetal wasnt my problem.



De.scription and Message

General Error
Midwest Virtual Forum Index ÂÂÂ » General Error
General Error

Could not query recent topics information

DEBUG MODE

SQL Error : 1064 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 ') AND t.topic_status <> 2 AND p.post_id = t.topic_l

SELECT u.user_group_id, u.user_session_time, t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username, p.post_username FROM phpbb_topics AS t LEFT OUTER JOIN phpbb_approve_posts AS a ON (t.topic_first_post_id = a.post_id), phpbb_posts AS p, phpbb_users AS u WHERE t.forum_id NOT IN () AND t.topic_status <> 2 AND p.post_id = t.topic_last_post_id AND p.poster_id = u.user_id AND a.post_id is NULL AND t.topic_time <= 1170153114 ORDER BY p.post_time DESC LIMIT 10

Line : 119
File : blocks_imp_recent_topics.php


Midwest Virtual Forum Index ÂÂÂ » General Error


Thats what I get when trying to create or edit a foum. If I put up all Categories only and no forums, Im fine. <img>

And please understand I have 2 other websites running on my server as well and Im getting that very same sql error
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
rather frequently. Maybe I got server issues?