Daydreams Posted March 15, 2011 Share Posted March 15, 2011 On my store i have the comments tab available for product reviews however when someone eneters a comment it says it will be sent for moderation however i can not find a section in the back office at all, does anyone know where this may be please?Thanks Link to comment Share on other sites More sharing options...
keweli Posted March 23, 2011 Share Posted March 23, 2011 For 1.4:Modules -> Front Office Features -> Product Comments (configure) Link to comment Share on other sites More sharing options...
adammontague Posted June 16, 2011 Share Posted June 16, 2011 I'm running 1.4 and I've checked in the BO but it says "No comments to validate at this time."I must have added at least 3 reviews, but nothing? Link to comment Share on other sites More sharing options...
shokinro Posted June 16, 2011 Share Posted June 16, 2011 “No comments to validate at this time.” maybe your comments is not added successfully.check your database if records are really added in database.ps_product_commentIf there is not data there, it means there is something wrong when you added the comments.If there is no data in database, try to change to "display_error" to "on" in file /config/config.inc.php, and then to to add "comment" again to see if there is any errors.If there is data in database, then go to moderate page again to see if there is any errors. Link to comment Share on other sites More sharing options...
adammontague Posted June 16, 2011 Share Posted June 16, 2011 Doesn't look like there's any comments/reviews? I'm not entirely sure what I'm looking for here, but the Warning message at the bottom doesn't look too friendly either? Link to comment Share on other sites More sharing options...
shokinro Posted June 16, 2011 Share Posted June 16, 2011 It means your test post of the comments are not saved successfully. You need to find out the cause of the problem.have you tried the display_errors to on and see any errors? Link to comment Share on other sites More sharing options...
adammontague Posted June 17, 2011 Share Posted June 17, 2011 Ok, so I changed the config file to the following... /* Debug only */ @ini_set('display_errors', 'on'); define('_PS_DEBUG_SQL_', true); and got this... 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 'AND c.nright <= ORDER BY `level_depth` ASC, c.`position` ASC' at line 9 SELECT c.id_parent, c.id_category,c.nleft,c.nright, cl.name, cl.description, cl.link_rewrite FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE (c.`active` = 1 OR c.`id_category` = 1) AND `level_depth` <= 3 AND cg.`id_group` = 1 AND c.nleft >= AND c.nright <= ORDER BY `level_depth` ASC, c.`position` ASC The SQL error doesn't mean anything to me, I don't know enough about SQL to diagnose it. Can anyone help on this? Link to comment Share on other sites More sharing options...
shokinro Posted June 17, 2011 Share Posted June 17, 2011 this error comes from category, seem not from comments.here is the part cause, c.nright <= ORDER BY .... There is nothing on the right side of the comparing.I guess something is wrong with your data. Link to comment Share on other sites More sharing options...
shokinro Posted June 19, 2011 Share Posted June 19, 2011 I have just released my own Product Reviews module. It has more features than the standard one.Here some of the features.* Configurable to show reviewers name or not * There are 3 predefined Criteriions: Quality, Performance, Value* Apply criterion to different level: Whole Catalog, Category, Product criterion and product mapping in one step * Lanugae sensitive - display reviews in user's lanuage only by default,one click to include other languages.* Pagination of reviews list in product detailed page* Most validation is performed before post, so that user does not have to back and forth.* Duplication post is checked to avoid misuse or mistakes* Product average rating will be automatically displayed on following pages - home featured product list - category product list - search result product list - manufacturer product list* One click batch validation of customer reviewsYou can find more info herehttp://www.prestashop.com/forums/viewthread/115506/ Link to comment Share on other sites More sharing options...
adammontague Posted June 24, 2011 Share Posted June 24, 2011 For any one else having this problem, my issues just "fixed" themselves when we uploaded the website on to the "proper" domain and out of our testing server?!Coincidence...perhaps? try it... Link to comment Share on other sites More sharing options...
shokinro Posted June 24, 2011 Share Posted June 24, 2011 For any one else having this problem, my issues just “fixed” themselves when we uploaded the website on to the “proper” domain and out of our testing server?! I guess it is cache issue. some time because cache, weird things appears.so when you feel it is weird, try to switch cache off/on, it will changes. Link to comment Share on other sites More sharing options...
Recommended Posts