It will add a record with the information i typed but it adds record with id zero. i can add several different records and they all appear in db with id zero.

version 1.2.8

Dan

Hey Dan,
I have no idea waht is causing that. Very weird.
If you make a testwebsite for me with FTP acces i can have a look at it if you want.

What i can tell you about this is this:

The first query to the users table isnt choosing an id because its automaticly given one by the db. If it gives ID=0 then something is wrong with your DB i guess.

You can see that here
do a search for Insert record into users in the component files.
When you found it you will see the sql query to add a user to the DB.

A little bit lower you can see the script getting back that ID and using it again for other sql queries.

Code:

list($user_id) = mysql_fetch_row(mysql_query('SELECT LAST_INSERT_ID()'));

BTW: I changed your username to dan. I am not allowing @ signs in username!

Thanks for the quick reply, i checked my DB and it did not have AUTO INCREMENT on for the user table ID field. Don't know how that happened but fixing it did the trick. thanks Dan