Whenever I try to create a table using innodb, i get a 1266 warning that the
table has been created with myisam instead. I receive the error both at the
mysql command line and using the mysql query browser.
I've also tried alterring the table to change the engine , which says it
completes successfully but still has the 1266 warning. eg
alter table pp_related_product_type engine=innodb;
Query OK, 0 rows affected, 1 warning (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show warnings;
+---------+------+-----------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+-----------------------------------------------------------------+
| Warning | 1266 | Using storage engine MyISAM for table
'pp_related_product_type' |
+---------+------+-----------------------------------------------------------------+
1 row in set (0.00 sec)
I'm using mysql Ver 14.12 Distrib 5.0.15, for sun-solaris2.9 (sparc) using
readline 5.0.
Has anyone come across this before ? Any suggestions ?
Thanks
Pierre
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
