[SMF Converter] IPB 2.3.x

[quercus]

Getting there I think:
Converting settings...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/hussars/public_html/forums2/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: variable

[ThorstenE]

ok, let's try it without settings (just the forum name and some general information, nothing special)...

[quercus]

*Sigh*
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting smileys... Successful.
Converting attachments...
Notice: Use of undefined constant attachmentUploadDir - assumed 'attachmentUploadDir' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40

Warning: filesize() [function.filesize]: stat failed for attachmentUploadDir/35_e5a8e6067b12d75363b127c213bc3b2a1e11a16c in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40
Wrong value type sent to the database. Integer expected. (size)

[ThorstenE]

next one, another two bugs fixed 

[quercus]

Excellent - that seems to have finally (more or less) cracked it.
The bb code seems a bit messed up and there are lots of custom images and groups that need to be sorted out, but the basic forum has been converted.

Now I just need to figure out how the member groups, permissions and codes within SMF work!
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?

[ThorstenE]

By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?

Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube

[Nakto]

By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?

Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube

why when I update 2.3.6 to smf 2.0 users passwords is changed. it is not good

[ThorstenE]

Nakto,
SMF and IPB are using different password encrytions but SMF should be able to read the old IPB passwords. At first time login the password will be updated to SMF's encryption.

[Nakto]

sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?

[ThorstenE]

sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?

no clue, maybe the password_salt in IPB has more than 5 characters..

added a modified version of the converter, please try the attached file.

[Nakto]

maybe the password_salt in IPB has more than 5 characters..

yes, my pass have more 5 characters.

added a modified version of the converter,

without any changes

when i converted forum to smf , converter have a error :

Code Select Expand

Notice: Undefined variable: oldAvatarDir in /home/user566952/smf/convert.php(1254) : eval()'d code on line 58

Warning: copy(/av-124.jpg) [function.copy]: failed to open stream: No such file or directory in /home/user566952/smf/convert.php(1254) : eval()'d code on line 59
Successful.
Recalculating forum statistics... Successful.

[Nakto]

maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only  а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt

[ThorstenE]

without any changes

You'd better checked my file:

Code Select Expand

ALTER TABLE {$to_prefix}members
CHANGE COLUMN passwd passwd varchar(64) NOT NULL default '',
CHANGE COLUMN password_salt password_salt varchar(64) NOT NULL default '';

maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only  а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt

password_salt is a field in SMF (table smf_members)

Which charset / language is your forum?

[Nakto]

Which charset / language is your forum?

IPB and SMF in win-1251 / english

[ThorstenE]

win-1251 / english

That's most likely the reason.

I'm sorry, but you'll have to use the "forgotten password" link.

[Frank496]

I have an ipb sql database and an smf sql database combined as one.  I need to convert the ipb to smf but it seems to cause errors because of duplicate member ids.  Is there a way around this?

[R1cho]

hi , where can i download the convert.php file? i tried clicking the link on your first post and i just keep going in circles clicking on links 

[0djvu0]

Hi,
i get this error: Unknown system variable 'SQL_MAX_JOIN_SIZE'
What to do? IPB 2.3.6 use XAMPP

[margarett]

Are you using this converter?
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_invision23_converter.zip

In convert.php you should find:

Code Select Expand


// Attempt to allow big selects, only for mysql so far though.
if ($smcFunc['db_title'] == 'MySQL')
{
$results = $smcFunc['db_query']('', "SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE", 'security_override');
list($big_selects, $sql_max_join) = $smcFunc['db_fetch_row']($results);

// Only waste a query if its worth it.
if (empty($big_selects) || ($big_selects != 1 && $big_selects != '1'))
$smcFunc['db_query']('', "SET @@SQL_BIG_SELECTS = 1", 'security_override');

// Lets set MAX_JOIN_SIZE to something we should
if (empty($sql_max_join) || ($sql_max_join == '18446744073709551615' && $sql_max_join == '18446744073709551615'))
$smcFunc['db_query']('', "SET @@SQL_MAX_JOIN_SIZE = 18446744073709551615", 'security_override');
}

Remove it.

[martinmike2]

Followed the advice posted earlier in this thread and still getting errors.  Converting IP.Board 2.3.5 to SMF 2.0 using the converter available on the site.

the error is:

Converting calendar events...Error in convert script - line 550!
Error in convert script - line 551!
Wrong value type sent to the database. Date expected. (start_date)