[SMF Converter] XMB - 1.9.8

[PatrickPriest]

Good News!!!  It all worked!

Code Select Expand



[root@server ~]# php /home/xxxx/public_html/smf/convert.php --path_to=/home/xxxx/public_html/smf --path_from=/home/xxxx/public_html/test --db_pass=******** --convert_script=xmb_to_smf.sql --debug

Starting Conversion
* Converting members...... Successful.
* Converting categories... Successful.
* Converting boards... Successful.
* Converting topics.......................... Successful.
* Converting posts (this may take some time)... Successful.
* Converting posts (part2)................ Successful.
* Converting polls... Successful.
* Converting poll options... Successful.
* Converting poll votes.... Successful.
* Converting personal messages (step 1)... Successful.
* Converting personal messages (step 2)... Successful.
* Converting topic notifications.... Successful.
* Converting banned users... Successful.
* Converting settings... Successful.
* Converting moderators.... Successful.
* Converting smileys... Successful.
* Converting attachments... Successful.
* Recalculating forum statistics... .... Successful.

Conversion Complete!
Please delete this file as soon as possible for security reasons.
[root@server ~]#


I deleted all the PMs.  Thank you for all the help!

[PatrickPriest]

um so yeah.... i remember saving those files you had to edit (convert.php & xmb_to_smf.sql) from my server... but i can't seem to find them.

any chance you still have them?

i am trying to get the REAL forums converted this weekend.

[SleePy]

Just use the same files that you had there during the demo conversion. They are the ones you need.

[Kaotic_For_Kaos]

Hi I'm new to SMF and I have a bit of a problem. It said it converted except for posts. I clicked the continue button and now I have gotten this error.

It's not letting me put it as a code. It's bascially what a few others had here. A bunch of numbers and then it says Caused the error:

Duplicate entry '511' for key 1

[SleePy]

What was the error before you clicked continue?

Sometimes clicking continue will cause errors and cause a double submission of the form (I need to look into fixing that).

[Kaotic_For_Kaos]

Well the boards, topics, and posts didn't convert. I tried again right now and it said the following.

Converting posts (this may take some time)... Incomplete

[ThorstenE]

this is the only error? or is it the same as posted above?

Duplicate entry '511' for key 1

as SleePy posted above:

Sometimes clicking continue will cause errors and cause a double submission of the form (I need to look into fixing that).

i think there should be a more specific error message like Duplicate entry or something else..

did you restart conversion from the beginning?

[Kaotic_For_Kaos]

I just tried the converter again, I got this. It said it coverted the members when I didn't even select that cause they converted already. Same with the categories.

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Incomplete.

Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

Actually it finally worked! I had to click continue a few times before it finished converting over the boards, posts and topics.

[prvul]

I got this error when converting from command line:

Code Select Expand


. . .
* Converting posts (part2)........................................ Successful.
* Converting polls.... Successful.
* Converting poll options... Successful.
* Converting poll votes... Successful.
* Converting personal messages (step 1)............. Successful.
* Converting personal messages (step 2).... Successful.
* Converting topic notifications.... Successful.
* Converting banned users... Successful.
* Converting settings... Successful.
* Converting moderators... Successful.
* Converting smileys...Unsuccessful!  MySQL error message:
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 'LENGTH(code) DESC' at line 2

Notice: Use of undefined constant COMMENTOUTPUT - assumed 'COMMENTOUTPUT' in /var/www/forum/config.php on line 53


I used this command:  php /var/www/smf/convert.php --path_to=/var/www/smf --path_from=/var/www/forum --convert_script=xmb_to_smf.sql --db_pass=XXX

I used convert.php and xmb_to_smf.sql from this thread. Smf version is 1.1.7 and xmb is version 1.9.10 Karl.
Is there a solution for this?
Can i continue from where error ocured (how?), or i need to go from the beginning?

[ThorstenE]

restart the conversion and use the attached version..

[murray.crane]

Is there any danger in re-running the conversion process? I ran it once prior to doing some work on an install of SMF, as I'm moving over to SMF from XMB, but now I've done all this backend work, I don't want to loose any of the changes I've made to the SMF installation by re-installing it. However, I can loose all the posting, topic and membership content as it's only for demo.

[ThorstenE]

usually there is no risk. open the xmb_to_smf.sql with a text-editor and search for "TRUNCATE", whenever you find a TRUNCATE the related table will be cleaned  by the new conversion process.

If you don't like a risk in any way make a backup from your SMF database before you re-convert your XMB.

[murray.crane]

Thanks TE

Much as I thought then... Roll on Saturday morning and the "live" switchover.

[Carlos Faria]

How do I convert the XMB to SMF 2.0 RC1.2 ??

[ThorstenE]

Converting to SMF

[rcpp]

Hi! Im not 100% sure if this is the right thread, but I've followed the link on the fixed thread.

I've downloaded the converter available on the download page and used it to convert an xmb board version 1.9.11 to SMF 1.1.11. The convertion worked and everything is fine expect for 2 issues:

1 [minor]: xmb 1.9.11 generates a thumbnail for the pictures attached to a post and insert them into [file]##[/file], where ## is the attachment number (i.e. 42). Since SMF does not have a default [file] bbCode what happens is that we don't see the thumbnail, only a plain text with

[file]42[/file].

However, the files are attached to the bottom of the post, making this a less important issue.

2. [major]: xmb 1.9.11 uses the bbCode [rquote] as its default tag, instead of [\quote\]  ( \ just for escaping) for quoting users. This drives to a problem where we don't see any quotation block, only a plain text with

[rquote=1111&tid=54&author="UserName"] Text quoted [/rquote].


Im not skilful enough with PHP to code something to do this task. I guess this not a simple task to do after inserting the data, so any help would be appreciated - even with editing the script, so it converts [rquote] to [\quote\] before inserting the data into the SMF db.


cheers and thank you!

[rcpp]

Updating!


I was able to convert every [rquote] to [\quote] using string replace inside the SQL conversion file.

Code Select Expand


SUBSTRING(REPLACE(p.message, 'rquote', 'quote'), 1, 65534) AS body,[/quote]

however, we don't have a link on the top of the quote block simply because the link from xmb is different from the SMF:

[code]
SMF:
Topic ID+Post Number, date, author (correct me if Im wrong)
[quote link=topic=604.msg42493#msg42493 date=1252204771 author=UserName]

XMB:
Post Number, Topic ID, Author
[rquote=60875&tid=416&author=UserName]


That would be a really more complex regex for changing the link structure... Any help? I can't find the section where it formats it (not in the sql, file though).

Cheers!

[amesfan]

Hello,

I'm also trying to convert from XMB 1.9.10 to SMF.  Everything goes OK, until it fails when converting attachments.  Sounds like it is allocating more memory than allowed on my server.  Is there a way to fix this?

Converting smileys... Successful.
Converting attachments...
Fatal error: Out of memory (allocated 1835008) (tried to allocate 921655 bytes) in /home/amesfan/public_html/board/convert.php on line 2371

Also, when I go to my SMF forum, my boards don't show up, although the categories appear in the admin panel.

Thank you!

[rcpp]

Hello,

I'm also trying to convert from XMB 1.9.10 to SMF.  Everything goes OK, until it fails when converting attachments.  Sounds like it is allocating more memory than allowed on my server.  Is there a way to fix this?

I think you have to contact your support. They will be more helpful than we, since you need more memory to your, since this is more concerned to local setup.

Also, when I go to my SMF forum, my boards don't show up, although the categories appear in the admin panel.

Thank you!

That is because it did not finish the conversion, so no posts or threads were fully converted.

Cheers!

[amesfan]

I checked and I have a 64M memory limit, so it looks that size is well below it.  Is there anything else that would cause this?