Error importing Customers

Error comes up?
CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘suffix’ at row 1
What shall I do?

7 answers

Profile photo of Mall Staff 171930.00 $tone October 22, 2021
Public

Hi there,

1406 Data too long for column ‘suffix’ at row 1…
What shall I do?

Please let me know the version of your M2 instance as well as the version of our module in your instance. 

Also, please provide me with more details of the error message you mentioned. I will help to check further and help you out.

Regards,
Mall.

#1
Profile photo of cojiyun11585 10.00 $tone October 22, 2021
Public

Using 2.4.1 using the correct plugin with it
I have complete steps 1-5
This is step 6 Importing Customers this error comes up on the control panel is red and STOPs?

#2
Profile photo of ubdev Staff 90840.00 $tone October 22, 2021
Public

Hi there, 
Please help to provide additional information that we mentioned in reply #1 above:

  • Please let me know the version of our module in your instance. 
  • And more details of the error message you mentioned.

Besides, please provide us with your site credentials: 

  • URL and admin credentials of your M2 instance
  • SSH credentials of your M2 instance
  • Let us know the path to your M2 folder

Please make sure you mark your reply private or simply switch this ticket to the private mode. Then it’s safe to share your site information here. 
Regards,
Ubertheme team

#3
Profile photo of ubdev Staff 90840.00 $tone October 22, 2021
Public

Hi there,
Please move forward with the migration at your end. If you have any additional questions, please get back to us here. 
Since our team is off at the weekend, our apology for a certain delay if you reach out to us during this time. 
Regards,
Ubertheme team

#7

Please login or Register to Submit Answer

Written By

Comments