Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Joomla Bridge Support => Topic started by: GJSchaller on June 17, 2006, 06:27:05 PM

Title: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 06:27:05 PM
I am running into an issue (as stated in the title) - here's the full details.

1) I am importing into SMF 1.1RC2 my forums & users from PHPNuke.  The conversion (appears) to be working successfully.  I can log into SMF fine as a stand-alone application, and it works wonderfully.

2) I can log into Joomla as administrator - that is the currently the ONLY account within Joomla 1.0.9.  (I had the same issue with 1.0.8, BTW, I tried patching up to fix another, separate issue.)

3) When I go to the Bridge and click on "Migrate SMF Users to Mambo / Joomla," I get a Joomla Admin page with no text, no errors, nuttin' but the Save / Cancel button in the upper right corner and the normal Joomla footer.  It's like the body of the page, if there is one, is not being returned.  When I go to check the User Manager in Joomla, administrator is still the only one there.

4) I have about 500 users in SMF.  User ID #1 in SMF is "Anonymous," imported over from PHPNuke.  I also have another account (administrator).  I tried deleting both of these from SMF, so that there would not be a conflict with my Joomla's administrator account, and it's still doing the same thing.

That's all I have at the moment... I'm guessing it's something silly I am just missing.  Can anyone help me out?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 06:32:15 PM
Can I see a URL?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 06:45:26 PM
http://www.knightrealms.com/joomla/ - all the synching stuff is internal, do you need access to that, or can you do your mojo from looking at the outside?

Thank you for the help!
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 06:54:05 PM
I just registered a Test account thru the Bridge, and it appeared in Joomla - I noticed you signed up as well, Orstio. Thank you for helping!  :D
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 06:57:04 PM
No problem.  Do I show up in the Joomla user list?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 07:02:43 PM
Yes, yes you do.  So new registratons work fine... I just can't move the old / current SMF logins into Joomla.
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 07:08:27 PM
OK.  Let's have a look in the database.  Using PhpMyAdmin, go to your Joomla database.  Click on the jos_core_acl_aro table.  Does it have all 512 rows?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 07:11:12 PM
Interestingly, it has some there... I've been playing with this for a while (testing the import) - let me check and see if this is all 512, of if this is an old batch that is gumming up the works.

It's only 40 or so... that might be an issue. ;-)
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 07:21:20 PM
Hmmm..  OK, i was expecting it to be emptier than that.

How many users in the jos_users table?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 07:55:32 PM
4: the Admin, you, my Test account I made, and one other account.  Interestingly, that account does NOT show up in Joomla.

Shoud I try dropping all the "spare" users in both tables?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 07:58:35 PM
Weird.  Have you ever had the PhpBB component for Joomla installed?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 08:17:30 PM
I don't THINK - I may have a long time ago when I was trying to port Nuke into Joomla, before I found SMF. ;-)
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 08:21:45 PM
The reason I ask is that the PhpBB component alters the Joomla table structure.  The SMF bridge only works with the default table structure.

But...then the new registrations wouldn't work either.  :-\

When you migrated users, did you have registration turned on in Joomla?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 08:43:06 PM
Let me know if you would like access to my phpMyAdmin - I'll give you a peek at the table.
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 09:00:07 PM
It's rather curious why you would have 40 entries in the jos_core_acl_aro table, but only 4 in the jos_users table.

Sure, I wouldn't mind a look.
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 09:09:25 PM
Sent via PM. Thank you!
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 09:29:12 PM
OK, I've straightened out your ACL tables.  Do you want to try that sync again?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 09:55:03 PM
Same thing - no messages of any sort, only 4 users in Joomla.  ::)
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 09:57:57 PM
Would it matter at all if some users had the same email address?  That restriction was relaxed in Nuke for a while, and I know there's a few IDs with duplicate emails.  (Come to think of it, can that be tured off in SMF?  I could not find it.)
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 10:03:50 PM
You will want to get rid of duplicate emails later.  Things like duplicate email addresses and duplicate real names can cause obscure security issues.
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 10:27:48 PM
Looks like you were able to fix it logged in as an Admin - for the record / documntation, what needed to be done?
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 17, 2006, 10:29:17 PM
I fixed it in PhpMyAdmin before synching.  You had 27 entries in the ACL that had no corresponding users in the jos_users table.  It looks like at some point the jos_users table was emptied, but the ACL was not.
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 17, 2006, 10:38:06 PM
Thank you, VERY much!  :D
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 19, 2006, 05:37:35 PM
My conversion is done, and the new site is up and running smoothly.  The old PHPNuke site is still in existence, although not in use.  All the users are in SMF and Joomla now, and it looks like the groups have synced successfully as well.

Something I have noticed, however, is that users who are Admins cannot log into the Administrator section of Joomla - they are getting a Bad Username / Password error.  I am trying to log in using my personal account (GJSchaller), and am unable to do so.  I can log in as the original Superuser account, but not as anyone else, even after verifying they have Admin permissions in Joomla, and removing and re-adding those permissions / ranking.  I can edit & update stories normally within Joomla, indicating I do have some permissions - I just can't seem to log into the Administrator interface with a non-Superuser account.

Any insight or hep would be appreciated!
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Kindred on June 19, 2006, 05:40:51 PM
usernames are case sensetive...
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 19, 2006, 05:46:32 PM
Yes, being a Linux fan, I am in the habit of typing the same case wether it's sensitive or not. ;-)  I can log into Joomla fine with that ID (GJSchaller), just not the Admin portion of it.
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: Orstio on June 19, 2006, 05:58:16 PM
Users that are synched from SMF to Joomla will need to change their password once before they can login to the Joomla admin panel.  (You can use the same password, as long as you go to the profile, and go through the process of changing it.)
Title: Re: Issue synching from SMF to Joomla using 1.1.4 Bridge
Post by: GJSchaller on June 19, 2006, 06:09:42 PM
Bingo!  Thank you, again!