Products Review Reminder [Support Thread]

With this plugin: https://www.zen-cart.com/downloads.php?do=file&id=2148

In the file C:\Users\Andrew\Downloads\products_review_reminder.1\products_review_reminder.1\catalog\shizzle\includes\extra_datafiles\addon_review_reminder.php

lines 10-11:
[PHP] define('TABLE_ADDON_REVIEW_REMINDER_LOG','addon_review_reminder_log');
define('TABLE_ADDON_REVIEW_REMINDER_OPTOUT','addon_review_reminder_optout');
[/PHP]

are missing the DB_PREFIX code. Should be:
[PHP]
define('TABLE_ADDON_REVIEW_REMINDER_LOG', DB_PREFIX . 'addon_review_reminder_log');
define('TABLE_ADDON_REVIEW_REMINDER_OPTOUT', DB_PREFIX . 'addon_review_reminder_optout');
[/PHP]

Has the author been contacted about the issue to support updating?

I PM'ed them.

CREATE TABLE IF NOT EXISTS `addon_review_reminder_log` (
`orders_id` int(11) NOT NULL,
`date_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`sent_by` varchar(16) NOT NULL DEFAULT 'web',
PRIMARY KEY (`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `addon_review_reminder_optout` (
`customers_id` int(11) NOT NULL,
`orders_id` int(11) NOT NULL,
`date_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

the 2 lines in red above are supported in
[B]Database:[/B] MySQL 5.5.5

Is there a work around ?

Posting here because I tried installing this mod on my test site and I encountered issues:

When running the SQL file, I got messages (4 of them) that " ERROR: Cannot insert configuration_key "" because it already exists"

When checking under Configuration > Product Review Reminder, nothing is displayed.

When checking Tools > Product Review Reminder, I have the message that "WARNING: An Error occurred, please refresh the page and try again."

So it seems to me that it is only partially installed. Is it because of the bugs mentioned above or an installation error on my part? I don't know.

CaroleAs:

Posting here because I tried installing this mod on my test site and I encountered issues:

When running the SQL file, I got messages (4 of them) that " ERROR: Cannot insert configuration_key "" because it already exists"

When checking under Configuration > Product Review Reminder, nothing is displayed.

When checking Tools > Product Review Reminder, I have the message that "WARNING: An Error occurred, please refresh the page and try again."

So it seems to me that it is only partially installed. Is it because of the bugs mentioned above or an installation error on my part? I don't know.

Similar issue here. When running the SQL install file, I get "WARNING: An Error occurred, please refresh the page and try again."

Under Configuration > Product Review Reminder, I DO get all of the editables.

However, under Tools > Product Review Reminder, I also get the "WARNING: An Error occurred, please refresh the page and try again."

I checked the addon_review_reminder.php as mentioned above, but mine is already including the DB_PREFIX codes.

When you get that error is an error log also created that you can copy and paste here?

I am getting this error in the log:

[29-Oct-2017 16:07:38 America/New_York] Request URI: /test4store/xxxxxx/addon_review_reminder.php, IP address: 142.167.45.240
#1  trigger_error() called at [/home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php:167]
#2  queryFactory->show_error() called at [/home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php:139]
#3  queryFactory->set_error() called at [/home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php:266]
#4  queryFactory->Execute() called at [/home/creat419/public_html/creationcassel.com/test4store/xxxxxx/addon_review_reminder.php:344]

[29-Oct-2017 16:07:38 America/New_York] PHP Fatal error:  1146:Table 'creat419_test4.addon_review_reminder_optout' doesn't exist :: SELECT DISTINCT o.`orders_id` AS oid,
				o.`customers_id`,
				DATE_FORMAT(o.`date_purchased`,'%m/%d/%y') AS date, 
				os.`orders_status_name` AS status,
				o.`customers_name` AS customer,
				o.`customers_company` AS company,
				osh.`date_added`
			FROM `zen_orders` AS o
				LEFT JOIN `zen_orders_status` AS os 
					ON o.`orders_status` = os.`orders_status_id`
				LEFT JOIN `zen_customers` AS c
					ON o.`customers_id` = c.`customers_id`
				LEFT JOIN `zen_orders_status_history` AS osh
					ON (o.`orders_id` = osh.`orders_id` 
						AND osh.`orders_status_id` = '')
			WHERE osh.`date_added` > '1969-12-31'
				AND osh.`date_added` < '1969-12-31 23:59:59'
				AND o.`orders_status` = ''
				AND o.`customers_id` NOT IN (
					SELECT `customers_id` 
					FROM `addon_review_reminder_optout`
				)
				AND o.`orders_id` NOT IN (
					SELECT `orders_id`
					FROM `addon_review_reminder_log`
				)
			GROUP BY o.`orders_id`
			ORDER BY o.`orders_id` DESC ==> (as called by) /home/creat419/public_html/creationcassel.com/test4store/xxxx/addon_review_reminder.php on line 344 <== in /home/creat419/public_html/creationcassel.com/test4store/includes/classes/db/mysql/query_factory.php on line 167

I x'ed out the admin folder.

I've got the plugin working , but what I would like to know, is if there is a centralized file or location where reviews that we receive back are saved to. It would be nice to be able to go back and view specific responses, without having to dig through our email archives.

Some DBMS do not recognize the CURRENT_TIMESTAMP I am using as a default value for the date_time attribute on both the addon_review_reminder_log AND addon_review_reminder_optout relations (tables). As a result, none of the two required tables are created when users run the install.sql file.
To fix that problem, just delete the DEFAULT CURRENT_TIMESTAMP on both CREATE TABLE commands before you execute the install.sql file. Or, if the plugin is already installed and those tables are still missing, just copy and paste the following into your Admin: Tools > Install SQL Patches:

CREATE TABLE IF NOT EXISTS addon_review_reminder_log (
`orders_id` int(11) NOT NULL,
`date_time` datetime NOT NULL,
`sent_by` varchar(16) NOT NULL DEFAULT 'web',
PRIMARY KEY (`orders_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS addon_review_reminder_optout (
`customers_id` int(11) NOT NULL,
`orders_id` int(11) NOT NULL,
`date_time` datetime NOT NULL,
PRIMARY KEY (`customers_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

If Zen Cart prompts you with a "2 statements processed", you should be good to go.
I am submitting a new version of that plugin, only updating the install.sql file, to address that problem.
Thank you for your feedback!

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

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

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.

Design75:

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

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 [PHP]a href="/myreviews[/PHP] should be changed to[PHP] a href=" /index.php?main_page=addon_my_reviews[/PHP]

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?

e-standard:

I found the problem,i think [PHP]a href="/myreviews[/PHP] should be changed to[PHP] a href=" /index.php?main_page=addon_my_reviews[/PHP]

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.

swguy:

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

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]/* 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;
}[/PHP]