Author Topic: VM 2.0.18a SQL errors on Remove VM data  (Read 1383 times)

yakkes

  • Beginner
  • *
  • Posts: 40
VM 2.0.18a SQL errors on Remove VM data
« 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