News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VM AIO update error

Started by EvanGR, August 08, 2018, 11:18:59 AM

Previous topic - Next topic

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:

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)
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

EvanGR

Deleting payment id 7, fixed this. Thank you!

;D

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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/