Duplicate entry '2147483647' for key 1 (unique_ID)

alonzo

Well-known member
I Often got duplicate entry for number 2147483648 in Key (unique ID) auto increment...why?

[08] Error: during query execution.
INSERT INTO `PANDA` (`Key`, `Targa`, `Carburante`, `Data-rifornimento`, `Driver`, `Km`, `Distributore`, `ID-User`, `Data-inserimento`, `Data-aggiornamento`, `Note`) VALUES ('dd13163b11506bd2c5d79bc8b932294d3240', 'EJ422LJ G1 SPSLL', '111', '2011-01-01', 'Matarazzo Clemente', '1111', 'Agosta', 'webmaster', '2011-10-15', '2011-10-15', '')
DBMS server said: Duplicate entry '2147483647' for key 1
 

DebbieS

DaDaBIK Guru
?????

Can you provide more details about how your table is set up? What is your Primary Key field? What are it's settings in DB and in DaDaBIK? What data are you entering? Is this located where we can view it?

Without details, it's like me asking you how long this piece of string is.
 
Top