Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
Reply with quote Download Post 
Post 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: [Download] [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.
 



 
MaeseSend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post 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: [Download] [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

 



 
MaeseSend private message  
Back to topPage bottom
Reply with quote Download Post 
Post 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...
 



 
MaeseSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron