1. stanoli
  2. RO CSVI
  3. Monday, 16 April 2018
  4.  Subscribe via email
I got this message: Column count doesn't match value count at row 1
when i use loadtype single

if i use loadtype Full
ICEcat index could not be loaded. Error occured: The used command is not allowed with this MySQL version

The supplier index is fine
Accepted Answer Pending Moderation
i have another shop running presta. I use also icecat import on that one. Also shared server. No problems at all.
I use Wicecat add-on
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
Hello,

I am not saying it cannot run on a shared server, just loading the index file is a big task. There are almost a few hundred thousand products in that file. Looking at Wicecat I can't tell how it functions, however it seems like you need to download something there as well otherwise it won't know what data is available.

To get back to the basics, if you import the ICEcat data with 1000 lines per import, do you still get an error with version 7.6.1?

You never sent me the file I requested as well, so I can't look at that.
Kind regards,

RolandD

=========================
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. # 22
Accepted Answer Pending Moderation
I used version 7.6.1 and do 1000 lines per import, 5 seconds between
i counted processed 1000 lines: i got 93 or 94 lines on screen that 1000 lines was processed
after that it stopped with this error: Column count doesn't match value count at row 971
  1. more than a month ago
  2. RO CSVI
  3. # 23
Accepted Answer Pending Moderation
sorry what file you requested?
  1. more than a month ago
  2. RO CSVI
  3. # 24
Accepted Answer Pending Moderation
Ok, all clear. I asked to send me the file but I have a better idea, I can download it from your site. Can you send me a private message and let me know the URL of your site?
Kind regards,

RolandD

=========================
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. # 25
Accepted Answer Pending Moderation
i replied your email: ....@csvimproved.com
  1. more than a month ago
  2. RO CSVI
  3. # 26
Accepted Answer Pending Moderation
Hello,

The issue has been identified as an erroneous double quote causing the line to be misread by PHP. This issue has been fixed and the fix will be included in the next release. Thank you for your patience.
Kind regards,

RolandD

=========================
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. # 27
Accepted Answer Pending Moderation
Hi Roland, i started all over again with a clean install of joomla and virtuemart. Downloaded and installed the latest CSVI extension 7.6.1 but again i have te same error:

Column count doesn't match value count at row 271
I used: 300 lines, load type: single

When i process 1000 lines i get error:
Column count doesn't match value count at row 971
Thats exactly the same as we had before
  1. more than a month ago
  2. RO CSVI
  3. # 28
Accepted Answer Pending Moderation
Hello,
Update your CSVI to 7.6.2 version as ICECat fix has been included in this version.
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. # 29
  • Page :
  • 1
  • 2


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