error in the database storing products

[naxmt]

Hello, I would like to ask for help. I did upgrade VM 2.0.x to VM 2.0.26d not always but sometimes I get error when changing products. I noticed that deletes the name of the product in the backend(image in attachement). In front end product shows OK, when checking the database names are there okay too. Problem can be solved by correct errors table in phpMyAdmin. I can repair it but the issue i got again. Do you have experience as someone solve this permanently? I do not have a database backup , in FTP is enough space(there problem isnt).
Joomla 2.5.27 , VM 2.0.26d

error message:
•   vmError: vmTable load xTable './f9xjv1412/tadisu726_virtuemart_product_customfields' is marked as crashed and should be repaired SQL=SELECT `tadisu726_virtuemart_products_sk_sk`.* ,`tadisu726_virtuemart_products`.* ,`tadisu726_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` ,`tadisu726_virtuemart_product_customfields`.`virtuemart_customfield_id` FROM `tadisu726_virtuemart_products_sk_sk` JOIN tadisu726_virtuemart_products using (`virtuemart_product_id`) LEFT JOIN `tadisu726_virtuemart_product_manufacturers` on `tadisu726_virtuemart_product_manufacturers`.`virtuemart_product_id`=`tadisu726_virtuemart_products_sk_sk`.`virtuemart_product_id` LEFT JOIN `tadisu726_virtuemart_product_customfields` on `tadisu726_virtuemart_product_customfields`.`virtuemart_product_id`=`tadisu726_virtuemart_products_sk_sk`.`virtuemart_product_id` WHERE tadisu726_virtuemart_products_sk_sk.`virtuemart_product_id` = "1871"

[attachment cleanup by admin]

[jenkinhill]

2.0.26d was a long time ago. You should really be using 2.6.10 now - http://virtuemart.net/news/latest-news/462-security-release-of-vm2-6-10-and-vm2-9-9b

I don't know if that will fix your problem, but it is possible.

Test the update on a backup copy of the site, of course.

[naxmt]

Thank you for quick answer. I have trouble with webprovider he can give me max version of PHP 5.2.17 and this is not compatible with VM 2.6.10 can you wrote mi which newest version is compatible with PHP 5.2.17 ? Thank you once again

[jenkinhill]

Given that support for pHP5.2.x finished in January 2011  surely it is time that this host updated! Old PHP versions have security implications as well as old versions of software. There is no secure version of VM that works properly with 5.2.17, and the last version to work with that PHP is 2.0.26d,  but you could apply the security patch as documented in the link I gave earlier.

It is possible that your db issue is related to that old PHP version, and more than likely other software on the server is old, too. I'd consider looking for a new host, especially as the "recommended" PHP version for Joomla 2.5.x is now 5.4+

[Milbo]

You can still use vm2.6.10 with older php versions. We just say you need at leaset, the version 5.3.10. There are two reasons, first all below 5.3.10 is unsecure and seconed we dont want to be told that we have to fix whatever for that versions. But you can still just install them, there is even a fallback for versions below 5.3.10.

mError: vmTable load xTable './f9xjv1412/tadisu726_virtuemart_product_customfields' is marked as crashed and should be repaired

This also indicates that you have to repair your table, for example with webmin.