Author Topic: custom fields database error [Solved]  (Read 1804 times)

Ty3uK

  • Beginner
  • *
  • Posts: 13
custom fields database error [Solved]
« on: August 31, 2012, 18:23:07 pm »
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

  • Beginner
  • *
  • Posts: 13
Re: custom fields database error
« Reply #1 on: September 04, 2012, 17:37:06 pm »
help deleting all indexes exept primary (maybe dameged index)
command
 ALTER TABLE  DROP INDEX