Problem with Product Comments Module

jshop1 · April 13, 2014

Hello,

I am facing problem with module Product Comments. When I finished comment and review I clicked on "SEND" button but nothing happened. So I checked Module Product Comments and it showes New update of this version so I updated for the latest version but after that it shows error message "Can not install". I also tried manually download Module from Prestashop website and replace by FTP there the new version but now it still can not install.

Does anybody know how to fix it?

Thank you

vekia · April 15, 2014

hello

what prestashop version you use?

jshop1 · April 16, 2014

Hello Vekia,

I am using 1.5.4.1.

Thanks

NemoPS · April 16, 2014

No module update should not be performed on 1.5 anymore. Get a fresh 1.5 zip file, grab the productcomments module and upload all files to your site, overwriting the ones on the server.

When it's done, can you share the site's url? You might have a javascript issue

jshop1 · April 16, 2014

Hello dear, it is not working :-( I download Prestashop 1.5.4.1 I took module productcomments and I replaced module in my FTP but it is not working. When I click in Administration to Install module it it just shows Installation was not successful.

Do you have some advices or can I give you my access?

Thanks

vekia · April 16, 2014

try to remove these tables from database:

PREFIX_product_comment

PREFIX_product_comment_criterion

PREFIX_product_comment_criterion_product

PREFIX_product_comment_criterion_lang

PREFIX_product_comment_criterion_category

PREFIX_product_comment_grade

PREFIX_product_comment_usefulness

PREFIX_product_comment_report

and then try to install module again.

jshop1 · April 17, 2014

Thanks Vekia, now I installed but I am facing another problem:

When I add some comment and I click "SEND" nothing is happened. There is missing some direction which will send the comment.

You can check it here:

http://nakupledky.j-shop.cz/index.php?id_product=10&controller=product

Komentáře = Comments

Do you know how to fix it?
Thanks

NemoPS · April 18, 2014

This is the error:

productcomments_url_rewrite is not defined

Should be defined here

{addJsDef productcomments_url_rewrite=$productcomments_url_rewriting_activated|boolval}

themes\default-bootstrap\modules\productcomments.tpl

Check that you have it in your theme as well, or in the original tpl

vekia · April 18, 2014

i tried to add comment and for me, it works well, jut wondering if you see my comment in back office

can you check?

jshop1 · April 18, 2014

Vekia: No unfortunately I can not see your comment in Backoffice :-(

Nemo1: I found that file but can not see {addJsDef productcomments_url_rewrite=$productcomments_url_rewriting_activated|boolval}

I am sending you here script of productcomments.tpl. What I should to change to let it works?

Thank you

NemoPS · April 19, 2014

Hm, weird, it's different from the default one I have.

Anyway, add this at the very end

{strip}

{addJsDef productcomments_controller_url=$productcomments_controller_url|@addcslashes:'\''}

{addJsDef moderation_active=$moderation_active|boolval}

{addJsDef productcomments_url_rewrite=$productcomments_url_rewriting_activated|boolval}

{addJsDef secure_key=$secure_key}

{addJsDefL name=confirm_report_message}{l s='Are you sure you want report this comment?' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_added}{l s='Your comment has been added!' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_added_moderation}{l s='Your comment has been added and will be available once approved by a moderator' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_title}{l s='New comment' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_ok}{l s='OK' mod='productcomments' js=1}{/addJsDefL}

{/strip}

You can get rid of duplicate declarations at the beginning or your file

jshop1 · April 21, 2014

Thanks Nemo,

When I delete these:

And add these in the very end:

{strip}

{addJsDef productcomments_controller_url=$productcomments_controller_url|@addcslashes:'\''}

{addJsDef moderation_active=$moderation_active|boolval}

{addJsDef productcomments_url_rewrite=$productcomments_url_rewriting_activated|boolval}

{addJsDef secure_key=$secure_key}

{addJsDefL name=confirm_report_message}{l s='Are you sure you want report this comment?' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_added}{l s='Your comment has been added!' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_added_moderation}{l s='Your comment has been added and will be available once approved by a moderator' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_title}{l s='New comment' mod='productcomments' js=1}{/addJsDefL}

{addJsDefL name=productcomment_ok}{l s='OK' mod='productcomments' js=1}{/addJsDefL}

{/strip}

It is not working, I could not even load the page.

Please do you have another idea?

Thanks

Wefgndy · April 21, 2014

what prestashop version you use?

walidon · April 21, 2014

I have seen this problem before and it seems it is common among the 1.4 and 1.5 PS users.

can you try the following:

go to modules/productcomments/js/productcomments.js (BUT PLZ MAKE A COPY OF THAT AS A 1ST STEP)

change ligne 66 (or something like that, in my file it is ligne 66)

data: $('#id_new_comment_form').serialize(),

to

data: $('#new_comment_form form').serialize(),

then clear the cache in your BO as well as in your browsers.

let us know the result.

DO NOT FORGET TO MAKE A COPY OF THE ORIGINAL.

jshop1 · April 22, 2014

Hi, my Prestashop is v1.5.4.1.

Unfortunately, I am not having any data: $('#id_new_comment_form').serialize(), line in my file. Below is all the code I have in that file. Do you know what I should to change or rewrite?

$(function() {
   $('input[@type=radio].star').rating();
   $('.auto-submit-star').rating();

   $('.open-comment-form').fancybox({
       'hideOnContentClick': false
   });

   $('button.usefulness_btn').click(function() {
       var id_product_comment = $(this).data('id-product-comment');
       var is_usefull = $(this).data('is-usefull');
       var parent = $(this).parent();

       $.ajax({
           url: productcomments_controller_url + '?rand=' + new Date().getTime(),
           data: {
               id_product_comment: id_product_comment,
               action: 'comment_is_usefull',
               value: is_usefull
           },
           type: 'POST',
           headers: { "cache-control": "no-cache" },
           success: function(result){
               parent.fadeOut('slow', function() {
                   parent.remove();
               });
           }
       });
   });

   $('span.report_btn').click(function() {
       if (confirm(confirm_report_message))
       {
           var idProductComment = $(this).data('id-product-comment');
           var parent = $(this).parent();

           $.ajax({
               url: productcomments_controller_url + '?rand=' + new Date().getTime(),
               data: {
                   id_product_comment: idProductComment,
                   action: 'report_abuse'
               },
               type: 'POST',
               headers: { "cache-control": "no-cache" },
               success: function(result){
                   parent.fadeOut('slow', function() {
                       parent.remove();
                   });
               }
           });
       }
   });

   $('#submitNewMessage').click(function(e) {
       // Kill default behaviour
       e.preventDefault();

       // Form element

       url_options = parseInt(productcomments_url_rewrite) ? '?' : '&';
       $.ajax({
           url: productcomments_controller_url + url_options + 'action=add_comment&secure_key=' + secure_key + '&rand=' + new Date().getTime(),
           data: $('#fancybox-content form').serialize(),
           type: 'POST',
           headers: { "cache-control": "no-cache" },
           dataType: "json",
           success: function(data){
               if (data.result)
               {
                   $.fancybox.close();
                   document.location.href = document.location.href;
               }
               else
               {
                   $('#new_comment_form_error ul').html('');
                   $.each(data.errors, function(index, value) {
                       $('#new_comment_form_error ul').append('<li>'+value+'</li>');
                   });
                   $('#new_comment_form_error').slideDown('slow');
               }
           }
       });
       return false;
   });
});

NemoPS · April 22, 2014

Can you turn on error reporting and copy the error you get when you add my code instead of the original one?

walidon · April 22, 2014

So you use an old version of the module! try to get a new version then do the change of the code that I told you to do.

jshop1 · April 22, 2014

Nemo1: How can I turn on "Error reporting"? I had just blank screen when I open some product

Walidon: My PS version is 1.5.4.1 and I used default module for this version, when I download module for PS 1.5.6.2 and I replaced by this module I had the same problem as with Nemo = blank screen

Please do you have another advices?

Thank you

walidon · April 22, 2014

to turn error reporting on; please follow these steps:

1- Navigate to the PrestaShop 1.5 root folder.
2- From there, navigate the path /config/defines.inc.php
3- Open up the defines.inc.php file in the text editor.
4- Find the line of code that reads "define('_PS_MODE_DEV_', false)" This is line 28 by default in PrestaShop 1.5.
5- Change it to read "define('_PS_MODE_DEV_', true)".

NemoPS · April 23, 2014

Do what walidon suggested with error reporting, then paste the error screen here

jshop1 · April 23, 2014

I followed walidon steps and I add in the very end your code. The result is the same: The page is just blank, there is no message error report.

Can I give you my accesses and you can try to fix it?

Thanks

benjamin utterback · April 24, 2014

I followed walidon steps and I add in the very end your code. The result is the same: The page is just blank, there is no message error report.

Can I give you my accesses and you can try to fix it?

Thanks

There is no code you need to add. You simply need to change False to True..

Here are the steps again.

2- From there (the root folder), navigate the path /config/defines.inc.php

3- Open up the defines.inc.php file in the text editor.

4- Find the line of code that reads "define('_PS_MODE_DEV_', false)" This is line 28 by default in PrestaShop 1.5.

5- Change it to read "define('_PS_MODE_DEV_', true)".

jshop1 · April 25, 2014

Yes I did this... And then?

When I try to add comment still nothing is going to happen, I don't receive even some report.

When I follow these steps:

2- From there (the root folder), navigate the path /config/defines.inc.php
3- Open up the defines.inc.php file in the text editor.
4- Find the line of code that reads "define('_PS_MODE_DEV_', false)" This is line 28 by default in PrestaShop 1.5.
5- Change it to read "define('_PS_MODE_DEV_', true)".

What is next?

benjamin utterback · April 25, 2014

Now try and add a comment.

There is nothing there?

What is shown at the console with you press F12 and click Console

jshop1 · April 26, 2014

Yes there is nothing and I can not "click" on send button. I also made printscreen with F12 console.

jshop1 · April 26, 2014

Oh sorry and in Console, it is showing this error - see printscreen. Do you know how to fix?

jshop1 · April 29, 2014

Benjamin did you see my printscreens?

benjamin utterback · April 30, 2014

Hi! Can you check on a test product that has no special characters... test the product comments module and see if it works.

Also, try turning off friendly URL and try the comments module.

Of course, make sure to make a backup before changing any of these settings

jshop1 · May 4, 2014

Hi, what does it mean "special character"? How can I turn off friendly URL?
Thanks

NemoPS · May 5, 2014

Special characters are like accented letters, or non-unicode characters

As for friendly urls, in the back office, preferences, Seo and Urls tab Scroll down to see the option

jshop1 · May 5, 2014

Still not working :'(

jshop1 · May 5, 2014

When I add product without any special characters the result is the same. When I turn off Friendly URL, I can not open any product it is saying "This page is not available".

walidon · May 5, 2014

Hi Jshop1

have you tried this solution here

https://github.com/PrestaShop/PrestaShop/commit/9377775eca428c7022abd4bfa301ef83c8b108b8

if not try it and give result

jshop1 · May 9, 2014

Hi, thank you. I tried but it still does not working

Ron morales · June 21, 2014

]in ps 1.6.0.6 not submit a comment, defines.inc error:

Notice: Undefined index: tabs inC:\xampp\htdocs\people_presta\cache\smarty\compile\69\e1\e8\69e1e837423c7a1f93a2cf6e29380a91dae861c6.file.product.tpl.php on line 774

Notice: Trying to get property of non-object in C:\xampp\htdocs\people_presta\cache\smarty\compile\69\e1\e8\69e1e837423c7a1f93a2cf6e29380a91dae861c6.file.product.tpl.php on line 774

in local, but remote server not work, no send a comment

productcomment version:v3.3.5, in v3.3.4 not work

Edited June 21, 2014 by Ron morales (see edit history)

Ron morales · June 21, 2014

Work for me in 1.6 SOLVED, was a problem of my theme

vekia · June 21, 2014

]in ps 1.6.0.6 not submit a comment, defines.inc error:

Notice: Undefined index: tabs inC:\xampp\htdocs\people_presta\cache\smarty\compile\69\e1\e8\69e1e837423c7a1f93a2cf6e29380a91dae861c6.file.product.tpl.php on line 774

Notice: Trying to get property of non-object in C:\xampp\htdocs\people_presta\cache\smarty\compile\69\e1\e8\69e1e837423c7a1f93a2cf6e29380a91dae861c6.file.product.tpl.php on line 774

in local, but remote server not work, no send a comment

productcomment version:v3.3.5, in v3.3.4 not work

[attachment=101482:Sin título-1.jpg

cases like this one needs inspection so if it is possible please share remote url address

Ron morales · June 21, 2014

cases like this one needs inspection so if it is possible please share remote url address

my problem was solved, by changing my template that I made a mistake and corrected, work for me very thanks!

jshop1 · June 23, 2014

Which file did you edited?

Thanks

NemoPS · June 24, 2014

Which file did you edited?

Thanks

Do you have the exact same error? If so, it's product.tpl

Ron morales · July 29, 2014

can´t not a post comment, because he had changed a few lines of code to make lashes now works correctly fault was mine,

in default template and module default fine correct

Edited July 29, 2014 by Ron morales (see edit history)

patrmich · December 30, 2014

Hi,

My shop is built with Prestashop 1.5.6.2
I am using the product comment module Version 2.5.

When validating the product page for w3c, I am facing the 2 following errors :

1-
Code :
<div id="new_comment_form_error" class="error" style="display: none;">
<ul></ul>
</div>
Error :
This W3C error is related to <ul></ul>, with nothing between <ul> and </ul>.

2-
Code :
<input id="id_product_comment_send" name="id_product" type="hidden" value='785' />
"id_product_comment_send" already defined
Error :
"id_product_comment_send" already defined

The same line (<input id="id_product_comment_send" name="id_product" type="hidden" value="785" />) is included twice in the product page code :
- one time in relation to the send to a friend module
- another time in relation to the product comment module

Would you have any suggestion to solve the above errors ?

Thank you in advance for any help

Patrick

NemoPS · December 31, 2014

uls are supposed to contain li tags, I bet that's why. It's empty

The second one is the real deal. You need to make sure either of the 2 ids can be changed (ie: no javascript is bound to them). Otherwise you will break the module. Prestashop always had duplicate ids issues

patrmich · January 6, 2015

Hi Nemo1,

Thank you for your reply.

I did the following to solve the matter:

1- modules/sendtoafriend/sendtoafriend-extra.tpl

1-a

I replaced :

var id_product = $('#id_product_comment_send').val();

by

var id_product = $('#id_product_comment_sendfriend').val();

1-b

I replaced :

<input id="id_product_comment_send" name="id_product" type="hidden" value="{$stf_product->id}" /> *}

by

<input id="id_product_comment_sendfriend" name="id_product" type="hidden" value="{$stf_product->id}" />

2-themes\lytheme\modules\productcomments\productcomments.tpl

I replaced

<ul></ul

by

<ul><li></li></ul>

So, the two W3C errors were solved.

Patrick

Edited January 6, 2015 by patrmich (see edit history)

grossiste · April 3, 2016

Hello,

I have the same problem, when i click on submit button, nothing happen.

http://www.thefreeglasses.com/kids-eyewear-and-blue-light-blocker-computer-glasses/106-addison-classic-pink-circular-and-kids-spectacles.html

I thought it was because a module, i deleted it and lost 5000 of data. I really don't know know how to fix this problem. I tried for hours.. I'm very tired.

I installed Firebug, and i can see an error:

POST http://www.thefreeglasses.com/module/productcomme...d327c91fe24d834189b104ddc5919&rand=1459699093807

500 Internal Server Error

1.64s

[PrestaShopDatabaseException]

Unknown column 'bdfb' in 'where clause'

SELECT p.*, pl.params, pl.id_lang 
				FROM ps_appagebuilder p 
					LEFT JOIN ps_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=1) 
					LEFT JOIN ps_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder)
				WHERE 
					pl.id_lang=1
					AND ps.id_shop=1
					AND p.id_appagebuilder_positions IN (39,bdfb,41,42)
				ORDER BY p.id_appagebuilder


at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {
787.             $dbg = debug_backtrace();
788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790.             if ($sql) {
791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792.             }
793. 
794.             throw new PrestaShopDatabaseException($this->getMsgError());
795.         }
796.     }

    DbCore->displayError - [line 425 - classes/db/Db.php] - [1 Arguments]
    DbCore->query - [line 643 - classes/db/Db.php] - [1 Arguments]
    DbCore->executeS - [line 280 - modules/appagebuilder/classes/ApPageBuilderModel.php] - [1 Arguments]
    ApPageBuilderModel->getAllItems - [line 1371 - modules/appagebuilder/appagebuilder.php] - [3 Arguments]
    APPageBuilder->hookdisplayHeader - [line 587 - classes/Hook.php] - [1 Arguments]
    HookCore::coreCallHook - [line 542 - classes/Hook.php] - [3 Arguments]
    HookCore::exec - [line 579 - classes/controller/FrontController.php] - [1 Arguments]
    FrontControllerCore->initContent - [line 101 - classes/controller/ModuleFrontController.php]
    ModuleFrontControllerCore->initContent - [line 44 - modules/productcomments/controllers/front/default.php]
    ProductCommentsDefaultModuleFrontController->initContent - [line 189 - classes/controller/Controller.php]
    ControllerCore->run - [line 367 - classes/Dispatcher.php]
    DispatcherCore->dispatch - [line 28 - index.php]

I noticed when i delete this file: /modules/appagebuilder/appagebuilder.php I can submit a comment.

I'm really exhausted.. Do you have any idea?

NemoPS · April 6, 2016

That bdfd thing is supposed to be a number. It's not between quotes so SQL treats it as a column. You have to whether add quotes around those numbers in the function, or find out why the app builder uses that as position number

grossiste · April 8, 2016

That bdfd thing is supposed to be a number. It's not between quotes so SQL treats it as a column. You have to whether add quotes around those numbers in the function, or find out why the app builder uses that as position number

Thank you Nemo1, it helped me a lot.

VianneyYooCI · January 17, 2017

Hello, I just installed this module but I still get the same error when trying to using it, when I click the button 'Write a review' I keep getting a message error saying 'The requested content cannot be loaded, please try again later' ... I also noticed that the js files of this module won't load when I'm on a product page, how can I fix that ? (sorry, but my english isn't this good)

NemoPS · January 18, 2017

How are they not loading exactly? 404 or something else? Custom template?

VianneyYooCI · January 18, 2017

The js files doesn't appear when I check the sources (but only on the front store) , I suppose that they must be on modules > productcomments > js > [js files]

Cause when I'm on the backoffice the file 'moderate.js' load in this folder

It's like the module isn't even trying to load its js files when on the front

Also, yes it's a custom template but not from me, so I don't know much about it...

Thank you for answering !

Edited January 18, 2017 by VianneyYooCI (see edit history)

NemoPS · January 20, 2017

Try to rehook the module to displayHeader

VianneyYooCI · January 20, 2017

Sorry, but it's my first time with prestashop, how can I do that ?

NemoPS · January 21, 2017

Modules,. positions. Translplant a new hook, choose that one and set the position to displayHeader

VianneyYooCI · January 30, 2017

Ok, I've just done that but the problem is still here, do you have any other idea ?

VianneyYooCI · January 30, 2017

I switch the theme and the module works now, but I can't figure out why it isn't working on my custom theme

Edited January 30, 2017 by VianneyYooCI (see edit history)

Problem with Product Comments Module

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment