Hi Everyone,
I have a big problem, that I bet could be solved pretty simply but I am new to
mysql so its killing me and my database.
Ok heres the problem, suddenly out of no where when my php script tries to (or
manually) do a insert it says:
ERROR 1062: Duplicate entry '127' for key 1
Now why all of a sudden is this doing this at id 127?
This is what my create table statement looks like if this is of any help to you:
CREATE TABLE custinfo ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, date
date, name varchar(50), card varchar(22), exp_date
varchar(7), authcode varchar(8), amount double(4,2), tax double(3,2), pnref
varchar(16), address text, city tinytext, state varchar(
3), zip varchar(15), country varchar(2), contact_first varchar(20), contact_last
varchar(20), contact_phone varchar(20), contact_ema
il tinytext, tickets tinyint(3), description varchar(50), PRIMARY KEY (id), UNIQUE id
(id));
Now after I got this message these are some of the things I have tried to solve the
problem but of course had no success:
I tried isamchk -r and -R, i have even tried it with -rkis and then just plain
-kis i pretty much have tried them all and it still gives the same error when i try to
insert anything into the list ? What do i do to fix it and what did i do to cause it?
Please help me I need this database up and running (loosing money every hour its
down!)
:( please please please help thank you very much for your time and help.
-Steven