SMF Support > Converting to SMF

how can I use the converter if I'm not allowed to use same user?

<< < (2/4) > >>

Elmacik:
Hmm I wonder if "type" column causes a conflict here since it's a MySQL keyword. Would you try to alter this line:


--- Code: ---    type varchar(80) NOT NULL default ''
--- End code ---

To this:


--- Code: ---    `type` varchar(80) NOT NULL default ''
--- End code ---

webewitch:
Hi, still the same error I'm afraid.   :(
Do I have to restart the server when I have altered the file?

Elmacik:
I tried the query on my server and it ran without any problem. Have you changed all of the instances of "TYPE=MyISAM" to "ENGINE=MyISAM" in the file? And what exact message do you get when you run the query using engine key?

webewitch:
Hi
There only seems to be be one instance of "TYPE=MyISAM and I have changed that to "ENGINE=MyISAM".
The  error I'm getting is:

Converting members... Unsuccessful!
This query:

    CREATE TABLE IF NOT EXISTS `smf`.smf_convert (
    old_id_topic int(10) unsigned NULL default '0',
    old_id_msg int(10) unsigned NULL default '0',
    msg_date bigint(20) unsigned NULL default '0',
    type varchar(80) NOT NULL default ''
    ) TYPE=MyISAM;

Caused the 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 6

Elmacik:
As you see, there are still instances of TYPE=MyISAM in somewhere. Did you edit both convert.php and the SQL file?

Navigation

[0] Message Index

[#] Next page

[*] Previous page