This is a discussion on "Out of range error" within the PHP Forum section. This forum, and the thread "Out of range error are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Out of range error
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
May 6th, 2007, 11:01
|
|||
|
|||
|
Out of range error
hello
Thus anybody explain what is "Out of range value adjusted for column 'id' at row 1" how does it coz an error..? thanks 
|
|
|
|
May 6th, 2007, 14:16
|
|||
|
|||
|
Re: Out of range error
Apparently this is a MySQL version 5 bug (earlier MySQL versions not affected) and can be fixed by turning off strict SQL mode.
Try fixing it as follows: Open up your MySQL configuration file ( see http://dev.mysql.com/doc/refman/5.0/...ion-files.html ) and replace: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION" with: sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" this will disable the strict SQL mode setting. If you do not have access to this file, ask you host/administrator to make these changes for you.
|
|
| Tags |
| out of range |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Keep getting error message Microsoft VBScript runtime error '800a01a8' | cpando1974 | Classic ASP | 2 | Aug 7th, 2007 12:00 |
| Disabling Dropdown based on value range | Matc | JavaScript Forum | 0 | Jun 26th, 2007 11:02 |
| Setting a veiwing range for a AI character | Throntel | Flash & Multimedia Forum | 7 | Dec 17th, 2006 06:08 |
| Updating using a range? | BrokenImage | Databases | 2 | Nov 18th, 2005 13:00 |
| range object | da_stimulator | JavaScript Forum | 0 | Dec 6th, 2004 10:40 |
