[SMF Converter] Snitz Forums - 3.4

Started by JayBachatero, February 01, 2007, 08:59:27 AM

Previous topic - Next topic

bostonb

got over the initial capitalization glitch, but now getting stuck on some "duplicate entry for key 1" error when it seems to be converting topics....


here is a snippet of the error message:

INSERT INTO `reach_dat`.datt_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, numReplies, numViews, locked)
VALUES ('2571', '0', '1', '47414', '47430', '798', '150', '2', '29', '0'),
('2573', '0', '1', '47477', '47580', '139', '856', '18', '103', '0'),
('2574', '0', '1', '47493', '47607', '344', '344', '31', '127', '0'),

...

Caused the error:

Duplicate entry '2571' for key 1


to see if there was an actual problem with topic_id 2571 I went into phpadmin and deleted the row, and reran, but then it said "duplicate entry '2572' for key 1", and so on ...

hope I'm not posting a question that has been answered, searched and found something about "category id's" that doesn't seem to follow what is happening to me with "topics"... any ideas?


ThorstenE

which snitz_to_smf.sql did you use? the version from our downloads page or the (updated version) attached to the first message from this topic?

you have to edit the snitz_to_smf.sql and find:
---* {$to_prefix}topics

replace it with:
---* {$to_prefix}topics
---{
$ignore = true;
---}


then restart the conversion..

Mannerheim

Hi!

My first post here, just installed the system and im trying to convert from my old snitz-forum, but i get the following error. I downloaded the latest .sql from the first post in this thread.

Does anybody have a idea? should i just delete all entries in the snitz notification-table?

Converting topic notifications... Unsuccessful!
This query:
INSERT INTO `web2_imil1s`.imil_log_notify
(ID_MEMBER, ID_TOPIC)
VALUES ('12', '327'),
('62', '263'),
('62', '283'),
('20', '296'),
('74', '278'),
('20', '404'),
('12', '308'),
('12', '93'),
('12', '199'),
('12', '339'),
('87', '360'),
('20', '335'),
('20', '239'),
('20', '303'),
('20', '317'),
('20', '356'),
('54', '239'),
('92', '70'),
('4', '120'),
('54', '153'),
('74', '219'),
('93', '60'),
('20', '320'),
('46', '320'),
('14', '390'),
('12', '372'),
('20', '366'),
('20', '365'),
('20', '358'),
('20', '376'),
('84', '356'),
('54', '355'),
('4', '302'),
('74', '404'),
('93', '45'),
('12', '302'),
('46', '149'),
('74', '174'),
('74', '358'),
('74', '356'),
('32', '376'),
('74', '203'),
('20', '253'),
('42', '508'),
('74', '307'),
('74', '226'),
('74', '24'),
('74', '167'),
('74', '366'),
('74', '335'),
('74', '239'),
('74', '30'),
('74', '179'),
('74', '355'),
('20', '219'),
('74', '399'),
('74', '365'),
('55', '263'),
('12', '412'),
('84', '358'),
('20', '153'),
('12', '412'),
('74', '412'),
('12', '418'),
('74', '303'),
('84', '303'),
('84', '303'),
('74', '409'),
('4', '435'),
('11', '435'),
('11', '435'),
('74', '432'),
('74', '437'),
('11', '442'),
('11', '442'),
('87', '450'),
('87', '450'),
('87', '451'),
('87', '450'),
('20', '449'),
('20', '450'),
('20', '435'),
('20', '437'),
('74', '449'),
('74', '452'),
('74', '450'),
('87', '453'),
('20', '109'),
('87', '109'),
('87', '457'),
('87', '458'),
('20', '457'),
('87', '457'),
('87', '458'),
('87', '459'),
('87', '459'),
('87', '109'),
('20', '66'),
('87', '465'),
('87', '365'),
('87', '365'),
('87', '468'),
('20', '468'),
('20', '474'),
('87', '474'),
('20', '475'),
('87', '491'),
('74', '468'),
('20', '479'),
('12', '470'),
('93', '381'),
('93', '60'),
('93', '492'),
('94', '239'),
('12', '476'),
('12', '493'),
('12', '476'),
('12', '494'),
('12', '496'),
('74', '491'),
('74', '228'),
('42', '358'),
('87', '239'),
('87', '401'),
('87', '360'),
('74', '70'),
('74', '528'),
('42', '528'),
('57', '531'),
('57', '531'),
('42', '411'),
('42', '369'),
('20', '487'),
('20', '535'),
('74', '510'),
('87', '537'),
('107', '50'),
('20', '537'),
('5', '554'),
('107', '153'),
('107', '568'),
('87', '564'),
('107', '556'),
('107', '566');
Caused the error:

Duplicate entry '12-327-0' for key 1

SleePy

Open the .sql file

Find:
---* {$to_prefix}log_notify

Replace:
---* {$to_prefix}log_notify
---{
$ignore = true;
---}
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Mannerheim

That did the trick! Thanks!

:)

Quote from: SleePy on April 09, 2009, 06:56:46 PM
Open the .sql file

Find:
---* {$to_prefix}log_notify

Replace:
---* {$to_prefix}log_notify
---{
$ignore = true;
---}


bostonb

#85
I'm still having some troubles with this

when I do the initial conversion, it seems to expect all capitals in some places for the table names, and all lower case in other places for the table names

I got an initial error when it was expecting table FORUM_REPLY to be in lower case, so I renamed the table and things went well for a bit, then I got an error a minute later expecting forum_reply to be in upper case

now I'm stuck, because I can't have the table both ways :(


edit: to make it more clear, here is the error message:

Converting...
Converting topics... Successful.
Converting posts ( part 1 - this may take some time)... Successful.
Converting posts ( part 2 - this may take some time)... Unsuccessful!
This query:
SELECT
c.ID_MSG AS ID_MSG, fr.TOPIC_ID AS ID_TOPIC, fr.FORUM_ID AS ID_BOARD, ft.T_SUBJECT AS subject,
UNIX_TIMESTAMP(REPLACE(fr.R_DATE, '\0', '')) AS posterTime, fr.R_AUTHOR AS ID_MEMBER,
fr.R_IP AS posterIP, IFNULL(ftm.realName, '') AS posterName,
REPLACE(REPLACE(R_MESSAGE, '\n', '<br />'), '\r', '') AS body,
IFNULL(ftm.emailAddress, '') AS posterEmail, fte.realName AS modifiedName,
UNIX_TIMESTAMP(REPLACE(fr.R_LAST_EDIT, '\0', '')) AS modifiedTime
FROM `tests_ikNm0`.iknm_convert AS c
INNER JOIN `tests_forum`.FORUM_TOPICS AS ft ON (c.old_id_topic = ft.TOPIC_ID)
INNER JOIN `tests_forum`.FORUM_REPLY AS fr ON (c.old_id_msg = fr.REPLY_ID)
LEFT JOIN `tests_ikNm0`.iknm_members AS ftm ON (ftm.ID_MEMBER = fr.R_AUTHOR)
LEFT JOIN `tests_ikNm0`.iknm_members AS fte ON (fte.ID_MEMBER = fr.R_LAST_EDITBY)
WHERE c.type = 'msg'
LIMIT 0, 200;
Caused the error:

Table 'tests_forum.FORUM_REPLY' doesn't exist


note that I got an error at first expecting FORUM_REPLY to be forum_reply, so I renamed..... now I am getting the opposite problem..... should I keep renaming the table as the script runs??

bostonb

#86
self reply to the above.... I tried renaming the capitalization of the table half way through the conversion process and it worked to get the process to "complete successfully", but there is a big problem in that the forum is filled with topics but no replies now, and the stats are wrong and when I tried to reply to a message it gave a database error, although the reply showed up (out of order though)

on a happy note, it seems my passwords and users converted over properly, and all the topics are there, so that is progress, but something is really screwed up with the reply conversions etc.

ThorstenE

please try  - Admin - Maintenance - "Find and Repair any Errors" and "Recount all forum totals and statistics."

bostonb

that conversion failed, I have now downloaded the Sleepy version of  snitz_to_smf.sql and had to modify it for proper capitalization, but so far it seems to be working partially

I have a problem with internet connection failing after an hour or so and then it doesn't want to restart the conversion process at the correct spot, and now it says it is finished but the forum is not anywhere near complete, only having finished 30000 posts out of a forum that has 150000 posts

back to the drawing board again, not sure what I will do because maybe the problem is due to my internet connection going down halfway through the process (which seems to be an 8 hour process I think)

so is the consensus that Sleepy's version is the proper one to use for large forums?

SleePy

If you have a large forum,
You should try the command line conversion option.
convert.php can be used in your shell window for your web server (if you have shell access to your web server). Once you call it, it will let you know the parameters to input :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

simonlogan

Hi, I'm trying to convert from Snitz (MySQL) to SMF 1.1.10 using the SQL script attached to this topic and the convert.php attached to the topic linked to from this one but the conversion stops at Step 3 as follows:

Converting moderators... Successful.
Recalculating forum statistics... Successful.

Notice: Undefined variable: to_prefix in C:\xampp\htdocs\simpleMachines\convert.php on line 1821
Unsuccessful!
This query:

    REPLACE INTO settings (variable, value)
    VALUES ('conversion_time', 1248868765),
    ('conversion_from', 'snitz_to_smf.sql');

Caused the error:

    No database selected



If I click on Try Again it just keeps coming up with the same error.  Any ideas how to solve this?

ThorstenE

don't care about these error:
QuoteRecalculating forum statistics... Successful
is the last important step.

The error is related to a variable we add to the SMF database after the conversion (for support reasons).


marco76

Hello to all, to me in phase of conversion it gives back this error to me: Caused the error: Duplicate value ' 6259' for the key ' PRIMARY'.
I have installed smf v. 1.1.11

Norv

Can you please tell, to what step that happened? Copy paste here the full error message.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

dethklok

Hello guys.
I have the same error in this topic http://www.simplemachines.org/community/index.php?topic=125523.0
I have tried to use attached snitz_to_smf.sql but when i open the convert.php I get the following errors:

Warning: fopen(/opt/lampp/htdocs/forum/snitz_to_smf.sql) [function.fopen]: failed to open stream: Permesso negato in /opt/lampp/htdocs/forum/convert.php on line 465

Warning: fread() expects parameter 1 to be resource, boolean given in /opt/lampp/htdocs/forum/convert.php on line 466

Warning: fclose() expects parameter 1 to be resource, boolean given in /opt/lampp/htdocs/forum/convert.php on line 467
Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.
Try again

Hope you can help me.
I'm sorry for my english..it's very poor.
Bye


Norv

Can you please make sure that both convert.php and snitz_to_smf.sql are in the same directory, with these names, they should not be named differently) and restart convert.php fully, by typing its full URL in the browser, with no parameters?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

dethklok

Both files are in the same directory and have original names. I start convert.php with this url hxxp:localhost/forum/convert.php [nonactive]
I have changed read/write permissions maybe now it's working.....

dethklok

Now I have a similar error:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_messages
    (ID_TOPIC, ID_BOARD, posterTime, ID_MEMBER, subject, posterName, posterEmail, posterIP, body, modifiedName, modifiedTime, icon)
    VALUES (28, 8, 1119589155, 3, 'Ricongiungimento dei parenti di cittadini italiani', 'xanderx', '[email protected]', '81.208.60.199', '<font size=\"3\"><b>Il ricongiungimento dei parenti di cittadini italiani </b> </font id=\"size3\"> <br /><br />Entrata e permanenza nel territorio dello stato per i cittadini di paesi terzi familiari di cittadini italiani/comunitari <br /><br />a cura di Alessandro Savoia <br /><br />Le leggi: <br /><br />
This is a little part of forum's topics
Then the error ends with:

Caused the error:

    MySQL server has gone away

Norv

That error is a problem with your host's MySQL server. Please eventually check this documentation and try applying the suggestions (or notifying your host to do it):
http://docs.simplemachines.org/index.php?topic=1501.msg4941#msg4941

Eventually, if by any chance you try again when the server is not very loaded, it may work.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Advertisement: