Duplicate entry '1' for key 1

previously entered data table is not empty.

auto_increment value for your table as records or upgrade your table or empty
alter table member auto_increment=your record count

Hi
As you se, I have already auto_increment!
CREATE TABLE members(

id int(11) unsigned auto_increment,

name varchar(150),

passwd varchar(255),

email varchar(255),

activation int(1),

datetime datetime,

last_login datetime,

gender varchar(10),

description longtext,

city varchar(32),

country varchar(255),

married varchar(255),

homepage varchar(255),

online varchar(3),

birthdate datetime,

updated datetime,

image varchar(255),

status varchar(25),

groupid varchar(25),

counter int(6),

rated int(6),

PRIMARY KEY (id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;
I am not sure what you mean.

Can you set the parameter here?
id int(11) unsigned auto_increment,
BR

Maali

Hi
is this the solution?
ALTER TABLE members AUTO_INCREMENT=10;
BR

Maali

yes?

the mysql auto_incriment counts OK. The members_add.php for some reason dose not get the ID and gets the same ID which creates the record!!

disabling this in the members_add.php fixed the problem.

$avalues["id"]=prepare_for_db("id",$SESSION["".$strTableName."_OwnerID"]);