[itdoell]

I'm trying to create a search using match and against, while creating a ranking system. I'm using SQL running on MAMP and using Querious for database management.

Does anyone have any idea how I could possibly fix this...? Any help is appreciated, thank you.

[AdaHacker]

You omitted the one detail that actually matters here: what type of table are you trying to create the index on? If you're not sure, you can check it by running SHOW CREATE TABLE <tablename>. Fulltext indexes are only supported on MyISAM tables. I'm guessing your table is probably InnoDB. If so, you're just going to have to change it to MyISAM.

[itdoell]

AdaHacker, on 14 August 2011 - 05:09 AM, said:

You omitted the one detail that actually matters here: what type of table are you trying to create the index on? If you're not sure, you can check it by running SHOW CREATE TABLE <tablename>. Fulltext indexes are only supported on MyISAM tables. I'm guessing your table is probably InnoDB. If so, you're just going to have to change it to MyISAM.

All that shows up when I run that query is...

Table: posts
Create Table CREATE TABLE 'posts' (

I know nothing about MyISAM or InnoDB and do not know how to change them.

[AdaHacker]

itdoell, on 14 August 2011 - 04:45 PM, said:

All that shows up when I run that query is...

Huh? You left out the important part! The "ENGINE=" at the end is what you need to know. The results should look roughly like this:

mysql> SHOW CREATE TABLE test1;
+-------+-----------------------------------------------+
| Table | Create Table                                  |
+-------+-----------------------------------------------+
| test1 | CREATE TABLE `test1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `val` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------+
1 row in set (0.00 sec)

The "ENGINE" parameter tells you what storage engine was used to create the table. In this example, it was MyISAM, which is what your table needs to be to support fulltext indexes. YOu can change the storage engine with a simple ALTER TABLE statement:

ALTER TABLE test1 Engine=MyISAM

Quote

I know nothing about MyISAM or InnoDB and do not know how to change them.

Then you should read up on them. MySQL supports a number of storage engines, each with different capabilities and limitations. MyISAM and InnoDB are the two most widely used. It would be a good idea to do your homework on the two in order to avoid any unintended consequences.