[WIP - Converter] IPB 3.2/3.3/3.4

[brunob]

Password issue is resolved.
The password reminder mail came in my spambox.
When you click on that link the link does not work.
You will need to approve the mail so it is not spam and the problem is solved!

Greating Bruno

[mentalist]

mmm...the same as IPB2?
Then in theory it should work out of the box since this is already included in SMF and both the password and the salt are transferred by the converter.
It should ask to reintroduce the password, but it should work.

yep, but IPB passwords use 8 characters salt, the SMF salt is by default limited to 4 characters..

Code Select Expand

SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
You'd need to extend the column password_salt to 8 characters in order get get it working..

[emanuele]

From phpMyAdmin:

Code Select Expand

password_salt varchar(255)
So there is space to properly store the salt.
The converter migrates it "properly" (i.e. the entire salt should be in smf's table).
As far as I remember SMF generates a 4 chars salt, but doesn't shorten it when retrieved from the db.
Not sure why it doesn't work.

[brunob]

Hello,

Before and after the url of the image is automatically added this -> \ "
When I remove them the image suddenly does it.

Where can i find that script?

Greating Bruno

[brunob]

Hello,

The text problem is still there.

Emanuele which database fields you want to see exactly?

Greatings Bruno 

See also image <p> and <br> between the line/text

[brunob]

Hello,

we have decided to start all over again 

Itself we have looked if we could fix the problems, but that's what too much for us.

Greetings,

Bruno 

[emanuele]

I'm really sorry, the topic was buried under several other topics and I lost track of it...

The image problem should be "easy" to solve, the other one...no, it seems that your IPB adds random paragraphs inside the text, I should read the text of a message stored in the database in order to try to understand what is going on, but I'm not sure I could fix it.

[Dan Claimant]

Hi.
Something wrong at the beginning of convertation:

Notice: Undefined index: substep in /usr/local/www/***/media3/convert.php on line 975Converting members...ErrorNotice: Undefined index: cache_enable in /usr/local/www/***/media3/Sources/Subs-Db-mysql.php on line 438You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 2), (820, 'KsuSha', 'KsuSha', '[email protected]', '', '', '', 125061719' at line 325Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0Warning: Unknown: Failed to write session data (files). Please verify that the current setting of hxxp:session.save [nonactive]_path is correct () in Unknown on line 0

[emanuele]

Hello Dan and welcome to sm.org.

Unknown: write failed: No space left on device (28) in Unknown on line 0

You problem seems to be that you don't have enough space.

[Dan Claimant]

Hello Dan and welcome to hxxp:sm.org [nonactive].

Thanks a lot =)

You problem seems to be that you don't have enough space.

After restart of DB-server (20 Gb free space):

Notice: Undefined index: substep in /usr/local/www/***/media3/convert.php on line 975Converting members...ErrorNotice: Undefined index: cache_enable in /usr/local/www/***/media3/Sources/Subs-Db-mysql.php on line 438You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 2), (820, 'KsuSha', 'KsuSha', '[email protected]', '', '', '', 125061719' at line 325

[Softovick]

I ran the script for converting forum IP.Bord 3.3.4.
More than 38,000 users
More than 268,000 messages.

And in the migration of posts each time an error occurs.
It looks like this:

Converting...
Converting posts (this may take some time)...
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 'ORDER BY null' at line 503

URL while such

Code Select Expand

convert.php?step=1&substep=9&start=96500

[mentalist]

Seems your MySQL version's having issues with ORDER BY NULL, check:
http://www.simplemachines.org/community/index.php?topic=218449.msg3496221#msg3496221

[emanuele]

Notice: Undefined index: substep in /usr/local/www/***/media3/convert.php on line 975Converting members...ErrorNotice: Undefined index: cache_enable in /usr/local/www/***/media3/Sources/Subs-Db-mysql.php on line 438You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, 2), (820, 'KsuSha', 'KsuSha', '[email protected]', '', '', '', 125061719' at line 325

It may be something broken in the birthdate, if the field is not important you may try removing the line:

Code Select Expand

IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, '0001', m.bday_year), IF(m.bday_month = 0, '01', IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, '01', IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate,


[Softovick]

Seems your MySQL version's having issues with ORDER BY NULL, check:
http://www.simplemachines.org/community/index.php?topic=218449.msg3496221#msg3496221

Thank you very much, it solved the problem

[eddie1973]

Anyone have luck with IPB 3.4.5?

[emanuele]

http://www.simplemachines.org/community/index.php?topic=477019.msg3557208#msg3557208

I suppose is basically the same.

[eddie1973]

Does the original converter have all your fixes?

[emanuele]

TBH I lost track of what was fixed and what not...

[Dan Claimant]

It may be something broken in the birthdate, if the field is not important you may try removing the line:

Thanx a lot. Now it's working almost well.
At the end of converting, at "Recalculating forum statistics... ":

Code Select Expand

Fatal error: Call to undefined function getAttachmentFilename() in /usr/local/www/***/media3/convert.php on line 1954

[emanuele]

Already answered few posts before:
http://www.simplemachines.org/community/index.php?action=search2;search=getAttachmentFilename;topic=477019


P.S.
Sorry for the late reply.