Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: m.davide82 on June 07, 2017, 12:11:52 PM

Title: Unknown column 'product_name' in 'order clause'
Post by: m.davide82 on June 07, 2017, 12:11:52 PM
Hi,

I receive this error after the latest update 3.2.3
Unknown column 'product_name' in 'order clause'

Any idea on how can I solve it?


Thanks in advance!
Title: Re: Unknown column 'product_name' in 'order clause'
Post by: jenkinhill on June 07, 2017, 12:26:55 PM
Like http://forum.virtuemart.net/index.php?topic=137578 ?  What PHP version?
Title: Re: Unknown column 'product_name' in 'order clause'
Post by: m.davide82 on June 07, 2017, 14:22:44 PM
Hi jenkinhill,

thanks a lot, but my php version is  7.0.12.


Thanks,
Davide
Title: Re: Unknown column 'product_name' in 'order clause'
Post by: m.davide82 on June 08, 2017, 22:10:49 PM
No one can help me please?


Thanks!
Title: Re: Unknown column 'product_name' in 'order clause'
Post by: Milbo on June 09, 2017, 10:55:32 AM
Come on, try to think from our perspective. When comes the message, where, what you are doing?

Your description says, you updated your VM and you get the message, always and anywhere.
Title: Re: Unknown column 'product_name' in 'order clause'
Post by: Milbo on June 09, 2017, 11:36:33 AM
Found and fixed.

Happened ordering for name in the product list and then editing a product. The ordering of the product list was used for the ordering of shopper who bought the product list.
Title: Re: Unknown column 'product_name' in 'order clause'
Post by: m.davide82 on June 09, 2017, 23:04:14 PM
Hi Milbo,

sorry if I wasn't clear.

The error appears each time that I create a new product.

Thanks a lot,
Davide


PS.
Fot the moment I downgraded to 3.2.2 and now it's working....
Text only | Text with Images