FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


have problem on my sql





skynet
don't know y.. my site worked nice.. i have a IBHEB power.. and now it's write me this when i enter to the site:
mySQL query error: SELECT ibf_topics.*,ibf_forums.name as forumname FROM ibf_topics LEFT JOIN ibf_forums ON ibf_forums.id=ibf_topics.forum_id WHERE ibf_forums.id IN () AND ibf_topics.approved=1 GROUP by ibf_topics.tid order by last_post DESC LIMIT 0,10

mySQL 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 ') AND ibf_topics.approved=1 GROUP by ibf_topics.tid order by la
mySQL error code:
Date: Friday 22nd of July 2005 11:14:39 PM
n0obie4life
Which page is it causing that error on?

Make a copy of that page and post it in .txt form.
skynet
here i took picture of this problam.. and this appeard at index.. this happend when i try to enter my site...
here is the picture:
http://img152.imageshack.us/my.php?image=problam7kr.jpg
Bondings
http://skynet.frihost.net/ is where he gets the problem.
cool-online
It's not releated with frihost's mysql. It's your IPB problem.
If you intalled some mods, check your mods and redo!
skynet
oh ok... so it's not the mysql server problem??
sure?
Bondings
skynet wrote:
oh ok... so it's not the mysql server problem??
sure?

Most likely not, but that doesn't solve your problem. Wink

But I have no idea how to make that forum work. Sad
skynet
damn.. Sad
ammm... ok.. thank u all.. i will rty to reinstall the forum..
that u
n0obie4life
Most prolly an extra

Code:
'
or something in the SQL syntax. Can you get a txt replica of index.php?

Rename index.php --> index.txt
skynet
look.. at the error message it's write that ibf_forums.name and at ibf_topics there is a problam.. but when i check at my cpanel at database if there a problem it'swrite me that the all files are ok.. can someone plz say me what is the problem?? plz.. Sad
skynet
plz.. can someone answer me..?
mathiaus
Maybe you should Try the IPB forums for help from them as they actually use it! Rolling Eyes
http://forums.invisionboard.com/
skynet
yea.. i tried to.. but i can't type there ... don't know why
Related topics
I can't upload my Database SQL script ! Helllppppp!!!!
Forum Problem
SQL
SQL and PHP
Sql Error: 1017. Missing all the indexes files of phpbb
How to edit SQL files?
MySql to SQL
.sql problem
phpBB problem
MySQL problem :'(
SQL error on my site
phpmyadmin upload problem
Problem with my SQL Server (not Frihost)
Strange SQL cursor problem. Pls do not ignore if can help.
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.