Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2010
    Posts
    3

    Unanswered: You have an error in your SQL syntax

    can anybody please dubug the error in this script


    Code:
    SQL Error: 1064 - 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 ''Technology\' IN BOOLEAN MODE)
                                                           LIMIT 1' at line 6
    Query: SELECT `mybb_threads`.fid, `mybb_threads`.tid, `mybb_threads`.tag, `mybb_threads`.subject,
                                                           `mybb_forumpermissions`.canview
                                                           FROM
                                                           `mybb_threads` LEFT JOIN `mybb_forumpermissions` ON `mybb_forumpermissions`.canview = 0
                                                           WHERE
                                                           MATCH (`mybb_threads`.subject) AGAINST ('Technology\' IN BOOLEAN MODE)
                                                           LIMIT 1
    please i want to debug script error ...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try removing the escape character \ in Technology\'
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2004
    Posts
    480
    I'd guess your error is here:
    FROM
    Code:
    `mybb_threads` 
    LEFT JOIN 
    `mybb_forumpermissions` 
    ON `mybb_forumpermissions`.canview = 0
    you haven't specified which column in mybb_threads is being joined.

  4. #4
    Join Date
    Jul 2010
    Posts
    7
    If you need 'Technology\' in your query string, use 'Technology\\' instead.

    check this site for more SQL programming information:
    Learn SQL

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sqlfan View Post
    check this site ...
    is that your web site?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •