Once the database is incremented to 127 entries the database no longer increments. As a result I get a 127 error. Does anyone know how to get around this?
It sounds to me that you're using a TINYINT columntype for your auto_increment column. TINYINT can take values from -128 to 127. TINYINT UNSIGNED can take values from 0 to 255.
Alter the table so that the auto_increment column is wider. See the MySQL online documentation entries for Numeric types and ALTER TABLE
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.