MySQL new version error

PHP
1

Everything was fine until the hosting company upgraded MySQL to 5.5.21 version.

I don’t wat’s wrong with this query in 5.5.21 version?
Code MySQL:


CREATE TABLE #__hp_temp (
 id INT(11) NOT NULL,
type MEDIUMTEXT NOT NULL,
suburb MEDIUMTEXT NOT NULL,
price MEDIUMTEXT NOT NULL,
pov MEDIUMTEXT NOT NULL,
sead MEDIUMTEXT NOT NULL,
more SET('more') NOT NULL,
PRIMARY KEY  (id)
) TYPE=MyISAM ;

I’m getting error
Code MySQL:


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \\'TYPE=MyISAM\\' at line 10 SQL=CREATE TABLE jos_hp_temp (\
 id INT(11) NOT NULL, \
type MEDIUMTEXT NOT NULL, \
suburb MEDIUMTEXT NOT NULL, \
price MEDIUMTEXT NOT NULL, \
pov MEDIUMTEXT NOT NULL, \
sead MEDIUMTEXT NOT NULL, \
more SET(\\'more\\') NOT NULL, \
PRIMARY KEY (id)\
) TYPE=MyISAM ;

Any idea?

Thanks.

2

The reason your getting an error is because TYPE is now deprecated, instead you need to ENGINE which is now the default standard for creating tables and works all the way back to MySQL 4.