Fatal error on 2.5.5

De New Zealand
Membro desde ago 2019

Is anyone using this add-on on a fresh install of 2.5.5?

I get this error when displaying a product:

Fatal error: 1054 - Unknown column 'pr.date_created' in 'order clause'
select pr.*, pri.title, pri.review
from lc_products_reviews pr
left join lc_products_reviews_info pri on (pr.id = pri.review_id and pri.language_code = 'en')
left join lc_customers c on (pr.customer_id = c.id)
where pr.status and pr.product_id = 14
and pri.review != ''
order by pr.date_created desc;
in ~/includes/library/lib_database.inc.php (Line 177)

Looks like the first change in the VMOD for page/product.inc.php is wrong. The search string >and pr.product_id = ". (int)$product->id ."< does not exist.

De New Zealand
Membro desde ago 2019

OOPS:
One should double check before one should post. I did find an error on my part - when altering the database I actually did not create the "date_created" item in ls_products_review.

Sorry for the confusion - all working well

tim
Founder
De Sweden
Membro desde mai 2013
tim

🙂

Tu
This website uses no cookies and no third party tracking technology. We think we can do better than others and really think about your privacy.