Duplicate user records

I've searched the forums on this and it seems like there are lots of reasons this can happen -- but this is such a simple form, it must be something small:

http://draft.masc.org/index.php?option=com_chronocontact&chronoformname=Registration

When a user registers, I get two entries in jos_user. I can only see one when I go to Joomla -- User Manager -- everything looks fine there. But there's a duplicate entry when I go to Chronoforms -- Table Manager and view jos_users that way.

One record will have id=88, username, encrypted password, and the correct registerDate and lastVisit. The next record (id=89) will be for the same user, but the password won't be encrypted, and most fields will be blank, including registerDate and lastVisit.

Screen shots attached. How can I prevent the duplicate record from being created?[attachment=1]screen1.jpg[/attachment]
[attachment=0]screen2.jpg[/attachment]

Hi gtownwebdev,

It sounds as though you may be using the Joomla Registration plug-in AND have a DB Connection to the jos_users table. If so disable the DB Connection.

If not, . . . I don't know right now . . .

Bob

That was it, thanks. I guess I thought having the DB connection was one of the steps needed in using the plug-in to handle registration.

Now the Joomla -- User Manager still shows the right info, but the record when I go to Table Manager shows all zeros for the user's registration date and last visit date. How do I get that info come through/show up properly in the record?

A related question -- I have additional data I'm collecting in the form that I need to capture somehow. Right now it's just vanishing into the ether. As a novice, is it better for me to ...

1) Try to add the new fields to the jos_users table (and are there simple steps somewhere I can follow?)

or

2) Have a new table I create capture the data? That would be in addition to users being added to the jos_users table -- I don't want to mess up what's already working.

I'm not sure which option is more appropriate and/or easier for me to manage.

Hi gtownwebdev,

Not sure about the registration date; the last visited date won't be set until they visit.

Don't add new fields to the jos_users table - it couases to many potential problems in the future.

Instead add to a separate table but include the User ID so that you can connect the two tables. Keep the same form but add a DB Connection to the new table.

Bob

OK, I have another table up and running and collecting the data I need.

But now the user gets two confirmation e-mails -- one for each table I guess (jos_user plus my new table). How can I fix that? I can't turn off the dbConnection; I need it to collect those extra fields.