kamy99

Hi all: I am suddenly experiencing a problem inserting values into one of my tables in mySQL. I have a products table: [php:1:891bf19023]<?php TABLE `products` ( `ProductID` int(11) NOT NULL auto_increment, `ProductName` varchar(250) NOT NULL default \'\',........... ?>[/php:1:891bf19023] The DB and this table have been working just fine for over a year now. We only have just abobut 300 products in it, so it\'s nothing big. As of two days ago when I try to insert a Prodcut into db, either through phpmyadmin OR the backend application which I wrote from scratch, it just doesn\'t work!! The last proper ID was 296, and since it is an autoincrement field and I do NOT insert any numbers while populating the db, the next should be 297, instead I get the weird 2147483653 I read through mySQL manual, it apparentlyhas something to do with integer range. http://www.mysql.com/doc/en/Numeric_types.html But the integer range is: -2147483648 2147483647 I\'m nowhere near close to that range!!!! Do you have any ideas? Thanx kamy