1052 Column 'product_sku' in where clause is ambiguous

[2cool]

Hi recently got this error when trying to access virtuemart products:
How can this be solved. I can acess all other except products.

Using VirtueMart 3.4.2 and Joomla! 3.9.0

Code Select Expand


1052 Column 'product_sku' in where clause is ambiguous
    /home/buildbyp/public_html/libraries/joomla/database/driver/mysqli.php:661

Call stack
# Function Location
1 () JROOT/libraries/joomla/database/driver/mysqli.php:661
2 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544
3 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_virtuemart/helpers/vmmodel.php:852
4 VmModel->exeSortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:789
5 VirtueMartModelProduct->sortSearchListQuery() JROOT/administrator/components/com_virtuemart/models/product.php:1744
6 VirtueMartModelProduct->getProductListing() JROOT/administrator/components/com_virtuemart/views/product/view.html.php:375
7 VirtuemartViewProduct->display() JROOT/administrator/components/com_virtuemart/helpers/vmcontroller.php:122
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
 

Thanks in advance,
Pas

[GJC Web Design]

?     ->   http://forum.virtuemart.net/index.php?topic=141095.msg497663#msg497663

[2cool]

Thanks but not sure what to do, change or update?
I'm using custom fields for all, is this causing the trouble....

Regards,
Pas

[GJC Web Design]

Also to test http://dev.virtuemart.net/attachments/download/1146/com_virtuemart.3.4.3.9973_package_or_extract.zip

From my tests, the issue with the ambiguous and duplicate fields seems solved.

[2cool]

Thanks, just updated and problem is solved.

Regards,
Pas