VirtueMart Forum

VirtueMart 2 + 3 => General Questions => Topic started by: 2cool on November 11, 2018, 09:43:03 am

Title: 1052 Column 'product_sku' in where clause is ambiguous
Post by: 2cool on November 11, 2018, 09:43:03 am
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]
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
Title: Re: 1052 Column 'product_sku' in where clause is ambiguous
Post by: GJC Web Design on November 11, 2018, 10:32:20 am
????     ->   http://forum.virtuemart.net/index.php?topic=141095.msg497663#msg497663
Title: Re: 1052 Column 'product_sku' in where clause is ambiguous
Post by: 2cool on November 11, 2018, 12:09:18 pm
Thanks but not sure what to do, change or update?
I'm using custom fields for all, is this causing the trouble....

Regards,
Pas
Title: Re: 1052 Column 'product_sku' in where clause is ambiguous
Post by: GJC Web Design on November 11, 2018, 12:18:02 pm
Quote
Also to test http://dev.virtuemart.net/attachments/download/1146/com_virtuemart.3.4.3.9973_package_or_extract.zip

Quote
From my tests, the issue with the ambiguous and duplicate fields seems solved.
Title: Re: 1052 Column 'product_sku' in where clause is ambiguous
Post by: 2cool on November 11, 2018, 12:26:24 pm
Thanks, just updated and problem is solved.

Regards,
Pas