Duplicate entry '2147483647' for key 1
I have started getting this error when using DA to try and insert a page into the database.
i have checked the database and all seems fine (the ID field is a primary key, int not null, auto increment)
The database works sweet when you upload a record via navicat however when you manually try to insert a record, it creates a long ID as above and then when you try and insert another record it comes up with the Duplicate entry '2147483647' for key 1 error.
Any help will be greatly appreciated.