News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Product import csv file Database crash

Started by jesperkronholm, November 13, 2012, 14:27:36 PM

Previous topic - Next topic

jesperkronholm

Hi, I'm using a plugin, CSV Advanced, to import about 230 products. It all seemed to work well in the beginnig but the table "_virtuemart_product_customfields" keeps crashing. I have now tried importing just a few products at a time and it seems, however i do it, when I get up to about 151 products the table crashes. Even if I just try to import one more product.
I have "TRUNCATE":ed the table many times (is this enough to get a "fresh start"?) and started all over again.
I have not removed the products, I am just trying to update their short description, long description, custum fields and value for custom fields.

I got this error in phpMyadmin when I analysed yhe table (after importing just one more product than 151):
XXX_virtuemart_product_customfields    check    warning    Table is marked as crashed
XXX_virtuemart_product_customfields    check    error    Can't read indexpage from filepos: 33792
XXX_virtuemart_product_customfields    check    Error    Incorrect key file for table './XXX_virtuemart_product_customfields.MYI'; try to repair it
XXX_virtuemart_product_customfields    check    error    Corrupt

Anyone have any idea about what might be causing this? I really dont belive that there are any misstakes in my CSV-file.
maybe worth mentioning the information in the file is in swedish, with åäö, but the CSV is in UTF-8 format.

jenkinhill

You will have to ask the developer of the plugin about this. It could be related to limitations in PHP resources, but he will know.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum