Printable View
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.Quote:
Originally Posted by e-standard
Opps,I forgot that,thanks very much. I have no idea why i could not run it from zencart admin area,it reminds me forbidenQuote:
Originally Posted by Design75
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 thinkQuote:
Originally Posted by e-standard
should be changed toPHP Code:a href="/myreviews
PHP Code:a href=" /index.php?main_page=addon_my_reviews
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.
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?
Suggested better practice: useQuote:
Originally Posted by e-standard
<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.Quote:
Originally Posted by swguy
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
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.
PHP Code:/* 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;
}