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
- stanoli
- RO CSVI
- Monday, 16 April 2018
- Subscribe via email
0
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
I use Wicecat add-on
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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.
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
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
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
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
Accepted Answer
Pending Moderation
Hello,
Update your CSVI to 7.6.2 version as ICECat fix has been included in this version.
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
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
- 2
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »