VirtueMart Forum

VirtueMart 2 + 3 => Product creation => Topic started by: roby on November 22, 2020, 10:30:12 am

Title: 1054 Unknown column 'Array' in 'where clause'
Post by: roby on November 22, 2020, 10:30:12 am
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
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: roby on November 22, 2020, 10:35:37 am
I try to fix database but nothing.....
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: Jörgen on November 22, 2020, 11:08:12 am
??
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
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: roby on November 22, 2020, 11:18:31 am
joomla 3.9.22     Virtuemart  3.8.6
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: GJC Web Design on November 22, 2020, 12:22:42 pm
switch on Joomla debug so u get a full error trace and paste that here
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: roby on November 22, 2020, 15:54:15 pm
/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
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: patosal on November 23, 2020, 13:08:00 pm
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
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: igormoor on November 25, 2020, 10:09:13 am
Same situation, same logs and db update tools behavior...

Topic about this problem: http://forum.virtuemart.net/index.php?topic=145855.0
Title: Re: 1054 Unknown column 'Array' in 'where clause'
Post by: GJC Web Design on November 25, 2020, 10:33:17 am
please ONLY now post in topic http://forum.virtuemart.net/index.php?topic=145855.0