Hi,
I was wondering if it were possible to take the .sql file from IPB and just convert it to SMF...cause I deleted all of the IPB files, and I'm on dialup, and it is really messed up if I have to reinstall it again..
dk
Just import the database dump through phpMyAdmin, then put the following information in a file called conf_global.php and upload it to the directory where IPB was stored:
$INFO['sql_database'] = '{database name}';
$INFO['sql_tbl_prefix'] = '{database table prefix}';
$INFO['admin_group'] = '{id of administrators group in IPB}';
$INFO['upload_dir'] = '{directory where attachments were uploaded}';
However, since you said you deleted all your old IPB files, if you had any attachments or uploaded avatars, and you deleted those folders, you might run into problems with the converter...
what is the "Id of admins group in IPB"??
cause its giving me errors, etc.
IPB and SMF are in the same database.
dk
Ok..I took away the brakets, and uploaded the installers, now its importing the members and:
QuoteCaused the error:
Unknown column 'pm_email_notify' in 'field list'
Make sure you're using the correct converter for the version of SMF you're converting to. If you want to convert to 1.0.5, then use the one on the download page (under "Tools and Converters"). It sounds like you're trying to use a 1.1 converter with 1.0.5 (the column is called im_email_notify in 1.0.5, but the 1.1 converter won't work even if you rename the column because other tables have additional columns in 1.1 that aren't in 1.0.5).
I got it imported, but now I can't access the admin panel.
I think I know why...I don't know the "$INFO['admin_group'] = '{id of administrators group in IPB}';
"
id of administrators thing...whats the default for IPB?
No clue.
Since you can't access the admin panel though:
UPDATE smf_members SET ID_GROUP = '1' WHERE memberName = 'you';
Replace "you" with your username.
Quote from: Oldiesmann on September 24, 2005, 12:06:37 PM
Just import the database dump through phpMyAdmin, then put the following information in a file called conf_global.php and upload it to the directory where IPB was stored:
$INFO['sql_database'] = '{database name}';
$INFO['sql_tbl_prefix'] = '{database table prefix}';
$INFO['admin_group'] = '{id of administrators group in IPB}';
$INFO['upload_dir'] = '{directory where attachments were uploaded}';
However, since you said you deleted all your old IPB files, if you had any attachments or uploaded avatars, and you deleted those folders, you might run into problems with the converter...
I will try this too. My inv 2 (trial) forum is in deep trouble.
How will I import the sql ? as its > 250mb
Will phpmyadmin import it . i had tried a few yrs back, and got a run time error.
Thanks for the info. :)
If you can send me your database dump, I can split it up into several smaller dumps for you so you can import it without getting any errors...