has anyone heard of a MySQL database having row limits? I have a database that was created for me, I created my tables and started inputting information and for some reason I am not able to input any new records after 127. I have manually tried inputting and entering 128 in the auto-increment ID field and I get the same error message "Duplicate Entry for '127' on Primary Key".
I have asked the company that has created the database if they put any restrictions in their schemas to not allow more than 127 rows in a table. They claim no but I have two tables that won't allow more than 127 rows. I don't have a lot of fields per table.
Could there be something in the setup or would this have to do with database size? Remember I didn't create the table and they won't allow me access to check the database creation.
any help would be great.