VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: webzight on May 24, 2019, 01:31:09 AM

Title: 1052 Column 'product_sku' in order clause is ambiguous
Post by: webzight 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
Title: Re: 1052 Column 'product_sku' in order clause is ambiguous
Post by: Milbo on May 24, 2019, 08:04:40 AM
Please use http://dev.virtuemart.net/attachments/1165/com_virtuemart.3.4.5.10063_package_or_extract.zip
Title: Re: 1052 Column 'product_sku' in order clause is ambiguous
Post by: webzight 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
Title: Re: 1052 Column 'product_sku' in order clause is ambiguous
Post by: webzight 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)
Title: Re: 1052 Column 'product_sku' in order clause is ambiguous
Post by: jenkinhill on May 25, 2019, 11:43:56 AM
Quote from: webzight on May 24, 2019, 22:21:37 PM
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.
Title: Re: 1052 Column 'product_sku' in order clause is ambiguous
Post by: webzight 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