Categories
View Replies (2)

Resolved Strange "Data too long" error on csv import

  1. barracuda69
    barracuda69
  2. RO CSVI
  3. Wednesday, 31 July 2024
  4.  Subscribe via email
Hi,

Importing the attached csv produces the following error: Duplicate entry '0' for key 'PRIMARY'

In the log I see: Incorrect Failure Not added. Error: Data too long for column 'products_per_row' at row 1

Checked the log file and could not find anything useful...

Could you please check and let me know what I'm doing wrong?

Thanks!

D
Attachments (3)
swimmingshop2.csv
com_csvi.log.228.zip
csvi_templates_apostolidisaction.gr.dedi5844.your-server.de_20240731.xml
0
Responses (2)
barracuda69
barracuda69
Accepted Answer Pending Moderation
You're great, thank you!
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Dennis,
The field products_per_row can take only one character in database but in your case value 24 is inserted and that is too long for the field and so the error. In VirtueMart default value for products per row is 3 but it is set to 24 in your case. Since this value is not in import file it is taken from VirtueMart config. You need to change this value and then run the import.
Attachments (2)
Screenshot 2024-07-31 at 3.18.02 PM.png Screenshot 2024-07-31 at 3.18.02 PM.png
Screenshot 2024-07-31 at 3.20.19 PM.png Screenshot 2024-07-31 at 3.20.19 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
  • Page :
  • 1


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