Advertisement:

Author Topic: Converting from Snitz Forums  (Read 73811 times)

Offline Radianation

  • Sophist Member
  • *****
  • Posts: 1,269
  • Gender: Male
  • Why not believe in me?
Re: Converting from Snitz Forums
« Reply #120 on: December 31, 2006, 04:04:20 AM »
There is some SQL code here that might help. Follow the discussion on pages 4 & 5.

http://www.simplemachines.org/community/index.php?topic=15521.msg133936#msg133936

Offline belio

  • Newbie
  • *
  • Posts: 6
Re: Converting from Snitz Forums
« Reply #121 on: January 03, 2007, 02:42:48 PM »
Hi,

I'm trying to convert a snitz-forum using the utf-8 charset, and containing multiple languages like English, French, German, Chineese, Arabic...

I've setup an smf-forum, with the uft-8 option active, and all goes fine (I can post in any language).

As intermediate step I've converted the mssql-db to mysql(5); from phpmyadmin all looks OK, including all special characters.

Then, when running the convertor, only characters like é, à, ç, ü arrive correctly, but more special ones like 圣 숭 get replaced by '??'s

Any idea's on how to fix this?

Thanks

Offline belio

  • Newbie
  • *
  • Posts: 6
Re: Converting from Snitz Forums
« Reply #122 on: January 03, 2007, 05:27:39 PM »
After some searching, editing convert.php and adding

Code: [Select]
if (!empty($db_character_set))
  mysql_query("SET NAMES $db_character_set");

just after

Code: [Select]
// Persist?
if (empty($db_persist))
mysql_connect($db_server, $db_user, $db_passwd);
else
mysql_pconnect($db_server, $db_user, $db_passwd);

did the trick for me  ;D and maybe for others too, with a problem alike  :)



Offline rav4oz

  • Semi-Newbie
  • *
  • Posts: 11
Re: Converting from Snitz Forums
« Reply #123 on: February 03, 2007, 04:08:51 AM »
im going to have to open up this topic again for discussion.

I have checked with my hosting provider and they do not support the mhash module. This leaves me in the sh!t as I now have a forum with 700 members that cannot login. Is there any way around this? can the passwords be converted from SHA256 to the SMF format in any way?

Offline rav4oz

  • Semi-Newbie
  • *
  • Posts: 11
Re: Converting from Snitz Forums
« Reply #124 on: February 06, 2007, 12:42:47 AM »
Anyone there willing to help out? Would really like to make the move to SMF soon. Cheers

Offline rav4oz

  • Semi-Newbie
  • *
  • Posts: 11
Re: Converting from Snitz Forums
« Reply #125 on: February 08, 2007, 12:33:34 AM »
:((

Offline laser

  • Jr. Member
  • **
  • Posts: 202
  • Gender: Male
Re: Converting from Snitz Forums
« Reply #126 on: February 12, 2007, 10:40:06 PM »
Why don't you just remind them that they have to use the "forgot password" feature ? Is that a good solution ?

Offline rav4oz

  • Semi-Newbie
  • *
  • Posts: 11
Re: Converting from Snitz Forums
« Reply #127 on: February 13, 2007, 02:13:23 AM »
Hi Laser, at this stage that looks like the "only" solution for me. Unless of course there is some way to translate the passwords.......

Offline Radianation

  • Sophist Member
  • *****
  • Posts: 1,269
  • Gender: Male
  • Why not believe in me?
Re: Converting from Snitz Forums
« Reply #128 on: March 06, 2007, 03:55:50 PM »
A forum I'm a member of recently converted from SMF to another forum (shame on them!) ... but they sent out a mass email to all users with a link to generate a new password and have it Emailed to you. This might be a nice middle-ground solution.

MHASH would have been a better fix, but oh well. You could try a new host?  ;)
 

Offline rav4oz

  • Semi-Newbie
  • *
  • Posts: 11
Re: Converting from Snitz Forums
« Reply #129 on: March 06, 2007, 07:19:12 PM »
can you receommend a good host that will let me do this? I am presently with godaddy and while there uptime is great, their lack of flexibility gets quite annoying at times!

Offline Radianation

  • Sophist Member
  • *****
  • Posts: 1,269
  • Gender: Male
  • Why not believe in me?
Re: Converting from Snitz Forums
« Reply #130 on: March 09, 2007, 12:55:14 PM »
Might there be a correlation with lack of flexibility and uptime? ;)

Offline laser

  • Jr. Member
  • **
  • Posts: 202
  • Gender: Male
Re: Converting from Snitz Forums
« Reply #131 on: March 18, 2007, 06:17:09 AM »
OK, I'm stuck ...

I'm attempting my first conversion on a fairly important Snitz > SMF conversion

I've downloaded the convert.php and the snitz_to_smf.sql and it asks three simple questions :

Path to SMF:      (autofilled and correct)
MySQL database used by Snitz:    I know this, let's say it's ACME
SMF database password: simple :)

So I enter the values, press the CONVERT button and ...

The error MySQL gave was: Table 'ACME.FORUM_MEMBERS' doesn't exist

NO!!!!, this is wrong !!! ... the table IS there, I've just spent the last 30 minutes converting it from Access to MySQL and making sure it works.

If I use myphpAdmin then it mentions the proper database name all the time. (ie it's not ACME but it's the right name.


AARRGGHH !!!!..

I realised before posting that all my table names are lowercase, so it's cruising along as we speak.

Offline laser

  • Jr. Member
  • **
  • Posts: 202
  • Gender: Male
Re: Converting from Snitz Forums
« Reply #132 on: March 18, 2007, 04:19:41 PM »
AMAZING

I went from hours of errors (caused by the data, people subscribed multiple times, etc...) to a fully converted forum in a few hours .....  Goodbye Snitz and H-E-L-L-O SMF !!!

I'll post full details of the site when it is released, but still under development at the moment.

I still have a lot of testing to do, but it looks great.  I did need to use the sql file posted (somewhere, forget where) to get around the GROUP BY error at the substep 7 or 8 mark.

All in all, VERY pleased !!!

Offline Radianation

  • Sophist Member
  • *****
  • Posts: 1,269
  • Gender: Male
  • Why not believe in me?
Re: Converting from Snitz Forums
« Reply #133 on: March 18, 2007, 11:33:15 PM »
Congrats. Snitz is the junk and ASP can burn. =P

Offline Cixi

  • Jr. Member
  • **
  • Posts: 116
Re: Converting from Snitz Forums
« Reply #134 on: December 13, 2008, 09:49:52 PM »
Can anyone of you help me to convert Snitz to SMF?
I have created a dump.sql file using bullzip application converter.
Now what step I have to do to obtain the conversion?

I always get the following error:
"Sorry, 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: SELECT command denied to user 'cixi_smf1'@'localhost' for table 'FORUM_MEMBERS'"


Thank You
« Last Edit: December 13, 2008, 10:21:40 PM by Cixi »