RSS2 Feed Contribution

where is cache? How can delete/update it? browser cache is deleted!

100asa:

where is cache? How can delete/update it? browser cache is deleted!
Wow! Is it not written in the readme? It is much discussed in the forum!

my rss feed cache time is set to 0

100asa:

my rss feed cache time is set to 0
OK. Goto PM.

Ok I can't get RSS to install in my 1.5 store. When I copy & paste the code below (from fresh_install.sql) into the Install SQL Patches I get the message WARNING: An Error occurred, please refresh the page and try again. Now I use a zen_ prefix in my store ... do I need to put that in the code and if so where????. Before I upgraded to 1.5 I had not problems and since the upgrade i've tried installing this so many times and can never get it to work.

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=zen_configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'RSS Feed' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'RSS_FEED_VERSION';

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'RSS Feed', 'RSS Feed', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'RSS Title', 'RSS_TITLE', '', 'RSS Title (if empty use Store Name)', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'RSS Description', 'RSS_DESCRIPTION', '', 'RSS description', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'RSS Image', 'RSS_IMAGE', '', 'A GIF, JPEG or PNG image that represents the channel', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'RSS Image Name', 'RSS_IMAGE_NAME', '', 'RSS Image Name (if empty use Store Name)', @configuration_group_id, 4, NOW(), NULL, NULL),
(NULL, 'RSS Copyright', 'RSS_COPYRIGHT', '', 'RSS Copyright (if empty use Store Owner)', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'RSS Managing Editor', 'RSS_MANAGING_EDITOR', '', 'RSS Managing Editor (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'RSS Webmaster', 'RSS_WEBMASTER', '', 'RSS Webmaster (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'RSS Author', 'RSS_AUTHOR', '', 'RSS Author (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 8, NOW(), NULL, NULL),

(NULL, 'RSS Home Page Feed', 'RSS_HOMEPAGE_FEED', 'new_products', 'RSS Home Page Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array('news', 'new_products', 'upcoming', 'featured', 'specials', 'products', 'categories'),'),
(NULL, 'RSS Default Feed', 'RSS_DEFAULT_FEED', 'new_products', 'RSS Default Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array('news', 'new_products', 'upcoming', 'featured', 'specials', 'products', 'categories'),'),

(NULL, 'Strip tags', 'RSS_STRIP_TAGS', 'false', 'Strip tags', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Descriptions', 'RSS_ITEMS_DESCRIPTION', 'true', 'Generate Descriptions', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Descriptions Length', 'RSS_ITEMS_DESCRIPTION_MAX_LENGTH', '0', 'How many characters in description (0 for no limit)', @configuration_group_id, 22, NOW(), NULL, NULL),
(NULL, 'Time to live', 'RSS_TTL', '1440', 'Time to live - time after reader should refresh the info in minutes', @configuration_group_id, 23, NOW(), NULL, NULL),

(NULL, 'Default Products Limit', 'RSS_PRODUCTS_LIMIT', '100', 'Default Limit to Products Feed', @configuration_group_id, 31, NOW(), NULL, NULL),
(NULL, 'Add Product image', 'RSS_PRODUCTS_DESCRIPTION_IMAGE', 'true', 'Add product image to product description tag', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Add "buy now" button', 'RSS_PRODUCTS_DESCRIPTION_BUYNOW', 'true', 'Add "buy now" button to product description tag', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),

(NULL, 'Categories for Products', 'RSS_PRODUCTS_CATEGORIES', 'master', 'Use 'all' or only 'master' Categories for Products when specified cPath parameter', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array('master', 'all'),'),

(NULL, 'Generate Products Price', 'RSS_PRODUCTS_PRICE', 'true', 'Generate Products Price (extended tag <g:price>)', @configuration_group_id, 90, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products ID', 'RSS_PRODUCTS_ID', 'true', 'Generate Products ID (extended tag <g:id>)', @configuration_group_id, 91, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Weight', 'RSS_PRODUCTS_WEIGHT', 'true', 'Generate Products Weight (extended tag <g:weight>)', @configuration_group_id, 93, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Brand', 'RSS_PRODUCTS_BRAND', 'true', 'Generate Products Manufacturers Name (extended tag <g:brand>)', @configuration_group_id, 94, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Currency', 'RSS_PRODUCTS_CURRENCY', 'true', 'Generate Products Currency (extended tag <g:currency>)', @configuration_group_id, 95, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Quantity', 'RSS_PRODUCTS_QUANTITY', 'true', 'Generate Products Quantity (extended tag <g:quantity>)', @configuration_group_id, 96, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Model', 'RSS_PRODUCTS_MODEL', 'true', 'Generate Products Model (extended tag <g:model_number>)', @configuration_group_id, 97, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Rating', 'RSS_PRODUCTS_RATING', 'true', 'Generate Products Rating (extended tag <g:rating>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Images', 'RSS_PRODUCTS_IMAGES', 'true', 'Generate Products Images (extended tag <g:image_link>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Images Size', 'RSS_DEFAULT_IMAGE_SIZE', 'large', 'What image size Generate (extended tag <g:image_link>)', @configuration_group_id, 99, NOW(), NULL, 'zen_cfg_select_option(array('small', 'medium', 'large'),'),
(NULL, 'Feed Cache Time', 'RSS_CACHE_TIME', '10', 'Cache Time (in min). If you don't want caching, set it to 0', @configuration_group_id, 200, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');

SELECT @t4:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'RSS Feed';
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRSSFeed','BOX_CONFIGURATION_RSS_FEED','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);

disregard - went in and removed the rss tables from database and reinstalled and it's working now.

Ok new issue ... I followed a post that said to change:

date('r', strtotime($products->fields['products_date'])),

to

false,

and part of that worked great. Now my feed no longer shows everything with a date of November 30th but each products shows the exact same date (the current date & time) instead of the date the product was acually added. Anybody know how to fix this? RSS Graffiti (on FB) just keeps pulling in the oldest products (since everything on my feed page shows the exact same date & time). I never had this problem with 1.39h, only with 1.5. Any suggestions???

I am running zen cart 1.5.1 with version 2.1.6 of RSS Feed. I my error logs I get the below:

[02-Oct-2012 08:15:43] PHP Warning: filemtime() [<a href='function.filemtime'>function.filemtime</a>]: stat failed for /home/nuganics/public_html/cache/rssfeed_9b0282316c6b32b5d311bacbc85a6952 in /home/nuganics/public_html/includes/classes/rss_feed.php on line 383

Is there some issue with zen cart 1.5.1 or have I updated incorrectly?

nuganics:

I am running zen cart 1.5.1 with version 2.1.6 of RSS Feed. I my error logs I get the below:

[02-Oct-2012 08:15:43] PHP Warning: filemtime() [<a href='function.filemtime'>function.filemtime</a>]: stat failed for /home/nuganics/public_html/cache/rssfeed_9b0282316c6b32b5d311bacbc85a6952 in /home/nuganics/public_html/includes/classes/rss_feed.php on line 383

Is there some issue with zen cart 1.5.1 or have I updated incorrectly?

Ignore this warning - it does not affect performance.

Thanks Andrew. Love the plugin :)

Hello fellow Zen Cart users...I have a couple of questions about adding custom fields within the rss feed for each product. I want to add vin# for each product. Also I would like to know how to exclude my sold inventory catagory and my coming soon catagory. The site is https://www.qualityautowi.com and the rss feed is http://www.qualityautowi.com/index.php?main_page=rss_feed&feed=products Any help would be greatly appriecated. Thank you

Can someone please give me some assitance or point me to where I can find some answers. I have installed the RSS feed for my store. using vi.5 and the problems i just start to have is when i try to get a rss feed for a product i get Feed Code Error. And the other problem is it is not giving me the full total that is in my store even though I have set the amount to more than what i have in my store in the admin.

I have searched but still cant find and answer in the forum please help.

make sure you edit the correct template files. Check the template that you have selected in zen cart then check that you are editing the correct files. If not sure move back to default template then edit those files. Is there any error log file in /logs/ ?

Hi, im having xml parse error

XML Parsing Error: XML or text declaration not at start of entity
Line Number 1, Column 3:

--^

Previously it was working fine but now it cant work.

Anyone can help? Thanks in advance

Hi .Would someone be able to help please ..
When I first installed Rss it worked fine (about 4 weeks ago)now I was playing around and am getting this error

XML Parsing Error: XML or text declaration not at start of entity
Location: http://pewter world.co.uk/index.php?main_page=rss_feed&feed=products
Line Number 3, Column 1:<?xml version="1.0" encoding="utf-8"?>
^

just found this in the logs

[21-Mar-2013 21:24:45] PHP Fatal error: 1062:Duplicate entry 'configRSSFeed' for key 1 :: INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRSSFeed','BOX_CONFIGURATION_RSS_FEED','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4); in /var/www/vhosts/pewter world.co.uk/httpdocs/includes/classes/db/mysql/query_factory.php on line 120

I've been though I few pages but nothing found ...Although I'm sure there is an answer

thanks

Does anyone know if it works on Zen Cart 1.51 cause I'm getting the following error:

Success 11 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

Here's the sql I'm using:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'RSS Feed' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'RSS_FEED_VERSION';

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'RSS Feed', 'RSS Feed', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'RSS Title', 'RSS_TITLE', '', 'RSS Title (if empty use Store Name)', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'RSS Description', 'RSS_DESCRIPTION', '', 'RSS description', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'RSS Image', 'RSS_IMAGE', '', 'A GIF, JPEG or PNG image that represents the channel', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'RSS Image Name', 'RSS_IMAGE_NAME', '', 'RSS Image Name (if empty use Store Name)', @configuration_group_id, 4, NOW(), NULL, NULL),
(NULL, 'RSS Copyright', 'RSS_COPYRIGHT', '', 'RSS Copyright (if empty use Store Owner)', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'RSS Managing Editor', 'RSS_MANAGING_EDITOR', '', 'RSS Managing Editor (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'RSS Webmaster', 'RSS_WEBMASTER', '', 'RSS Webmaster (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'RSS Author', 'RSS_AUTHOR', '', 'RSS Author (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 8, NOW(), NULL, NULL),

(NULL, 'RSS Home Page Feed', 'RSS_HOMEPAGE_FEED', 'new_products', 'RSS Home Page Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array('news', 'new_products', 'upcoming', 'featured', 'specials', 'products', 'categories'),'),
(NULL, 'RSS Default Feed', 'RSS_DEFAULT_FEED', 'new_products', 'RSS Default Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array('news', 'new_products', 'upcoming', 'featured', 'specials', 'products', 'categories'),'),

(NULL, 'Strip tags', 'RSS_STRIP_TAGS', 'false', 'Strip tags', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Descriptions', 'RSS_ITEMS_DESCRIPTION', 'true', 'Generate Descriptions', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Descriptions Length', 'RSS_ITEMS_DESCRIPTION_MAX_LENGTH', '0', 'How many characters in description (0 for no limit)', @configuration_group_id, 22, NOW(), NULL, NULL),
(NULL, 'Time to live', 'RSS_TTL', '1440', 'Time to live - time after reader should refresh the info in minutes', @configuration_group_id, 23, NOW(), NULL, NULL),

(NULL, 'Default Products Limit', 'RSS_PRODUCTS_LIMIT', '100', 'Default Limit to Products Feed', @configuration_group_id, 31, NOW(), NULL, NULL),
(NULL, 'Add Product image', 'RSS_PRODUCTS_DESCRIPTION_IMAGE', 'true', 'Add product image to product description tag', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Add "buy now" button', 'RSS_PRODUCTS_DESCRIPTION_BUYNOW', 'true', 'Add "buy now" button to product description tag', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),

(NULL, 'Categories for Products', 'RSS_PRODUCTS_CATEGORIES', 'master', 'Use 'all' or only 'master' Categories for Products when specified cPath parameter', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array('master', 'all'),'),

(NULL, 'Generate Products Price', 'RSS_PRODUCTS_PRICE', 'true', 'Generate Products Price (extended tag <g:price>)', @configuration_group_id, 90, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products ID', 'RSS_PRODUCTS_ID', 'true', 'Generate Products ID (extended tag <g:id>)', @configuration_group_id, 91, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Weight', 'RSS_PRODUCTS_WEIGHT', 'true', 'Generate Products Weight (extended tag <g:weight>)', @configuration_group_id, 93, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Brand', 'RSS_PRODUCTS_BRAND', 'true', 'Generate Products Manufacturers Name (extended tag <g:brand>)', @configuration_group_id, 94, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Currency', 'RSS_PRODUCTS_CURRENCY', 'true', 'Generate Products Currency (extended tag <g:currency>)', @configuration_group_id, 95, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Quantity', 'RSS_PRODUCTS_QUANTITY', 'true', 'Generate Products Quantity (extended tag <g:quantity>)', @configuration_group_id, 96, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Model', 'RSS_PRODUCTS_MODEL', 'true', 'Generate Products Model (extended tag <g:model_number>)', @configuration_group_id, 97, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Rating', 'RSS_PRODUCTS_RATING', 'true', 'Generate Products Rating (extended tag <g:rating>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Images', 'RSS_PRODUCTS_IMAGES', 'true', 'Generate Products Images (extended tag <g:image_link>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Images Size', 'RSS_DEFAULT_IMAGE_SIZE', 'large', 'What image size Generate (extended tag <g:image_link>)', @configuration_group_id, 99, NOW(), NULL, 'zen_cfg_select_option(array('small', 'medium', 'large'),'),
(NULL, 'Feed Cache Time', 'RSS_CACHE_TIME', '10', 'Cache Time (in min). If you don't want caching, set it to 0', @configuration_group_id, 200, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');

SELECT @t4:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'RSS Feed';
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRSSFeed','BOX_CONFIGURATION_RSS_FEED','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);

the site has a zen_ prefix and like I said I've installed it on 1.51 before but this isn't my site it is someone else's.

honrheart:

Does anyone know if it works on Zen Cart 1.51 cause I'm getting the following error:

Success 11 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

Here's the sql I'm using:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'RSS Feed' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'RSS_FEED_VERSION';

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'RSS Feed', 'RSS Feed', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'RSS Title', 'RSS_TITLE', '', 'RSS Title (if empty use Store Name)', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'RSS Description', 'RSS_DESCRIPTION', '', 'RSS description', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'RSS Image', 'RSS_IMAGE', '', 'A GIF, JPEG or PNG image that represents the channel', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'RSS Image Name', 'RSS_IMAGE_NAME', '', 'RSS Image Name (if empty use Store Name)', @configuration_group_id, 4, NOW(), NULL, NULL),
(NULL, 'RSS Copyright', 'RSS_COPYRIGHT', '', 'RSS Copyright (if empty use Store Owner)', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'RSS Managing Editor', 'RSS_MANAGING_EDITOR', '', 'RSS Managing Editor (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 6, NOW(), NULL, NULL),
(NULL, 'RSS Webmaster', 'RSS_WEBMASTER', '', 'RSS Webmaster (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'RSS Author', 'RSS_AUTHOR', '', 'RSS Author (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 8, NOW(), NULL, NULL),

(NULL, 'RSS Home Page Feed', 'RSS_HOMEPAGE_FEED', 'new_products', 'RSS Home Page Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array('news', 'new_products', 'upcoming', 'featured', 'specials', 'products', 'categories'),'),
(NULL, 'RSS Default Feed', 'RSS_DEFAULT_FEED', 'new_products', 'RSS Default Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array('news', 'new_products', 'upcoming', 'featured', 'specials', 'products', 'categories'),'),

(NULL, 'Strip tags', 'RSS_STRIP_TAGS', 'false', 'Strip tags', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Descriptions', 'RSS_ITEMS_DESCRIPTION', 'true', 'Generate Descriptions', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Descriptions Length', 'RSS_ITEMS_DESCRIPTION_MAX_LENGTH', '0', 'How many characters in description (0 for no limit)', @configuration_group_id, 22, NOW(), NULL, NULL),
(NULL, 'Time to live', 'RSS_TTL', '1440', 'Time to live - time after reader should refresh the info in minutes', @configuration_group_id, 23, NOW(), NULL, NULL),

(NULL, 'Default Products Limit', 'RSS_PRODUCTS_LIMIT', '100', 'Default Limit to Products Feed', @configuration_group_id, 31, NOW(), NULL, NULL),
(NULL, 'Add Product image', 'RSS_PRODUCTS_DESCRIPTION_IMAGE', 'true', 'Add product image to product description tag', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Add "buy now" button', 'RSS_PRODUCTS_DESCRIPTION_BUYNOW', 'true', 'Add "buy now" button to product description tag', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),

(NULL, 'Categories for Products', 'RSS_PRODUCTS_CATEGORIES', 'master', 'Use 'all' or only 'master' Categories for Products when specified cPath parameter', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array('master', 'all'),'),

(NULL, 'Generate Products Price', 'RSS_PRODUCTS_PRICE', 'true', 'Generate Products Price (extended tag <g:price>)', @configuration_group_id, 90, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products ID', 'RSS_PRODUCTS_ID', 'true', 'Generate Products ID (extended tag <g:id>)', @configuration_group_id, 91, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Weight', 'RSS_PRODUCTS_WEIGHT', 'true', 'Generate Products Weight (extended tag <g:weight>)', @configuration_group_id, 93, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Brand', 'RSS_PRODUCTS_BRAND', 'true', 'Generate Products Manufacturers Name (extended tag <g:brand>)', @configuration_group_id, 94, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Currency', 'RSS_PRODUCTS_CURRENCY', 'true', 'Generate Products Currency (extended tag <g:currency>)', @configuration_group_id, 95, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Quantity', 'RSS_PRODUCTS_QUANTITY', 'true', 'Generate Products Quantity (extended tag <g:quantity>)', @configuration_group_id, 96, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Model', 'RSS_PRODUCTS_MODEL', 'true', 'Generate Products Model (extended tag <g:model_number>)', @configuration_group_id, 97, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Rating', 'RSS_PRODUCTS_RATING', 'true', 'Generate Products Rating (extended tag <g:rating>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Images', 'RSS_PRODUCTS_IMAGES', 'true', 'Generate Products Images (extended tag <g:image_link>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),'),
(NULL, 'Generate Products Images Size', 'RSS_DEFAULT_IMAGE_SIZE', 'large', 'What image size Generate (extended tag <g:image_link>)', @configuration_group_id, 99, NOW(), NULL, 'zen_cfg_select_option(array('small', 'medium', 'large'),'),
(NULL, 'Feed Cache Time', 'RSS_CACHE_TIME', '10', 'Cache Time (in min). If you don't want caching, set it to 0', @configuration_group_id, 200, NOW(), NULL, 'zen_cfg_select_option(array('true', 'false'),');

SELECT @t4:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'RSS Feed';
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configRSSFeed','BOX_CONFIGURATION_RSS_FEED','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);

the site has a zen_ prefix and like I said I've installed it on 1.51 before but this isn't my site it is someone else's.

I installed it on 1.5 before not 1.51 ... typo

honrheart:

Success 11 statements processed.
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Error ERROR: Cannot insert configuration_key "" because it already exists
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
http://www.zen-cart.com/wiki/index.php/Troubleshooting_-_SQL_Patches#Cannot_insert_configuration_key_.22.22_because_it_already_exists

This is due to the operation mode mySQL.

Try this sql:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'RSS Feed' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'RSS_FEED_VERSION';

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'RSS Feed', 'RSS Feed', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;


INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Title', 'RSS_TITLE', '', 'RSS Title (if empty use Store Name)', @configuration_group_id, 1, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Description', 'RSS_DESCRIPTION', '', 'RSS description', @configuration_group_id, 2, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Image', 'RSS_IMAGE', '', 'A GIF, JPEG or PNG image that represents the channel', @configuration_group_id, 3, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Image Name', 'RSS_IMAGE_NAME', '', 'RSS Image Name (if empty use Store Name)', @configuration_group_id, 4, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Copyright', 'RSS_COPYRIGHT', '', 'RSS Copyright (if empty use Store Owner)', @configuration_group_id, 5, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Managing Editor', 'RSS_MANAGING_EDITOR', '', 'RSS Managing Editor (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 6, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Webmaster', 'RSS_WEBMASTER', '', 'RSS Webmaster (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 7, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Author', 'RSS_AUTHOR', '', 'RSS Author (if empty use Store Owner Email Address and Store Owner)', @configuration_group_id, 8, NOW(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Home Page Feed', 'RSS_HOMEPAGE_FEED', 'new_products', 'RSS Home Page Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array(\'news\', \'new_products\', \'upcoming\', \'featured\', \'specials\', \'products\', \'categories\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'RSS Default Feed', 'RSS_DEFAULT_FEED', 'new_products', 'RSS Default Feed', @configuration_group_id, 8, NOW(), NULL, 'zen_cfg_select_option(array(\'news\', \'new_products\', \'upcoming\', \'featured\', \'specials\', \'products\', \'categories\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Strip tags', 'RSS_STRIP_TAGS', 'false', 'Strip tags', @configuration_group_id, 20, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Descriptions', 'RSS_ITEMS_DESCRIPTION', 'true', 'Generate Descriptions', @configuration_group_id, 21, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Descriptions Length', 'RSS_ITEMS_DESCRIPTION_MAX_LENGTH', '0', 'How many characters in description (0 for no limit)', @configuration_group_id, 22, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Time to live', 'RSS_TTL', '1440', 'Time to live - time after reader should refresh the info in minutes', @configuration_group_id, 23, NOW(), NULL, NULL);

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Default Products Limit', 'RSS_PRODUCTS_LIMIT', '100', 'Default Limit to Products Feed', @configuration_group_id, 31, NOW(), NULL, NULL);
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Add Product image', 'RSS_PRODUCTS_DESCRIPTION_IMAGE', 'true', 'Add product image to product description tag', @configuration_group_id, 32, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Add "buy now" button', 'RSS_PRODUCTS_DESCRIPTION_BUYNOW', 'true', 'Add "buy now" button to product description tag', @configuration_group_id, 33, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Categories for Products', 'RSS_PRODUCTS_CATEGORIES', 'master', 'Use \'all\' or only \'master\' Categories for Products when specified cPath parameter', @configuration_group_id, 23, NOW(), NULL, 'zen_cfg_select_option(array(\'master\', \'all\'),');

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Price', 'RSS_PRODUCTS_PRICE', 'true', 'Generate Products Price (extended tag <grice>)', @configuration_group_id, 90, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products ID', 'RSS_PRODUCTS_ID', 'true', 'Generate Products ID (extended tag <g:id>)', @configuration_group_id, 91, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Weight', 'RSS_PRODUCTS_WEIGHT', 'true', 'Generate Products Weight (extended tag <g:weight>)', @configuration_group_id, 93, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Brand', 'RSS_PRODUCTS_BRAND', 'true', 'Generate Products Manufacturers Name (extended tag <g:brand>)', @configuration_group_id, 94, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Currency', 'RSS_PRODUCTS_CURRENCY', 'true', 'Generate Products Currency (extended tag <g:currency>)', @configuration_group_id, 95, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Quantity', 'RSS_PRODUCTS_QUANTITY', 'true', 'Generate Products Quantity (extended tag <g:quantity>)', @configuration_group_id, 96, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Model', 'RSS_PRODUCTS_MODEL', 'true', 'Generate Products Model (extended tag <g:model_number>)', @configuration_group_id, 97, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Rating', 'RSS_PRODUCTS_RATING', 'true', 'Generate Products Rating (extended tag <g:rating>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Images', 'RSS_PRODUCTS_IMAGES', 'true', 'Generate Products Images (extended tag <g:image_link>)', @configuration_group_id, 98, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Generate Products Images Size', 'RSS_DEFAULT_IMAGE_SIZE', 'large', 'What image size Generate (extended tag <g:image_link>)', @configuration_group_id, 99, NOW(), NULL, 'zen_cfg_select_option(array(\'small\', \'medium\', \'large\'),');
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Feed Cache Time', 'RSS_CACHE_TIME', '10', 'Cache Time (in min). If you don\'t want caching, set it to 0', @configuration_group_id, 200, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

SELECT @t4:=configuration_group_id FROM configuration_group WHERE configuration_group_title = 'RSS Feed';
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order ) VALUES ('configRSSFeed','BOX_CONFIGURATION_RSS_FEED','FILENAME_CONFIGURATION',CONCAT('g ID=',@t4), 'configuration', 'Y', @t4);

Excuse me, but maybe this question/problem has been placed several times: the presence of the symbol degrees in the description of a product generates me error in the file rss feeds. How can I fix?

Hi All,

I know this is an old mod and thread, but I'm trying to use this RSS feed on my heavily modified site!
All is working fine, and I get all the info from the feed (set on Categories).....

However....

The "First Main Category" appears in every feed result, no matter what cPath is used!

The proper "sub categories" that are associated to the cPath are displayed, but that "Same 1st Main Category" is in Every Result!

Can someone PLEASE Help?