This is structure of the table before I "fixed".
CREATE TABLE `products` (
`prod_id` int(8) unsigned NOT NULL auto_increment,
`prod_no` varchar(50) NOT NULL default '',
`prod_name` varchar(255) NOT NULL default '',
`prod_description` text,
`prod_colors` text,
`prod_includes` text,
`prod_catalog` varchar(45) default NULL,
`prod_status` enum('hidden','live','new') NOT NULL default 'new',
`prod_supplier` varchar(45) default NULL,
`prod_start_date` date default '0000-00-00',
`prod_end_date` date default '0000-00-00',
`prod_featured` enum('0','1') default NULL,
`on_sale` enum('Yes','No') NOT NULL default 'No',
PRIMARY KEY (`prod_id`),
UNIQUE KEY `prod_no` (`prod_no`),
KEY `products_index1` (`prod_status`),
KEY `products_index2` (`prod_start_date`,`prod_end_date`),
KEY `on_sale` (`on_sale`),
FULLTEXT KEY `prod_search` (`prod_name`,`prod_description`),
FULLTEXT KEY `prod_no_2` (`prod_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6151 ;
And, after I deleted prod_no_2 key (it doesn't make a sence to have it
though) everything was ok. I'm no t getting error message anymore.
-afan
> Key 6 relates to the 6th key, or index, in the CREATE TABLE statement
> for this table:
>
>> >> PRIMARY KEY (`prod_id`),
>> >> UNIQUE KEY `prod_no` (`prod_no`),
>> >> KEY `products_index1` (`prod_status`),
>> >> KEY `products_index2` (`prod_start_date`,`prod_end_date`),
>> >> KEY `on_sale` (`on_sale`),
>> >> FULLTEXT KEY `prod_search` (`prod_name`,`prod_description`),
>> >> FULLTEXT KEY `prod_no_2` (`prod_no`)
>
> "Key" is another name for "Index", so this is about your FULLTEXT index:
>
> FULLTEXT KEY `prod_search` (`prod_name`,`prod_description`)
>
> I noticed that the INSERT you listed was for the products table and
> the CREATE TABLE was for the web_products table.
>
> Just to be sure, please can you post the CREATE TABLE statement for
> the products table?
>
> Im
>
> --
> http://www.atomdatabase.com
> MySQL Database Management & Design Services
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
