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 Code:

---

    define('TABLE_ADDON_REVIEW_REMINDER_LOG','addon_review_reminder_log');
    define('TABLE_ADDON_REVIEW_REMINDER_OPTOUT','addon_review_reminder_optout'); 


---

are missing the DB_PREFIX code. Should be:

PHP Code:

---

define('TABLE_ADDON_REVIEW_REMINDER_LOG', DB_PREFIX . 'addon_review_reminder_log');
    define('TABLE_ADDON_REVIEW_REMINDER_OPTOUT', DB_PREFIX . 'addon_review_reminder_optout'); 


---

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
Database: 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.

Quote:

---

Originally Posted by 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:

Code:

---

[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:

Code:

---

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!