Resolved Load icecat indexes Column count doesn't match value count at row 1

Hello,
Update your CSVI to 7.6.2 version as ICECat fix has been included in this version.

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

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.

i replied your email: ....@csvimproved.com

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?

sorry what file you requested?

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

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 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

And my serverlog at moment icecat maintenance stopped.
Strange why images go to root? http://

Hello,

Using 20 lines is not what you want with a file this size so you could try to increase that some more. That is why the default is set to 1000. The reason for the unknown error could be that it is simply a long running process, having that on a shared server is often not so liked by hosters.

My hoster does not change LOAD DATA INFILE LOCAL, because its a shared server and they tell its insecure

That they don't enable it on a shared server I can understand. Saying that is insecure I disagree I guess they do allow FTP? That is insecure as well as it sends everything in plain text

To recap, importing the ICEcat index file on a shared server is a daunting task because it is a very large file and requires quite some resources. The alternative might be to load the file locally and then import it to the database via the command line but that requires expertise.

Roland, it now worked
It took al long time 20 lines but after that a unknown error.
My hoster does not change LOAD DATA INFILE LOCAL, because its a shared server and they tell its insecure

Hello,

Ok, sounds good. With 20 lines it will take a while because it is a huge file. While that is running, you could inform with your hosting provider if you can use the LOAD DATA INFILE LOCAL option, even if it is temporarily because that will make things go so much faster.

Roland, i am now testng with 20 lines. Its already running over 2 hours and still running. I let you know the final result

I tried 970 lines. It was running long, but after a while again an error:
Column count doesn't match value count at row 821

I sent com_csvi.log.56.zip com_csvi.log.56.zip you my logfile

Hello,

Can you update to CSVI Pro 7.6.1? This contains the latest changes I made. It does not include the new length of 0 but I still wonder how we get different results. ICEcat should deliver us the same file, assuming you also use the free version of ICEcat.

The other thing you can check is if there are any lines in the ICEcat file that are longer than 4096 characters.

That date in the path, is only something we type. What is more important is that the value on line 2199 of the maintenance.php file. That is correct in the latest patch.

Roland, i think you send me wrong patch
When i unzip patch_icecat2_20180417
i get files: patch_icecat2_20180416/administrator and ../plugins

See the date of file

Hello,

With the latest patch I do not have the issue and I also checked the line 471 which is not really long in my case. So now we need to figure out why it fails for you. How many lines per import have you set?

When I set 20, it works just fine and also if I set it to 970.

If you set the Lines per import to 20, does it stop earlier?

Can you send me the ICEcat file you are trying to import? Perhaps best is to use a service like WeTransfer due to the size of that file.

The load is running longer but still: Column count doesn't match value count at row 971

Hello,
Can you try to load the attached patch file and try again?

patch_icecat2_20180417.zip