VM 2.0.4 - SQL error at removing VM data by migration tools

Started by SamF, April 14, 2012, 16:44:26 PM

Previous topic - Next topic

SamF

Hello,

J2.5.4 +VM2.0.4
MySQL Server version: 5.1.61

Backend, Tools->Tools & Migration

Trying to push "Remove VirtueMart Data" button. Get the following error message:


JInstaller::install: /.../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 `XYXYX_virtuemart_paymentmethod_creditcards` IF EXISTS;

SQL = DELETE FROM `#__virtuemart_paymentmethod_creditcards` IF EXISTS;