Print Page - 1052 Column 'product_sku' in where clause is ambiguous

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

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

QuoteFrom 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

VirtueMart Forum

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