Converting from Snitz Forums

[NoRad]

haha I'm notorious for being a moron. 

Totally overlooked the Charter member in my blind rambling. Guess what? I'm getting ready to convert yet *another* forum from Snitz to SMF. Wish me luck this time. haha!

[ssoltz]

Bah,

No worries! No one can feel as moronic as I during this process. Talk about multiple learning curves!

Anyway, feel free to IM me at any point during your process if you get stuck remembering how you did something (only because its fresh in my mind...not like I'd be able to troubleshoot for you or anything!).

I'm on most of the IM services as well during normal business hours.

Good luck!

[NoRad]

Thank you!

[castle900]

I can't even get past the first page.. It comes up and tells me

CGI Timeout
The specified CGI application exceeded the allowed time for processing. The server has deleted the process.

[castle900]

anyone have any ideas 

[NoRad]

Read all 7 pages of this thread and you'll figure out that those of us that have actually managed to convert from Snitz were rather lucky that it worked, but each installation is a little different. It could be a number of things. Good luck.

[atomickarma]

Hi
I'm attempting to convert a Snitz forum to SMF.  I've exported the access db into a mysql file, and following installation have attempted to run the snitz_to_smf.php script, however i get the following SQL error:

    SELECT COUNT(*)
    FROM `koutput.sql`.FORUM_MEMBERS;

Caused the error:

    Incorrect table name 'FORUM_MEMBERS'

Obviously this is a valid table - any thoughts as to how I can resolve this? 

Thanks
atomickarma

[atomickarma]

I should add that I get the same error when attempting to use the access db instead of the mysql version.

[NoRad]

Are they both in the same db?

[ZeusChicago]

To anyone that reads this. I have found that the converted in the "downloads" area does not work, but if you follow unknown's threads in here (and download the latests in his post) you can get this working pretty smoothly.

Make sure your logged into the forums (otherwise you wont see his attachments)

One question, any way to increase the amount it proceses per refresh when converting the posts? I have about 300,000 posts, 100,000 topics. 200-300 at a time, just aint cutting it.

Z

[NoRad]

100,000 topics with 300,000 posts? That's an average of 3 posts per topic and a very unusual ratio for most forums. What type of a site do you run out of curiosity?

You can adjust this in the script of course. Just search for it.

[ZeusChicago]

100,000 topics with 300,000 posts? That's an average of 3 posts per topic and a very unusual ratio for most forums. What type of a site do you run out of curiosity?

You can adjust this in the script of course. Just search for it.

I host several events/nightlife chat board for the Chicagoland area. This particular one is one of the oldest, http://www.inside-chicago.com/forum [nofollow] . Not sure if you know Gargoyle on here (he's an old Snitz guy to). I was running SHN Version of Snitz, which if your familiar with is a heavily mod'd version of Snitz. The code's was just way to old, troubleshooting was a ******, support was nonexistent, and I find myself disliking Windows Dedicated servers more and more after I picked up a Unix box 

I found the settings and after using the scripts found in this thread (as the ones in the download section didn't work at all for me). I got everything taken care of.

Many thanks to all (and unknown for sure) who contributed to this thread

Z

p.s. I was wrong on the post/topic count...its was more like 20,000 topics to 100,000 replys. Snitz however did topic/replies differantly so I was looking at the number of records imported when I moved it from the access database to mysql to run the convertor (and was basing it on that)

[NoRad]

Awesome. I do a similar site for the Louisville and surrounding cities in the Midwest. we have some Chicago posters on our site as well. Love the city. Was just staying at the Sofitel a few weeks ago to see the Pet Shop Boys and of course my wife wanted to see Wicked. Le Colonial was amazing as well.

Glad you got the conversion working. Snitz is just way dated these days.

Cheers!

[ZeusChicago]

Awesome. I do a similar site for the Louisville and surrounding cities in the Midwest. we have some Chicago posters on our site as well. Love the city. Was just staying at the Sofitel a few weeks ago to see the Pet Shop Boys and of course my wife wanted to see Wicked. Le Colonial was amazing as well.

Glad you got the conversion working. Snitz is just way dated these days.

Cheers!

Nice   

I have two or three other Snitz boards I am going to be converting to over SMF over the course of the next couple weeks. It's sad really, Snitz is like that old best friend that is happy liveing out in the country and doesnt want to move into the big city with ya  I will miss the folks (but not that damn code...lol).

Z

[NoRad]

The code was a mess, just like ASP in general. 

I hope the migration went smoothly.

[wilsy]

Hi all,

Big thanks to all in this thread as I too have now converted across from my Snitz forum without too much pain.

Did anyone ever manage to work out the sorting order for the topics? Mine didn't sort properly when they came across  and I dont want to go through the conversion process again having come this far 

www.farnworthgrammar.com

Merry Xmas!

Regards,

Rick.

[NoRad]

Did you run the maintenance tools in the admin section? I think that fixed the sorting for me.

[wilsy]

Hi Radianation,

Yes, but with no luck i'm afraid. Am trying to install the custom board sort mod in the hope that this will resolve my issues.

Many thanks for providing the inspiration to migrate from Snitz, SMF rocks!

Regards,

Wilsy.

[NoRad]

Something sounds familiar about this problem. Is it sorting based on the topic creation date and not the last reply date? There is another thread on here and I wonder if that was something I ran into.

[wilsy]

Hi Radianation,

Yes, that seems to be the case.

Regards,

Wilsy.