Page 1 of 5 123 ... LastLast
Results 1 to 10 of 41
  1. #1
    Join Date
    Jun 2007
    Posts
    438
    Plugin Contributions
    0

    Default 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'); 

  2. #2
    Join Date
    Jul 2012
    Posts
    15,022
    Plugin Contributions
    17

    Default Re: Products Review Reminder - Bugs

    Has the author been contacted about the issue to support updating?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  3. #3
    Join Date
    Jun 2007
    Posts
    438
    Plugin Contributions
    0

    Default Re: Products Review Reminder - Bugs

    I PM'ed them.

  4. #4
    Join Date
    Feb 2007
    Posts
    218
    Plugin Contributions
    0

    Default 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 ?

  5. #5
    Join Date
    Feb 2009
    Posts
    747
    Plugin Contributions
    0

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

  6. #6
    Join Date
    Nov 2017
    Location
    Athens, Georgia, USA
    Posts
    99
    Plugin Contributions
    0

    Default Re: Products Review Reminder - Bugs

    Quote Originally Posted by CaroleAs View Post
    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.
    Last edited by Lordzoabar; 4 Nov 2017 at 06:34 PM.

  7. #7
    Join Date
    Jun 2007
    Posts
    438
    Plugin Contributions
    0

    Default Re: Products Review Reminder - Bugs

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

  8. #8
    Join Date
    Feb 2009
    Posts
    747
    Plugin Contributions
    0

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

  9. #9
    Join Date
    Nov 2017
    Location
    Athens, Georgia, USA
    Posts
    99
    Plugin Contributions
    0

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

  10. #10
    Join Date
    Jan 2008
    Location
    San Diego, CA - USA
    Posts
    7
    Plugin Contributions
    14

    Default 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!
    - WDV -

 

 
Page 1 of 5 123 ... LastLast

Similar Threads

  1. v139a Problems with mailbeez review reminder module
    By zbdblues in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 10 Nov 2012, 03:45 PM
  2. Aftersales Email Module: Review Reminder
    By BeautyHealth.com.cy in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 27 Jul 2010, 12:00 AM
  3. Review reminder
    By raphaelsewing in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 18 Mar 2008, 06:17 PM
  4. Auto/Manual Email for Review Reminder?
    By cpjfox in forum Managing Customers and Orders
    Replies: 1
    Last Post: 13 Mar 2008, 04:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR