Sql Error 1191 Plz help

Discussion in 'MySQL' started by fundl, Dec 9, 2008.

0
  1. #1
    i have recently upgraded my script to latest version,everything was gone right & script successfully installed,but now the problem is whenever im opening "READ MORE" Link of any article it's giving the following error,

    MySQL Error!
    ------------------------

    The Error returned was:
    Can't find FULLTEXT index matching the column list

    Error Number:
    1191

    SELECT id, title, date, alt_name FROM dle_post WHERE MATCH (short_story, full_story) AGAINST ('RAAZ-2 (The Mystery Continues) RAAZ-2 (The Mystery Continues)Single Song HQ SoundDownload:[hide]>>> DOWNLOAD NOW <<') AND id != 869 AND approve='1' AND date < '2008-12-09 16:26:58' LIMIT 5

    ------------------------------------------------

    Can anyone plz help what should i do this to fix the problem!!!!
    Plz Plz help me im in big trouble!
     
    fundl, Dec 9, 2008 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    you need to create a fulltext fields
    adapt it
    CREATE fulltext index something ON table (fields, here, dude)
     
    crivion, Dec 9, 2008 IP