Simple Machines Community Forum

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 (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.

Unofficial Update
For users who have issues with this attached converter,

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


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.

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?

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

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.   

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.

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!

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?

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.

password translation see this link http://www.simplemachines.org/community/index.php?topic=34642.120

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.

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!

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.

Were you able to convert?

No.

Help desk ticket #1587 is open regarding the issue.

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?

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.

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,

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!

Quote from: cuneytsn on June 25, 2007, 11:02:32 AM
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,

You can't just upload a SQL file, you need to create the tables in a mySQL database.

I have to do the same procedure soon (I last did it about 6 months ago), so I'll document exactly the steps that I do ... I remember the road was a bit wobbly, but in the end I had a perfect SMF forum, a mirror image of the old Snitz

That was my mistake. You are absolutely right. After created MySQL database (run SQL commands via PhpAdmin)  I run convert.php

And works perfectly. !
thanks for advices,

How big was your database that you converted? My Snitz Access DB is about 65Mb with a few mods and while I have created the SQL files, I am having tons of trouble getting them into the database. Errors everywhere!

I've tried all .sql and convert.php files and i still have the TposterTime problem.

I can't understand why the hell the script doesnt detect the "keys" arrar :|

Quote from: sunflashx on April 26, 2007, 06:57:58 PM
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.

I have same problem... someone can help me?

In attach a browser screen-shot and a db print.

up :'(

Quote from: sunflashx on May 21, 2007, 04:43:40 PM
No.

Help desk ticket #1587 is open regarding the issue.

Where I can read this ticket?

You can't read the ticket as it is a private ticket with our help desk. Only the ticket starter and the SMF team can read it.

Is this still to convert from 3.4? or a newer version?

Hi there,

i ran the converter for my snitz forum and by using these custom converter.php files here, it finally worked. Now i have another problem: the passwords. I tried and looked through these "password conversion"-topics but didn't find anything usefull, since i'm not a very good programmer. The problem is, that i activated the maintance-mode for the SMF-Forum bevor i started the conversion. Since my old adminaccount was deleted during the conversion and the password for my Snitz-adminaccount doesn't work, i have no access to my SMF-forum any more. Is there a pretty simple way to convert my admin's password or to reset it somwhow?

Thanks in advance.

Register a new user by yourself and follow this:

I accidentally deleted my admin account (http://docs.simplemachines.org/index.php?topic=466)

This will give you admin access for the user you register.

The Problem is, that i can't register a new user, because my forum is in maintenance mode. So i could do the following:
-Delete the SMF
-Install it again
-run the snitz->SMF converter, but this time with the forum not being in maintenance mode
-make all users choose a new password

Could you access your database via phpmyadmin and delete the password for your actual admin? This way you could have a blank password, that you could change later.

I did this too,but the problem is, when U try to login this way and enter a blank password it says: "The Password-Field is empty."

So it checks, if U type a password and doesn't let U log in with a blank password...

I see... Well, maybe you can change the password field of the members table to be "plain" instead of "md5". Then you write a password you know...

Input a plain text password.

SMF will detect that the password needs upgrading to its security measures it does and ask you to type your password again. once it does it makes sure it is the same then it uses that to rehash it into its style.

Converting members... Successful.
Converting categories... Unsuccessful!

I was converting members over and i guess it was successful.
But my administrator account was overwritten.  how can i get it back or manual add an admin account.  thanks

In phpMyAdmin look for your user name and set the ID_GROUP to 1.

Just a comment:
This one doesnt run properly if the database is relatively big.
I converted a Snitz to SMF today, but did lots of work manually.
First, I tried running in my personal computer locally.
It always screws the processor for about 10-20 minutes, then it prints "Converting posts (this may take time...)" but it actually exits the code. Because its trimmed. (For example no continue button)
Then I uploaded to the production server, the same result.
The database was only 20 Megs..

It doesnt continue from where it left. The reason I think; these new convert.php files divide the sum of data into parts proportional to its size. For example divides 1000 messages into 100 parts and inserts the data 100 by 100.
But if the database goes over 10000-20000 posts, it divides to for example 1500 and cant insert it once. Suppose that its 50.000 messages, it will probably lock the server completely.

Elmacik,

Try out this one. I modified it for a charter member who had this issue with a large forum.
It also should fix an issue with snitz thinking it was a good idea to do static signatures and insert signatures into messages, resulting in double signatures when viewing the post in SMF.

Thanks SleePy, as I stated above, I already converted it doing the lots of work manually. :)
I also edited snitz_to_smf.sql for some errors, but didnt know signature problem.
But I will try your locally, just to test it and give a report.

And I think converters section must be rearranged. Because there are lots of files attached to posts. Most people will confuse which to use and what to do.

Edit: Seems like yours is working better, SleePy. Didnt give any errors. (Used with a patched convert.php for the common errors.)

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!

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 :)

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.

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.

Which file are you using?

I downloaded this converter file last week:
http://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-2_snitz_converter.zip

(I hope that is what you were asking)

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.

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.

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
-------------------------------------------

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

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.

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.

for the first error look at this topic, I added information into it
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)

yay! conversion successful! Thx SleepY!

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

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!

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

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?

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 >

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 :)

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 ?

Which convert.php are you using?

I believe I have the latest versions of convert.php and the SQL script. I'm getting the following error however:
Notice: Undefined index: charsets in /home/sl113/public_html/forums/convert.php on line 378

And then later on it killed on:
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 ' 'Drive in the Redwoods', '', '', '0', 'We has a great drive through the redwood' at line 251

Which I suppose is caused by incorrect characters in that record... but I'm still checking that.

I do need character set conversion... so any help you can give me much appreciated.

Peter

I had to use Sleepy's converter to get away from an 'm_sig' error when converting.   My forum converted successfully and everything appears to be working, but with one big problem --- topics with 0 replies did not come across.

I assume this is due to Snitz not making an entry in the reply table when a topic is posted, only when it is replied to.  Anyone have a fix?    This is the only thing left preventing me from removing one more snitz board from the www....

Does snitz in the forum topics table track now many replies to a topic?

I can't see a way around that easily (maybe I shouldn't be looking at programing when I am very tired) without having that sort of information.

Yes, in the t_replies column

Below is a list of column names in the topics table:

CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_MAIL, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_ARCHIVE_FLAG, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG

My issue seems to be different, when I run the converter I get the following:

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

this happens in an instant, way to fast for me to think it acutally worked. When I look at the database nothing appears to have changed.

I understand many are using SMF on a Linux box, I intend to run this on a windows machine, my local setup seems to work just fine. Currently I'm just trying to run the conversion on my local machine, later I will move the data to the live site. I will be converting three forums one of which is very active, the other two are moderately active.

I have SMF 1.1.5 installed and working, once for a new site I'm working on starting with SMF no conversion required, another installation is for the first of the three sites to be convertered. A third installation is for testing this conversion process.

My Snitz software is 3.4.03, it has a few mods but I'm assuming the conversion process does not care about any added fields to any of the tables as long as the fields it needs are there.

My main goal is to get the membership moved over and the last few months posts. For now I'm working with a three month old version of the MS-SQL database. Using SQLyog I have migrated the tables and data to a MySQL database. My test conversion setup has both the snitz tables and the smf tables in the same database each forum's tables using a different prefix.

I have looked through a few different threads about the problems others have had and it seems that I should see messages indicated what is being converterted with some indication as to its success or failure. As mentioned above I get a rather quick success message but it does not appear to have worked.

I'm not really sure where to go from here, any thoughts would be apprecitated.

Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)

That may help explain this :)

Quote from: dno on August 16, 2008, 06:43:30 PM
My issue seems to be different, when I run the converter I get the following:

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

this happens in an instant, way to fast for me to think it acutally worked. When I look at the database nothing appears to have changed.

I understand many are using SMF on a Linux box, I intend to run this on a windows machine, my local setup seems to work just fine. Currently I'm just trying to run the conversion on my local machine, later I will move the data to the live site. I will be converting three forums one of which is very active, the other two are moderately active.

I have SMF 1.1.5 installed and working, once for a new site I'm working on starting with SMF no conversion required, another installation is for the first of the three sites to be convertered. A third installation is for testing this conversion process.

My Snitz software is 3.4.03, it has a few mods but I'm assuming the conversion process does not care about any added fields to any of the tables as long as the fields it needs are there.

My main goal is to get the membership moved over and the last few months posts. For now I'm working with a three month old version of the MS-SQL database. Using SQLyog I have migrated the tables and data to a MySQL database. My test conversion setup has both the snitz tables and the smf tables in the same database each forum's tables using a different prefix.

I have looked through a few different threads about the problems others have had and it seems that I should see messages indicated what is being converterted with some indication as to its success or failure. As mentioned above I get a rather quick success message but it does not appear to have worked.

I'm not really sure where to go from here, any thoughts would be apprecitated.

Any thoughts on how I can get around the problem I'm having?

Did you read my reply?

Hi, I have email problems - forum does not send out some emails. I posted this in the 1.x support with no solutions so far, but then realized since I converted from Snitz 3.4 this might be related. Anyway, my post is at:
http://www.simplemachines.org/community/index.php?topic=257513.0

so if you can help in any way.
Thanks

serge06,

If you are having such issues, you would get a faster response by asking in the general English, which I have see you have done :)

The issue is most likely related to a setting and not what was converted.

Quote from: SleePy on August 22, 2008, 12:05:03 PM
Did you read my reply?

Sorry about that, I've been bug-eyed with a ton of projects, but this has moved up to the top of my priority list.

I did look at your link (which I missed for some reason) I thought I had my folders writeable but I will double check it.

I did manage for my initial test to convert things using a more recent version of the converter running on a linux server. I just moved the data from that server to my soon to be live server.

One interesting thing came up. It seemed like everyone that was testing on the conversion server was able to log in without any issue, on the soon to be live server everyone had to reset their passwords. As far as I know I have the correct settings on the live server. The biggest difference is the live server is on windows.

I also tried the converter version 1.1.6 and got an error about a ";" which was expected to be a ")" I'm sorry I don't have the exact error right now but if you need it I will replicate it.

The convert files from the 1.1.6 are broke, still working on getting a developer to update the download packages but they are very busy people.

There is a fixed one here.
Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)

I finally managed to get it converted, although it seemed to drop every occurence of the number one so 10 would be zero and 911 would be nine. Not a big deal the meat got moved and I can live with it. The membership got moved and my members are finding there way over and exploring the new features. Now I'm off to track down a different (non conversion) issue.

Thanks for you help.

Im trying to use the converter - but i get following error :
Converting posts (this may take some time)... Unsuccessful!
......
Caused the error:

Unknown column 'M_SIG' in 'field list'

what is wrong - no posts is transfered...

try this:
edit the snitz_to_smf.sql and find:
REPLACE(REPLACE(REPLACE(R_MESSAGE, '\n', ''), '\r', ''), M_SIG, '') AS Rbody,
replace it with:
R_MESSAGE AS Rbody,
the restart the conversion..

Quote from: 86atc250r on July 24, 2008, 08:58:28 PM
I had to use Sleepy's converter to get away from an 'm_sig' error when converting.   My forum converted successfully and everything appears to be working, but with one big problem --- topics with 0 replies did not come across.

I assume this is due to Snitz not making an entry in the reply table when a topic is posted, only when it is replied to.  Anyone have a fix?    This is the only thing left preventing me from removing one more snitz board from the www....

I am having this exact same problem. I finally got my access database converted to MySql and got Sleepy's converter to work but all of my topics that do not have a reply do not get converted. Has anyone found a solution to this problem? Thanks.

yes, that's exactly the reason why I updated the snitz_to_smf.sql in the first post from this topic:
http://www.simplemachines.org/community/index.php?topic=147215.0

Thanks TE but when I use that file I get this error.

Converting members... Successful.
Preparing Conversion (part 1)... Unsuccessful!
This query:

    SELECT
    REPLY_ID AS old_id_msg, 'msg' AS type, R_DATE AS msg_date, TOPIC_ID AS old_id_topic
    FROM `mivadiva_ddg14IC`.forum_reply
    LIMIT 0, 200;

Caused the error:

    Table 'mivadiva_ddg14IC.forum_reply' doesn't exist

I do not get that error with Sleepy's file from this post.
http://www.simplemachines.org/community/index.php?topic=147215.msg1231855#msg1231855
It works fine except for the zero reply problem. I have looked at the database with phpmyadmin and the table actually does exist and has records in it.

I think that I may have solved it. I am new to PHP and MySql so I am not that familiar with the code. It seems that the code is case sensitive so I changed forum_reply to FORUM_REPLY in the snitz_to_smf.sql file from the first post of this topic and everything was converted successfully. This conversion was for my test forum that was not active. Now to see if I can convert my active forum...

Update: I noticed that ALL members accounts converted. Snitz has the ability for the admin to "lock" a members account. It does not delete the account but simply prevents the user from using it. I guess this is similar to the ban feature in SMF. I had some spam accounts that were created that I had locked in Snitz. In my SMF forum all accounts came through and show as active. It is really not a big deal in this case as I only have 7 such accounts and I can simply delete them from the new SMF members list. I just thought that I would share this information since I have seen no other mention of it.

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?

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..

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


Open the .sql file

Find:
---* {$to_prefix}log_notify

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

That did the trick! Thanks!

:)

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

Find:

Code Select Expand

---* {$to_prefix}log_notify

Replace:

Code Select Expand

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

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??

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.

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

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?

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 :)

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?

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).

Thanks muchly :)

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

Can you please tell, to what step that happened? Copy paste here the full error message.

Hello guys.
I have the same error in this topic http://www.simplemachines.org/community/index.php?topic=125523.0 (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

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?

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

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

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.

with original files (http://download.simplemachines.org/?converters;software=snitz) works perfectly

Thank you! ;)

I am trying to migrate my Snitz forum to SMF and I would say I am 95% successful, just a couple of issues I'd like to figure out how to fix. It has to do with a difference in how Snitz and SMF interpret the URL tag. I had a mod on my snitz forum which allowed users to do file uploads which would then automatically post a URL link to it in their message. The format it used was:

[img]icon_paperclip.gif[/img] <b>Download Attachment:</b>
[url="http://www.zabaware.com/forum/uploaded/snowman/20091225211915_HAPSWAP-2.uhp"]HAPSWAP-2.uhp[/url]
18.29 KB

SMF doesn't interpret the URL tag the same way, it doesn't like the double quotes after the url= so the link to the attachment doesn't work.  Also a more minor issue is the img link to the paperclip doesn't work either, it doesn't understand relative links to images and tries to link to the image as if it was a domain name. 

Also sometimes users would post a URL link to another post on the forum. Would it be possible to get the converter to detect links on the old forum (such as forum/topic.asp?TOPIC_ID=1234) and automatically convert it to the new forum equivalent (in my case community/index.php?topic=1234.0)?

Is there anyway to modify the conversion script to automatically deal with this issue?

About the URL format of uploads: a little mod could be made, for SMF to interpret them as well. The relevant code is in parse_bbc() (Sources/Subs.php).
About the links rewriting, I think a solution would be a .htaccess file which would rewrite on the fly exactly as you say, the URL with topic.asp into one SMF-like v- that is, would redirect the user to the new one, when he/she clicks on the old one. (assuming your server runs Apache or something accepting .htaccess files and mod_rewrite is enabled)

Hi. Struggling to see what I need to do to convert my Snitz 3.4 to SMF. I have downloaded convert.php (the original post in this thread leads to a loop but I found it elsewhere on this board. I have no information on preparation or whether I can do this offline as it's an Access database.

Here are my current params:

Snitz 3.4.03
Access DB
55,000 posts of which 39,000 are archived
941 members
PM mod

Not much else really, a couple of small mods eg image resizing.

Because it is an Access DB is it worth me unarchiving the posts first and if so how?  Thanks in advance for any help.

I used DPRU Database Converter - MS SQL to MySQL to convert my Snitz 3.4.07 MS SQL DB. I then used the convert.php from the first msg in this topic and the sql-file from SleePy (page2 of this topic: http://www.simplemachines.org/community/index.php?topic=147215.msg1179015#msg1179015 (http://www.simplemachines.org/community/index.php?topic=147215.msg1179015#msg1179015)).

First I got all kinds of errors but then I realized I had to use a v1 version of SMF, I now use smf_1-1-16_install.zip. Upgrading to v2 will be another project :)

EDIT: After analyzing more I found that rows were missing and that the Converter software for ms to mysql wasn't doing it's job correctly. I switched to this product - http://www.convert-in.com/mss2sql.htm - and now I got everyhing converted.

hello all I tried to do a conversion, sensing the way aggire, but gives me this 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 'TYPE = MyISAM' at line 6

Which converter did you use?

There is more of a converter?
I can not remember , I only saw one, you give me the latest version

I think I've used this

http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_snitz_converter.zip

Try the converter attached to this post here
http://www.simplemachines.org/community/index.php?topic=528995.msg3754532#msg3754532

Also, the post report is NOT to be used to request for help...

an application file
snitz_to_smf.sql
  I have to put it in the root of the forum?

while phpadmin must contain the two .sql, that of 'smf and that of snitz


thanks in a while I try and tell you

I tried it and it stops now to this error

Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Strange, that is one of the errors I fixed...
I'm on the phone now, I'll check later what might be wrong...

ok help me
in the conversation where you made me download the files, the user has had the same mistake, and they were answered by you and you have attached another file, but that was taken away
thank you

No, not really. That was the latest file I uploaded.

So, in steps: I fixed an issue and attached. Then I fixed another issue, so I uploaded another file and removed the previous one. Which resulted in the file you got.
The birthday thing is one of the issues I fixed so please make sure you really uploaded the correct file.

if I wanted to skip complenni
how should I modify the tables of mysql?

Not sure I understand... Why do you want to change tables? :o

if we remove the problem, even in the profiles there is no date of the birthday does nothing

No, that should not be necessary.
Make sure you download both files from that post I linked you, then upload both to you new SMF installation and then run the converter as documented

ok thanks for the advice
I do so
1) amount of the forum via ftp
2) put the file convert.php and snitz_to_smf.sql file in the root of the forum
3) start the file convert.php

I do the exact procedure?














Digita il testo o l'indirizzo di un sito web oppure traduci un documento.






Forse cercavi: ti all'ego le immagini ho appena riprovato













I am attaching pictures
I just tried again

up

Please don't bump your posts in such short notice...

Some things that I noticed:
- You are using Snitz 3.4 and the converter is ready for 2.0. There are probably database changes and the converter needs to be updated.
- The printscreen that you posted before has something strange. It refers to "SMF" in some places where it should use "Snitz". Weird.

Anyway, I don't think that there is a quick fix for your case :(

I apologize if I was impatient
I really like smf
But I urge to migrate. you can 'do something faster?
I change so that birthdays are skipped in the conversion
thank you

Wait. now I messed up :P

The converter I fixed was in fact for Snitz 2.0.
But this topic is for Snitz 3.4 like you have. I messed up, sorry.

I need to fix this converter (3.4) with the same fix as with the other one. You might skip the birthdate but the posts time/date will produce the same error. And those you can't skip...

OKAY, I look RESPONSE here, for when you are ready to give me news byone

While confident appearance

I can insert various mods forum with the various settings?

so then when I do I find the settings migration template included

I have to do before migration and then put the mods?

I uregente need, even with a cotributo to those who can do it, if you contact me in private

Hello. Dunno what is the problem, but I'm always getting 500 internal server error when running the script. Probably is a problem with my hosting? Thank you!

Someone knows how to solve this error for the conversion?

wrong value type sent to the database. expected dates. (birthdate)


Thank you so much I would need to fix error even privately with donation

Quote from: oldboy on February 27, 2015, 04:42:19 AM
Hello. Dunno what is the problem, but I'm always getting 500 internal server error when running the script. Probably is a problem with my hosting? Thank you!

It should be something server-related, yes. Check if you have any file permissions to 777 and, if so, change the folders to 755 and files to 644. Some hosts trigger error 500 in this scenario. If in doubt, check with your host. The server logs should allow to discover the cause.

Quote from: magicolotto on February 27, 2015, 05:39:02 AM
Someone knows how to solve this error for the conversion?

wrong value type sent to the database. expected dates. (birthdate)

Thank you so much I would need to fix error even privately with donation

Thank you for the offer. I will fix it when time allows. No donation required. Of course, if someone else wants to pick the offer, go ahead ;)

Quote from: margarett on February 27, 2015, 09:00:55 AM
It should be something server-related, yes. Check if you have any file permissions to 777 and, if so, change the folders to 755 and files to 644. Some hosts trigger error 500 in this scenario. If in doubt, check with your host. The server logs should allow to discover the cause.

Huh. Thank you @margarett. Thanks God that file permissions is the problem :D

nothing here

Anyone got any advice, when i run the convert.php and give it the DB details it moves onto this screen and just sits there with the first line "Select Script" highlighted.  What am i doing wrong?


Select Script
Welcome
Main Conversion
      - Members...
      - Preparing Conversion (part 1)...
      - Preparing Conversion (part 2)...
      - Categories...
      - Boards...
      - Topics...
      - Posts ( part 1 - this may take some time)...
      - Posts ( part 2 - this may take some time)...
      - Topic notifications...
      - Board notifications...
      - Censored words...
      - Moderators...
Recount Totals and Statistics
Done

News?