SitemapXML v.2

jeking:

https://www.zen-cart.com/content.php?124-blank-page

Especially 2.a.

There are error logs but I have no idea what they mean. Here is today's error log.....

([17-Feb-2017 16:22:33 America/Los_Angeles] Request URI: /products/admin/login.php, IP address: 24.00.00.000
#1 trigger_error() called at [/home/######/public_html/products/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/home/######/public_html/products/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/home/#####/public_html/products/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/home/######/public_html/products/admin/includes/functions/database.php:53]
#5 zen_db_perform() called at [/home/#####/public_html/products/admin/includes/classes/ext_modules.php:109]
#6 ext_modules->install_configuration() called at [/home/#####/public_html/products/admin/includes/installers/sitemapxml/3_9_1.php:19]
#7 include(/home/#####/public_html/products/admin/includes/installers/sitemapxml/3_9_1.php) called at [/home/#####/public_html/products/admin/includes/init_includes/init_sitemapxml.php:48]
#8 require(/home/#####/public_html/products/admin/includes/init_includes/init_sitemapxml.php) called at [/home/#####/public_html/products/includes/autoload_func.php:48]
#9 require(/home/#####/public_html/products/includes/autoload_func.php) called at [/home/#####/public_html/products/admin/includes/application_top.php:171]
#10 require(/home/#####/public_html/products/admin/includes/application_top.php) called at [/home/#####/public_html/products/admin/login.php:9]

[17-Feb-2017 16:22:33 America/Los_Angeles] PHP Fatal error: 1062:Duplicate entry 'SITEMAPXML_VERSION' for key 'unq_config_key_zen' :: insert into configuration (configuration_key, configuration_group_id, configuration_title, configuration_value, configuration_description, sort_order, use_function, set_function, date_added) values ('SITEMAPXML_VERSION', '', 'TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION', '3.9.2', 'TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION', '-10', '', 'zen_cfg_read_only(', now()) ==> (as called by) /home/#####/public_html/products/admin/includes/functions/database.php on line 53 <== in /home/#####/public_html/products/includes/classes/db/mysql/query_factory.php on line 167)

Hi,

hflsales:

There are error logs but I have no idea what they mean. Here is today's error log.....
Can you send me access to ftp?

a_berezin:

Hi,

Can you send me access to ftp?

Thank you a_berezin. I figured it out and got it working finally. Apparently I had installed an older version a long time ago and never removed the sitemap tables from the database. That was causing all the problems. I have it up and running now and it works great.

Does this plug in disable the internal sitemap page /index.php?main_page=site_map?
Since I got this plug in working, when I go to the internal sitemap link, it sends me to the home page.

i got a PHP problem when i re-create sitemap,anyone know how to solve this? thanks

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4096 bytes) in /home/estand/public_html/includes/classes/sitemapxml.php on line 788

The server allocation for PHP Memory Limit needs to be increased, by at least another 16MB. Best talk to Hoster about this.

Where are the instructions????
I see references to it but it wasn't in the download.

Thanks
Carol

spminis:

Where are the instructions????
I see references to it but it wasn't in the download.

Thanks
Carol

I did find some instructions but the sql file is missing in the download.

Carol

spminis:

I did find some instructions but the sql file is missing in the download.

Carol

Never mind. I found it when I downloaded it from Zucando

Carol

a_berezin:

Hi,

Module "News Box Manager" is the last time I had seen more than 10 years ago. It is better to disable it in the sitemapxml plugins settings.

Did you find a solution for this problem? I installed it on ZC1.5.5e and have the same problem, I don't know, what to do. Sitemap folder and file have 777 permission. System always write:
"
News Box Manager Sitemap
WARNING: An Error occurred, please refresh the page and try again.
"

If anyone knows, please help. Thank you very much.

DarkMen:

Did you find a solution for this problem? I installed it on ZC1.5.5e and have the same problem, I don't know, what to do. Sitemap folder and file have 777 permission. System always write:
"
News Box Manager Sitemap
WARNING: An Error occurred, please refresh the page and try again.
"

If anyone knows, please help. Thank you very much.

Read this once more:

a_berezin:

Module "News Box Manager" is the last time I had seen more than 10 years ago. It is better to disable it in the sitemapxml plugins settings.

As @a_berezin indicated, the most recent versions of "News Box Manager" have different database settings, so the sitemapxml's configuration should disable that feature in the sitemapxml settings.

hflsales:

Thank you a_berezin. I figured it out and got it working finally. Apparently I had installed an older version a long time ago and never removed the sitemap tables from the database. That was causing all the problems. I have it up and running now and it works great.

OK - I have the same error. And I'm fairly sure that once-upon-a-time (prob when my site was vs. 1.3.x) I had an older version of SitemapXML installed. What tables and how do I delete them?

Three Sisters:

OK - I have the same error. And I'm fairly sure that once-upon-a-time (prob when my site was vs. 1.3.x) I had an older version of SitemapXML installed. What tables and how do I delete them?

SitemapXML uses only one table - temporary. It is automatically deleted after execution. So I don't know of any tables talk hflsales.

Three Sisters:

OK - I have the same error.
"Same error" - what error?

a_berezin:

"Same error" - what error?

The same errors as what hflsales mentioned in post #1763. When the files are all installed I get a white screen in the admin, while the site continues to work. If I delete admin/includes/auto_loaders/config.sitemapxml.php, my admin page starts to work again.

Here's the error log:

[10-Apr-2017 18:07:34] Request URI:  /admin/login.php?camefrom=index.php&zenAdminID=atu0srti5fpvnj67eibuefk564, 
#1  trigger_error(1062:Duplicate entry 'SITEMAPXML_VERSION' for key  'unq_config_key_zen' :: insert into configuration (configuration_key,  configuration_group_id, configuration_title, configuration_value,  configuration_description, sort_order, use_function, set_function,  date_added) values ('SITEMAPXML_VERSION', '',  'TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION', '3.9.2',  'TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION', '-10', '',  'zen_cfg_read_only(', now()) ==> (as called by)  /home/xxxx/public_html/admin/includes/functions/database.php on line 53  <==, 256) called at  [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:167]
#2  queryFactory->show_error() called at [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:139]
#3  queryFactory->set_error(1062, Duplicate entry  'SITEMAPXML_VERSION' for key 'unq_config_key_zen', 1) called at  [/home/xxxx/public_html/includes/classes/db/mysql/query_factory.php:266]
#4  queryFactory->Execute(insert into configuration  (configuration_key, configuration_group_id, configuration_title,  configuration_value, configuration_description, sort_order,  use_function, set_function, date_added) values ('SITEMAPXML_VERSION',  '', 'TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION', '3.9.2',  'TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION', '-10', '',  'zen_cfg_read_only(', now())) called at  [/home/xxxx/public_html/admin/includes/functions/database.php:53]
#5  zen_db_perform(configuration, Array ([configuration_key] =>  SITEMAPXML_VERSION,[configuration_group_id] => ,[configuration_title]  => TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION,[configuration_value]  => 3.9.2,[configuration_description] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION,[sort_order] =>  -10,[use_function] => ,[set_function] =>  zen_cfg_read_only(,[date_added] => now())) called at  [/home/xxxx/public_html/admin/includes/classes/ext_modules.php:109]
#6  ext_modules->install_configuration(Array ([SITEMAPXML_VERSION]  => Array ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION,[1]  => 3.9.2,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION,[3] => -10,[4]  => ,[5] => zen_cfg_read_only(),[SITEMAPXML_SITEMAPINDEX] =>  Array ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_SITEMAPINDEX,[1]  => sitemapindex,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_SITEMAPINDEX,[3] => 1,[4]  => ,[5] => ),[SITEMAPXML_DIR_WS] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_DIR_WS,[1] => ,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_DIR_WS,[3] => 1,[4] =>  ,[5] => ),[SITEMAPXML_COMPRESS] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_COMPRESS,[1] => false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_COMPRESS,[3] => 2,[4] =>  ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_LASTMOD_FORMAT] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_LASTMOD_FORMAT,[1] => date,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_LASTMOD_FORMAT,[3] =>  3,[4] => ,[5] => zen_cfg_select_option(array('date',  'full'),),[SITEMAPXML_EXECUTION_TOKEN] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_EXECUTION_TOKEN,[1] => ,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_EXECUTION_TOKEN,[3] =>  3,[4] => ,[5] => ),[SITEMAPXML_USE_EXISTING_FILES] => Array  ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_USE_EXISTING_FILES,[1]  => true,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_USE_EXISTING_FILES,[3] =>  4,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_USE_ONLY_DEFAULT_LANGUAGE] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_USE_ONLY_DEFAULT_LANGUAGE,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_USE_ONLY_DEFAULT_LANGUAGE,[3]  => 5,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_USE_LANGUAGE_PARM] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_USE_LANGUAGE_PARM,[1] => true,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_USE_LANGUAGE_PARM,[3]  => 6,[4] => ,[5] => zen_cfg_select_option(array('true', 'all',  'false'),),[SITEMAPXML_CHECK_DUPLICATES] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CHECK_DUPLICATES,[1] => true,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CHECK_DUPLICATES,[3]  => 7,[4] => ,[5] => zen_cfg_select_option(array('true',  'mysql', 'false'),),[SITEMAPXML_PING_URLS] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PING_URLS,[1] => Google =>  http://www.google.com/webmasters/sitemaps/ping?sitemap=%s;
Bing => http://www.bing.com/webmaster/ping.aspx?siteMap=%s,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PING_URLS,[3] => 10,[4]  => ,[5] => zen_cfg_textarea(),[SITEMAPXML_PLUGINS] => Array  ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_PLUGINS,[1] =>  sitemapxml_boxnews.php;sitemapxml_categories.php;sitemapxml_ezpages.php;sitemapxml_mainpage.php;sitemapxml_manufacturers.php;sitemapxml_news.php;sitemapxml_products.php;sitemapxml_products_reviews.php;sitemapxml_reviews.php;sitemapxml_testimonials.php,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PLUGINS,[3] =>  15,[4] => ,[5] =>  zen_cfg_read_only(),[SITEMAPXML_HOMEPAGE_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_HOMEPAGE_ORDERBY,[1] =>  sort_order ASC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_HOMEPAGE_ORDERBY,[3] =>  20,[4] => ,[5] => ),[SITEMAPXML_HOMEPAGE_CHANGEFREQ] => Array  ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_HOMEPAGE_CHANGEFREQ,[1]  => weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_HOMEPAGE_CHANGEFREQ,[3] =>  21,[4] => ,[5] => zen_cfg_select_option(array('no', 'always',  'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_PRODUCTS_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_ORDERBY,[1] =>  products_sort_order ASC, last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_ORDERBY,[3] =>  30,[4] => ,[5] => ),[SITEMAPXML_PRODUCTS_CHANGEFREQ] => Array  ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_CHANGEFREQ,[1]  => weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_CHANGEFREQ,[3] =>  31,[4] => ,[5] => zen_cfg_select_option(array('no', 'always',  'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_PRODUCTS_USE_CPATH] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_USE_CPATH,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_USE_CPATH,[3] =>  32,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_PRODUCTS_IMAGES] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_IMAGES,[1] => false,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_IMAGES,[3]  => 35,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_PRODUCTS_IMAGES_CAPTION] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_IMAGES_CAPTION,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_IMAGES_CAPTION,[3]  => 36,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_PRODUCTS_IMAGES_LICENSE] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_IMAGES_LICENSE,[1] =>  ,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_IMAGES_LICENSE,[3]  => 37,[4] => ,[5] => ),[SITEMAPXML_CATEGORIES_ORDERBY] =>  Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CATEGORIES_ORDERBY,[1] =>  sort_order ASC, last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CATEGORIES_ORDERBY,[3] =>  40,[4] => ,[5] => ),[SITEMAPXML_CATEGORIES_CHANGEFREQ] => Array  ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CATEGORIES_CHANGEFREQ,[1] =>  weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CATEGORIES_CHANGEFREQ,[3]  => 41,[4] => ,[5] => zen_cfg_select_option(array('no',  'always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_CATEGORIES_IMAGES] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CATEGORIES_IMAGES,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CATEGORIES_IMAGES,[3] =>  42,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_CATEGORIES_IMAGES_CAPTION] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CATEGORIES_IMAGES_CAPTION,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CATEGORIES_IMAGES_CAPTION,[3]  => 43,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_CATEGORIES_IMAGES_LICENSE] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CATEGORIES_IMAGES_LICENSE,[1] =>  ,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CATEGORIES_IMAGES_LICENSE,[3]  => 44,[4] => ,[5] => ),[SITEMAPXML_CATEGORIES_PAGING] =>  Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_CATEGORIES_PAGING,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_CATEGORIES_PAGING,[3] =>  45,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_REVIEWS_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_REVIEWS_ORDERBY,[1] =>  reviews_rating ASC, last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_REVIEWS_ORDERBY,[3] =>  50,[4] => ,[5] => ),[SITEMAPXML_REVIEWS_CHANGEFREQ] => Array  ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_REVIEWS_CHANGEFREQ,[1]  => weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_REVIEWS_CHANGEFREQ,[3] =>  51,[4] => ,[5] => zen_cfg_select_option(array('no', 'always',  'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_EZPAGES_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_EZPAGES_ORDERBY,[1] =>  sidebox_sort_order ASC, header_sort_order ASC, footer_sort_order ASC,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_EZPAGES_ORDERBY,[3]  => 60,[4] => ,[5] => ),[SITEMAPXML_EZPAGES_CHANGEFREQ] =>  Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_EZPAGES_CHANGEFREQ,[1] =>  weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_EZPAGES_CHANGEFREQ,[3] =>  61,[4] => ,[5] => zen_cfg_select_option(array('no', 'always',  'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_TESTIMONIALS_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_TESTIMONIALS_ORDERBY,[1] =>  last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_TESTIMONIALS_ORDERBY,[3] =>  70,[4] => ,[5] => ),[SITEMAPXML_TESTIMONIALS_CHANGEFREQ] =>  Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_TESTIMONIALS_CHANGEFREQ,[1] =>  weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_TESTIMONIALS_CHANGEFREQ,[3]  => 71,[4] => ,[5] => zen_cfg_select_option(array('no',  'always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_NEWS_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_NEWS_ORDERBY,[1] => last_date  DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_NEWS_ORDERBY,[3] => 80,[4]  => ,[5] => ),[SITEMAPXML_NEWS_CHANGEFREQ] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_NEWS_CHANGEFREQ,[1] => weekly,[2]  => TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_NEWS_CHANGEFREQ,[3]  => 81,[4] => ,[5] => zen_cfg_select_option(array('no',  'always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_MANUFACTURERS_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_MANUFACTURERS_ORDERBY,[1] =>  last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_MANUFACTURERS_ORDERBY,[3]  => 90,[4] => ,[5] => ),[SITEMAPXML_MANUFACTURERS_CHANGEFREQ]  => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_MANUFACTURERS_CHANGEFREQ,[1] =>  weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_MANUFACTURERS_CHANGEFREQ,[3]  => 91,[4] => ,[5] => zen_cfg_select_option(array('no',  'always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_MANUFACTURERS_IMAGES] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_MANUFACTURERS_IMAGES,[1] =>  false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_MANUFACTURERS_IMAGES,[3] =>  92,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_MANUFACTURERS_IMAGES_CAPTION] => Array ([0]  =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_MANUFACTURERS_IMAGES_CAPTION,[1]  => false,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_MANUFACTURERS_IMAGES_CAPTION,[3]  => 93,[4] => ,[5] => zen_cfg_select_option(array('true',  'false'),),[SITEMAPXML_MANUFACTURERS_IMAGES_LICENSE] => Array ([0]  =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_MANUFACTURERS_IMAGES_LICENSE,[1]  => ,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_MANUFACTURERS_IMAGES_LICENSE,[3]  => 94,[4] => ,[5] => ),[SITEMAPXML_BOXNEWS_ORDERBY] =>  Array ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_BOXNEWS_ORDERBY,[1]  => last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_BOXNEWS_ORDERBY,[3] =>  100,[4] => ,[5] => ),[SITEMAPXML_BOXNEWS_CHANGEFREQ] => Array  ([0] => TEXT_CONFIGURATION_TITLE_SITEMAPXML_BOXNEWS_CHANGEFREQ,[1]  => weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_BOXNEWS_CHANGEFREQ,[3] =>  101,[4] => ,[5] => zen_cfg_select_option(array('no', 'always',  'hourly', 'daily', 'weekly', 'monthly', 'yearly',  'never'),),[SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY,[1] =>  last_date DESC,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY,[3]  => 110,[4] => ,[5] =>  ),[SITEMAPXML_PRODUCTS_REVIEWS_CHANGEFREQ] => Array ([0] =>  TEXT_CONFIGURATION_TITLE_SITEMAPXML_PRODUCTS_REVIEWS_CHANGEFREQ,[1]  => weekly,[2] =>  TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_PRODUCTS_REVIEWS_CHANGEFREQ,[3]  => 111,[4] => ,[5] => zen_cfg_select_option(array('no',  'always', 'hourly', 'daily', 'weekly', 'monthly', 'yearly', 'never'),)))  called at  [/home/xxxx/public_html/admin/includes/installers/sitemapxml/3_9_1.php:19]
#7   include(/home/xxxx/public_html/admin/includes/installers/sitemapxml/3_9_1.php)  called at  [/home/xxxx/public_html/admin/includes/init_includes/init_sitemapxml.php:48]
#8   require(/home/xxxx/public_html/admin/includes/init_includes/init_sitemapxml.php)  called at [/home/xxxx/public_html/includes/autoload_func.php:48]
#9  require(/home/xxxx/public_html/includes/autoload_func.php) called at  [/home/xxxx/public_html/admin/includes/application_top.php:171]
#10 require(/home/xxxx/public_html/admin/includes/application_top.php) called at [/home/xxxx/public_html/admin/login.php:9]

[10-Apr-2017 18:07:34] PHP Fatal error:  1062:Duplicate entry  'SITEMAPXML_VERSION' for key 'unq_config_key_zen' :: insert into  configuration (configuration_key, configuration_group_id,  configuration_title, configuration_value, configuration_description,  sort_order, use_function, set_function, date_added) values  ('SITEMAPXML_VERSION', '',  'TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION', '3.9.2',  'TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION', '-10', '',  'zen_cfg_read_only(', now()) ==> (as called by)  /home/xxxx/public_html/admin/includes/functions/database.php on line 53  <== in  /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php on  line 167

Curious if you have any thoughts or advice on the error?

[10-Apr-2017 18:07:34] PHP Fatal error:  1062:Duplicate entry  'SITEMAPXML_VERSION' for key 'unq_config_key_zen' :: insert into  configuration (configuration_key, configuration_group_id,  configuration_title, configuration_value, configuration_description,  sort_order, use_function, set_function, date_added) values  ('SITEMAPXML_VERSION', '',  'TEXT_CONFIGURATION_TITLE_SITEMAPXML_VERSION', '3.9.2',  'TEXT_CONFIGURATION_DESCRIPTION_SITEMAPXML_VERSION', '-10', '',  'zen_cfg_read_only(', now()) ==> (as called by)  /home/xxxx/public_html/admin/includes/functions/database.php on line 53  <== in  /home/xxxx/public_html/includes/classes/db/mysql/query_factory.php on  line 167

The error msg. is telling you SiteMap XML is already installed in the database.

Website Rob:

The error msg. is telling you SiteMap XML is already installed in the database.

Thanks a million.... That's what I would have guessed, and that would lead to the same conclusion as hflsales metioned in post #1765. But Andrew said that there is only a temporary table that gets created and then deleted so he thought that couldn't be the solution. But, perhaps, an older version didn't delete the table?

Could you advise where I should look for this table to delete? I tried poking around and couldn't seem to find anything that I could confidently delete.

The module alters the "configuration_group" table to add in entries related to the module.

If you use phpMyAdmin and search your database for "sitemap" (no quotes) you will see all related entries.