SMF Support > Converting to SMF

[SMF Converter] Snitz Forums - 3.4

(1/21) > >>

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,

rav4oz:
Im getting an error


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

--- End code ---

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

Navigation

[0] Message Index

[#] Next page

Go to full version