Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: SleePy on May 27, 2008, 05:03:27 PM

Title: [SMF Converter] Drupal 5.7
Post by: SleePy on May 27, 2008, 05:03:27 PM
Software: Drupal
Version: 5.7

This is the official support topic for Drupal 5.7 converter.  Use this topic to ask for support for this converter.

Changelog
!Fixed a bug in topics / messages conversion.

drupal_migration.php
For the conversion to be able to complete, the drupal_migration.php file is required. You will need to modify this file to reflect your Database name and Database prefix (if specified). You can find this information in /sites/<site name>/settings.php in the variable "$db_url" and "$db_prefix"

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Title: Re: [SMF Converter] Drupal 5.7
Post by: Wolvix on July 08, 2008, 11:48:12 PM
I'm having problems getting this to work. I've uploaded convert.php,  drupal_migration.php and drupal57_to_smf.sql to the root of my SMF install. Changed the information in drupal_migration.php. I then point my browser to the convert.php, change the information for  path to Drupal install and SMF database password. But I get the message "Unable to find the settings for Drupal 5.7 . Please double check the path and try again." no matter what I do.

Is there something I've missed? (And yes, the path to the Drupal install is correct)
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on July 09, 2008, 12:08:49 AM
For best results the "drupal_migration.php" file should be in your drupal root folder..

Make sure you specified the correct database name and prefix As well that the mysql user has access to both the smf and drupal database.
Title: Re: [SMF Converter] Drupal 5.7
Post by: Wolvix on July 09, 2008, 12:22:27 AM
Quote from: SleePy on July 09, 2008, 12:08:49 AM
For best results the "drupal_migration.php" file should be in your drupal root folder..

Make sure you specified the correct database name and prefix As well that the mysql user has access to both the smf and drupal database.
Thank you for your reply.

Placing the drupal_migration.php file in the root of the Drupal install did the trick, but now I've having some problems converting the users. I'm getting the message "Duplicate entry '572' for key 1" So I'm guessing there's a problem with my database somewhere. I'll try to sort this out and report back.
Title: Re: [SMF Converter] Drupal 5.7
Post by: ThorstenE on July 09, 2008, 01:23:16 AM
Quote from: Wolvix on July 09, 2008, 12:22:27 AM
I'm getting the message "Duplicate entry '572' for key 1" So I'm guessing there's a problem with my database somewhere. I'll try to sort this out and report back.
Duplicate Entry is sometimes a reason for slow server-performance.. retry the conversion from the beginning.. is the error the same?
Title: Re: [SMF Converter] Drupal 5.7
Post by: Wolvix on July 09, 2008, 01:43:50 AM
Yes the error is the same. I also tried dropping the SMF database and did a fresh install and a fresh conversion, but the conversion problem persists. I also tried to delete the user #572 but then the duplicate key just jumped to #574.

It would not surprise me if there are problems with my Drupal database, it's an old install which have been running for a long time and has had several Drupal upgrades plus a bunch of 3rd-party modules. I've  tried to repair and optimize the database through phpmyadmin, but it's not helping.
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on July 09, 2008, 02:11:23 AM
Well, we could tell it to ignore the errors, the only possibility is that you might have some users with incomplete data.

To do this open the .sql file

Find:
---* {$to_prefix}members

Replace:
---* {$to_prefix}members
---{
$ignore = true;
---}
Title: Re: [SMF Converter] Drupal 5.7
Post by: Wolvix on July 09, 2008, 02:20:27 AM
OK, that helped a bit. I'm getting a few steps further. Now the conversion stops with this error:
QuoteConverting members... Successful.
Converting categories... Successful.
Converting boards... Unsuccessful!
This query:

    DELETE FROM `wolvix_smf`.smf_boards
    WHERE ID_BOARD =;

Caused the error:

    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 '' at line 2

EDIT:  BTW. I really appreciate you guys helping me out. Thanks a lot.

EDIT2: I've tried to uncheck the [ ]Boards... box, but the error persists. I also tried unchecking all the boxes, just for fun, but it seems the script insist on doing all the steps whether they're selected or not.

I've tried to search for the error, but most of the results just gives me websites with a broken MySQL installs displaying the error "You have an error in your SQL syntax.  [...]"

I've also been looking at the 'Converting boards' section in the drupal57_to_smf.sql file, but my knowledge about MySQL is rather slim, so I can't tell if there's a problem in the code or not.

EDIT3: I'm using MySQL 4.0.24 if that's any help
Title: Re: [SMF Converter] Drupal 5.7
Post by: ThorstenE on July 09, 2008, 03:26:54 AM
open the .sql file

remove:
---{
$no_add = true;
$keys = array('ID_CAT', 'name', 'catOrder');

$request = mysql_query("
SELECT value
FROM {$from_prefix}variable
WHERE name ='forum_containers'
LIMIT 1");
list($containers) = mysql_fetch_row($request);
mysql_free_result($request);
$cont = unserialize($containers);

foreach ($cont as $categories)
{
$request = mysql_query("
SELECT name
FROM {$from_prefix}term_data
WHERE tid = $categories
LIMIT 1");
list($name) = mysql_fetch_row($request);
mysql_free_result($request);

convert_query("
DELETE FROM {$to_prefix}boards
WHERE ID_BOARD = $categories ");
}
---}

this may result in converting the drupal categories to SMF Boards.. after successful conversion you can remove these by hand..
Title: Re: [SMF Converter] Drupal 5.7
Post by: Wolvix on July 09, 2008, 03:36:04 AM
Yes!! That did the trick.
QuoteConverting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts - Part 2(this may take some time)... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Successful.
Conversion Complete

Thanks a bunch! I've been wanting to move my community over from Drupal to SMF for quite some time now.

I really appreciate the help I've gotten here and the fact that you two guys have been making this converter. Now all I need to do is some forum house keeping and I'm set.

Cheers!

Wolven
Title: Re: [SMF Converter] Drupal 5.7
Post by: Trulyana on July 13, 2008, 07:47:38 PM
Do you need to have a clean workable database for the conversion to work? As my database has an error in the settings file, and won't read off in smf. Will it work in conversion when transferred over into drupal? Or not work at all, as the error will still be visible?
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on July 13, 2008, 10:27:11 PM
The converter assumes you have SMF installed and that it is working properly. You can try it, I don't know if it will still convert correctly to SMF.
Title: Re: [SMF Converter] Drupal 5.7
Post by: Trulyana on July 14, 2008, 02:05:48 PM
Quote from: SleePy on July 13, 2008, 10:27:11 PM
The converter assumes you have SMF installed and that it is working properly. You can try it, I don't know if it will still convert correctly to SMF.

So, it assumes the SMF software is there, before converting to drupal? Will a corrupted database affect it? I just want to move the database into drupal. The database from SMF, not the actual software.
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on July 14, 2008, 02:07:09 PM
Are you wanting to convert away from SMF? This converter is to SMF. It won't convert you to Drupal..
It takes data from a Drupal database and rereads it and puts it into the SMF database.
Title: Re: [SMF Converter] Drupal 5.7
Post by: Trulyana on July 14, 2008, 02:27:01 PM
Quote from: SleePy on July 14, 2008, 02:07:09 PM
Are you wanting to convert away from SMF? This converter is to SMF. It won't convert you to Drupal..
It takes data from a Drupal database and rereads it and puts it into the SMF database.

Yup, that's the idea. Convert from SMF to drupal. I gather I'll need to have a look at the website for that. Unless there is a converter here for that too?
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on July 14, 2008, 02:28:09 PM
Our converters are only made for converting to SMF. We don't provide converters for converting away.
Title: Re: [SMF Converter] Drupal 5.7
Post by: Trulyana on July 17, 2008, 01:45:43 PM
Quote from: SleePy on July 14, 2008, 02:28:09 PM
Our converters are only made for converting to SMF. We don't provide converters for converting away.


Cheers! :)
Title: Re: [SMF Converter] Drupal 5.7
Post by: marlz827 on August 02, 2008, 01:53:47 PM
Hello guys i have drupal 5.7 installed and was wondering about this smf conversion is there a mod i need to install on smf for this to work?
Title: Re: [SMF Converter] Drupal 5.7
Post by: ThorstenE on August 02, 2008, 03:19:04 PM
The files above are needed when converting your drupal (forum) to SMF..
Helpful information: Converting to SMF (http://docs.simplemachines.org/index.php?topic=15)
Title: Re: [SMF Converter] Drupal 5.7
Post by: BigMike on October 01, 2008, 11:37:20 AM
Hey guys,

I posted in Drupal + SMF bridge Question... (http://www.simplemachines.org/community/index.php?topic=244723.msg1725610#msg1725610) last week and never got a response, so I used different search terms and finally found this thread.

I am running Drupal 5.10. I am entirely new to Drupal.

I am not quite sure what this Converter is all about. So.................... this is to convert the default forum software embedded with Drupal to SMF, right?

Ok, if this is true, then my question is which SMF?

What if I already have a huge SMF forum that I've been using for many, many years, is there a merge or bridge software?

I understand what convert to means, but how about connect to ? Is this a two step process?

Thanks for the clarification
BigMike
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on October 01, 2008, 07:48:33 PM
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.
Title: Re: [SMF Converter] Drupal 5.7
Post by: BigMike on October 02, 2008, 12:20:26 AM
Quote from: SleePy on October 01, 2008, 07:48:33 PM
The released converter only supports SMF 1.1

Why only 1.1? This thread was created much, much after 1.1......
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on October 02, 2008, 06:50:38 PM
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).
Title: Re: [SMF Converter] Drupal 5.7
Post by: BigMike on October 03, 2008, 01:07:44 AM
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
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 23, 2008, 04:31:43 PM
I'm having an issue converting, Maybe someone can help here :)


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
Title: Re: [SMF Converter] Drupal 5.7
Post by: SleePy on October 23, 2008, 11:03:33 PM
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.
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 02:22:57 AM
Quote from: SleePy on October 23, 2008, 11:03:33 PM
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"


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!"
Title: Re: [SMF Converter] Drupal 5.7
Post by: ThorstenE on October 24, 2008, 09:30:20 AM
edit the drupal57_to_smf.sql

find:

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


replace it with
---* {$to_prefix}messages 100
---{


if this doesn't fix it then replace it with:
---* {$to_prefix}messages 200
---{
$ignore = true;
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 11:38:55 AM
Quote from: TE on October 24, 2008, 09:30:20 AM
edit the drupal57_to_smf.sql

find:

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


replace it with
---* {$to_prefix}messages 100
---{


if this doesn't fix it then replace it with:
---* {$to_prefix}messages 200
---{
$ignore = true;


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


That worked - Thank You very much.
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 12:06:51 PM
Now I Do have another issue :D

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

Admin -> Maintenance -> Find and repair any errors


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.
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 12:09:24 PM
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:

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.



Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 12:30:12 PM
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
Title: Re: [SMF Converter] Drupal 5.7
Post by: ThorstenE on October 24, 2008, 12:48:49 PM
"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?
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 12:51:18 PM
Yes, I can - would you like me to email it to you?
Title: Re: [SMF Converter] Drupal 5.7
Post by: ThorstenE on October 24, 2008, 01:24:53 PM
I have send you a PM..
Title: Re: [SMF Converter] Drupal 5.7
Post by: wiszmaster on October 24, 2008, 01:27:49 PM
I sent the email @about 25 min ago.