Page 1 of 1

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

Posted: Mon Jun 26, 2006 3:22 pm
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]

Posted: Mon Jun 26, 2006 3:40 pm
by feyd
Database questions should be in Databases.

it would help to know what you are sending the database that generates it.

Posted: Mon Jun 26, 2006 3:49 pm
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.

Posted: Mon Jun 26, 2006 4:20 pm
by black85
thanks eve