SMF Support > Converting to SMF

Need some help

(1/1)

phrequency:
I'm trying to upgrade IPB to convert to SMF and I'm getting this error:

2 errors found

CREATE TABLE ibf_skin_url_mapping ( map_id    INT(10) NOT NULL auto_increment, map_title    VARCHAR(200) NOT NULL default '', map_match_type   VARCHAR(10) NOT NULL default 'contains', map_url    VARCHAR(200) NOT NULL default '', map_skin_set_id   INT(10) UNSIGNED NOT NULL default '0', map_date_added   INT(10) UNSIGNED NOT NULL default '0', PRIMARY KEY (map_id) ) TYPE=MyISAM;

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 9

CREATE TABLE ibf_skin_template_links ( link_id    INT(10) UNSIGNED NOT NULL auto_increment, link_set_id    INT(10) UNSIGNED NOT NULL default '0', link_group_name VARCHAR(255) NOT NULL default '', link_template_name VARCHAR(255) NOT NULL default '', link_used_in VARCHAR(255) NOT NULL default '', PRIMARY KEY (link_id) ) TYPE=MyISAM;

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 8

I read that I have to change TYPE to ENGINE, but I'm not quite sure if that'll fix it.

TE:
phrequency, is this still an issue? AFAIK the IPB upgrade script needs to be modified. You're using a newer MySQL version where TYPE=MyISAM isn't supported anymore (needs to be ENGINE=MyISAM instead). Since it's a problem with IPB I'd recommend to ask the IPB folks for support..

Navigation

[0] Message Index