News:

Looking for documentation? Take a look on our wiki

Main Menu

custom fields database error [Solved]

Started by Ty3uK, August 31, 2012, 18:23:07 PM

Previous topic - Next topic

Ty3uK

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]

Ty3uK

help deleting all indexes exept primary (maybe dameged index)
command
ALTER TABLE  DROP INDEX