VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: yakkes on February 09, 2013, 10:33:55 AM

Title: VM 2.0.18a SQL errors on Remove VM data
Post by: yakkes on February 09, 2013, 10:33:55 AM
Try to remove VM data using the Tools&Migration and get errors

JInstaller::install: homepath/administrator/components/com_virtuemart/install/uninstall_data.sql SQL Error DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS' at line 1 SQL=DELETE FROM `r20ep_virtuemart_paymentmethod_creditcards` IF EXISTS;
SQL =
DELETE FROM `#__virtuemart_paymentmethod_creditcards` IF EXISTS;

JInstaller::install: homepath/administrator/components/com_virtuemart/install/uninstall_data.sql SQL Error DB function failed with error number 1146
Table 'vmdb.r20ep_virtuemart_product_downloads' doesn't exist SQL=DELETE FROM `r20ep_virtuemart_product_downloads`;
SQL =
DELETE FROM `#__virtuemart_product_downloads`;


edit: tables dont exist in standard install. Looks like the if exists doesn't behave correctly.

linux Centos, mysql 5.0.67, php v5.2.13, Joomla v2.5.9