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

Ok

The following changes have been made ( i still need to write you a new authentication plugin)

Anyway, use the first script "smf2k.php"

WARNING: This new script deletes all existing Joomla users

one more time

THIS SCRIPT DELETES ALL EXISTING JOOMLA USERS SO BACKUP THE JOS_USER TABLE FIRST

anyway run this script, then upload teh script called "tools.php
to you Joomla root directory, run this and enter your Username and Password

You will then be put back in as a Super Administrator and you will have your password working.

At this point you will be able to login, but your users will not as their passwords will be salted with the SMF SALT

Tomorrow I will write you a script that will update your users passwords on their first correct login and MD5 hash them.

This is very ugly scripting but it works

The tools.php is thanks to the jfusion team. I altered it to change the password also so thanks to that team for a quick and good script to do this

Just for parity

THIS DELETES ALL JOOMLA USERS SO TAKE A BACKUP FIRST

removed download file as I just realised that the original author was re-hashing the already hashed passwords, making for a double hash and overheads for login. The new download includes an authentication file and the fixed "as-is" password

Ok new version of the script

Full convert, fresh Joomla, old SMF. This will delete all Joomla users.

You have been warned!

This script puts the passwords into the database straight into the database from SMF.
There is a Joomla.php that you place in your plugins/authentication folder, (backup your old and replace with this one)

What this does is it checks to see if the login works with standard Joomla authentication, if this fails, it checks it against the SMF crypt (basically SMF uses SHA1 + salt and Joomla uses MD5 + salt> I removed the salt for now though but joomla will fix that.

Anyway if the password then match the SMF hash it updates your record to the standard Joomla hash and logs you in.

The reason i did this is that over time, say 3 - 6 months the majority of your users would have logged into Joomla and therefore update their passwords, after that time you can revert to the latest Joomla.php authentication file and login as normal, the users who had not yet logged in can simply retrieve their passwords via joomla password retrieval.

Simple huh?

Any questions let me know

- tools.php -> joomla root (thanks jfusion.org team)
- joomla.php -> plugins/authentication/
- smf3k.php -> replace old

enjoy

- One more warning can't hurt. THIS WILL DELETE ALL EXISTING JOOMLA USERS

Dan

* next I might work on a phpBB converter and eventually clean this up so it actually looks kind of nice and the code isn't so hacky and messy

Hi,

This is Tamir who started the intial post

I could not have imagined that my post would sitmulate reactions from so many people. I guess, This is the beuty of open source.

Because there was not really a good way of migrating smf to anything in Joomla 1.5x, It postponed my upgrade to Joomla 1.5 for almost a year.

Now I am glad that if someone runs into the same problems I had a while ago, she\he could easly solve these.

On behalf of the Joomla 1.x+Smf 1.x users :woohoo: Thank you all for your contribution.


Tamir

Thanks Danny!
I will give this a try and let you know how it goes.

So... will this delete my current Joomla users? :laugh:

OK, so there was a DB error and I lost my post

Here goes again..

OK, the script seemed to run OK, but there were a few issues (So far, all I have found).


1. This error came up at the end of the script:

2. When you view categories, everything in the 'Last Post' column shows as updated today at xx:xxpm (The time changes to the current time every time you click the Categories Tab). If you go into the actual category, it shows the correct date.

I am not sure if this would be fixed if I ran the Recount Board Totals (Read next issue)


3. While I am able to login to the front end, I cannot login to the admin side. I took a look at the DB (in jos_users)and the admin user was set to Registered. I set it to Super Administrator, but that didn't do anything. I compared the Field and Type columns to another Joomla installation and found some differences. I have copied them below:

To fix the dates, just recount the totals, the script wont effect these.

As for the admin. did you run tools.php and set to Super Administrator??