Sticky migrating Joomla 1.x+Smf 1.x to Joomla 1.5+kunena Script

Could you please send the Error message? Thanks

You will need to add "addslashes()" to the postername and also ad mysql_real_escape_string() to the insert of threads etc.

I need to finish some work on the script myself to import mine, including breaking it into batches, once I have finishes I will post it for you

For anyone interested I edited this script to make it much more likely to succeed

I added the following

- mysql_real_escape_string where required to queries to ensure that characters are correctly escaped andentered into the database correctly (i.e. will allow apostrophe's etc)
- Placed a timer script in there so that you wont overload your server and runs in batches

It basically only lets the MSG import run for 20 seconds at a time, it then stops the script takes current MSG_ID, stops the page load and waits 10 seconds, it then reloads the page and picks up where it left off.

This is by far the ugliest script I have used in a long time, and the changes are adequate at best. So please check everything after it completes.

It's also not very secure, in that it will allow SQL injections, but if you are leaving this on your server, for people to access, well frankly you deserve to have your site hacked

So when you are finished with it make sure you delete it.

I am testing this on my site which has about 225227 Posts in 15714 Topics by 1602 Members

Running my full test now(going to take a good hour to complete given it works on execution time, rather than specific amount of queries/topics)

Anyway should work, I offer no warranty or support, though if you ask questions here I will do my best to answer them and help. IF you have a lot more members than I do and you have a lot more forums/categories than I do, then you may need further changes like a break in the user import, that can be added easily so just let me know if you are getting "maximum execution time" errors and I will make the change for you.

USAGE:
- Download the original package from the first thread
- replace SMF2k.php with the one attached here
- edit the mysql.php file with your settings
- upload to your server
- hit the http://<yourserver>/pathtoscript/smf2k.php in your browser
- Make a coffee, or hang back and watch, it's not that interesting to watch though

re-attaching script as .zip

Please extract then follow steps above

Hey Guys,
First, thanks so much for putting together something like this. I have a quick question though.

I have an SMF 1.1.10 board that is currently standalone. I am setting up a J! 1.5 site and would like to switch to Kunena because of the SMF issues and power struggle.

Can this script be used just to convert over the forum by itself?

THanks!

Hi,

Yes this can be used to convert just the forum