"You have an error in your SQL syntax"

[bilco105]

Hi,

When viewing the newest thread in a forum, I am getting this error...

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT threadid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE forumid IN () AND visible = 1 AND (sticky = 1 OR sticky = 0)
AND lastpost >= -30 AND open <> 10 AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 1

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 visible = 1 AND (sticky = 1 OR sticky = 0)
AND lastpo

mysql error number: 1064

Date: Thursday 09th of December 2004 11:21:11 AM
Script: http://www.amsterdamaged.net/forums/...ost&forumid=29
Referer:
Username: bilco105
IP Address: xx.xx.xx.xxx

Now, I have not touched this (or atleast I dont think I have) however I have imported from another system using impex.

Any ideas?

[Zachery]

Go into the AdminCP > Import & Maitence > Repair / Optmize Database > Check All, hit continue.


Then go to Forums & Moderators > Forum Manager > Edit a forum and save.

[bilco105]

Then go to Forums & Moderators > Forum Manager > Edit a forum and save.

Just one forum, Or all the ones I am having problems with.

Thanks for the awesomely fast responce by the way

[Zachery]

Anyone, I am gessing the forumid's were not properly rebuilt after the import. So I am guessing that this may fix it, it may not however.

[bilco105]

Thanks for your help..

Unfortunetly the error is still occuring

[Zachery]

And you are still using all stock templates and files?

[bilco105]

I havn't installed any hacks to produce that error, I have two installed over the past 20minutes though, but the error was already occuring.

I have a custom template from cpstyles or something like that

[Zachery]

1. Restore all ORIGINAL FILES, we do not provide support for hacked instalitions, and as it was working prior to the hacks I can only assume its them

2. Add a new style with no parrent

AdminCP > Styles & Templates > Style Manager > [ Add New Style ]

Change to the new style and see if the bug is still happening

[bilco105]

I will do a second install and use the same database, We can see if there are any errors that way.

[Zachery]

A second install ont he same database is not going to fix the issue, as it will probaly whipe out your forums, it will be much simpler to just upload the default files and create a defautl style.

[bilco105]

The reason I'm installing it the files, Is because its only the files I have modified.

The theme has no relation to a mysql database, I have the new files and am getting exactly the same error

http://www.amsterdamaged.net/forums_tmp/showthread.php?goto=lastpost&forumid=10

However, I have not changed the theme because for some reason it wont allow me to upload the default theme aswell.

But as I mentioned, I havn;t changed anything in the theme that would affect a mysql statement

[Steve Machol]

Reupload the original showthread.php file from the vB zip file. Make sure you upload in ASCII and overwrite the one on the server.