[08] Error: during query execution

[ChrisG]

Hi,
We have just started receiving "[08] Error: during query execution" but only when we try to insert a new record.

I happened to have a backup all all of the Dadabik folders and files so I deleted the original and copied the backup over.

Everything starts back working as normal for a little bit and then suddenly we start receiving the [08] error again.

Again, deleted and recopied and again everything started back working for a short time before giving the error again.

I turned on debugging and this is what I saw on the last error:

Your SQL query (for debugging purpose): INSERT INTO `Inventory` (`ID`, `Barcode`, `Vendor`, `Mfr`, `Model`, `Serial#`, `CPU`, `Mem`, `Warranty`, `Site`, `Room`, `Staff`, `UserType`, `Req_Date`, `Install_Date`, `PO#`, `Purch_By`, `Fund`, `OSVersion`, `Type`, `Status`, `Tech`) VALUES ('ce64fa6c798cb04431b8508b2cf7bdb69807', '79999999', 'Amer', 'Acer', '500', '434234324', '2600 DC', '4000', '5', 'TECH', 'OFFICE', 'almon', 'Teacher', '05/11/11', '01/06/12', '2325-08', 'BOE', 'CNS', 'Windows7', 'LAPTOP', 'InUse', 'cguest')

[08] Error: during query execution.
INSERT INTO `Inventory` (`ID`, `Barcode`, `Vendor`, `Mfr`, `Model`, `Serial#`, `CPU`, `Mem`, `Warranty`, `Site`, `Room`, `Staff`, `UserType`, `Req_Date`, `Install_Date`, `PO#`, `Purch_By`, `Fund`, `OSVersion`, `Type`, `Status`, `Tech`) VALUES ('ce64fa6c798cb04431b8508b2cf7bdb69807', '79999999', 'Amer', 'Acer', '500', '434234324', '2600 DC', '4000', '5', 'TECH', 'OFFICE', 'almon', 'Teacher', '05/11/11', '01/06/12', '2325-08', 'BOE', 'CNS', 'Windows7', 'LAPTOP', 'InUse', 'cguest')
DBMS server said: Duplicate entry '2147483647' for key 1

Can anyone give me any idea on what I need to look for or what I need to look at? I would be glad to post additional information just let me know what is needed.

Thanks.

 

[ChrisG]

Okay one additional note:
I checked the ID's within my database and found that it is not continuing the "auto increment".

My last valid ID was 8437 and when I inserted a new record it gave it ID 2147483647

hmmm... what do I need to do to correct.

I did find out that if I manually change the ID to be the next in line 8438 it will then allow me to insert another record.

Of course... the new record then is given that same ID of 2147483647. If I don't manually change the ID I get the 08 error again.

Thanks.

 

[ChrisG]

Is there an easy way to get the ID's back in sync?

 

[ChrisG]

Well nevermind... finally got it back working... or it appears to be working again anyway.

After trying everything from running the SQL querry autoincrement, dropping and recreating the ID field to dropping and reimporting the entire Table. I made sure the ID field was set to text and alphanumeric. Nothing seemed to work.

Just about to give up and found a place in my mysql management gui called Alter Table that had a very large number in the autoincrement field. I changed that number to 1.

Ran a few tests of inserting several data and then going back and deleting them while keeping an eye on the ID number. Problem seems to be solved