Virtuemart 1054 Unknown column 'Array' in 'where clause'

Neu bei Joomla? Allgemeine Fragen über Joomla! 3.0
Post Reply
Steven1998
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Nov 26, 2020 7:49 pm

Virtuemart 1054 Unknown column 'Array' in 'where clause'

Post by Steven1998 » Thu Nov 26, 2020 7:57 pm

Hallo,

ich bekomme immer wenn ich bei Virtuemart im Backend ein Produkt suche eine Fehlermeldung :
1054 Unknown column 'Array' in 'where clause'

Die Datenbankverbindung stimmt und ich habe alle Updates gemacht, aber ich weiß nicht wie lang dieser Fehler bereits existiert.

Hat jemand eine Idee?

Ich verwende Joomla3.9.23 PHP 7.3.24 und Virtuemart 3.8.6

Vielen Dank!
Last edited by toivo on Mon Nov 30, 2020 5:45 pm, edited 1 time in total.
Reason: typo in subject

User avatar
apithanos99
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Sat Aug 02, 2008 2:51 pm
Location: Hong Kong S.A.R.
Contact:

Re: Viruemart 1054 Unknown column 'Array' in 'where clause'

Post by apithanos99 » Mon Nov 30, 2020 5:15 pm

I have the same problem after updating VM to the latest version on 24/11. I checked database tables on products and categories, i tried "Fix database" from the administration panel, i tried check and repair database from cpanel, NOTHING!

Any ideas how to fix this please?
Web design and 360° Virtual tour services in Hong Kong, Russia and Greece
http://www.aid360.com.hk

salmolin
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Dec 07, 2020 9:00 pm

Re: Virtuemart 1054 Unknown column 'Array' in 'where clause'

Post by salmolin » Mon Dec 07, 2020 9:05 pm

Same problem here. Also interested in a solution

- Joomla 3.9.23
- PHP 7.4.13
- Virtuemart 3.8.6

ex3mist
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Dec 08, 2020 6:31 am

Re: Virtuemart 1054 Unknown column 'Array' in 'where clause'

Post by ex3mist » Tue Dec 08, 2020 6:44 am

salmolin wrote:
Mon Dec 07, 2020 9:05 pm
Same problem here. Also interested in a solution

- Joomla 3.9.23
- PHP 7.4.13
- Virtuemart 3.8.6
Hello, did you find solution? I have the same problem after migrating VM data to the new site. The error appears only when opening Virtuemart - Products in the admin.
(Same Joomla, PHP and VM versions)

Groucho76
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Wed Dec 09, 2020 11:57 pm

Re: Virtuemart 1054 Unknown column 'Array' in 'where clause'

Post by Groucho76 » Thu Dec 10, 2020 12:14 am

ex3mist wrote:
Tue Dec 08, 2020 6:44 am
Hello, did you find solution? I have the same problem after migrating VM data to the new site. The error appears only when opening Virtuemart - Products in the admin.
(Same Joomla, PHP and VM versions)
Have a client who had exactly the same problem however I found a manual code fix has been released AND/OR a beta of VirtueMart 3.8.7 resolving this issue. I opted for the manual fix and all is now well.

http://forum.virtuemart.net/index.php?topic=145855.15


Post Reply

Return to “Allgemeine Fragen”