News:

Support the VirtueMart project and become a member

Main Menu

VM 2.0.18a SQL errors on Remove VM data

Started by yakkes, February 09, 2013, 10:33:55 AM

Previous topic - Next topic

yakkes

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