stefanpws De New Zealand Membro desde ago 2019 stefanpws 25 fev 2024 21:14 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.
stefanpws De New Zealand Membro desde ago 2019 stefanpws 25 fev 2024 21:42 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