News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

[SMF Converter] Snitz Forums - 3.4

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

Previous topic - Next topic

JayBachatero

Software: Snitz Forum
Version: 3.4

This is the official support topic for Snitz Forums converter.  Use this topic to ask for support for this converter.

Changelog
! Typos (snitz_to_smf.sql)
! Updated converter with he fixes sleepy provided including the static signature issue.
!fixed Major Bug in topics / messages conversion.

convert.php
Use this convert.php with the .sql file attached in this topic.

Unofficial Update
For users who have issues with this attached converter,
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

rav4oz

Im getting an error


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

    SELECT
    t.TOPIC_ID AS ID_TOPIC, t.T_STICKY AS isSticky, t.FORUM_ID AS ID_BOARD,
    MIN(m.ID_MSG) AS ID_FIRST_MSG, MAX(m.ID_MSG) AS ID_LAST_MSG,
    t.T_AUTHOR AS ID_MEMBER_STARTED, t.T_LAST_POST_AUTHOR AS ID_MEMBER_UPDATED,
    t.T_REPLIES AS numReplies, t.T_VIEW_COUNT AS numViews, t.T_STATUS = 0 AS locked
    FROM (`pra073111034676`.FORUM_TOPICS AS t, `pra073111034676`.smf_messages AS m)
    WHERE m.ID_TOPIC = t.TOPIC_ID
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 0, 500;

Caused the error:

    Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

rav4oz

#2
After some mucking around, I manually edited the conversion file with the changes suggested on another thread that was closed.

The converter crashed at the FORUM_SUBSCRIPTIONS Table since somehow there were some duplicate entires for members who had the same subscription  :-X Dont ask me why snitz did that. After a little back and forward deleting the duplicate entries via phpmyadmin the converter complted the job successfully.

I then had to get the forum to reset the admin password after which I had to run Forum Maintenance. everything turned out sweet in the end  8)

I have attached my sql file to this post for anyone having problems with all the other modded files available on this site.

Emnitec

Hello!

I'm extremly new to SMF and I'm trying to convert a Snitz 3.4.06 to SMF. But, after I have placed the convert.php and snitz_to_smf.sql in the root of the server and start, It goes on for 10 second and then I get the fault: "lost connection or error with the DNS"??

When I look at the smf-database I can se that the members have been converted but then it stops.

Any suggestions?

rav4oz

what is the exact error that you are getting? How big is your forum database? members / posts etc.

Emnitec

#5
It's the same error as you get when you really lost connection to your network. No, php och database error. I'm doing the convertion locally, with a rather descent machine.

The forum holds 1200 members, 11000 topics with around 80000 posts.

My Computer is running XP and IIS. All web-applications are working well.   

rav4oz

well you might want to try a Linux machine buddy, not too familar with the running of this stuff on a windoze box. You might want to check your script timeout setting on IIS (this is all I can think of at the moment)

In my case I imported all of the snitz tables into the same dbase as joomla and imported it across, but I did it all online on through our web hosting service.

Emnitec


Ok, thanks for the answer! I would probably get an Ubuntu-server up'n running on vmware pretty fast so I could try the conversion there. I have thought of doin it at the web hoster, but I'll try this first!

sunflashx

I'm trying to convert a Snitz board to SMF.  The converter is currently giving me this error:

Converting members... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_members
-- procedes to list all row and all users from table

Caused the error:

    Incorrect date value: '' for column 'birthdate' at row 1

Any suggestions?

superdave

I ran the converter and after several versions it was successful, but when I try to log in, it gives me this message:

Password security has recently been upgraded. Please enter your password again.

When I enter my password again, it says that is in invalid. Has anyone seen this after this conversion. Any help would be greatly appreciated.

David H.


JayBachatero

Quote from: sunflashx on March 21, 2007, 02:58:23 PM
I'm trying to convert a Snitz board to SMF.  The converter is currently giving me this error:

Converting members... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_members
-- procedes to list all row and all users from table

Caused the error:

    Incorrect date value: '' for column 'birthdate' at row 1

Any suggestions?

Try this file.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

jjprices

Thanks to everyone for their work on helping with this conversion!

I have a snitz forum with about 200,000 total posts and replies.  With the help in this thread and others, I have gotten past errors, but the process of loading the actual smf_messages is very slow.  After about 12 hours it has loaded about 25,000 records.  It seems to run in bursts, 50ish at a time, then 100ish maybe 15 seconds later.  The 2200 members loaded up right away, just takes quite a while on the messages.  I made sure the indexes were in place on the snitz tables, and I did optimize all tables before starting the convert.php. 

It appears to be working, just trying to see if there are any ideas to speed it up so I have less downtime when I do this for real (doing a mock run right now)

Thanks!

sunflashx

Seems the error is gone but now the conversion process runs for about 7 hours or so and then just stops.  The whole time CPU is at 100% utilization.

The board is medium sized, 692 Members, 133615 posts, 13098 topics.

This is the last line posted to the browser.

Converting posts (this may take some time)...

Throughout the process none of the DB files gain any significant size.

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

sunflashx

No.

Help desk ticket #1587 is open regarding the issue.

OpenIntro

#16
I just got my SMF forum up and I ran the convert.php to start the conversion process from my Snitz (3.4.03) database.

When I started it, it immediately came back with an error of:

QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Snitz Forums. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect table name 'FORUM_MEMBERS'

Any ideas? It looks as if I am not giving the correct path to the snitz db....even though I have given it the direct path....

*edit* My Snitz Database is an Access Database....could this be the problem? I am trying to convert it to MySQL but am having a hell of a time....any suggestions?

JayBachatero

Quote from: OpenIntro on May 30, 2007, 08:19:04 AM
I just got my SMF forum up and I ran the convert.php to start the conversion process from my Snitz (3.4.03) database.

When I started it, it immediately came back with an error of:

QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Snitz Forums. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Incorrect table name 'FORUM_MEMBERS'

Any ideas? It looks as if I am not giving the correct path to the snitz db....even though I have given it the direct path....

*edit* My Snitz Database is an Access Database....could this be the problem? I am trying to convert it to MySQL but am having a hell of a time....any suggestions?

You need to convert it to MySQL in order to convert to SMF.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

cuneytsn

Hi all,

I have the same problem exactly. I converted my snitz forum database (was in access) with AccessToMySQL converter. I have a dump file (whole forum including table structure and data). I put this dum file "FORUMDUMP.sql" to my SMF forum directory, and I 'm trying to run convert.php (for snitz). Finally I get an error :
The error MySQL gave was: Incorrect table name 'FORUM_MEMBERS'

I looked around and all of them same advices . Convert to MySQL first !
I did already. Whats wrong ? Any idea
thx,



bananas

I have also experienced slowness during the message migration process.  I've managed to speed things up by an order of magnitude by increasing the batch size. 

By default, the batch size for message conversion is set to 100.  I increased this value to 4000 (your mileage may vary; I suggest experimenting to find a value that's appropriate for your system).  The batch size is found inside the snitz_to_smf.sql file. Look for a line:
---* {$to_prefix}messages 100

and change it to something like this:
---* {$to_prefix}messages 4000


Important note: this change caused the message conversion routine to fail because the larger batch size exceeded a packet size limit in the MySQL server.  By default, the value of max_allowed_packet is set to 1M. I increased it to 16M after doing a little research on the internet and had no problems with message conversion batches of size 4000. 

On my MacBook Pro (Intel core duo 2.0ghz) I converted 200,000 messages in about 40 minutes.

That hurdle over, I'm off to tackle the next!

Advertisement: