Categories
View Replies (4)

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

  1. owegen
    owegen
  2. RO CSVI
  3. Monday, 16 October 2023
  4.  Subscribe via email
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?
Attachments (1)
com_csvi.log.22.zip
0
Responses (4)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
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.
Attachments (1)
Screenshot 2023-10-16 at 7.01.42 PM.png 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
  1. more than a month ago
  2. RO CSVI
  3. # 2
owegen
owegen
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!