VM AIO update error

[EvanGR]

Hello,

I am getting an error (see screenshot) when trying to install the VM AIO update package.

More specifically, I am testing a migration on localhost from a J2.5.28/VM2.6.22 website, on to VM 3 (initially, then to Joomla 3 also).

I first install VM 3.2.3.9624, which succeeds.
Then I try the AIO component (same version), which fails with the error:

Code Select Expand

JDatabaseMySQLi::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'username@email.com"|hide_login="0"|logourl=""|secret_word=""|payment_currency="0' at line 2 SQL=UPDATE `jos_virtuemart_paymentmethods` SET `payment_params`= "product=acc|pay_to_email="username@email.com"|hide_login="0"|logourl=""|secret_word=""|payment_currency="0"|payment_logos=""|countries=""|cost_per_transaction=""|cost_percent_total=""|min_amount=""|max_amount=""|tax_id=0|status_pending="P"|status_success="C"|status_canceled="X"|" , `payment_jplugin_id` = 10324 , `payment_element`= "skrill" WHERE `virtuemart_paymentmethod_id` =7

(also check attached screenshot)


I get the same AIO installation error with other VM3 releases that I tried to install (e.g. VM 3.0.19)

Localhost setup is xampp with the following components: Apache 2.4.33, PHP 5.6.36, MariaDB 5.5.5-10.1.34

Any help appreciated, thanks!

[GJC Web Design]

I can't spot the error in the params string but i would just delete payment id 7 skrill  and remake it after the upgrade

why waste time debugging this ( or delete the entry in the payments_param field for id 7)

[EvanGR]

Deleting payment id 7, fixed this. Thank you!

[Milbo]

Actually, the migration can be done within vm, but it was just tested for vm3.0.x. Should also work with the last vm3.2.14. There are some extra tools to adjust the customfields stuff (in the tools section).

But personally, I recommened to use the migrator of daycounts. https://extensions.virtuemart.net/back-office/import-export/virtuemart-migrator-detail