All,
I'm experiencing a problem with a MySQL database table. I have an auto increment field that I use for a primary key for photo ids. The last id in the DB is 113, but when I try to add another photo the id that MySQL chooses is 2147483647 instead of 114. The other tables with auto increment don't seem to be having any trouble and I can access the other fields in the table, no problem. When I try to add another photo after the 2147... the database won't add it and returns an id of 0. Any ideas as to what's going on? Thanks for your help.
Mike
I'm experiencing a problem with a MySQL database table. I have an auto increment field that I use for a primary key for photo ids. The last id in the DB is 113, but when I try to add another photo the id that MySQL chooses is 2147483647 instead of 114. The other tables with auto increment don't seem to be having any trouble and I can access the other fields in the table, no problem. When I try to add another photo after the 2147... the database won't add it and returns an id of 0. Any ideas as to what's going on? Thanks for your help.
Mike