Products Review Reminder [Support Thread]

[e-standard]

I love this plugin, but when I try to install the SQL, I got the following errors and i could not find any menu for product review under configuration, please kindly help.

Error

SQL query: Documentation

SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title = 'Product\'s Review Reminder' LIMIT 1

MySQL said: Documentation
#1046 - No database selected

[Design75]

I love this plugin, but when I try to install the SQL, I got the following errors and i could not find any menu for product review under configuration, please kindly help.

Error

SQL query: Documentation

SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title = 'Product\'s Review Reminder' LIMIT 1

MySQL said: Documentation
#1046 - No database selected

Assuming you are running this command from phpmyadmin, or equal, you first need to select/open a database. In some cases when you open phpmyadmin and go straight to the run sql command, there is no database selected.

[e-standard]

Assuming you are running this command from phpmyadmin, or equal, you first need to select/open a database. In some cases when you open phpmyadmin and go straight to the run sql command, there is no database selected.

Opps,I forgot that,thanks very much. I have no idea why i could not run it from zencart admin area,it reminds me forbiden

[e-standard]

Sorry,i got one more question, if the following link is not correct: when i login website and click my account, the page goes to the main page/myreviews but the page was not found..

<li><?php echo ' <a href="/myreviews">' . MY_ACCOUNT_PRODUCT_REVIEWS . '</a>'; ?></li>

[e-standard]

Sorry,i got one more question, if the following link is not correct: when i login website and click my account, the page goes to the main page/myreviews but the page was not found..

<li><?php echo ' <a href="/myreviews">' . MY_ACCOUNT_PRODUCT_REVIEWS . '</a>'; ?></li>

I found the problem,i think

a href="/myreviews 

should be changed to

 a href=" /index.php?main_page=addon_my_reviews 

[e-standard]

I would like to take this opportunity to thanks the author for this excellent plugin, I really love it and I have been looking for it for many years, thanks for your hard work and wish your a happy new year!

I got a question, what should I do if I need customer write something when they provide the reviews, not only just click the start, I found most of the customer did not write anything for the reviews and just check the stars.

[CaroleAs]

I installed the newer version of this mod on my test site and still get issues:
- I get the same error message that "Cannot insert configuration_key "" because it already exists" "
- When checking under Configuration > Product Review Reminder, nothing is displayed.

Furthermore, I am NOT getting any log for those errors like I did previously.

I would LOVE to install that mod! What could be the issue? What could be a solution?

[swguy]

I found the problem,i think

a href="/myreviews 

should be changed to

 a href=" /index.php?main_page=addon_my_reviews 

Suggested better practice: use

<li><?php echo ' <a href="' . zen_href_link('addon_my_reviews','','SSL') . '">' . MY_ACCOUNT_PRODUCT_REVIEWS . '</a>'; ?></li>

This way if you have a test site installed in a subdirectory, it will all still work.

[e-standard]

Suggested better practice: use

<li><?php echo ' <a href="' . zen_href_link('addon_my_reviews','','SSL') . '">' . MY_ACCOUNT_PRODUCT_REVIEWS . '</a>'; ?></li>

This way if you have a test site installed in a subdirectory, it will all still work.

thanks for your information, would you please kind enough to take a look at my other question, how could I force the customer to write something when they provide the reviews, not only just click the start, I found most of the customer did not write anything for the reviews and just check the stars.

I just like the system default review,it will show

Errors have occurred during the processing of your form.

Please make the following corrections:

* * Please add a few more words to your comments. The review needs to have at least 50 characters

[e-standard]

To be specific,l think I need to do something with the following code, what could I do to achieve what I want.I need customer at least write something, even in one or word, if he did not write anything, the rating will not be posted publicly.

/* LOAD FEEDBACK */
        if( review != '' ){
            feedback  = '<span class="feedback">';
            feedback += '<span class="feedback-pending">Pending review.</span> ' + name + ' | ';
        }else{
            feedback  = '<span class="feedback">';
            feedback += '<span class="feedback-posted">✔ posted publicly as</span> ' + name + ' | ';
        }
        
        feedback += '<span onclick="change_rating(' + pid + ');" class="clear-rating" id="change-' + pid + '">Change</span>';
        feedback += '</span>';
        
        /* ENFORCE MINIMUM CHARACTERS IN REVIEW */
<?php
    $min_length = 0;
    $short_review_message = '';
    $sql = "SELECT `configuration_value`
            FROM `" . TABLE_CONFIGURATION . "`
            WHERE `configuration_key` = 'REVIEW_TEXT_MIN_LENGTH'";
    $rec = $db->Execute($sql);
    if(!$rec->EOF){
        $min_length = $rec->fields['configuration_value'];
        $short_review_message = sprintf(SHORT_REVIEW_MESSAGE, $min_length);
    }
?>
        var short_review_message = '<?php echo $short_review_message; ?>';
        if( review.length > 0 ){
            if( review.length < <?php echo $min_length; ?> && short_review_message != '' ){
                alert( short_review_message );
                return;
            }