[SMF Converter] Drupal 5.7

[SleePy]

Yes, it will convert you from drupal to smf.

The released converter only supports SMF 1.1, We do have SMF 2.0 converters in development and I am willing to hand them out to those who don't mind dealing with bugs in the converter, don't mind testing converters with little or no testing on them and have some understanding of common errors to resolve themselves.

[BigMike]

The released converter only supports SMF 1.1

Why only 1.1? This thread was created much, much after 1.1......

[SleePy]

1.1 means 1.1, 1.1.1, 1.1.2, etc all the way to the current 1.1.6.

It won't support any 1.0.x install (although it may work) and it won't work with any SMF 2.0 converter (due to the column name changes to support multiple databases). Although I do have 2.0 converters in development. Mostly right now I think I am at the testing stage as I should of fixed all bugs in it and got it working for 2.0 with multiple database support for the converter (with some limits on that).

[BigMike]

Ahhh sounds great!


I am in the progress of switching my static html site over to drupal, after which I will look into this converter for sure! Thanks!

BigMike

[wiszmaster]

I'm having an issue converting, Maybe someone can help here

Code Select Expand


Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `db_nm`.smf_messages
(ID_MSG, ID_TOPIC, ID_BOARD, ID_MEMBER, posterTime, subject, body, posterName, posterIP, modifiedName, posterEmail, icon)
VALUES ('18', '18', '5', '2', '1173666004', 'adsfasdfasdf', 'adsfasdfasdf'


<cut much data out>

Caused the error:
Duplicate entry '18' for key 1




Thank You,

marco

[SleePy]

Are you clicking continue on the converter or letting it run?
This can sometimes happen if you try to click continue and the auto-continue has already started to process.

[wiszmaster]

Are you clicking continue on the converter or letting it run?
This can sometimes happen if you try to click continue and the auto-continue has already started to process.

Interesting.

I pulled up the convert.php, changed the path's, and entered the password.

"Continue"

Code Select Expand

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards...
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/forums/convert.php(1016) : eval()'d code on line 7


<lines cut out>


Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/forums/convert.php(1016) : eval()'d code on line 7
Successful.
Converting topics...
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/forums/convert.php(1016) : eval()'d code on line 7


<lines cut out>


Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/forums/convert.php(1016) : eval()'d code on line 7

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/xxxxxxx/public_html/forums/convert.php(1016) : eval()'d code on line 7
Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `xxxxxxx `.smf_messages
(ID_MSG, ID_TOPIC, ID_BOARD, ID_MEMBER, posterTime, subject, body, posterName, posterIP, modifiedName, posterEmail, icon)
VALUES ('3', '3', '9', '2', '1168796645', 'Flatworm removal - Part TROIS!', 'This morning we are @ it again!

this time we put in 4 power heads & directed the flow into the rockwork!

I think more flatworms died this time around that in the last 2 rounds together!!!

within about 90 seconds .... FLATWORMS EVERYWHERE.', 'wiszmaster', '', '', 'xxxxxxx@ xxxxxxx.com', 'xx'),
('17', '17', '5', '2', '1171200652', 'FS: Powder Blue Tang', 'as topic states ... FS is a Powder Blue Tang.

between 5-8\" ... he eats like a champ!

$60


LINK:
http://www.liveaquaria.com/product/prod_Display.cfm?pCatId=366

SW - Powder Blue Tang (Maldives) - Small - $ 59.99

SW - Powder Blue Tang (Maldives) - Medium - $ 79.99

SW - Powder Blue Tang (Maldives) - Large - $ 99.99', 'wiszmaster', '', '', 'xxxxxxx@ xxxxxxx.com', 'xx'),
('16', '16', '3', '2', '1173706988', 'RE-LISTED: Red Sea Berlin Protein Skimmer', 'as topic states .. i have a RedSea Berlin Protein skimmer with pump. I\'ve used this skimmer a little bit. It works great, it pulled ALOT of stuff out of my water, it filled the collection cup within less than 24 hours .. it has a threaded tap to install 1/4\" tubing for a large waste container.

Skimmer comes with pump.


$115 - OBO

LINK:
http://www.marinedepot.com/md_viewItem.asp?idproduct=RS1111




SOLD 03/07/2007
RE-LISTED 03/11/07 - buyer had financial difficulties.', 'wiszmaster', '', '', 'xxxxxxx@ xxxxxxx.com', 'xx'),
('6', '6', '5', '2', '1168999002', 'FS / FT: Sand Sifting Star Fish', 'We have 2 sand sifting star fish in our 150g - but i\'d like to get rid of 1.

I\'m open for trades!', 'wiszmaster', '', '', 'xxxxxxx@ xxxxxxx.com', 'xx'),



<many lines left out>


Caused the error:
Duplicate entry '24' for key 1


At this point I'm opted with a Try Again button. Even if I hit that, I don't get much other than the same .. minus the mysql_free errors.
If i go into the admin section of smf, and do a recount stats & board under maintenance, 11 posts show up in the board. Including the one it lists first above "VALUES ('3', '3', '9', '2', '1168796645', 'Flatworm removal - Part TROIS!', 'This morning we are @ it again!"

[ThorstenE]

edit the drupal57_to_smf.sql

find:

Code Select Expand

---* {$to_prefix}messages 200
---{

replace it with

Code Select Expand

---* {$to_prefix}messages 100
---{

if this doesn't fix it then replace it with:

Code Select Expand

---* {$to_prefix}messages 200
---{
$ignore = true;

[wiszmaster]

edit the drupal57_to_smf.sql

find:

Code Select Expand

---* {$to_prefix}messages 200
---{

replace it with

Code Select Expand

---* {$to_prefix}messages 100
---{

if this doesn't fix it then replace it with:

Code Select Expand

---* {$to_prefix}messages 200
---{
$ignore = true;

Code Select Expand

---* {$to_prefix}messages 200
---{
$ignore = true;

That worked - Thank You very much.

[wiszmaster]

Now I Do have another issue

upon conversion, the forum posts are fine on the front end, if I go into

Admin -> Maintenance -> Find and repair any errors

Code Select Expand


The following errors are fouling up your forum:
Topic #315 has the last message ID 315, which is incorrect.
Topic #315 has the wrong number of replies, 0.
Topic #316 has the last message ID 316, which is incorrect.
Topic #316 has the wrong number of replies, 0.
Topic #318 has the last message ID 318, which is incorrect.
Topic #318 has the wrong number of replies, 0.
Topic #319 has the last message ID 319, which is incorrect.
Topic #319 has the wrong number of replies, 0.
Topic #320 has the last message ID 320, which is incorrect.
Topic #320 has the wrong number of replies, 0.
Topic #321 has the last message ID 321, which is incorrect.
Topic #321 has the wrong number of replies, 0.
Topic #322 has the last message ID 322, which is incorrect.
Topic #322 has the wrong number of replies, 0.
Topic #323 has the last message ID 323, which is incorrect.
Topic #323 has the wrong number of replies, 0.
Topic #324 has the last message ID 324, which is incorrect.
Topic #324 has the wrong number of replies, 0.
Topic #325 has the last message ID 325, which is incorrect.
Topic #325 has the wrong number of replies, 0.
Topic #326 has the last message ID 326, which is incorrect.
Topic #326 has the wrong number of replies, 0.
Topic #327 has the last message ID 327, which is incorrect.
Topic #327 has the wrong number of replies, 0.
Topic #328 has the last message ID 328, which is incorrect.
Topic #328 has the wrong number of replies, 0.
Topic #329 has the last message ID 329, which is incorrect.
Topic #329 has the wrong number of replies, 0.
Topic #330 has the last message ID 330, which is incorrect.
Topic #330 has the wrong number of replies, 0.
Topic #331 has the last message ID 331, which is incorrect.
Topic #331 has the wrong number of replies, 0.
Topic #332 has the last message ID 332, which is incorrect.
Topic #332 has the wrong number of replies, 0.
Topic #333 has the last message ID 333, which is incorrect.
Topic #333 has the wrong number of replies, 0.
Topic #334 has the last message ID 334, which is incorrect.
Topic #334 has the wrong number of replies, 0.
Topic #335 has the last message ID 335, which is incorrect.
Topic #335 has the wrong number of replies, 0.
Topic #336 has the last message ID 336, which is incorrect.
Topic #336 has the wrong number of replies, 0.
Topic #337 has the last message ID 337, which is incorrect.
Topic #337 has the wrong number of replies, 0.
Topic #338 has the last message ID 338, which is incorrect.
Topic #338 has the wrong number of replies, 0.
Topic #340 has the last message ID 340, which is incorrect.
Topic #340 has the wrong number of replies, 0.
Topic #342 has the last message ID 342, which is incorrect.
Topic #342 has the wrong number of replies, 0.
Topic #343 has the last message ID 343, which is incorrect.
Topic #343 has the wrong number of replies, 0.
Topic #344 has the last message ID 344, which is incorrect.
Topic #344 has the wrong number of replies, 0.
Topic #347 has the last message ID 347, which is incorrect.
Topic #347 has the wrong number of replies, 0.
Topic #348 has the last message ID 348, which is incorrect.
Topic #348 has the wrong number of replies, 0.
Topic #351 has the last message ID 351, which is incorrect.
Topic #351 has the wrong number of replies, 0.
Topic #352 has the last message ID 352, which is incorrect.
Topic #352 has the wrong number of replies, 0.
Topic #353 has the last message ID 353, which is incorrect.
Topic #353 has the wrong number of replies, 0.
Topic #356 has the last message ID 356, which is incorrect.
Topic #356 has the wrong number of replies, 0.
Topic #364 has the last message ID 364, which is incorrect.
Topic #364 has the wrong number of replies, 0.
Topic #365 has the last message ID 365, which is incorrect.
Topic #365 has the wrong number of replies, 0.
Topic #366 has the last message ID 366, which is incorrect.
Topic #366 has the wrong number of replies, 0.
Topic #367 has the last message ID 367, which is incorrect.
Topic #367 has the wrong number of replies, 0.
Topic #370 has the last message ID 370, which is incorrect.
Topic #370 has the wrong number of replies, 0.
Topic #371 has the last message ID 371, which is incorrect.
Topic #371 has the wrong number of replies, 0.
Topic #372 has the last message ID 372, which is incorrect.
Topic #372 has the wrong number of replies, 0.
Topic #375 has the last message ID 375, which is incorrect.
Topic #375 has the wrong number of replies, 0.
Topic #376 has the last message ID 376, which is incorrect.
Topic #376 has the wrong number of replies, 0.
Topic #377 has the last message ID 377, which is incorrect.
Topic #377 has the wrong number of replies, 0.
Topic #378 has the last message ID 378, which is incorrect.
Topic #378 has the wrong number of replies, 0.
Topic #380 has the last message ID 380, which is incorrect.
Topic #380 has the wrong number of replies, 0.
Topic #382 has the last message ID 382, which is incorrect.
Topic #382 has the wrong number of replies, 0.
Topic #383 has the last message ID 383, which is incorrect.
Topic #383 has the wrong number of replies, 0.
Topic #384 has the last message ID 384, which is incorrect.
Topic #384 has the wrong number of replies, 0.
Topic #386 has the last message ID 386, which is incorrect.
Topic #386 has the wrong number of replies, 0.
Topic #387 has the last message ID 387, which is incorrect.
Topic #387 has the wrong number of replies, 0.
Topic #388 has the last message ID 388, which is incorrect.
Topic #388 has the wrong number of replies, 0.
Topic #389 has the last message ID 389, which is incorrect.
Topic #389 has the wrong number of replies, 0.
Topic #390 has the last message ID 390, which is incorrect.
Topic #390 has the wrong number of replies, 0.
Topic #392 has the last message ID 392, which is incorrect.
Topic #392 has the wrong number of replies, 0.
Topic #393 has the last message ID 393, which is incorrect.
Topic #393 has the wrong number of replies, 0.
Topic #394 has the last message ID 394, which is incorrect.
Topic #394 has the wrong number of replies, 0.
Topic #396 has the last message ID 396, which is incorrect.
Topic #396 has the wrong number of replies, 0.
Topic #398 has the last message ID 398, which is incorrect.
Topic #398 has the wrong number of replies, 0.
Topic #399 has the last message ID 399, which is incorrect.
Topic #399 has the wrong number of replies, 0.
Topic #400 has the last message ID 400, which is incorrect.
Topic #400 has the wrong number of replies, 0.
Topic #401 has the last message ID 401, which is incorrect.
Topic #401 has the wrong number of replies, 0.
Topic #402 has the last message ID 402, which is incorrect.
Topic #402 has the wrong number of replies, 0.
Topic #403 has the last message ID 403, which is incorrect.
Topic #403 has the wrong number of replies, 0.
Topic #404 has the last message ID 404, which is incorrect.
Topic #404 has the wrong number of replies, 0.
Topic #405 has the last message ID 405, which is incorrect.
Topic #405 has the wrong number of replies, 0.
Topic #407 has the last message ID 407, which is incorrect.
Topic #407 has the wrong number of replies, 0.
Topic #408 has the last message ID 408, which is incorrect.
Topic #408 has the wrong number of replies, 0.
Topic #409 has the last message ID 409, which is incorrect.
Topic #409 has the wrong number of replies, 0.
Topic #411 has the last message ID 411, which is incorrect.
Topic #411 has the wrong number of replies, 0.
Topic #412 has the last message ID 412, which is incorrect.
Topic #412 has the wrong number of replies, 0.
Topic #417 has the last message ID 417, which is incorrect.
Topic #417 has the wrong number of replies, 0.
Topic #418 has the last message ID 418, which is incorrect.
Topic #418 has the wrong number of replies, 0.
Topic #420 has the last message ID 420, which is incorrect.
Topic #420 has the wrong number of replies, 0.
Topic #421 has the last message ID 421, which is incorrect.
Topic #421 has the wrong number of replies, 0.
Topic #423 has the last message ID 423, which is incorrect.
Topic #423 has the wrong number of replies, 0.
Topic #424 has the last message ID 424, which is incorrect.
Topic #424 has the wrong number of replies, 0.
Topic #426 has the last message ID 426, which is incorrect.
Topic #426 has the wrong number of replies, 0.
Topic #427 has the last message ID 427, which is incorrect.
Topic #427 has the wrong number of replies, 0.
Topic #429 has the last message ID 429, which is incorrect.
Topic #429 has the wrong number of replies, 0.
Topic #431 has the last message ID 431, which is incorrect.
Topic #431 has the wrong number of replies, 0.
Topic #435 has the last message ID 435, which is incorrect.
Topic #435 has the wrong number of replies, 0.
Topic #436 has the last message ID 436, which is incorrect.
Topic #436 has the wrong number of replies, 0.
Topic #438 has the last message ID 438, which is incorrect.
Topic #438 has the wrong number of replies, 0.
Topic #439 has the last message ID 439, which is incorrect.
Topic #439 has the wrong number of replies, 0.
Topic #440 has the last message ID 440, which is incorrect.
Topic #440 has the wrong number of replies, 0.
Topic #446 has the last message ID 446, which is incorrect.
Topic #446 has the wrong number of replies, 0.
Topic #447 has the last message ID 447, which is incorrect.
Topic #447 has the wrong number of replies, 0.
Topic #448 has the last message ID 448, which is incorrect.
Topic #448 has the wrong number of replies, 0.
Topic #449 has the last message ID 449, which is incorrect.
Topic #449 has the wrong number of replies, 0.
Topic #450 has the last message ID 450, which is incorrect.
Topic #450 has the wrong number of replies, 0.
Topic #451 has the last message ID 451, which is incorrect.
Topic #451 has the wrong number of replies, 0.
Topic #452 has the last message ID 452, which is incorrect.
Topic #452 has the wrong number of replies, 0.
Topic #453 has the last message ID 453, which is incorrect.
Topic #453 has the wrong number of replies, 0.
Topic #454 has the last message ID 454, which is incorrect.
Topic #454 has the wrong number of replies, 0.
Topic #455 has the last message ID 455, which is incorrect.
Topic #455 has the wrong number of replies, 0.
Topic #457 has the last message ID 457, which is incorrect.
Topic #457 has the wrong number of replies, 0.
Topic #458 has the last message ID 458, which is incorrect.
Topic #458 has the wrong number of replies, 0.
Topic #459 has the last message ID 459, which is incorrect.
Topic #459 has the wrong number of replies, 0.
Topic #460 has the last message ID 460, which is incorrect.
Topic #460 has the wrong number of replies, 0.
Topic #461 has the last message ID 461, which is incorrect.
Topic #461 has the wrong number of replies, 0.


If I fix errors, many of the forum threads have the same post/reply many times within.

[wiszmaster]

Same happens if I do a

Admin -> Maintenance -> Recount all forum totals and statistics.

But If I recount first, the errors on the "Find and repair any errors" are the following:

Code Select Expand

The following errors are fouling up your forum:
Topic #315 has the last message ID 315, which is incorrect.
Topic #316 has the last message ID 316, which is incorrect.
Topic #318 has the last message ID 318, which is incorrect.
Topic #319 has the last message ID 319, which is incorrect.
Topic #320 has the last message ID 320, which is incorrect.
Topic #321 has the last message ID 321, which is incorrect.
Topic #322 has the last message ID 322, which is incorrect.
Topic #323 has the last message ID 323, which is incorrect.
Topic #324 has the last message ID 324, which is incorrect.
Topic #325 has the last message ID 325, which is incorrect.
Topic #326 has the last message ID 326, which is incorrect.
Topic #327 has the last message ID 327, which is incorrect.
Topic #328 has the last message ID 328, which is incorrect.
Topic #329 has the last message ID 329, which is incorrect.
Topic #330 has the last message ID 330, which is incorrect.
Topic #331 has the last message ID 331, which is incorrect.
Topic #332 has the last message ID 332, which is incorrect.
Topic #333 has the last message ID 333, which is incorrect.
Topic #334 has the last message ID 334, which is incorrect.
Topic #335 has the last message ID 335, which is incorrect.
Topic #336 has the last message ID 336, which is incorrect.
Topic #337 has the last message ID 337, which is incorrect.
Topic #338 has the last message ID 338, which is incorrect.
Topic #340 has the last message ID 340, which is incorrect.
Topic #342 has the last message ID 342, which is incorrect.
Topic #343 has the last message ID 343, which is incorrect.
Topic #344 has the last message ID 344, which is incorrect.
Topic #347 has the last message ID 347, which is incorrect.
Topic #348 has the last message ID 348, which is incorrect.
Topic #351 has the last message ID 351, which is incorrect.
Topic #352 has the last message ID 352, which is incorrect.
Topic #353 has the last message ID 353, which is incorrect.
Topic #356 has the last message ID 356, which is incorrect.
Topic #364 has the last message ID 364, which is incorrect.
Topic #365 has the last message ID 365, which is incorrect.
Topic #366 has the last message ID 366, which is incorrect.
Topic #367 has the last message ID 367, which is incorrect.
Topic #370 has the last message ID 370, which is incorrect.
Topic #371 has the last message ID 371, which is incorrect.
Topic #372 has the last message ID 372, which is incorrect.
Topic #375 has the last message ID 375, which is incorrect.
Topic #376 has the last message ID 376, which is incorrect.
Topic #377 has the last message ID 377, which is incorrect.
Topic #378 has the last message ID 378, which is incorrect.
Topic #380 has the last message ID 380, which is incorrect.
Topic #382 has the last message ID 382, which is incorrect.
Topic #383 has the last message ID 383, which is incorrect.
Topic #384 has the last message ID 384, which is incorrect.
Topic #386 has the last message ID 386, which is incorrect.
Topic #387 has the last message ID 387, which is incorrect.
Topic #388 has the last message ID 388, which is incorrect.
Topic #389 has the last message ID 389, which is incorrect.
Topic #390 has the last message ID 390, which is incorrect.
Topic #392 has the last message ID 392, which is incorrect.
Topic #393 has the last message ID 393, which is incorrect.
Topic #394 has the last message ID 394, which is incorrect.
Topic #396 has the last message ID 396, which is incorrect.
Topic #398 has the last message ID 398, which is incorrect.
Topic #399 has the last message ID 399, which is incorrect.
Topic #400 has the last message ID 400, which is incorrect.
Topic #401 has the last message ID 401, which is incorrect.
Topic #402 has the last message ID 402, which is incorrect.
Topic #403 has the last message ID 403, which is incorrect.
Topic #404 has the last message ID 404, which is incorrect.
Topic #405 has the last message ID 405, which is incorrect.
Topic #407 has the last message ID 407, which is incorrect.
Topic #408 has the last message ID 408, which is incorrect.
Topic #409 has the last message ID 409, which is incorrect.
Topic #411 has the last message ID 411, which is incorrect.
Topic #412 has the last message ID 412, which is incorrect.
Topic #417 has the last message ID 417, which is incorrect.
Topic #418 has the last message ID 418, which is incorrect.
Topic #420 has the last message ID 420, which is incorrect.
Topic #421 has the last message ID 421, which is incorrect.
Topic #423 has the last message ID 423, which is incorrect.
Topic #424 has the last message ID 424, which is incorrect.
Topic #426 has the last message ID 426, which is incorrect.
Topic #427 has the last message ID 427, which is incorrect.
Topic #429 has the last message ID 429, which is incorrect.
Topic #431 has the last message ID 431, which is incorrect.
Topic #435 has the last message ID 435, which is incorrect.
Topic #436 has the last message ID 436, which is incorrect.
Topic #438 has the last message ID 438, which is incorrect.
Topic #439 has the last message ID 439, which is incorrect.
Topic #440 has the last message ID 440, which is incorrect.
Topic #446 has the last message ID 446, which is incorrect.
Topic #447 has the last message ID 447, which is incorrect.
Topic #448 has the last message ID 448, which is incorrect.
Topic #449 has the last message ID 449, which is incorrect.
Topic #450 has the last message ID 450, which is incorrect.
Topic #451 has the last message ID 451, which is incorrect.
Topic #452 has the last message ID 452, which is incorrect.
Topic #453 has the last message ID 453, which is incorrect.
Topic #454 has the last message ID 454, which is incorrect.
Topic #455 has the last message ID 455, which is incorrect.
Topic #457 has the last message ID 457, which is incorrect.
Topic #458 has the last message ID 458, which is incorrect.
Topic #459 has the last message ID 459, which is incorrect.
Topic #460 has the last message ID 460, which is incorrect.
Topic #461 has the last message ID 461, which is incorrect.


[wiszmaster]

Is there an easy "Remove Duplicate Post" feature that I have not found yet?
Short of manually going through all the posts, and removing hundreds/thousands of duplicate posts, would you have a MySQL script  to remove the duplicate posts, like it was written for the duplicate user's for phpBB ?


Thanks,

marco

[ThorstenE]

"Find and repair any errors" will repair wrong values in the database .

There is something wrong with the converter or there are duplicates in your drupal database.. The converter schould not create dubplicates in the smf-tables..

Can you send me a dump from your drupal database?

[wiszmaster]

Yes, I can - would you like me to email it to you?

[ThorstenE]

I have send you a PM..

[wiszmaster]

I sent the email @about 25 min ago.