Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

General Error: DEBUG MODE: SQL Error : 1064

Reply to topic

 

Maese
Quote
Posts: 8
Sun 21 Oct, 2007 18:47
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: [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.

Profile PM  
Maese
Quote
Posts: 8
Mon 22 Oct, 2007 14:05
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: [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

Profile PM  
Maese
Quote
Posts: 8
Mon 22 Oct, 2007 14:10
Subject: 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...

Profile PM  
Reply to topic
 

Page 1 of 1


  
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

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.2745s (PHP: 6% SQL: 94%)
SQL queries: 10 - Debug Off - GZIP Enabled