Support is online

Not added. Error: Data too long for column 'product_s_desc' at row 1 #77753

Open owegen opened this topic Monday, 16 October 2023 · 4 replies
Author

Hello, I have this Issue in the Virtuemart Product Import:
Not added. Error: Data too long for column 'product_s_desc' at row 1

Any Idea how can I fix it?

Support

Hello,
Thank you for the debug log. In the debug log I see after line 4453 it goes to line 8874 and with time duration of around 2 hours. Is it modified debug log?

Also post the import file you are using. Will run import and check.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Support

Hello,
One possibility for this error is when you import product_s_desc field value greater than what is accommodated in database. In VirtueMart product language table product_s_desc can support 2000 characters. See attached screenshot. See if you have short description more than this in your import file.

  • Screenshot 2023-10-16 at 7.01.42 PM.png

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hello,
Thank you for the debug log. In the debug log I see after line 4453 it goes to line 8874 and with time duration of around 2 hours. Is it modified debug log?

Also post the import file you are using. Will run import and check.

Hello, the problem is: the full Log File is too big (9 Mb) to be posted here. That's why I removed lines.

Support

Hello,
Did you check the product_s_desc field in import file? Check if there are any values more than 2000 characters.

Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.