News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] Snitz Forums - 3.4

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

Previous topic - Next topic

medeksza

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?

Norv

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)
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

SEOSEO

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.

johankr

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

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 - hxxp:www.convert-in.com/mss2sql.htm [nonactive] - and now I got everyhing converted.

magicolotto

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

margarett

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

magicolotto

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


margarett

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...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

magicolotto

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

magicolotto

I tried it and it stops now to this error

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

margarett

Strange, that is one of the errors I fixed...
I'm on the phone now, I'll check later what might be wrong...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

magicolotto

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

margarett

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.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

magicolotto

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

margarett

Not sure I understand... Why do you want to change tables? :o
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

magicolotto

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

margarett

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
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

magicolotto

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

Advertisement: