Invalid SQL error in VB 2.3.2

[ChAiN LeTtEr]

Hello,

We switched hosts awhile back and had someone move our forum over. Since then, we've had errors. We can't add new styles and when you try and search for all posts by a user, we get an error. Here is one:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
LEFT JOIN thread ON thread.threadid=post.threadid WHERE post.visible=1 AND post.threadid= AND 1=1 AND NOT (thread.forumid='3' OR thread.forumid='14' OR thread.forumid='83' OR thread.forumid='31' OR thread.forumid='32' OR thread.forumid='76' OR thread.forumid='36' OR thread.forumid='42') AND post.userid='1804'
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 1=1 AND NOT (thread.forumid='3' OR thread.forumid='14' OR

mysql error number: 1064

Date: Wednesday 24th of August 2005 06:54:00 PM
Script: http://www.theoc-boards.com/forum/fo...searchid=57270


Any ideas?

Thanks in advance!

I just realized that link has /forum/forum/search.php which is probably not right. But why does it show up like that? When you copy the link location of the search for a certain user, it is this: http://www.theoc-boards.com/forum/se...er&userid=2252 Only 1 /forum/.

Hmm

Actually, have 2 errors. Here's the second:

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: INSERT INTO style (styleid,title,replacementsetid,templatesetid,user select) VALUES (NULL,'TestingJenny','90','1','0','justtesting','y uptesting')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Wednesday 24th of August 2005 07:22:27 PM
Script: http://www.theoc-boards.com/forum/forum/admin/style.php
Referer: http://www.theoc-boards.com/forum/ad...?action=add&s=

Any ideas?