Author Topic: 1052 Column 'product_sku' in where clause is ambiguous  (Read 650 times)

2cool

  • Jr. Member
  • **
  • Posts: 211
1052 Column 'product_sku' in where clause is ambiguous
« 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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8864
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
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

2cool

  • Jr. Member
  • **
  • Posts: 211
Re: 1052 Column 'product_sku' in where clause is ambiguous
« Reply #2 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

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8864
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: 1052 Column 'product_sku' in where clause is ambiguous
« Reply #3 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.
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

2cool

  • Jr. Member
  • **
  • Posts: 211
Re: 1052 Column 'product_sku' in where clause is ambiguous
« Reply #4 on: November 11, 2018, 12:26:24 pm »
Thanks, just updated and problem is solved.

Regards,
Pas