I figured out why it was doing this on my servers. I built the joomla database on utf8 character set but my database server was using the default latin1.
In the SMF install.php it calls "CREATE DATABASE IF NOT EXISTS" which resets the database to the server default (i.e. latin1_swedish_ci). The SMF tables were INSERTed as latin1 character set.
In the SMF bridge functions.php file when isMamboSMFUserSync() is called, the query would fail with a collation error on the username.
Make sure your jos_users and smf_members tables use the same character set.
Ok, I think I found it. After adding some debugging messages I was able to capture this error message:
Syncing username test2 Failed! WARNING: mosuser does not support checkin.
mosuser->checkin is the last task performed in insertToMambo2. This has been apparently failing yet it was not being checked for error messages. Question is, why does mosuser->checkin not work on Joomla and is it supposed to? Off to find out why.
In the meantime, just to make sure, how bout uploading this new functions.smf.php to administrator/components/com_smf/. Unzip it first of course.
« Last Edit: December 01, 2005, 03:01:50 PM by -Wolverine »
Just for kicks, I uninstalled and reinstalled. Don't know what the difference was between what I did before and what I did now, but it works. It fixed one problem but not another. I am now able to login using both SMF and the JoomlaSMF Login Mod. But when I look at the users in Joomla, I don't see the most recent members. I verified and synched again and no change. Still missing the most recent members.
Try logging on yourself to my site using the mod to make sure it works OK now.
What does BAH! mean? Should I upload the new functions.smf.php or wait?
I was able to login using both the login module and directly in the forums. Good deal. Hey, all is not lost, I know much more about this component than I did, which is never a bad thing. Glad your site is working.
oh, and btw, I don't think it sync's a user until they have logged in once. So until I had logged in you should have seen me in only the smf table and not joomla.
I do see you now in Joomla Member List under your real name not -Wolverine. Is that what you used? In the past, it did enter users that had not visited the site at least once. There was a red 'X' by those who had not activated the account. Is this a change in the new version of the bridge?
Apparently since you were able to login, you successfully went through the entire reg process, got the email, and activated your account, right? Any problems in that process at all?
Well, I always, and I mean always, forget that -Wolverine is an invalid Joomla username(can't have dashes). And when I regged via SMF I used -Wolverine which will never work in Joomla but SMF is happy go lucky with it. So delete that account b/c it was never going to work. That is why I used joshualross instead.
I am not sure if that has changed... believe it or not I am somewhat new to JoomlaSMF bridge. I love to hack at things and used to do tech support so I try to help others when/where I can. So if it has changed then I am unaware of it.
Let me verify that the sync from SMF to Mambo occurs after the first login before we investigate any further. Or if Cowboy is around and wants to set me straight that's fine too!
Joomla Hacks is a Joomla Components, Joomla Modules, Joomla Templates, & Joomla Mambots resource portal. None of the text or images in this public website may be copied without the expressed written consent of the authors. Copyright 2005 by JoomlaHacks.com. Powered by Joomla. All rights reserved. Terms of Use
Author
Forum
Logged
Wild goose chase.
Lemme go check to see if I can login.
Glad your site is working.
