envisionocity:
I'm having a similar issue to Peter. If I try to upload the SQL via Zen Cart, I get the following report:
1062 Duplicate entry 'RCS_BASE_DAYS' for key 'unq_config_key_zen'
in:
[INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Look back days', 'RCS_BASE_DAYS', '30', 'Number of days to look back from today for abandoned cards.', @configuration_group_id, 10, NULL, NOW(), NULL, NULL), (NULL, 'Sales Results Report days', 'RCS_REPORT_DAYS', '90', 'Number of days the sales results report takes into account. The more days the longer the SQL queries!.', @configuration_group_id, 15, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail time to live', 'RCS_EMAIL_TTL', '90', 'Number of days to give for emails before they no longer show as being sent', @configuration_group_id, 20, NULL, NOW(), NULL, NULL), (NULL, 'Friendly E-Mails', 'RCS_EMAIL_FRIENDLY', 'true', 'If true then the customer's name will be used in the greeting. If false then a generic greeting will be used.', @configuration_group_id, 30, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Show Attributes', 'RCS_SHOW_ATTRIBUTES', 'false', 'Controls display of item attributes.
Some sites have attributes for their items.
Set this to true if yours does and you want to show them, otherwise set to false.', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Ignore Customers with Sessions', 'RCS_CHECK_SESSIONS', 'false', 'If you want the tool to ignore customers with an active session (ie, probably still shopping) set this to true.
Setting this to false will operate in the default manner of ignoring session data & using less resources', @configuration_group_id, 40, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Ignore Repeat Customers', 'RCS_CHECK_REPEAT', 'false', 'Setting this to true will cause recover cart sales to ignore abandoned carts by repeat customers', @configuration_group_id, 45, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Current Customer Color', 'RCS_CURCUST_COLOR', '0000FF', 'Color for the word/phrase used to notate a current customer
A current customer is someone who has purchased items from your store in the past.', @configuration_group_id, 50, NULL, NOW(), NULL, NULL), (NULL, 'Uncontacted hilight color', 'RCS_UNCONTACTED_COLOR', '80FFFF', 'Row highlight color for uncontacted customers.
An uncontacted customer is one that you have not used this tool to send an email to before.', @configuration_group_id, 60, NULL, NOW(), NULL, NULL), (NULL, 'Contacted hilight color', 'RCS_CONTACTED_COLOR', 'FF9FA2', 'Row highlight color for contacted customers.
An contacted customer is one that you have used this tool to send an email to before.', @configuration_group_id, 70, NULL, NOW(), NULL, NULL), (NULL, 'Matching Order Hilight', 'RCS_MATCHED_ORDER_COLOR', '9FFF22', 'Row highlight color for entrees that may have a matching order.
An entry will be marked with this color if an order contains one or more of an item in the abandoned cart and matches either the cart's customer email address or database ID.', @configuration_group_id, 72, NULL, NOW(), NULL, NULL), (NULL, 'Skip Carts w/Matched Orders', 'RCS_SKIP_MATCHED_CARTS', 'true', 'To ignore carts with an a matching order set this to true.
Setting this to false will cause entries with a matching order to show, along with the matching order's status.
See documentation for details.', @configuration_group_id, 80, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Lowest Pending sales status', 'RCS_PENDING_SALE_STATUS', '1', 'The highest value that an order can have and still be considered pending. Any value higher than this will be considered by RCS as sale which completed.
See documentation for details.', @configuration_group_id, 85, NULL, NOW(), 'zen_get_order_status_name', 'zen_cfg_pull_down_order_statuses('), (NULL, 'Report Even Row Style', 'RCS_REPORT_EVEN_STYLE', 'dataTableRow', 'Style for even rows in results report. Typical options are dataTableRow and attributes-even.', @configuration_group_id, 90, NULL, NOW(), NULL, NULL), (NULL, 'Report Odd Row Style', 'RCS_REPORT_ODD_STYLE', '', 'Style for odd rows in results report. Typical options are NULL (ie, no entry) and attributes-odd.', @configuration_group_id, 92, NULL, NOW(), NULL, NULL), (NULL, 'E-Mail Copies to', 'RCS_EMAIL_COPIES_TO', '', 'If you want copies of emails that are sent to customers by this contribution, enter the email address here. If empty no copies are sent', @configuration_group_id, 35, NULL, NOW(), NULL, NULL), (NULL, 'Autocheck 'safe' carts to email', 'RCS_AUTO_CHECK', 'true', 'To check entries which are most likely safe to email (ie, not existing customers, not previously emailed, etc.) set this to true.
Setting this to false will leave all entries unchecked (you will have to check each entry you want to send an email for).', @configuration_group_id, 82, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'), (NULL, 'Match orders from any date', 'RCS_CARTS_MATCH_ALL_DATES', 'true', 'If true then any order found with a matching item will be considered a matched order.
If false only orders placed after the abandoned cart are considered.', @configuration_group_id, 84, NULL, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
>
> However, if I upload the SQL directly through MyPHPAdmin, everything seems to get installed correctly, but I, too, get absolutely nothing in Admin-->Configuration-->Recover Cart Sales (the options are blank)
>
> I am using the latest version of Zen Cart (v1.3.9h) and the latest version of the RCS module (v3.1.0).
>
> Any and all help/suggestions will be appreciated.
A few things:
1) You NEVER want to use the 'upload file' option to install an SQL patch in Zen Cart (this can be buggy.) The preferred way is to copy and paste the SQL patch into the proper area and then update.
2) You should also avoid using a tool like phpMyAdmin to run patches. If you have a prefix for your zen cart tables (like 'zen_') then using a tool like phpMyAdmin to run the patch will not include that prefix (unless you manually alter the patch file to include it in all locations) and as a result, although the patch may look to run, you won't see it working on the Zen Cart side (because your zen site will be referring to tables that lead with your designated prefix.)
3) Based on #2 above, this would explain why it appears your patch runs under phpMyAdmin (with no 'error'). The patch installed to a new table that is not lead by your prefix (thus not copying over what was already there.)
4) The error message you received saying a field / column was already present can be ignored. This simply means you already installed the patch and those fields are present. They can't be added if already in the DB and thus the SQL patch will not add them (and you are returned with a default SQL message saying so.)
