Author Topic: VM AIO update error  (Read 72 times)


  • Jr. Member
  • **
  • Posts: 84
VM AIO update error
« on: August 08, 2018, 11:18:59 am »

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, which succeeds.
Then I try the AIO component (same version), which fails with the error:

Code: [Select]
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 '"|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=""|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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7885
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: VM AIO update error
« Reply #1 on: August 08, 2018, 11:43:55 am »
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)
GJC Web Design
VirtueMart and Joomla Developers - php developers
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
Contact for any VirtueMart or Joomla development & customisation


  • Jr. Member
  • **
  • Posts: 84
Re: VM AIO update error
« Reply #2 on: August 08, 2018, 11:55:55 am »
Deleting payment id 7, fixed this. Thank you!