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

Sorry yeah meant the same database.

As for users no you cant really jsut backup the user table as you also need the ACL tables filled inc correctly.

Backup allt eh ACL and user tables and you will be right though.

better however to do this in aother installation

I want to apologize for being a nob. The person that did all the smf is no longer helping and with the upgrade to joomla 1.5/community builder kunena sounds like it might be the best solution long term. Hoping to get there. Many thanks to you.

What are the ACL tables?

What do you mean by on another installation? Do a fresh Kunena install?

ACl tables are all the Joomla ACL tables.

I dont have a list at the moment, as am at work,
They are all the tables that either contain

"acl" or "aro"

Fresh istall = a new install of jooml and kunena for testing purposes so you dont need to alter your live environment

Giving this another attempt. I'm excited because I made progress because I got an error this time compared to nothing happening before:) I posted it down below. I believe it is because I've changed my joomla prefix to something else so that is why it isn't finding "jos_fb_announcement". Can I just go through the php file and replace these. Just wanted to double check to make sure I'm not missing something with that line of thinking.

I am also using Tamir's original script with his updated smf2k.php file. I went that route because when I loaded up Kunena the users are appearing in there. So I thought I would give it a whirl to see if I didn't have to mess with users.

Thanks!

Done in 0
Creating Tables...

Truncating Tables...

Invalid query:
TRUNCATE TABLE jos_fb_announcement
Table 'inwardtr_sandpoint15.jos_fb_announcement' doesn't exist

Hey Danny,
Any luck on tweaking that script some more?

Thanks for this. I was able to get my posts, etc transferred over.

One thing I would like to change though if possible is all the old posts show the "username" instead of the "real name". Danny if I use your script instead is it possible so that it would import this way so that the author is te real name? I also can't click on a poster and go to their profile. Guessing this is because I used the older script?

Danny if I use your script and it resets the password how does that work. if they login to community builder and then hit the forums does it give them a new password and they have to use this for all of joomla?

I did get the following below when running the script.

Invalid query:
update `sh3s_fb_users` set userid= ifnull((select max(t.id) from sh3s_users_old q,sh3s_users t where t.username=q.username and q.id=userid ),userid)
Duplicate entry '64' for key 'PRIMARY'