VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: patbe60 on October 28, 2025, 17:14:10 PM

Title: Can't edit payment method in BE
Post by: patbe60 on October 28, 2025, 17:14:10 PM
When I try to edit a payment method in BE I get the following error:

An error has occurred.

    1054 Unknown column 'Array' in 'WHERE'

I can create new payment methods. But after saving them I get this error:

info
Payment Method successfully saved
An error has occurred.

    1054 Unknown column 'Array' in 'where clause'

J 5.4.0
VM 4.6
Title: Re: Can't edit payment method in BE
Post by: patbe60 on October 28, 2025, 17:32:30 PM
I made some tests: It works with the following methods (editing and creating):

klarna
paypal
amazon
opctracking
opc_shipping_last
authorizenet

All other methods end in the above described error. Also older paypal method can't be edited.
Title: Re: Can't edit payment method in BE
Post by: Milbo on October 28, 2025, 19:10:43 PM
I thank you very much for this detailed bug report. I check it out.
Title: Re: Can't edit payment method in BE
Post by: Milbo on October 29, 2025, 09:08:20 AM
Hmmm, but I cannot reproduce it. Maybe the problem lies in a non core plugin? For example this opctracking? Maybe that interferes.
Title: Re: Can't edit payment method in BE
Post by: patbe60 on October 29, 2025, 17:53:13 PM
Okay, I finally found the error in the virtuemart_vendors table. It works fine again.
Title: Re: Can't edit payment method in BE
Post by: Milbo on October 30, 2025, 10:54:02 AM
okey, ehrm, what was the error in the virtuemart_vendors table?
Title: Re: Can't edit payment method in BE
Post by: patbe60 on October 30, 2025, 11:34:40 AM
It wouldn't have been necessary to check the database. The error was that there was no value in shop -> vendor tab -> List of accepted currencies.

This leaded to a wrong value in the table in vendor_accepted_currencies: "Array" instead of a currency ID (in my case swiss francs - ID = 27).

I don't know, why this field wasn't filled in any longer. As you know I'm using VM since years without this problem.