[SMF Converter] Snitz Forums - 3.4

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

Previous topic - Next topic

ZyberZone

I am converting from Snitz to SMF. From Access to MySQL.
I have been able to convert the database, and have started the conversion. But after the members, categories and boards successfully have been converted, I have some trouble with the posts. I've attached a screenshot.
It uses about 5-10 minutes to convert 100 posts, and then it stops. It may start to convert some more, if I push continue, but thats different everytime I try. It seems to time-out somewhere in the script, but I don't know where.
I tried to convert the snitz-datbase to phpbb, and that took about 5 minutes for the posts (80 000 posts).

What am I doing wrong?
Hope someone can help me :) Thanks!

ZyberZone

I think i've solved it, with the last snitz_to_smf.sql from SleePy combined with the tip from bananas on the first page here :)

SleePy

This is in the bug tracker for our converter specialist to update one day. So hopefully someday he will get this fixed. I believe this is happening with newer versions of snitz.

I noticed newer versions as well offered an option to have a static signature that is causing double signatures with SMF. Sadly there isn't much that can be done due to snitz did with this idea.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

PeakD

I am trying to convert my Snitz 3.4.05 on MySQL to SMF.  The converter script returns the following:
==================
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting posts (this may take some time)...
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\inetpub\mydomainname\forums\convert.php(827) : eval()'d code on line 6
===========

The Parse error is repeated several dozen times, then it says:

===========
The query
INSERT INTO `mydbname`.smf_messages
(ID_TOPIC, ID_BOARD, subject, TposterTime, TID_MEMBER, TposterIP, TposterName, Tbody, TposterEmail, TmodifiedName, TmodifiedTime, RposterTime, RID_MEMBER, RposterIP, RposterName, Rbody, RposterEmail, RmodifiedName, RmodifiedTime)
VALUES ('2', '2', 'The post title', '1111288703', '1', '65.56.98.156', 'MemberName', 'Welcome to the  blah blah blah<br />', '[email protected]', '', '', '', '', '', '', '', '', '', ''),
============

Then the VALUES block is repeated several dozen times for the various posts, then:

============
Caused the error:

    Unknown column 'TposterTime' in 'field list'
============

It appears to me that virtually all of the field names are incorrect, each with a T or R tacked on the front. I assume that is related to the Snitz forum using separate Topic and Reply tables, but I don't understand what the converter is doing stacking them together like this.

I'm stuck. Can anyone tell me what is going on here?

Thanks.

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

PeakD


SleePy

Try either the one attached at the start of the thread or this one
http://www.simplemachines.org/community/index.php?topic=147215.msg1231855#msg1231855

I edited the first post and linked to the second one as an unofficial update. For those who find it works with newer versions of snitz.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

PeakD

Thank you!! That seems to have worked perfectly. So far, SMF seems to be a huge improvement. Can't wait to dig in and see what it can do.

target_locked

#48
I am trying to convert my Snitz 3.4.06 MySQL to SMF 1.1.4 My SQL but all failed.
My Snitz Forum was not applied any MODs.

First I use the Convert tool at Archive page (smf_1-1-2_snitz_converter.zip), but it is too old and give a lot of errors.

Secondly I download the file "snitz_to_smf.sql", last posted by SleePy on page 2 of this thread. (still use the convert.php from the coverter tool above)
And below is the result: (see at the end of this post)

My questions:
What is the best tool to convert my Forum? Where can I download it?
Any one who convert successfully from Snitz 3.4.06 to SMF 1.1.4, pls tell me how you did it.

SleePy, could you modify your SQL file to fix that error? and make a note in that file showing what version of SQL file/Snitz Ver/SMF Ver ? And what PHP file should be used with it?
Will the Converter still retain the passwords of users?

Thanks.

______________________________
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting posts (this may take some time)... Successful.
Converting topics... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
    ALTER TABLE `smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2
-------------------------------------------
SMF 1.1.4 now 1.1.8
¡uʍop ǝpısdn ɹoʇıuoɯ ʎɯ pǝuɹnʇ oɥʍ ¡ʎǝɥ

SleePy

#49
That is a mysql bug from my knowledge now allowing us to do that even though it should.

Just open the convert.php file and find:
    ORDER BY LENGTH(code) DESC;

Replace with
    ORDER BY code DESC;

We have a full featured document on this as well (Not for converters, but I will get it going for converters in the team section) :)
http://docs.simplemachines.org/index.php?topic=1079.0
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

target_locked

#50
Thanks SleePy,
That worked.

But I still have problem with the collation utf8_general_ci.
The multi language font can not be converted correctly.  Does your code support UTF-8 characters?

And after the conversion from Snitz to SMF, all user passwords gone. How to retrieve those passwords?

Thanks.
SMF 1.1.4 now 1.1.8
¡uʍop ǝpısdn ɹoʇıuoɯ ʎɯ pǝuɹnʇ oɥʍ ¡ʎǝɥ

lockelaton

#51
QuoteConverting posts (this may take some time)... Successful.
Converting topics... Successful.
Converting censored words... Successful.
Converting moderators... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `forumtest`.smf_smileys
ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2

I've got this error when trying to use SleepY's file. Before it I've deleted the converting board notification and topic  notification and converting censored words processes because they caused error and it wasn't really neccessary to do keep them.

Using Snitz Forums 2000 Version 3.4.03 - converting locally with MySQL 5.01 and Apache 2.2 installed.

Any idea how to solve this? Thx!

=============== update =============

This query:
INSERT INTO `forumtest`.smf_log_notify
(ID_MEMBER, ID_TOPIC)
VALUES ('21', '29'),
('45', '62'),
('63', '54'),
......etc
.....('384', '776'),
('1281', '1624'),
('1283', '1552');
Caused the error:

Duplicate entry '211-155-0' for key 1


This is the error if I use SleepY's original file.

SleePy

for the first error look at this topic, I added information into it
Common conversion errors.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

lockelaton

yay! conversion successful! Thx SleepY!

@mod: we should make SleepY's sql file official.

et10yl

I seem to have successfully converted my snitz forum. Only thing is my host won't enable mhash. Is there a way to get all the user passwords into SMF without them having to use the Retrieve Password feature?

Oh, and I noticed that Private Messages did not import. Is there a way to do that easily?

Thanks!

Sarge

I have sent a PM to SleePy to check out your post and he should be able to read it soon.

    Please do not PM me with support requests unless I invite you to.

http://www.zeriyt.com/   ~   http://www.galeriashqiptare.net/


Quote
<H> I had zero posts when I started posting

SleePy

Quote from: et10yl on December 13, 2007, 07:25:52 PM
I seem to have successfully converted my snitz forum. Only thing is my host won't enable mhash. Is there a way to get all the user passwords into SMF without them having to use the Retrieve Password feature?

Oh, and I noticed that Private Messages did not import. Is there a way to do that easily?

Thanks!

Unfortunately without mhash SMF is unable to attempt to figure out the password. Since it is a password hash it is one way encryption. SMF attempts to figure out the password though by guessing the means other forums use to create a password. If it can match it then it askes for you to type your password again and updates the new one using the SMF hashing method.
Since your host won't enable it, then there isn't much that can be done as this is per user login to update their hash. This may be a good time to look at a new host, as using mhash has no disadvantages or security risks.

The script doesn't appear to convert Private Messages. Is private Messages apart of the default install of snitz 3.4?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

et10yl

Sleepy thanks for your answer & Sarge thanks for bringing it to Sleepy's attention. I guess I'll have to ask users to use the retrieve password feature for now. My hosting is paid through till middle of next year, but I'll be looking to switch then.

No, PM's are not default in Snitz 3.4 though one can't imagine why they wouldn't be. I've looked at the SMF tables and Snitz tables for PM's though, and I think this is how the fields maps over. So it looks like I'll need to figure out the date conversion sequence.


SMF:Snitz
smf_personal_messages:forum_pm
ID_PM:M_ID
ID_MEMBER_FROM:M_FROM
deletedBySender:< i think this might map to M_OUTBOX >
fromName:< I'll need to do a lookup by member ID >
msgtime (1197877620):M_SENT (20060606065937)
subject:M_SUBJECT
body:M_MESSAGE


SMF:Snitz
smf_pm_recipients:forum_pm
ID_PM:M_ID
ID_MEMBER:M_TO
labels:< no snitz equivalent >
bcc:< no snitz equivalent >
is_read:M_READ
deleted:< don't think there's a snitz equivalent >

SleePy

Yea that would work. Its basically an sql query to insert into the databases.
If you figure it out, please post it so other users may convert their pms as well if they wish :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

kurt2000

Hi there

Thank you for this great conversion tool.

My problem is that messages are truncated after danish letters.

"17/2-1999:
Jeg har i alt tre gange oplevet, at bremserne ikke har haft nogen effekt det første par sekunder under bremsningen. Fælles er, at bilen har stået natten over, og at problemet er opstået ved første bremsning efter starten på køreturen. Derefter bremser bilen perfekt."

is truncated to
"17/2-1999:<br />Jeg har i alt tre gange oplevet, at bremserne ikke har haft nogen effekt det f"

It seems that the danish letters æøå is the problem.

The snitz database is utf8, so is the smf.

Anyone have a clue where to look ?

Advertisement: