problem begin at version 2.08.
upgrade to version 2.10 not help
i have 700+ records on table jos_virtuemart_product_customfields
when i add goods with customfields sometimes it ok, but sometimes i got error:
vmError: TableProduct_customfields::store failed - Incorrect key file for table './krasotka_krasotka/jos_virtuemart_product_customfields.MYI'; try to repair it SQL=INSERT INTO `jos_virtuemart_product_customfields` ( `virtuemart_customfield_id`,`virtuemart_product_id`,`virtuemart_custom_id`,`custom_value`,`custom_price`,`custom_param`,`published`,`ordering`,`created_on`,`created_by`,`modified_on`,`modified_by` ) VALUES ( '0','682','6','15421 № 49','0','','0','20','','0','2012-08-31 15:35:06','62' )
vmError: TableProduct_customfields::store failed - Duplicate entry '812' for key 1 SQL=INSERT INTO `jos_virtuemart_product_customfields` ( `virtuemart_customfield_id`,`virtuemart_product_id`,`virtuemart_custom_id`,`custom_value`,`custom_price`,`custom_param`,`published`,`ordering`,`created_on`,`created_by`,`modified_on`,`modified_by` ) VALUES ( '0','682','6','15242 № 50','0','','0','21','','0','2012-08-31 15:35:06','62' )
when i check table jos_virtuemart_product_customfields
i got: CHECK TABLE jos_virtuemart_product_customfields
krasotka_krasotka.jos_virtuemart_product_customfie... check warning Table is marked as crashed
krasotka_krasotka.jos_virtuemart_product_customfie... check error Found key at page 9216 that points to record outside datafile...
krasotka_krasotka.jos_virtuemart_product_customfie... check error Corrupt
i do repair table jos_virtuemart_product_customfields..
all ok. but when i added some goods error begin again
[attachment cleanup by admin]
help deleting all indexes exept primary (maybe dameged index)
command
ALTER TABLE DROP INDEX