MySQL 5.5.21 error

Databases
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?


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


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