Announcement

Collapse
No announcement yet.

SQL Errors while using Search Function

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

  • mayhemmike
    replied
    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...

    Leave a comment:


  • mayhemmike
    replied
    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...

    Leave a comment:


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

    Leave a comment:


  • mayhemmike
    started a topic SQL Errors while using Search Function

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X