1054 Unknown column 'Array' in 'where clause'

[roby]

When I try to upload a new product it gives me this error and doesn't keep me going. I can see the category table, orders, etc but not products

[roby]

I try to fix database but nothing.....

[Jörgen]

??
Try google the error code, probable a ver old joomla or vm or plugin or component or bad moon ...

Giving soo little info 

Jörgen

[roby]

joomla 3.9.22     Virtuemart  3.8.6

[GJC Web Design]

switch on Joomla debug so u get a full error trace and paste that here

[roby]

/home/sh3owvui/public_html/libraries/joomla/database/driver/mysqli.php:665
Call stack
#   Function   Location
1   ()   JROOT/libraries/joomla/database/driver/mysqli.php:665
2   JDatabaseDriverMysqli->execute()   JROOT/libraries/joomla/database/driver.php:1550
3   JDatabaseDriver->loadColumn()   JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:865
4   VmModel->exeSortSearchListQuery()   JROOT/administrator/components/com_virtuemart/models/product.php:833
5   VirtueMartModelProduct->sortSearchListQuery()   JROOT/administrator/components/com_virtuemart/models/product.php:1992
6   VirtueMartModelProduct->getProductListing()   JROOT/administrator/components/com_virtuemart/views/product/view.html.php:394
7   VirtuemartViewProduct->display()   JROOT/administrator/components/com_virtuemart/helpers/vmcontroller.php:121
8   VmController->display()   JROOT/libraries/src/MVC/Controller/BaseController.php:710
9   Joomla\CMS\MVC\Controller\BaseController->execute()   JROOT/administrator/components/com_virtuemart/virtuemart.php:76
10   require_once()   JROOT/libraries/src/Component/ComponentHelper.php:402
11   Joomla\CMS\Component\ComponentHelper::executeComponent()   JROOT/libraries/src/Component/ComponentHelper.php:377
12   Joomla\CMS\Component\ComponentHelper::renderComponent()   JROOT/libraries/src/Application/AdministratorApplication.php:101
13   Joomla\CMS\Application\AdministratorApplication->dispatch()   JROOT/libraries/src/Application/AdministratorApplication.php:159
14   Joomla\CMS\Application\AdministratorApplication->doExecute()   JROOT/libraries/src/Application/CMSApplication.php:196
15   Joomla\CMS\Application\CMSApplication->execute()   JROOT/administrator/index.php:51

[patosal]

I'm in the same situation. After the virtuemart 3.8.6 10373 update every time I try to enter in the products backend page it shows a 1054 Unknown column 'Array' in 'where clause' error. When I try to update the database tables, it shows a message:
alterColumns jos_virtuemart_waitingusers from TIMESTAMP NOT NULL DEFAULT 'CURRENT_TIMESTAMP()' ON UPDATE CURRENT_TIMESTAMP() to notify_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
alterTable CHANGE jos_virtuemart_waitingusers.notify_date

What's happening?

thanks

[igormoor]

Same situation, same logs and db update tools behavior...

Topic about this problem: http://forum.virtuemart.net/index.php?topic=145855.0

[GJC Web Design]

please ONLY now post in topic http://forum.virtuemart.net/index.php?topic=145855.0