Announcement

Collapse
No announcement yet.

SQL Errors while using Search Function

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL Errors while using Search Function

    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

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

    Comment


    • #3
      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...

      Comment


      • #4
        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...

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X