kamy99 Posted September 12, 2003 Share Posted September 12, 2003 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 Quote Link to comment Share on other sites More sharing options...
gizmola Posted September 12, 2003 Share Posted September 12, 2003 The table may be corrupt. Take a look at running the fixisam or whatever the name of that mysql function is. Quote Link to comment Share on other sites More sharing options...
Kriek Posted September 15, 2003 Share Posted September 15, 2003 Run this query REPAIR TABLE products REPAIR TABLE works only on MyISAM tables and is the same as running myisamchk -r products Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.