SitemapXML v.2

giuly:

nothing, I installed then user tracking and I have same issue with sitemap xml... (but on the other site works!!!)
:blink:

What do you mean ?
SitemapXML worked good, then you installed User Tracking and now SitemapXML not working ?

exactly, fresh install of only zc, sitemap and user tracking...
If someone paying can help me, because I will be crazy...

Send PM to me

delete files and database of user tracking the sitemap xml works again!!!
I will ask on that forum...
thanks to everyone

does Sitemap xml have any influence in Google indexing images? all my sites except one have product urls and images indexed, one site is only product urls .... or is this a Google thing?

shags38:

does Sitemap xml have any influence in Google indexing images? all my sites except one have product urls and images indexed, one site is only product urls .... or is this a Google thing?

I do sitemaps almost only for Google (with cron job) and I belive as many others that
it helps SEO a lot.

Now I see you asked about images....
So...does Sitemap xml have any influence in Google indexing images? :D

shags38:

does Sitemap xml have any influence in Google indexing images? all my sites except one have product urls and images indexed, one site is only product urls .... or is this a Google thing?

Have you checked your robots.txt file to be sure images are not being blocked?

gunni:

I do sitemaps almost only for Google (with cron job) and I belive as many others that
it helps SEO a lot.

Now I see you asked about images....
So...does Sitemap xml have any influence in Google indexing images? :D
The sitemap is only a tool for Google and others to make it easier to find your stuff. Pages and images get index (or not) with or without a sitemap, once a search engines knows your site is on the web.

jeking:

Have you checked your robots.txt file to be sure images are not being blocked?

Hi Jim and thanks for your response - there is nothing in robots text blocking images.

As you are aware Images folder is in the root and I doubt that Googlebot would index every image in the folder as it contains all manner of images so I can only assume that Googlebot will index images from the Products pages - so I don't know if there is any instructions in the sitemapproducts.xml telling Googlebot to look specifically for images in the products sitemap - I somehow doubt it but it is strange that normally images show up in Google Webmaster Tools in sitemaps in addition to url's with a graph showing how many submitted and how many indexed. This is happening as it should with 5 of 6 of my sites but not with one in particular - only url's submitted/indexed - no mention of images at all.

Any ideas?

cheers, Mike

hello, just playing around with the news box, (read that you haven't look at it for a decate) and found what actually caused the problem. it's the name of a table which has changed. so I corrected the table name to reflect the db

from this

 $last_date = $db->Execute("SELECT MAX(GREATEST(news_added_date, IFNULL(news_modified_date, '0001-01-01 00:00:00'), news_published_date)) AS last_date

to this

$last_date = $db->Execute("SELECT MAX(GREATEST(n.news_added_date, IFNULL(n.news_modified_date, '0001-01-01 00:00:00'), n.news_start_date)) AS last_date

now it does not longer throw an error, but no data is written to the xml file

the result is

XML Parsing Error: no root element found
Location: https://xxxxxxxxxxxx/sitemap/sitemapboxnews.xml
Line Number 1, Column 1:

any idea where to look now?

thanks for reading.

Hi all,

I'm trying to install SitemapXML on an existing site running zencart 1.55e. The problem i'm facing has already been reported a couple of page back but not the cause nor the solution (the solution given was simply reinstall on a fresh 1.55e install, but i cannot do it).
In a few words, installed SitemapXML (renamed admin directory and copied all the stuff, all went good). Under Configuration the menu show correctly with all the options.

Under Tools the menu shows, if i enter It there is the Button "Upgrade SitemapXML SQL", pressing it runs the script and all seems ok (like in the pictures posted before) but no changes in the page, simply it show anly the button.
Maybe it is something related to the database, even if the script seems to work it really doesnt do anything... no error log.. nothing so i'm quite in a dire situation...
What should the script do? Is ther a way to do it manually (to test it)?

Any help would be appreciated

Best Regards.

Zencart 1.55e
SitemapXML 3.95
MySQL 5.5.57
Version PHP: 5.6.31

Not sure if this should be here but wasn't sure where else to put it.
I have SiteMapXml setup and it is working but every time I try to run a Cron job, via Bluehost, using the different examples given I always get an error back via email stating:

"/bin/sh: 5: command not found"

The last Cron job command line was as follows:

5 * * * curl -s 'http://www.wildsteedworx.com/index.php?main_page=sitemapxml&rebuild=yes&ping=yes'

I have tried all the examples but I am new at this so I don't fully understand it yet.
To have update sitemaps and automatically notify crawlers, you will need to set up a Cron job via your host's control panel.
To run it as a cron job (at 5:0am like you wanted), put in your crontab something like the following:
"0 5 * * * GET 'http://your_domain/index.php?main_page=sitemapxml&rebuild=yes&ping=yes'
or
0 5 * * * wget -q 'http://your_domain/index.php?main_page=sitemapxml&rebuild=yes&ping=yes' -O /dev/null
or
0 5 * * * curl -s 'http://your_domain/index.php?main_page=sitemapxml&rebuild=yes&ping=yes'
or
0 5 * * * php -f <path to shop>/cgi-bin/sitemapxml.php rebuild=yes ping=yes"

Any assistance would be greatly appreciated.

Thank You

ZC-1.5.5e, PHP 5.6.32, Database patch level 1.5.5

I'm getting the following error:

[14-Dec-2017 05:00:01 America/Denver] Request URI: /mysite/index.php?main_page=sitemapxml&rebuild=yes\ping=yes, IP address: 173.254.47.110
#1 mysqli_free_result() called at [/home2/sub/public_html/mysite/includes/modules/pages/sitemapxml/sitemapxml_products.php:122]
#2 include(/home2/sub/public_html/mysite/includes/modules/pages/sitemapxml/sitemapxml_products.php) called at [/home2/sub/public_html/mysite/includes/templates/template_default/sitemapxml/tpl_main_page.php:21]
#3 require(/home2/sub/public_html/mysite/includes/templates/template_default/sitemapxml/tpl_main_page.php) called at [/home2/sub/public_html/mysite/index.php:97]

[14-Dec-2017 05:00:01 America/Denver] PHP Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, null given in /home2/sub/public_html/mysite/includes/modules/pages/sitemapxml/sitemapxml_products.php on line 122

All of the sitemap files seem to be generated without any other problems.

Any help would be appreciated

ZC-1.5.5e, PHP 5.6.32, Database patch level 1.5.5
Resoled the previous issue (curl error)but now getting another log error.

Where is the above request coming from? The error is reproduced every time with that address entered into a browser.
If this address is used, no errors: /xxx/sitemap.xml

Same here, on
ZC 1.5.5e,
PHP 7.0.22-0ubuntu0.16.04.1 (Zend: 3.0.0)
MySQL 5.7.20-0ubuntu0.16.04.1
MySQL Mode: STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

Keeps giving the upgrade button, does the upgrade (at least says so) and back to the upgrade button.

Anyone have a fix ?

Same problem as above in post #1857. Anyone have a fix?

Using Zen 1.55e
XMLsitemap 3.95

fjbern1943:

Same problem as above in post #1857. Anyone have a fix?

Using Zen 1.55e
XMLsitemap 3.95

Fix is in post #1800
File is in your admin directory

Hi,

mikebr:

ZC-1.5.5e, PHP 5.6.32, Database patch level 1.5.5

I'm getting the following error:

[14-Dec-2017 05:00:01 America/Denver] Request URI: /mysite/index.php?main_page=sitemapxml&rebuild=yes\ping=yes, IP address: 173.254.47.110
#1 mysqli_free_result() called at [/home2/sub/public_html/mysite/includes/modules/pages/sitemapxml/sitemapxml_products.php:122]
#2 include(/home2/sub/public_html/mysite/includes/modules/pages/sitemapxml/sitemapxml_products.php) called at [/home2/sub/public_html/mysite/includes/templates/template_default/sitemapxml/tpl_main_page.php:21]
#3 require(/home2/sub/public_html/mysite/includes/templates/template_default/sitemapxml/tpl_main_page.php) called at [/home2/sub/public_html/mysite/index.php:97]

[14-Dec-2017 05:00:01 America/Denver] PHP Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, null given in /home2/sub/public_html/mysite/includes/modules/pages/sitemapxml/sitemapxml_products.php on line 122

All of the sitemap files seem to be generated without any other problems.

Any help would be appreciated

Quick bug fix:
File includes/modules/pages/sitemapxml/sitemapxml_products.php
Find

mysqli_free_result($products->resource);

Replace by

//mysqli_free_result($products->resource);

a_berezin:

Hi,

Quick bug fix:
File includes/modules/pages/sitemapxml/sitemapxml_products.php
Find

mysqli_free_result($products->resource);

> Replace by
> ```
//mysqli_free_result($products->resource);

Could go a little further with moving a few lines into the code bracket:

Changing:

  $sitemapXML->SitemapClose();
}
mysqli_free_result($products->resource);
unset($products);
unset($catsArray);

to:

  $sitemapXML->SitemapClose();
  mysqli_free_result($products->resource);
  unset($products);
}
unset($catsArray);

The variable $products is only set within that if statement group and therefore regarding the mysqli_free_result there wouldn't be anything to free if $sitemapXML->SitemapOpen('products', $last_date) returns false.

It seems that some of my disabled products are included in the sitemap. Is this normal?