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)
);
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]
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.