-
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');
-
Re: Products Review Reminder - Bugs
Has the author been contacted about the issue to support updating?
-
Re: Products Review Reminder - Bugs
-
Re: Products Review Reminder - Bugs
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 ?
-
Re: Products Review Reminder - Bugs
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.
-
Re: Products Review Reminder - Bugs
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.
-
Re: Products Review Reminder - Bugs
When you get that error is an error log also created that you can copy and paste here?
-
Re: Products Review Reminder - Bugs
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.
-
Re: Products Review Reminder - Bugs
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.
-
Re: Products Review Reminder [Support Thread]
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!
-
Re: Products Review Reminder [Support Thread]
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
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
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.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
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
-
Re: Products Review Reminder [Support Thread]
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>
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
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 Code:
a href="/myreviews
should be changed to
PHP Code:
a href=" /index.php?main_page=addon_my_reviews
-
Re: Products Review Reminder [Support Thread]
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.
-
Re: Products Review Reminder [Support Thread]
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?
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
e-standard
I found the problem,i think
PHP Code:
a href="/myreviews
should be changed to
PHP Code:
a href=" /index.php?main_page=addon_my_reviews
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.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
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
-
Re: Products Review Reminder [Support Thread]
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;
}
-
Re: Products Review Reminder [Support Thread]
Just go to admin->configuration->minimum values, and set Product Review Text to some value > 0. (Maybe 20 or so.)
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
swguy
Just go to admin->configuration->minimum values, and set Product Review Text to some value > 0. (Maybe 20 or so.)
Thanks for the reply, Let me explain in details for the question I have, what I mean is when a customer login website and go to review area, if he just simply clicks the stars and does not wite any review words,it will show the review have been published publicly as...
The bad thing is the review will show active at the admin area of ZenCart, what I want is review should not be published publicly when the customer or the visitor just simply click the start without wirting any review words.How should i force them at least write something in order to complete the review,Thanks very much for your help.
-
Re: Products Review Reminder [Support Thread]
Do you have admin-configuration-product info-Product Reviews Require Approval set to 1?
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
swguy
Do you have admin-configuration-product info-Product Reviews Require Approval set to 1?
Yes.That have been set as 1
-
Re: Products Review Reminder [Support Thread]
If they just click the stars and don't press submit (which they can't do successfully until they enter a certain number of characters, assuming you have set the minimum as I suggested a couple of posts back), the review won't show up. (If it does, you have some sort of modified template that doesn't work correctly.)
-
1 Attachment(s)
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
swguy
If they just click the stars and don't press submit (which they can't do successfully until they enter a certain number of characters, assuming you have set the minimum as I suggested a couple of posts back), the review won't show up. (If it does, you have some sort of modified template that doesn't work correctly.)
Thanks,i will do a test on a new fresh site,the strange thing is the product page have it's own review page,when you click the stars,it will not published..
Attachment 17617
-
3 Attachment(s)
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
swguy
If they just click the stars and don't press submit (which they can't do successfully until they enter a certain number of characters, assuming you have set the minimum as I suggested a couple of posts back), the review won't show up. (If it does, you have some sort of modified template that doesn't work correctly.)
I have tested on a fresh new site,zencart 1.5.5f with this this plugin installed,when customer click the star,it will show "✔ posted publicly as..."
Attachment 17621
It will become active at the admin area.
Attachment 17622
Attachment 17623
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
swguy
If they just click the stars and don't press submit (which they can't do successfully until they enter a certain number of characters, assuming you have set the minimum as I suggested a couple of posts back), the review won't show up. (If it does, you have some sort of modified template that doesn't work correctly.)
I am having the same issue with this plugin. The behaviour you are describing is for the default review page that comes with Zen Cart. With this addon, as has previously been mentioned by clicking any stars the review is automatically submitted, bypassing minimum review length and approval. Those only come into play after you start typing into the text field, at which time the submit button then becomes visible.
Any thoughts on how to fix this?
-
Re: Products Review Reminder [Support Thread]
@wvasconcelos responded to a message I sent in regards to this issue.
Quote:
1. Open the following file in a text editor (e.g. Notepad++, Nano, VIM, etc.):
\includes\modules\pages\addon_my_reviews\jscript_main.php
2. Add the following on line 114 (before /* SHOW RESULTS */):
if( review.length < <?php echo $min_length; ?> ){ $("#" + pid + '-review').css("display","block"); return; }
That line will:
1. Stop the execution of the JavaScript function before it sends the rating to the database;
2. Prevent the display of the "posted publicly as ..." message;
3. Trigger the display of the textbox to allow the user to write a review.
-
Re: Products Review Reminder [Support Thread]
v1.5.5f
Hi - I am interested in using this plugin and have read this support thread and the ReadMe for it but have a particular question;
Q ... currently contacting customers manually if the product is out of stock I have to make the product 'sold out', i.e. in product details page select qty 1 and 'out of stock', so that the link to the product given to the customer is 'live', i.e. the product page is still active, otherwise they get the 404 page ..... does this plugin override the need for this, i.e. does the link provided to the customer go directly to the review response page? (we sell a lot of 'one off' products).
many thanks,
Mike
-
1 Attachment(s)
Re: Products Review Reminder [Support Thread]
Hello,
My shop is installed in a subfolder, so to make this plugin works it needs some adjustments
I have made it work but there is still one thing i cant find
Where can i change the link of the images in the email?
Now it is linked to includes/templates/my-template/images/rating_star.png but it needs to link at the subfolder shop/includes/templates/my-template/images/rating_star.png and i cant find it where to change this
Attachment 18190
One more thing, are the emails send automatically at the set time to the clients or do i need to send this manually from admin?
Thanks
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
KGL Racing
Hello,
My shop is installed in a subfolder, so to make this plugin works it needs some adjustments
I have made it work but there is still one thing i cant find
Where can i change the link of the images in the email?
Now it is linked to includes/templates/my-template/images/rating_star.png but it needs to link at the subfolder
shop/includes/templates/my-template/images/rating_star.png and i cant find it where to change this
Attachment 18190
One more thing, are the emails send automatically at the set time to the clients or do i need to send this manually from admin?
Thanks
What has been done (or needed) to "make it work" to support an install to a sub-dorectory?
-
Re: Products Review Reminder [Support Thread]
In several files you will find this code, so here i added /shop to make it work
define('EMAIL_REMINDER_SUBJECT',', how would you rate your recent order at ' . STORE_NAME . '?');
define('EMAIL_REMINDER_ITEM_TITLE', 'How did this item meet your expectations?');
define('EMAIL_REMINDER_ITEMS_TITLE','How did those items meet your expectations?');
define('EMAIL_REMINDER_START_RATING','Start by rating it');
define('EMAIL_REMINDER_REVIEW_PURCHASES_TITLE','Review your purchases');
define('EMAIL_REMINDER_REVIEW_PURCHASES_DESCRIPTION','Check out <a href="' . HTTPS_SERVER . '/shop/index.php?main_page=addon_my_reviews">' . HTTPS_SERVER . '/shop/index.php?main_page=addon_my_reviews</a> to find past purchases to review.');
Just found an other problem
My site is set to full https in the config file
define('HTTP_SERVER', 'https://kglracing.com');
define('HTTPS_SERVER', 'https://kglracing.com');
When i click the link start by rating it in the Review your purchases email it gets me to the http page instead of the https, what brakes the link and make it land on the account page instead of the review page.
So where can i change this also?
-
Re: Products Review Reminder [Support Thread]
Unfortunately neither is really right.
Ideally the define would be used in an sprintf function call where the link would be generated using zen_href_link called to ensure not to add the session id. But if going to edit just this area of code, then it should include the applicable DIR_WS_CATALOG like constant as well. Generally speaking that would be like this:
Code:
define('EMAIL_REMINDER_REVIEW_PURCHASES_DESCRIPTION','Check out <a href="' . HTTP_SERVER . DIR_WS_CATALOG . 'index.php?main_page=addon_my_reviews">' . HTTP_SERVER . DIR_WS_CATALOG . 'index.php?main_page=addon_my_reviews</a> to find past purchases to review.');
As to landing on the account page, likely because to provide a review, the individual needs to be logged in to provide a review. Otherwise any bot could rate the product and you'd have to go through and weed things out.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
mc12345678
Unfortunately neither is really right.
Ideally the define would be used in an sprintf function call where the link would be generated using zen_href_link called to ensure not to add the session id. But if going to edit just this area of code, then it should include the applicable DIR_WS_CATALOG like constant as well. Generally speaking that would be like this:
Code:
define('EMAIL_REMINDER_REVIEW_PURCHASES_DESCRIPTION','Check out <a href="' . HTTP_SERVER . DIR_WS_CATALOG . 'index.php?main_page=addon_my_reviews">' . HTTP_SERVER . DIR_WS_CATALOG . 'index.php?main_page=addon_my_reviews</a> to find past purchases to review.');
As to landing on the account page, likely because to provide a review, the individual needs to be logged in to provide a review. Otherwise any bot could rate the product and you'd have to go through and weed things out.
Just found it to get the link working in HTTPS
In the admin/addon_review_reminder.php
line 560 change this HTTP_CATALOG_SERVER to HTTPS_CATALOG_SERVER
and the link opens in https
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
KGL Racing
Just found it to get the link working in HTTPS
In the admin/addon_review_reminder.php
line 560 change this HTTP_CATALOG_SERVER to HTTPS_CATALOG_SERVER
and the link opens in https
Sure, but if your site with SSL were setup using: https://www.zen-cart.com/content.php...alled-zen-cart then the two would be the same and there would not be a discrepancy like described. For other readers, note that HTTP_CATALOG_SERVER and HTTPS_CATALOG_SERVER are both admin side defines.
-
1 Attachment(s)
Re: Products Review Reminder [Support Thread]
Quote:
My shop is installed in a subfolder, so to make this plugin works it needs some adjustments
I have made it work but there is still one thing i cant find
Where can i change the link of the images in the email?
Now it is linked to includes/templates/my-template/images/rating_star.png but it needs to link at the subfolder shop/includes/templates/my-template/images/rating_star.png and i cant find it where to change this
Ok so, I have checked all of the files in this plug in and there appears to be some lines missing in the includes/languages/english/addon_review_reminder.php
It does not define the location of the website, product image, or the rating star pictures. So when the email arrives it looks like this:
Attachment 18247
And if they attempt to click on the image areas as previously circled above it leads to a page not found error as there is no zen_href_link generated and nothing to define the images. I hope what I just said makes sense.
The file where the problem lies is here:
Code:
<?php
/**
* @package addon_review_reminder
* @copyright Copyright 2003-2017 Zen Cart Development Team
* @copyright Portions Copyright 2003 osCommerce
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: addon_my_reviews.php 2017-07-12 08:00 v.1.0 $
* @author Will Vasconcelos [email protected] $
*/
define('EMAIL_REMINDER_SUBJECT',', how would you rate your recent order at ' . STORE_NAME . '?');
define('EMAIL_REMINDER_ITEM_TITLE', 'How did this item meet your expectations?');
define('EMAIL_REMINDER_ITEMS_TITLE','How did those items meet your expectations?');
define('EMAIL_REMINDER_START_RATING','Start by rating it');
somthing is missing in this area: the links and images are not defined in the email
define('EMAIL_REMINDER_REVIEW_PURCHASES_TITLE','Review your purchases');
define('EMAIL_REMINDER_REVIEW_PURCHASES_DESCRIPTION','Check out <a href="' . HTTPS_SERVER . '/index.php?main_page=addon_my_reviews">' . HTTPS_SERVER . '/index.php?main_page=addon_my_reviews</a> to find past purchases to review.');
define('EMAIL_REMINDER_DISCLAIMER','We hope you found this message to be useful. If you would rather not receive future e-mails of this sort from <a href="' . HTTPS_SERVER . '/">' . HTTPS_SERVER . '</a>, please opt-out <a href="' . HTTPS_SERVER . '/index.php?main_page=addon_reviews_reminder_optout&e=%s">here</a>.');
// standard email disclaimers
define('EMAIL_DISCLAIMER', 'This email address was given to us by you or by one of our customers. If you feel that you have received this email in error, please send an email to %s ');
define('EMAIL_SPAM_DISCLAIMER','This email is sent in accordance with the US CAN-SPAM Law in effect 01/01/2004. Removal requests can be sent to this address and will be honored and respected.');
define('EMAIL_FOOTER_COPYRIGHT','Copyright (c) ' . date('Y') . ' <a href="' . HTTPS_SERVER . '" target="_blank">' . HTTPS_SERVER . '</a>.'."\n" . STORE_NAME_ADDRESS . "\n" . STORE_TELEPHONE_CUSTSERVICE . "\n" . 'Powered by <a href="' . HTTPS_SERVER . '" target="_blank">' . STORE_NAME . '</a>');
// email advisory for all emails customer generate
define('EMAIL_ADVISORY', '-----' . "\n" . '<strong>IMPORTANT:</strong> For your protection and to prevent malicious use, all emails sent via this web site are logged and the contents recorded and available to the store owner. If you feel that you have received this email in error, please send an email to ' . STORE_OWNER_EMAIL_ADDRESS . "\n\n");
-
Re: Products Review Reminder [Support Thread]
Building links like this:
'<a href="' . HTTPS_SERVER . '/index.php?main_page=addon_my_reviews">' ...
is wrong because it doesn't account for a subdirectory. Using zen_href_link solves this problem.
'<a href="' . zen_href_link('addon_my_reviews', '','NONSSL') . '">' ....
-
Re: Products Review Reminder [Support Thread]
The concept of this plug-in is great, however there are some flaws which need to be worked out in the connection between the actual email the customer receives and the addon_my_reviews.php (that is just my non-technical deduction after trying to make it work), I think there needs to be some more testing done, and with a few tweeks it will be even better. I look forward to the future outcome of this.
-
Re: Products Review Reminder [Support Thread]
Got PHP error for higher PHP,such as PHP 7.3.7.2,but there is no such error for PHP 7.0,anyone know how to fix this?
addon_review_reminder.php,
--> PHP Warning: Use of undefined constant IMAGE_REMOVE - assumed 'IMAGE_REMOVE' (this will throw an Error in a future version of PHP) in /home/adm/addon_review_reminder.php on line 421.
-
Re: Products Review Reminder [Support Thread]
Has there been a "revised" version of this mod? I would like to install it but reading through this thread, I am not sure if it works if installed as is.
-
Re: Products Review Reminder [Support Thread]
Still no update on this plugin?
-
Re: Products Review Reminder [Support Thread]
I just found this plug-in and really like it - except for the bugs that have been noted above. I did get it to work fully for my site by making some adjustments. Because our catalog is in a sub-folder /store/ from the root, i had to add that in a couple places. My style is definitely not 'Grade A' php coding, but it works.
File /admin/addon_review_reminder.php
1. Line 176: Added /store to: $template_images_folder = HTTP_CATALOG_SERVER . '/store/' . DIR_WS_TEMPLATES . $template_dir . '/images/
2. Line 560: Added /store to: $review_page_link = HTTP_CATALOG_SERVER . '/store/index.php?main_page=addon_my_reviews&pid=' . $rec->fields['products_id'];
3. Line 554: change ‘width=460’ to ‘width = 95%’ --- the entire email formatted better on my particular theme styling.
Also, i added a section to allow the customers to link to Google, FB and Trustpilot reviews from the same email. In /email/email_template_addon-review-reminder.html, around line 43, just after the </tr> for the 'check our your reviews...' table row, i added
Code:
<!-- BOF Company Review Links Added March 2021 -->
<tr>
<td>
<div style="line-height:15px;font-size:15px"> </div>
<div style="font-size:18px;color:#e47911;font-family:arial,helvetica,verdana,sans-serif">
Review YOUR COMPANY.
</div>
</td>
</tr>
<tr>
<td>
<div style="line-height:15px; font-size:7px"> </div>
<div style="font-size:14px; color:#333333; margin-right:37px; text-decoration:none; font-family:arial,helvetica,verdana,sans-serif;">
Leave a <a href="https://www.trustpilot.com/review/MODIFY URL HERE" style="text-decoration:none; color:124c90; font-size:14px;" target="_blank">TrustPilot</a> review.
</div>
<div style="font-size:14px; color:#333333; margin-right:37px; text-decoration:none; font-family:arial,helvetica,verdana,sans-serif;">
Leave a <a href="https://www.google.com/MODIFY URL HERE" style="text-decoration:none; color:124c90; font-size:14px;" target="_blank">Google</a> review.
</div>
<div style="font-size:14px; color:#333333; margin-right:37px; text-decoration:none; font-family:arial,helvetica,verdana,sans-serif;">
Leave a <a href="https://www.facebook.com/MODIFY URL HERE" style="text-decoration:none; color:124c90; font-size:14px;" target="_blank">Facebook</a> review.
</div>
</td>
</tr>
<!-- EOF Company Review Links March 2021 -->
Again, i know that pure coders will not add so much raw text, but build it into the /english/ definitions files, so there's of room for someone to improve on this.
Hope it helps.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
apollowilcox
I just found this plug-in and really like it - except for the bugs that have been noted above. I did get it to work fully for my site by making some adjustments. Because our catalog is in a sub-folder /store/ from the root, i had to add that in a couple places. My style is definitely not 'Grade A' php coding, but it works.
I'm interested in the TrustPilot additions. TrustPilot is telling my client that they need the sale info, delivered either in a BCC email or using JSON. Do you have that in place so that they are automatically receiving the data from your cart?
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
delia
I'm interested in the TrustPilot additions. TrustPilot is telling my client that they need the sale info, delivered either in a BCC email or using JSON. Do you have that in place so that they are automatically receiving the data from your cart?
The link we provide customers is the link to our Trustpilot page, which offers the user the opportunity to add a review (https://www.trustpilot.com/review/www.apollocaster.com).
-
Re: Products Review Reminder [Support Thread]
-
Re: Products Review Reminder [Support Thread]
This plugin is an orphan - if some kind person would be willing to adopt it and give it a refresh, that would be great.
ROOKIE DEVELOPERS: this is an opportunity for you to build some skills that will make you money.
-
Re: Products Review Reminder [Support Thread]
ZC 1.5.8a
php 7.4
v 1.0.3 test result (error log, real IP address and admin folder name are masked):
Quote:
Request URI: /YOUR_ADMIN/index.php?cmd=addon_review_reminder, IP address: xxx.xxx.xxx.xxx, Language id 1
#1 require(/YOUR_ADMIN/addon_review_reminder.php) called at [/YOUR_ADMIN/index.php:11]
--> PHP Warning: Use of undefined constant IMAGE_REMOVE - assumed 'IMAGE_REMOVE' (this will throw an Error in a future version of PHP) in /YOUR_ADMIN/addon_review_reminder.php on line 423.
-
Re: Products Review Reminder [Support Thread]
Update:
I tested v1.0.3 with php 8.0 and 8.1, and got the similar results.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
siliconbug
Update:
I tested v1.0.3 with php 8.0 and 8.1, and got the similar results.
For your old version you should try Version: 1.0.2
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
mprough
For your old version you should try Version: 1.0.2
v1.0.2 comes with the same error as @e-standard mentioned:
Quote:
Originally Posted by
e-standard
Got PHP error for higher PHP,such as PHP 7.3.7.2,but there is no such error for PHP 7.0,anyone know how to fix this?
addon_review_reminder.php,
--> PHP Warning: Use of undefined constant IMAGE_REMOVE - assumed 'IMAGE_REMOVE' (this will throw an Error in a future version of PHP) in /home/adm/addon_review_reminder.php on line 421.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
siliconbug
v1.0.2 comes with the same error as @e-standard mentioned:
just to make it easy, i would change the IMAGE_REMOVE to 'remove'. ie:
PHP Code:
//from
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', IMAGE_REMOVE, 'id="btnRemove"') . '</a>' . "\n";
//to
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', 'remove', 'id="btnRemove"') . '</a>' . "\n";
v1.0.3 also makes use of `zen_image_submit` which looks deprecated as of zc v1.5.8.
-
Re: Products Review Reminder [Support Thread]
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
siliconbug
It works, thanks!
:thumbsup:
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
carlwhat
just to make it easy, i would change the IMAGE_REMOVE to 'remove'. ie:
PHP Code:
//from
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', IMAGE_REMOVE, 'id="btnRemove"') . '</a>' . "\n";
//to
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', 'remove', 'id="btnRemove"') . '</a>' . "\n";
v1.0.3 also makes use of `zen_image_submit` which looks deprecated as of zc v1.5.8.
zen_image_submit is in a bunch of core files like (includes/functions/html_output.php) for example. It's in bootstrap also.
In any case I have made this change & resubmitted.
Thanks Carl =)
-
Re: Products Review Reminder [Support Thread]
How do some similar modules allow customer to login via the link supplied in the email reminder? Without them having to put their password in, its already logged in and ready to put review. Just wondering.
-
Re: Products Review Reminder [Support Thread]
What changes need to be made so customer don't have to login to leave review as some customers use guest checkout.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
get2go
What changes need to be made so customer don't have to login to leave review as some customers use guest checkout.
This plugin has no such controls. You will need to find a plugin or code for this. What version are you running?
-
Re: Products Review Reminder [Support Thread]
ZC 2.01
PhP 8.3
i am getting the following error log when accessing tools->product review reminder
Code:
[24-Nov-2024 17:53:56 America/Los_Angeles] Request URI: /sweety/index.php?cmd=addon_review_reminder, IP address: 24.4.88.128, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /sweety/includes/header.php(71): trigger_error()
#2 /sweety/addon_review_reminder.php(291): require('/home/zch1akhw6...')
#3 /sweety/index.php(16): require('/home/zch1akhw6...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in /sweety/includes/header.php on line 71.
[24-Nov-2024 17:53:56 America/Los_Angeles] PHP Fatal error: Uncaught Error: Undefined constant "remove" in /sweety/addon_review_reminder.php:423
Stack trace:
#0 /sweety/index.php(16): require()
#1 {main}
thrown in /sweety/addon_review_reminder.php on line 423
[24-Nov-2024 17:53:56 America/Los_Angeles] Request URI: /sweety/index.php?cmd=addon_review_reminder, IP address: 24.4.88.128
--> PHP Fatal error: Uncaught Error: Undefined constant "remove" in /sweety/addon_review_reminder.php:423
Stack trace:
#0 /sweety/index.php(16): require()
#1 {main}
thrown in /sweety/addon_review_reminder.php on line 423.
[24-Nov-2024 17:53:56 America/Los_Angeles] Request URI: /sweety/index.php?cmd=addon_review_reminder, IP address: 24.4.88.128
--> PHP Fatal error: Uncaught Error: Undefined constant "remove" in /sweety/addon_review_reminder.php:423
Stack trace:
#0 /sweety/index.php(16): require()
#1 {main}
thrown in /sweety/addon_review_reminder.php on line 423.
Should I revert 'remove' to IMAGE_REMOVE ? which would be the opposite of post# 52
Thank you
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
nicksab
ZC 2.01
PhP 8.3
i am getting the following error log when accessing tools->product review reminder
Code:
[24-Nov-2024 17:53:56 America/Los_Angeles] Request URI: /sweety/index.php?cmd=addon_review_reminder, IP address: 24.4.88.128, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /sweety/includes/header.php(71): trigger_error()
#2 /sweety/addon_review_reminder.php(291): require('/home/zch1akhw6...')
#3 /sweety/index.php(16): require('/home/zch1akhw6...')
--> PHP Deprecated: This page requires updates for the next Zen Cart version. Please refer your site developer or plugin author to <a href="https://docs.zen-cart.com/dev/plugins/admin_head_content/" rel="noopener noreferrer" target="_blank">this</a> documentation. in /sweety/includes/header.php on line 71.
[24-Nov-2024 17:53:56 America/Los_Angeles] PHP Fatal error: Uncaught Error: Undefined constant "remove" in /sweety/addon_review_reminder.php:423
Stack trace:
#0 /sweety/index.php(16): require()
#1 {main}
thrown in /sweety/addon_review_reminder.php on line 423
[24-Nov-2024 17:53:56 America/Los_Angeles] Request URI: /sweety/index.php?cmd=addon_review_reminder, IP address: 24.4.88.128
--> PHP Fatal error: Uncaught Error: Undefined constant "remove" in /sweety/addon_review_reminder.php:423
Stack trace:
#0 /sweety/index.php(16): require()
#1 {main}
thrown in /sweety/addon_review_reminder.php on line 423.
[24-Nov-2024 17:53:56 America/Los_Angeles] Request URI: /sweety/index.php?cmd=addon_review_reminder, IP address: 24.4.88.128
--> PHP Fatal error: Uncaught Error: Undefined constant "remove" in /sweety/addon_review_reminder.php:423
Stack trace:
#0 /sweety/index.php(16): require()
#1 {main}
thrown in /sweety/addon_review_reminder.php on line 423.
Should I revert 'remove' to IMAGE_REMOVE ? which would be the opposite of post# 52
Thank you
apparently my fix was not done properly. change:
PHP Code:
//from
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', remove, 'id="btnRemove"') . '</a>' . "\n";
//to
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', 'remove', 'id="btnRemove"') . '</a>' . "\n";
notice the single quotes around the word remove.
best.
-
Re: Products Review Reminder [Support Thread]
Quote:
Originally Posted by
carlwhat
apparently my fix was not done properly. change:
PHP Code:
//from
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', remove, 'id="btnRemove"') . '</a>' . "\n";
//to
echo '<a href="' . FILENAME_ADDON_REVIEW_REMINDER . '.php?oid=' . $selected_order_id . '&action=remove">' . zen_image_submit('button_remove.gif', 'remove', 'id="btnRemove"') . '</a>' . "\n";
notice the single quotes around the word remove.
best.
as always thank you for the assist.
