Icy Phoenix

Old Support Topics - General Error: DEBUG MODE: SQL Error : 1064

Maese [ Sun 21 Oct, 2007 18:47 ]
Post subject: General Error: DEBUG MODE: SQL Error : 1064

IP version: 1.1.5.20
Site: http://salamancarol.bolhost.com/index.php

Hi!

A new error appeared when i finished updating the IP.
The error is:

Code: [Hide] [Select]

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 '' at line 9

SELECT 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 FROM phpbb_topics AS t, phpbb_posts AS p, phpbb_users AS u WHERE t.forum_id NOT IN ('start') AND t.topic_status <> 2 AND p.post_id = t.topic_last_post_id AND p.poster_id = u.user_id AND t.topic_time <= 1192984848 ORDER BY p.post_time DESC LIMIT

Line : 105

File : blocks_imp_recent_topics.php

and i have no idea of how to fix it :S I've tried to reupdate the IP, but nothing happened (except some other errors that get fixed).

Thank you in advance!
Maese.

Maese [ Mon 22 Oct, 2007 14:05 ]
Post subject: Re: General Error: DEBUG MODE: SQL Error : 1064

I've done some experiments that did nothing but a strange thing happened and now it gives another error O.o

Code: [Hide] [Select]

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 <> 1 AND t.topic_status <> 2 AND t.topic_vote =' at line 4

SELECT t.*, vd.* FROM phpbb_topics AS t, phpbb_vote_desc AS vd WHERE t.forum_id IN () AND t.topic_status <> 1 AND t.topic_status <> 2 AND t.topic_vote = 1 AND t.topic_id = vd.topic_id ORDER BY t.topic_time DESC LIMIT 0,1

Line : 63

File : blocks_imp_poll.php

Maese [ Mon 22 Oct, 2007 14:10 ]
Post subject: Re: General Error: DEBUG MODE: SQL Error : 1064

yeha! I did

But the only bad thing is that i can't have the 'Top posters' and 'recent topics' blocks :S I thing is an error on my BD when updating icy to it latest version...