Joomla Forum

Joomla Hacks => Joomla-SMF 2.0.x => Topic started by: GlingGlo on January 29, 2007, 12:00:56 PM



Title: Duplicates in smf_members table
Post by: GlingGlo on January 29, 2007, 12:00:56 PM
Hi, i have:

Joomla 1.0.12
CB 1.0.2
JSMF 2.0 Final
SMF 1.1

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.

Any idea what is happening?

Cheers,
NiCo


Title: Re: Duplicates in smf_members table
Post by: peter mee on January 29, 2007, 12:28:17 PM
Hi NiCo

I rasied the same issue last week;

http://www.joomlahacks.com/component/option,com_smf/Itemid,94/topic,3210.0

Wolverine addressed it but I did not yet have a chance to verify that this was the cause of my problem.

Peter


Title: Re: Duplicates in smf_members table
Post by: GlingGlo on January 29, 2007, 12:35:52 PM
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?

Cheers,
NiCo


Title: Re: Duplicates in smf_members table
Post by: -Wolverine on January 29, 2007, 02:33:04 PM
In cb you are allowed to change your username. 


Title: Re: Duplicates in smf_members table
Post by: GlingGlo on February 04, 2007, 09:52:36 AM
I am sorry but this is not right.

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  ???

Cheers,
NiCo


Title: Re: Duplicates in smf_members table
Post by: -Wolverine on February 04, 2007, 11:13:26 AM
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.


Title: Re: Duplicates in smf_members table
Post by: GlingGlo on February 04, 2007, 11:26:11 AM
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.

Cheers,
NiCo


Title: Re: Duplicates in smf_members table
Post by: -Wolverine on February 04, 2007, 11:32:40 AM
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.


Title: Re: Duplicates in smf_members table
Post by: GlingGlo on February 04, 2007, 12:13:01 PM
just to make sure you didnīt overlook it... one of the problematic users so far does not have any special character (paika)

Cheers,
NiCo


Title: Re: Duplicates in smf_members table
Post by: manicon on July 14, 2007, 04:31:06 AM
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.


Title: Re: Duplicates in smf_members table
Post by: locutus on July 22, 2007, 02:10:00 PM
Hi all,

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.

I hope you have the time to look into this...



Joomla Forum | Powered by SMF 1.1 RC1.
© 2001-2005, Lewis Media. All Rights Reserved.
Joomla Bridge by JoomlaHacks.com