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

 

Zend\Oauth\Http\AccessToken.php(65,14):     

'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

Outcomes