SMF Support > Converting to SMF

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

(1/4) > >>

webewitch:
Hi
I'm trying to convert a snitz to smf.
The converter seems to require the same user for the snitz db and the blank smf db.
I'm with Fasthosts and it won't let me have the same user for different dbs.
What to do?

Elmacik:
A quick way to go:

1- Run a local webserver on your computer, a best way is using a LAMP/WAMP solution. (For example XAMPP for Windows.)
2- Download your Snitz database backup into your computer and put in an appropriate place (or restore on MS SQL)
3- Create a MySQL DB for SMF having the same username/password combination with your Snitz backup.
4- Convert! (Locally of course.)
5- Setup an SMF forum in your host.
6- Restore your local SMF DB to your host.
7- Use repair_settings.php to repair broken things.

Another efficient way is altering the convert.php to support different username/password pairs for different databases. This will require some time and familiarity with the code. (I planned to do it but didn't have enough time.)

webewitch:
Hi
Almost there, up to the conversion point. I have MAMP running on my iMac. But keep getting the following error on conversion:

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:
Try altering that line to:


--- Code: ---) ENGINE=MyISAM;
--- End code ---

webewitch:
I tried that but still get the same error which I find strange. I'm changing the 'snitz_to_smf.sql' file in htdocs in the main MAMP directory. Any ideas?

Navigation

[0] Message Index

[#] Next page