Author Topic: 1054 Unknown column 'Array' in 'where clause'  (Read 685 times)

roby

  • Beginner
  • *
  • Posts: 8
  • A beginner
1054 Unknown column 'Array' in 'where clause'
« 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

roby

  • Beginner
  • *
  • Posts: 8
  • A beginner
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #1 on: November 22, 2020, 10:35:37 am »
I try to fix database but nothing.....

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3216
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #2 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
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

roby

  • Beginner
  • *
  • Posts: 8
  • A beginner
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #3 on: November 22, 2020, 11:18:31 am »
joomla 3.9.22     Virtuemart  3.8.6

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10024
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #4 on: November 22, 2020, 12:22:42 pm »
switch on Joomla debug so u get a full error trace and paste that here
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

roby

  • Beginner
  • *
  • Posts: 8
  • A beginner
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #5 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

patosal

  • Beginner
  • *
  • Posts: 2
  • A beginner
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #6 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

igormoor

  • Beginner
  • *
  • Posts: 11
  • We are the Borg.
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #7 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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10024
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: 1054 Unknown column 'Array' in 'where clause'
« Reply #8 on: November 25, 2020, 10:33:17 am »
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation