C
Chris
Guest
My database currently has 93 rows. I frequently get an error when inserting a new row. I just read how to change the debug value and I will do that very soon.
However, when I opened my database in PHPAdmin I noticed my id number had grown extremely large. During the 93 rows, my id went from 1 to 2147483647. I manually corrected all the id values back to a sequential order ending at 94. On the very next insert I get an error and then after successfully inserting the record, I check the id number and the new record is back to 2147483648. How do I get this to check the unique id and use the next one available? I need to reset the number it uses back to match the table.
However, when I opened my database in PHPAdmin I noticed my id number had grown extremely large. During the 93 rows, my id went from 1 to 2147483647. I manually corrected all the id values back to a sequential order ending at 94. On the very next insert I get an error and then after successfully inserting the record, I check the id number and the new record is back to 2147483648. How do I get this to check the unique id and use the next one available? I need to reset the number it uses back to match the table.