ChrisG
New member
DaDaBIK Version 4.2
MySQL-Version 5.0.77
Browser: Internet Explorer 8.0.6001.18702
---------------------------------------------------------------
[08] Error: during query execution.
INSERT INTO `Inventory` (`Barcode`, `Mfr`, `Model`, `Serial#`, `CPU`, `Mem`, `Warranty`, `Site`, `Room`, `Staff`, `Req_Date`, `PO#`, `Purch_By`, `Fund`, `OSVersion`, `Type`, `Status`, `Tech`) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Discard', 'cguest')
DBMS server said: Duplicate entry '2147483647' for key 1
----------------------------------------------------------------
Hi... I'm hoping someone might can easily help me straighten this out.
Almost everytime I try to insert a record I get the above error message. I have checked all of the entries in the database for the ID key and their are no duplicates.
I have also gone into the administration area for dadabik and changed the ID to text and alphanumeric. Originally it was set to unique_ID and numeric.
Still same problem.
MySQL-Version 5.0.77
Browser: Internet Explorer 8.0.6001.18702
---------------------------------------------------------------
[08] Error: during query execution.
INSERT INTO `Inventory` (`Barcode`, `Mfr`, `Model`, `Serial#`, `CPU`, `Mem`, `Warranty`, `Site`, `Room`, `Staff`, `Req_Date`, `PO#`, `Purch_By`, `Fund`, `OSVersion`, `Type`, `Status`, `Tech`) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Discard', 'cguest')
DBMS server said: Duplicate entry '2147483647' for key 1
----------------------------------------------------------------
Hi... I'm hoping someone might can easily help me straighten this out.
Almost everytime I try to insert a record I get the above error message. I have checked all of the entries in the database for the ID key and their are no duplicates.
I have also gone into the administration area for dadabik and changed the ID to text and alphanumeric. Originally it was set to unique_ID and numeric.
Still same problem.