Page 1 of 1

User gets error when viewing under (my downloads)

Posted: Wed Apr 15, 2009 11:12 pm
by halalan
I am testing v. 1.2.6 and after signing up as a customer then going into my account. I clicked on (my downloads) Note: I have not ordered any.

I got this error:

Code: Select all

Error: Unknown column 'o.order_status' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM order_download od LEFT JOIN `order` o ON (od.order_id = o.order_id) WHERE o.customer_id = '3' AND o.order_status > '0' AND o.order_status_id = '5'
Possible bug...maybe

Re: User gets error when viewing under (my downloads)

Posted: Sun Apr 19, 2009 7:35 am
by japan
Hi, I find the this error and reported the bug.

Please refer
http://forum.opencart.com/viewtopic.php ... tus#p17922

Re: User gets error when viewing under (my downloads)

Posted: Sun Apr 19, 2009 8:36 am
by Daniel
Yeah its a bug.

I'm goign to release another version soon with a fix in.

Re: User gets error when viewing under (my downloads)

Posted: Mon Apr 20, 2009 5:23 am
by tommix
Daniel wrote:Yeah its a bug.

I'm goign to release another version soon with a fix in.
can you just say how to fix?? no time to wait another release. i think this is small problem, maybe mistake in query or something..


ok i've found: http://forum.opencart.com/viewtopic.php ... ads#p17987