Snitz to SMF 1.1

[Alan G]

Hello,

I'm trying to use the 1.1 snitz_to_smf convertor and i'm having some problems - after struggling to get the access db converted into mysql (which i believe is now ok) the convertor is hanging at Step 1

Converting...
Converting members...
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.

The ie status bar gets to just over a 1/3 in and stops - eventually timing out the page or just not going anywhere at all.

Sometimes i get this error:
(cut out the first 500 or so rows)

('503', '', 'CSP', 'd52b2ef6d422a96e3170800a6a45ec05113e1be49054a6f9ea30cbf729b816f2', '[email protected]', 'Kyrgyzstan', '', '', ' ', '', '', '', '', '0', '0', '1101489448', '1101489448', '', '0', '4', '1', '152.71.94.221', ''),
    ('504', '', 'smyla', '336e7b287413bc70e479512b8c520d49c486da3a64bc3b9f25fef85e397305cc', '[email protected]', 'Colombia', 'http://www.envyradio.com', 'http://www.envyradio.com', ' ', '', '', '', '', '0', '319', '1101881316', '1126913969', '', '0', '4', '0', '84.13.247.25', ''),
    ('505', '', 'Emma', '8e7964981f9e31697f256172c07b3309bb4776e81f239851ca550d9c36a83da6', '[email protected]', 'South Sandwich Islands', '', '', ' ', '', '', '', '', '0', '0', '1101937340', '1101937340', '', '0', '4', '2', '128.243.220.42', '');

Caused the error:

    Duplicate entry '1' for key 1

The snitz database has about 24,000 posts, 800 members and 2,500 topics.

I'm using the convert.php and snitz_to_smf.sql files attached to the first post in the 1.1 convertors thread.

I've tried a clean install of smf 1.1 and re imported the snitz data into mysql but i'm still getting the same problem.

Any help would be greatly appreciated!

Alan

(ps where did the spell check button come from! is that a mod or part of 1.1?)

[Alan G]

so yeah, i really can't get this convertor to work at all -

i am now getting

Converting...
Converting members... Unsuccessful!
This query:
INSERT INTO `det_forum_smf`.df_new_members
(ID_MEMBER, memberName, realName, passwd, emailAddress, location, websiteTitle, websiteUrl, signature, AIM, ICQ, MSN, YIM, ID_GROUP, posts, dateRegistered, lastLogin, usertitle, hideEmail, notifyTypes, gender, memberIP, birthdate)
VALUES ('1', 'escape', 'escape', '2e9089fefc7aaa5c45a2bb971e07f119c408f758b1b8f09cdf9c4210a0780376', 'XremovedX, '', '', '', ' ', '', '', '', '', '1', '10', '1038450309', '1128040510', 'Forum Admin', '0', '4', '0', '62.254.0.14', ''),
('2', '', 'Transit Mafia', 'f794efae7f78a7211253745ccb56690249baf253a0d39b98d9d2e840e2cd1901', 'XremovedX', 'United Kingdom', 'http://www.detonate1.co.uk', 'http://www.detonate1.co.uk', ' ', '', '', '', '', '0', '831', '1038453283', '1127412318', 'Detonate', '0', '4', '1', '62.254.0.14', ''),

......................... removed all the other entries to save space ...........................


('505', '', 'Emma', '8e7964981f9e31697f256172c07b3309bb4776e81f239851ca550d9c36a83da6', 'XremovedX', 'South Sandwich Islands', '', '', ' ', '', '', '', '', '0', '0', '1101937340', '1101937340', '', '0', '4', '2', '128.243.220.42', '');
Caused the error:

Duplicate entry '1' for key 1

whenever i run the script (if it doesn't time out)

However looking in the mysql tables it seems all 812 members have actually been moved into the right table??

can anyone help me here?

[Oldiesmann]

If all 812 members are already there then it would indeed give you a duplicate entry error. Try deleting all the values in that table (in phpMyAdmin, check the box next to it and choose "Truncate" from the "With selected:" menu) and running it again.

[Alan G]

i've cleaned out the tables (members, categories, boards, topics) and tried re-running it.

it's just timed out (not getting to stage 1 pause) however going back into the db the members, categories and boards tables all have entries in again so it's getting somewhere and then bombing out but not pausing as expected...

Thanks for your help, much appreciated 

[Alan G]

i'm contemplating going down the snitz to phpbb then phpbb to smf route... is that wise?

[Oldiesmann]

You're welcome to try it alang, but make sure you keep an extra copy of your Snitz data on hand in case it doesn't work. You might lose some information somewhere along the way too, because SMF has more features than phpBB, although it's been a while since I've used Snitz, so I don't know what all it has anymore.

[Alan G]

Ok, so i converted snitz to phpbb2 - which went ok other than the order of topics in phpbb is wrong (http://www.nottinghamculture.co.uk/detonate/phpbb) - i then converted phpbb to smf 1.1 - which went through fine (progress!).

now it's all looking promising, but the  topics are out of order in smf as well -

Now if i run forum maintenance / repair errors  in smf i get a huge list of errors, which are like this:

Topic #1 has the first message ID 25324, which is incorrect.
Topic #1 has the last message ID 116, which is incorrect.
Topic #2 has the first message ID 25325, which is incorrect.
Topic #2 has the last message ID 403, which is incorrect.
Topic #3 has the first message ID 25326, which is incorrect.
Topic #3 has the last message ID 128, which is incorrect.
.............
etc * 24,000

then:

The subject of topic #1 is currently not stored in the subject cache.
The subject of topic #2 is currently not stored in the subject cache.
The subject of topic #3 is currently not stored in the subject cache.
.........
etc * 24,000

So i do the repair but the topics are still out of order (it seems like empty posts are higher, but not all of them), i'm guessing this is related to the snitz to phpbb convert.

So really it would be better to get the smf to snitz convertor working properly to try and avoid that problem....hmm

The original and still live forum is here: http://www.detonate1.co.uk/forum for reference if it will help.

Any thoughts?

Thanks

[Alan G]

in fact looking at the smf forum it seems the first post is appearing last.

[Oldiesmann]

I'm not sure why it would be timing out. There are supposed to be steps in there to prevent that from happening.

[Alan G]

i'm guessing there is probably something wrong with the snitz database - but i'm not sure what or what i can do about it.

[Alan G]

I ended up installing smf 1.0.5 and running the convertor for that one (using the same snitz database as the 1.1 convertor):
(http://www.simplemachines.org/community/index.php?topic=15521.30)

which worked fine, leading me to think there must be a problem with the 1.1 convertor.

Having said that i can now just upgrade to 1.1 so i'm happy!

Has anyone else actually got the 1.1 snitz to smf convertor working then?

[Alan G]

it's probably worth noting that after running fix all errors it removed about 200 empty topics and they seem to be ones that had 0 replies in on the old forum.

not the end of the world though.

[Oldiesmann]

It shouldn't remove any topics. It should dump them all in a "Salvaged Topics" area...

[integroid]

Alan G or anyone else. Can you please give links to where you got the converters you used for the Access to MYSQL conversion and then the snitz to SMF conversion. That would be a lot of help for all of us nOObs:)