Post by crunchyroll » Sat Aug 22, 2015 7:37 am

a few of the products started randomly not working and showing a white blank page. In the error log I noticed this:

Code: Select all

PHP Notice:  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
						GROUP BY op.product_id ORDER BY no_sells DESC LIMIT 0,3' at line 3<br />Error No: 1064<br />SELECT op.product_id, SUM(op.quantity) as no_sells FROM oc_order_product op   
						WHERE op.product_id !='11'  

New member

Posts

Joined
Mon Mar 18, 2013 7:31 am

Post by IP_CAM » Sat Aug 22, 2015 11:39 pm

no_sells ???
then, tell us first, how this no_sells get's into your v.1.5.6.x Shop Software !
Ernie

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by crunchyroll » Tue Aug 25, 2015 4:33 am

I'm not understanding what you mean?

New member

Posts

Joined
Mon Mar 18, 2013 7:31 am

Post by straightlight » Tue Aug 25, 2015 10:03 pm

The no sells module is a contributed module. This error message originates from a specific module you installed after downloading this module. I would suggest contacting the author to resolve this problem. It looks like this error might be related to a typo or logic issue from one of the query models.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by crunchyroll » Wed Aug 26, 2015 5:11 am

I think I found the module that was contributing to the issue. Appreciate in providing insight! Thank you

New member

Posts

Joined
Mon Mar 18, 2013 7:31 am
Who is online

Users browsing this forum: No registered users and 109 guests