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
I try to fix database but nothing.....
??
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.22 Virtuemart 3.8.6
switch on Joomla debug so u get a full error trace and paste that here
/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
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
Same situation, same logs and db update tools behavior...
Topic about this problem: http://forum.virtuemart.net/index.php?topic=145855.0
please ONLY now post in topic http://forum.virtuemart.net/index.php?topic=145855.0