942,959 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Unsolved
  • Views: 4572
  • PHP RSS
Dec 3rd, 2004
0

Invision Power Board mysql error when trying to view newly created forums

Expand Post »
Well first some background, this hasn't happened before but last night I had some trouble installing a shoutbox mod so I undid all the steps I had performed I have also installed a search engine friendly mod successfuly which makes php links html links even though I know ipb supposedly has such a feature built in but this supposedly helps with getting the forum indexed in a search engine even more and this mod never caused this problem so I suspect something happened when I tried installing the shoutbox mod and I backtraced my steps undoing each one as I went. The error I get is:

There appears to be an error with the database.
You can try to refresh the page by clicking here.

Error Returned

mySQL query error: SELECT t.topic_id, t.pid, p.post FROM ibf_posts t LEFT JOIN ibf_posts p ON (p.pid=t.pid) WHERE t.topic_id IN () AND t.new_topic=1 AND t.queued=0

mySQL error: You have an error in your SQL syntax near ') AND t.new_topic=1 AND t.queued=0' at line 1
mySQL error code:
Date: Friday 03rd of December 2004 08:08:51 AM

We apologise for any inconvenience

and only happens with two staff only forums which as such I'm reluctant to link to and one public forum which can be found here: http://www.johnscompany.net/gamerzdr...rself-f36.html - any ideas on where this error is and if so how I can fix it? Any help is greatly appreciated.

Thanks!

P.S. The shoutbox mod I attempted to install is: http://mods.invisionize.com/db/index.php/f/3305
Similar Threads
Reputation Points: 21
Solved Threads: 2
Posting Whiz in Training
hexstar is offline Offline
212 posts
since Aug 2004
Dec 5th, 2004
0

Re: Invision Power Board mysql error when trying to view newly created forums

You have broken some PHP somewhere as the below part of the SQL statement:
[php]
t.topic_id IN ()
[/php]

should not be blank when submitted to MySQL.

Id suggest reuploading the original files you edited and starting again with any hacks
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Shorty is offline Offline
3 posts
since Oct 2004
Dec 5th, 2004
0

Re: Invision Power Board mysql error when trying to view newly created forums

ahh thanks for the tip, turns out that it's a bug from a mod I installed which shows a preview of the thread when you hover over its link, that error occurs whenever a forum's empty and the mod's installed
Reputation Points: 21
Solved Threads: 2
Posting Whiz in Training
hexstar is offline Offline
212 posts
since Aug 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: configure phpmailer
Next Thread in PHP Forum Timeline: Needed WSIWYG editor for PHP web pages, help Please





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC