Author Topic: 1052 Column 'product_sku' in order clause is ambiguous  (Read 1929 times)

webzight

  • Jr. Member
  • **
  • Posts: 81
    • WEBZIGHT.COM
1052 Column 'product_sku' in order clause is ambiguous
« on: May 24, 2019, 01:31:09 am »
HI Max and Kelvyn,

I looked around for an adequate answer to the subject error message I get while trying to look at the products in the admin area!
Another words, when I click on "Products", I get the subject error message!
I created a Custom field, which didn't do what I thought, after I tried calling it up, when I tried to go back after calling that, I got the subject error!
Now every time I try to access the "Products" in the Control Panel, 1052 Column 'product_sku' in order clause is ambiguous
Also seems to be coming from Joomla! and NOT VM, so running the VM debugger seems to be of no use as far as I can see!
VirtueMart 3.4.2
Joomla! 3.9.6
May the Cloud be with you :)

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10545
  • VM4.0.7 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

webzight

  • Jr. Member
  • **
  • Posts: 81
    • WEBZIGHT.COM
Re: 1052 Column 'product_sku' in order clause is ambiguous
« Reply #2 on: May 24, 2019, 17:37:34 pm »
Thanks for the reply Max  8)
I fiddled around some more and finally just reloaded 3.4.2 and it was still doing the same thing, but after I stopped VM and restarted, the error went away!  ???
GO FIGURE!  :P
May the Cloud be with you :)

webzight

  • Jr. Member
  • **
  • Posts: 81
    • WEBZIGHT.COM
Re: 1052 Column 'product_sku' in order clause is ambiguous
« Reply #3 on: May 24, 2019, 22:21:37 pm »
BTW Max I did install the latest version you sent me and no problems so far, just had do redo some custom mods to the "product" description views  8)
May the Cloud be with you :)

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28535
  • Always on vacation
    • Jenkin Hill Internet
Re: 1052 Column 'product_sku' in order clause is ambiguous
« Reply #4 on: May 25, 2019, 11:43:56 am »
had do redo some custom mods to the "product" description views  8)

Are you not using overrides?

Some VM3.4.2 users reported issues when they upgraded Joomla to 3.9, fixed by upgrading to VM3.5  No idea why.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 4.0.14 10805  J 3.10.11 PHP 8.0.27

webzight

  • Jr. Member
  • **
  • Posts: 81
    • WEBZIGHT.COM
Re: 1052 Column 'product_sku' in order clause is ambiguous
« Reply #5 on: May 25, 2019, 18:38:22 pm »
YES Kelvyn I am using the overrides, where I can get them to work that is!  ::)

The other issue is head scratcher for sure!  :P

May the Cloud be with you :)