Riparian Posted July 23, 2012 Share Posted July 23, 2012 I have upgraded my local server and having lots of probs. the following fatal error refers to a enum field with 2 values T and F The error is produced when the record is created with INSERT INTO cart etc error in function Update_xxx.php line 32 Data truncated for column 'rimless' at row 1 I dont understand how or why a single value can be truncated ?? Any help is greatly appreciated Link to comment https://forums.phpfreaks.com/topic/266106-help-with-truncate-error/ Share on other sites More sharing options...
ignace Posted July 23, 2012 Share Posted July 23, 2012 Do a var_dump before placing it into the INSERT INTO statement. My guess is that it contains spaces after the T or F. Link to comment https://forums.phpfreaks.com/topic/266106-help-with-truncate-error/#findComment-1363646 Share on other sites More sharing options...
Riparian Posted July 24, 2012 Author Share Posted July 24, 2012 Thank you for the reply Code var_dump($stock[rimless]);exit; Result string(0) "" ???? Link to comment https://forums.phpfreaks.com/topic/266106-help-with-truncate-error/#findComment-1363886 Share on other sites More sharing options...
Riparian Posted July 24, 2012 Author Share Posted July 24, 2012 Not Solved but work around.... Turned off strict in mysql my.ini Link to comment https://forums.phpfreaks.com/topic/266106-help-with-truncate-error/#findComment-1363909 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.