Jump to content

Archived

This topic is now archived and is closed to further replies.

kamy99

mySQL Insetion error!

Recommended Posts

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

Share this post


Link to post
Share on other sites

The table may be corrupt. Take a look at running the fixisam or whatever the name of that mysql function is.

Share this post


Link to post
Share on other sites

Run this query

 

REPAIR TABLE products

 

REPAIR TABLE works only on MyISAM tables and is the same as running

 

myisamchk -r products

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.