arn_php Posted February 25, 2008 Share Posted February 25, 2008 ERROR DETAILS :ERROR :: LIB_EXTRANET_FORM - MANAGE_SAVE - QUERY Out of range value adjusted for column 'field_display_order' at row 1 Query :: UPDATE edub_infob SET name='My name',phone='123.456.7890',ext='123',fax='123.456.7890',email='[email protected]',flag_status='1',field_display_order='' WHERE infob_id = '1'; What does this means? How can I get it corrected? Link to comment https://forums.phpfreaks.com/topic/92831-out-of-range-value-adjusted-for-column-field_display_order-at-row-1/ Share on other sites More sharing options...
Steve Angelis Posted February 25, 2008 Share Posted February 25, 2008 What is the code? Link to comment https://forums.phpfreaks.com/topic/92831-out-of-range-value-adjusted-for-column-field_display_order-at-row-1/#findComment-475590 Share on other sites More sharing options...
arn_php Posted February 25, 2008 Author Share Posted February 25, 2008 Steve, I just emailed you the codes since I have been having difficulties in posting it here. Please reply me or you may post the answer here. Thanks a lot. Link to comment https://forums.phpfreaks.com/topic/92831-out-of-range-value-adjusted-for-column-field_display_order-at-row-1/#findComment-475598 Share on other sites More sharing options...
sasa Posted February 25, 2008 Share Posted February 25, 2008 what is type of 'field_display_order'? Link to comment https://forums.phpfreaks.com/topic/92831-out-of-range-value-adjusted-for-column-field_display_order-at-row-1/#findComment-475599 Share on other sites More sharing options...
Steve Angelis Posted February 25, 2008 Share Posted February 25, 2008 Ya... I do not have that email anymore, I need to get a new one. Send it to this one: [email protected] The old domain withthe old email does not exist, has not for some time. Link to comment https://forums.phpfreaks.com/topic/92831-out-of-range-value-adjusted-for-column-field_display_order-at-row-1/#findComment-475601 Share on other sites More sharing options...
PFMaBiSmAd Posted February 25, 2008 Share Posted February 25, 2008 The error is a mysql error message due to the query that is displayed in the error. field_display_order='' The value in the query is an empty string ''. Your table probably defines this as requiring a value. Either this error has been occurring all along but has been suppressed or the different settings between the two servers has resulted in no value being supplied in the query. It would be necessary to see the php code for that query and finding out where the value for field_display_order is or should be set. It is highly likely that this is from a form field but the code is dependent on register globals being on... Just for the record, most of the errors/warning/notices that you are seeing now were occurring in the code when it was running under php4 but the display of errors was turned off or the error reporting level caused them not to be displayed. This is not really anything thing to do with php4/php5. Link to comment https://forums.phpfreaks.com/topic/92831-out-of-range-value-adjusted-for-column-field_display_order-at-row-1/#findComment-475602 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.