This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile


Duplicate entry '2147483647' for key 1 (unique_ID)

Posted by alonzo 
Duplicate entry '2147483647' for key 1 (unique_ID)
October 15, 2011 05:23AM
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
Re: Duplicate entry '2147483647' for key 1 (unique_ID)
October 29, 2011 02:14PM

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.

..:: Debbie |\.-./| DaDaBIK Support ::..
Sorry, only registered users may post in this forum.

Click here to login