https://www.icyphoenix.com/viewtopic.php?f=35&t=2971
-----------------------------------
Maese
Sun 21 Oct, 2007 18:47

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 linenumbers=false]
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
[/code]


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

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 linenumbers=false]
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
[/code]


-----------------------------------
Maese
Mon 22 Oct, 2007 14:10

Re: General Error: DEBUG MODE: SQL Error : 1064
-----------------------------------
yeha! I did :D


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...