AnsweredAssumed Answered

[FATAL] MySQL error 1406: Data too long for column 'nonce'

Question asked by Tokumoto Daisuke on Jan 20, 2016
Latest reply on Jan 20, 2016 by cmutek

Hi All


I am encountered following fatal error  in sugacrm.log


Query Failed: INSERT INTO oauth_nonce(conskey, nonce, nonce_ts) VALUES('conKey', '12179084825685c1bdda3827.94416491', 1451606461):

MySQL error 1406: Data too long for column 'nonce' at row 1 sugarcrm_01_01_16.log:Fri Jan 1 02:01:02 2016 [5010]


When I cross checked the core files, the "nonce" values is generated by SugarCRM. Please find the file path and function below



'oauth_nonce' => $this->_httpUtility->generateNonce()


My question is, the db field length is vachar(32) and why the function generate the more that the defined db field length


Please let me know the severity, cause and solution of this issue


SugarCRM Details


Sugar Professional

Version 6.5.22 (Build 1055)


Thanks in advance for your answers