(SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'STRING

[vince maraia]

I'm getting the error below when migrating to mysql...is it ok to increase the Table Lengths? It seems strange that this was ok from hsql but mysql is not happy? Thanks!

[GenericEntity:CustomFieldValue][id,282156][stringvalue,2014-01-22 18:50:54:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:54:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:54:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:55:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:55:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:55:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:55:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:56:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:56:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:56:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:57:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-01-22 18:50:57:[JIRA -> QC]Unable to set = in field BG_USER_25 for JIRA issue TJP-27693: Required field cannot be empty or contain only spaces. 2014-02-21 18:23:54:[QC -> JIRA]For issue TJP-27693: Working on field Status Can't find the corresponding status Assigned keep status as it was Open - Assigned][issue,51857][customfield,10600] (SQL Exception while executing the following:INSERT INTO customfieldvalue (ID, ISSUE, CUSTOMFIELD, PARENTKEY, STRINGVALUE, NUMBERVALUE, TEXTVALUE, DATEVALUE, VALUETYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (Data truncation: Data too long for column 'STRINGVALUE' at row 1))

[Nic Brough -Adaptavist- · Accepted solution]

What "migration" are you doing?

There should never be a need to change the table length, that's completely the wrong approach. It's trying to insert duff data - trying to fix the storage to accommodate it is not the right answer, you need to fix the import and/or the data.

[Mendus Chelapurath]

I am getting the same problem

[Nic Brough -Adaptavist-]

Same answer.