Jump to content


Photo

mySQL Insetion error!


  • Please log in to reply
2 replies to this topic

#1 kamy99

kamy99
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 12 September 2003 - 06:17 PM

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...eric_types.html
But the integer range is: -2147483648 2147483647

I\'m nowhere near close to that range!!!!

Do you have any ideas?

Thanx
kamy

#2 gizmola

gizmola
  • Administrators
  • Advanced Member
  • 4,664 posts
  • LocationLos Angeles, CA USA

Posted 12 September 2003 - 11:37 PM

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

#3 Kriek

Kriek
  • Members
  • PipPipPip
  • Advanced Member
  • 31 posts
  • LocationFlorida

Posted 15 September 2003 - 04:20 AM

Run this query

REPAIR TABLE products

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

myisamchk -r products

Jon Kriek ยท PHP Freaks
Sometimes the need to mess with their heads ...
... outweighs the millstone of humiliation.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users