Page 1 of 1
product links show blank randomly
Posted: Sat Aug 22, 2015 7:37 am
by crunchyroll
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'
Re: product links show blank randomly
Posted: Sat Aug 22, 2015 11:39 pm
by IP_CAM
no_sells 
then, tell us first, how this
no_sells get's into your v.1.5.6.x Shop Software !
Ernie
Re: product links show blank randomly
Posted: Tue Aug 25, 2015 4:33 am
by crunchyroll
I'm not understanding what you mean?
Re: product links show blank randomly
Posted: Tue Aug 25, 2015 10:03 pm
by straightlight
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.
Re: product links show blank randomly
Posted: Wed Aug 26, 2015 5:11 am
by crunchyroll
I think I found the module that was contributing to the issue. Appreciate in providing insight! Thank you