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

EvanGR

  • Jr. Member
  • **
  • Posts: 133
VM AIO update error
« on: August 08, 2018, 11:18:59 am »
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]
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8221
  • 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 http://www.gjcwebdesign.com
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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

EvanGR

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

 ;D

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9682
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM AIO update error
« Reply #3 on: August 20, 2018, 23:09:28 pm »
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
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/