Products Review Reminder [Support Thread]

[lindasdd]

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:

    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:

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

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

[wvasconcelos]

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!

[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