My site has been online for almost a month now. I have close to 200 registered users so far.
I noticed that the total users in SMF is higher than in Joomla. So i looked in the SMF Members list and i have 2 users that are listed 4-5 times. I checkd in smf_member table and there were additional entries for those users. I deleted the rows that were obviously not supposed to be there(the ones that had lastlogin = 0) and it seemed fixed.
One of those users(LemonPia) logged in today, and again same problem. 2 "new users" LemonPia were created in smf_members table, and of course the total statistics in smf total users now is 2 users more than in Joomla.
Thanks Peter for pointing that out to me. I had not found you had the same issue in my search cause my search had been for "duplicate smf_members", and you used the word "replicated"
What i donīt understand, and i hope Wolverine has an answer, is how can this happen if my users are not even allowed to change their username?
In CB component configuration, in tab "User Profile" there is a setting "Username" -> YES/NO that sets wether the username will be editable or not.
I have allways had this set to NO, so none of my users can change their username. When they get into their profile to edit it, Username is shown but is not an editable field.
However I am still having the problem that started this post with some users. Everytime they log in a new record is created in smf_members table
are these usernames with special characters? The only way a new user would be created at login is if we could not find a current entry in SMF with that username.
I had thought of that...but of the 3 users(out of more than 200) that i have observed they are being "re-created" when they login, 2 of them have special characters and 1 doesnīt:
olmeņa LemonPía Paika
I checked in the jos_users table and the username is exactly the same there for these 3 users. Just to make sure, i run:
Code:
select memberName from smf_members where memberName not in (select username from jos_users)
with zero results
Plus, there are other users that have special characters in their usernames as well, and there seems not to be a problem with them.
well, the thing is, it might be the bridge code that incorrectly quotes the string before checking. I don't know at this point but I promise to take a look and do some testing.
Has anyone found a solution for this problem so far?
We're having this trouble with a couple of users in our ca 500-Member Database. We used to live with this, but now its getting worse, because the CB-Profile synchronized with one of the duplicate smf accounts. So the user, who already got 200 posts and 80 pms suddenly has none of that and starts with a zero again.
I would appreciate your advice.
We have Joomla 1.0.12 CB 1.0.2 JSMF 2.0.2 SMF 1.1.13
Users are not allowed to change Username in CB. The affected users have nothing special in their usernames.
I have the same problems as stated above. As I register users manually, I don't use special characters. And I always use a strict username policy. This problem happend twice on a 150 users db. I have: Joomla 1.0.12, JSMF 2.0.2 SMF 1.1.12.
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
