VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: TechnoMage on April 03, 2012, 18:30:31 PM

Title: [BUG] Remove Virtuemart Data Error Message
Post by: TechnoMage on April 03, 2012, 18:30:31 PM
Hi,

When I click on the "Remove Virtuemart Data" under the Tools and Migration menu point the following error message is shown:

QuoteJInstaller::install: /var/www/topp/data/www/meseteszt.topp.hu/administrator/components/com_virtuemart/install/uninstall_data.sql SQL hiba 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 `topp_virtuemart_paymentmethod_creditcards` IF EXISTS;
SQL =

DELETE FROM `topp_virtuemart_paymentmethod_creditcards` IF EXISTS;

I am using Joomla 1.5.25 and VM 2.0.3.I (it was the same under the earlier versions as well like for example VM 2.0.3.E).

Cya
Title: Re: [BUG] Remove Virtuemart Data Error Message
Post by: Milbo on April 07, 2012, 18:43:30 PM
Why do yo uuse this command?
Title: Re: [BUG] Remove Virtuemart Data Error Message
Post by: TechnoMage on April 08, 2012, 11:59:52 AM
I am still struggling with the migration of my VM 1.1.9 webshop to 2.0.X and I am trying out your new releases in hope for that the migration tool will support the attributes part of VM 1.1.9. For that I have to empty the VM 2.0.X tables so I use that button of yours for that, then comes this error message (anyway it empty the tables).
Title: Re: [BUG] Remove Virtuemart Data Error Message
Post by: Milbo on April 08, 2012, 13:18:47 PM
Imho this is working partly, electrocity knows it better. Better in your case is to use
"Reset all tables
and do a fresh install "