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 Link to comment https://forums.phpfreaks.com/topic/1008-mysql-insetion-error/ 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. Link to comment https://forums.phpfreaks.com/topic/1008-mysql-insetion-error/#findComment-3417 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 Link to comment https://forums.phpfreaks.com/topic/1008-mysql-insetion-error/#findComment-3437 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.