SQL Errors while using Search Function

[mayhemmike]

Here is the error I get:

Invalid SQL:
SELECT threadid AS itemid, forumid,
IF(postuserid = 1, 'self', 'other') AS starter
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
WHERE threadid IN(29195, 28825, 29193, 23171, 18171, 23435, 29166, 29099, 28521, 29185, 29111, 29153, 29174, 28917, 29192, 29196, 29078, 29177, 29171, 25448, 29181, 29179, 29061, 29066, 29191, 29199, 29194, 29003, 29137, 29198, 29197, 28616, 29065, 29173, 29159, 18012, 29119, 29189, 29183, 28676, 28653, 29178, 29190, 29155, 29164, 29144, 29163, 29182, 28755, 28166, 29028, 28647, 10480, 27739, 29075, 28700, 29188, 29105, 29187, 29186, 29175, 29180, 29172, 29011)
AND delthread.primaryid IS NULL
AND thread.open <> 10
AND thread.visible = 1
AND thread.postuserid NOT IN (7818,14330,14571,14512,10883,11130,9876,14065,10105,11236,9647,11580,11153,8469,9973,3152 ,14734))

Any suggestions greatly appreciated.

Mike....
www.musclemayhem.com/forums
vBulletin Version 3.0.7

[Jake Bunce]

There should be more details in the error, including a MySQL error code. Can you post the whole error?

[mayhemmike]

Here you go:

Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT threadid AS itemid, forumid,
IF(postuserid = 1, 'self', 'other') AS starter
FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
WHERE threadid IN(29195, 28825, 29193, 23171, 18171, 23435, 29166, 29099, 28521, 29185, 29111, 29153, 29174, 28917, 29192, 29196, 29078, 29177, 29171, 25448, 29181, 29179, 29061, 29066, 29191, 29199, 29194, 29003, 29137, 29198, 29197, 28616, 29065, 29173, 29159, 18012, 29119, 29189, 29183, 28676, 28653, 29178, 29190, 29155, 29164, 29144, 29163, 29182, 28755, 28166, 29028, 28647, 10480, 27739, 29075, 28700, 29188, 29105, 29187, 29186, 29175, 29180, 29172, 29011)
AND delthread.primaryid IS NULL
AND thread.open <> 10
AND thread.visible = 1
AND thread.postuserid NOT IN (7818,14330,14571,14512,10883,11130,9876,14065,10105,11236,9647,11580,11153,8469,9973,3152 ,14734))

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 ')' at line 9
mysql error number: 1064
Date: Saturday 18th of June 2005 04:30:21 PM
Script: http://www.musclemayhem.com/forums/s...earchid=282025
Referer: http://www.musclemayhem.com/forums/s...ad.php?t=18171
Username: mike
IP Address: *******

Thanx!

Mike...

[mayhemmike]

Found the Problem

Had a Parentesise at the end of a line in my Tachy goes to Coventry.

All fixed now.

Thanx for yoiur quick response and willingness to help.

Mike...