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 Quote 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. Quote 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) "" ???? Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/266106-help-with-truncate-error/#findComment-1363909 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.