A Flash Developer Resource Site

Results 1 to 4 of 4

Thread: PHP/MYSQL FULLTEXT problem

  1. #1
    Who needs pants? hooligan2001's Avatar
    Join Date
    Apr 2001
    Location
    Somewhere
    Posts
    1,976

    PHP/MYSQL FULLTEXT problem

    I have a PHP file that sets up a few tables and when i run the script i get
    this error

    "The used table type doesn't support FULLTEXT indexes"

    What does it mean?

    Heres the code that sets up the table

    CREATE TABLE IF NOT EXISTS cms_articles (
    article_id int(11) NOT NULL auto_increment,
    author_id int(11) NOT NULL default '0',
    is_published tinyint(1) NOT NULL default '0',
    date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
    date_published datetime NOT NULL default '0000-00-00 00:00:00',
    title varchar(255) NOT NULL default '',
    body mediumtext NOT NULL,
    PRIMARY KEY (article_id),
    KEY IdxArticle (author_id,date_submitted),
    FULLTEXT INDEX IdxText (title,body)
    )

    Thanks in Advance

  2. #2
    Who needs pants? hooligan2001's Avatar
    Join Date
    Apr 2001
    Location
    Somewhere
    Posts
    1,976
    I looked up the error on the mysql error page and it doesnt really explain anything. Anyone have an idea

  3. #3
    im not sure but id try changing this line
    title varchar(255) NOT NULL default ''
    to
    title mediumtext NOT NULL default '',
    *shrug*

  4. #4
    Who needs pants? hooligan2001's Avatar
    Join Date
    Apr 2001
    Location
    Somewhere
    Posts
    1,976
    Just tried it and it didnt seem to work. This is really obthering me because i cant move on unless i work out why its doing this. Thanks for trying though.

    Anyone else know what could be the problem

Posting Permissions

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




Click Here to Expand Forum to Full Width

HTML5 Development Center