Out of range value adjusted for column 'id' at row

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
black85
Forum Newbie
Posts: 16
Joined: Mon Jun 26, 2006 1:36 pm

Out of range value adjusted for column 'id' at row

Post by black85 »

Weirdan | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


what does Out of range value adjusted for column 'id' at row 1 means? And how do i make changes to correct this?

This is my database table design below:
[syntax="sql"]
create table testTable
(
id int(11) not null primary key auto_increment,
testField varchar(75)
);

black85.


Weirdan | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Database questions should be in Databases.

it would help to know what you are sending the database that generates it.
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

It means you are sending a non-integer value or empty string to the database. This often happens on updates or changes to the field type when there is data already in the table. I just ran into this yesterday doing a manual dump install when trying insert rows without a primary key value. Once I added the numbers, the query executed fine. I also ran into this when trying to change a integer field (for a unixtimestamp) to a date field. I had to create a new field, run a query that added the date version of the timestamp into the date field, then I deleted the old timestamp field.
black85
Forum Newbie
Posts: 16
Joined: Mon Jun 26, 2006 1:36 pm

Post by black85 »

thanks eve
Post Reply