Products Review Reminder [Support Thread]

[mc12345678]

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

[lindasdd]

I PM'ed them.

[TamyA]

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 ?

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

[Lordzoabar]

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.

[lindasdd]

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

[CaroleAs]

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.