Paul J Stevens wrote:
Beryl Snyder wrote:
I am still getting this error, dbmail/user[9898]: Error:[sql]
dbmysql.c,db_query(+292): [Duplicate entry '2' for key 1] [INSERT INTO
dbmail_users (userid,passwd,client_idnr,maxmail_size,encryption_type,
last_login) VALUES ('chirsunited','united',0,0,'',CURRENT_TIMESTAMP)]
I looked for the error duplicate key. and i see are bug fixes, if i
change the Primary key for user number will that work, or is there a way
for me to tell DBmail its primary key is another number and not 2?
Beryl,
this means there is already a user named 'chirunited' in the database.
Finally got it figured out and fixed; the issue was that the
auto_increment was set to 2 rather then the act value, ran
ALTER TABLE table_name AUTO_INCREMENT = value; and that fixed it.
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
