SitemapXML v.2

UPDATE - sitemap is producing images with a url that includes the 'large' images folder and suffix but the images are not in that folder (or a sub-folder of it) so AGAIN Google cannot find the images from the submitted sitemap to be able to index them.

/images/large/tol/clip-on-earrings-419**_LRG**.gif
should be
/images/tol/clip-on-earrings-419.gif

website treeoflifejewellery dot com

This is happening on 2 of 5 sites that were all upgraded from 1.5.1 to 1.5.5f and sitemap version 3.9.5

Any ideas on a fix for this please?

cheers,
Mike

For trial purposes I have switched off USU on one site - Google will now be able to find the url's in that sitemap - not sure what may happen with existing ranking though, it is likely to be affected adversely but I have to try something.

cheers,
Mike

I just installed the curren version of SitemapXml on my Zencart 1.5.6. When I run it i get the following in the Bing Ping.

Ping Bing

http://www.bing.com/webmaster/ping.aspx?siteMap=http%3A%2F%2Ftennesseetraditionalflies.com%2Fv156%2Fsitemap.xml
Благодарим ви за изпращането на вашата карта на сайт . Присъединете се към Инструменти на Bing за уеб администратори, за да прегледате състоянието на вашите карти на сайт и още отчети за това как се справяте в Bing.
Total: Execution Time 0:0.8180, DB Queries 238, DB Queries Time 0.085.

Does anyone know what might be causing this?

I meant to mention that I am getting Russian instead of English but just in the Bing Ping the Google Ping is fine.

I have not actually looked at the files, but since the developer is Russian (or something close). It is possible that the English language files may contain some untranslated text. You can use the developers toolkit to search for (pieces of) the string

jodean:

I meant to mention that I am getting Russian instead of English but just in the Bing Ping the Google Ping is fine.

Zencart 1.5.6

I am receiving the following warning in my log file and how do I fix it?

[30-Dec-2018 15:17:23 CST6CDT] PHP Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, null given in /home/tennes60/public_html/v156/includes/modules/pages/sitemapxml/sitemapxml_products.php on line 122

The fix is post #1860

Pieces of the string not found. Deleted the Russian folders and still getting the Bing Ping Message in Russian.

How do i find post #1860?

jodean:

How do i find post #1860?
This is the link https://www.zen-cart.com/showthread.php?126810-SitemapXML-v-2&p=1339804#post1339804
You can see the post number on the upper right af a post like #1234

Hello

I modified my site to https. All seems to be ok. The only thing i have discovered is that the different sitemap files contain still the http links and not the https links.

Any idea what could be causing this?

Thank you

hbhorses:

Hello

I modified my site to https. All seems to be ok. The only thing i have discovered is that the different sitemap files contain still the http links and not the https links.

Any idea what could be causing this?

Thank you
What was done to make your site https?

mc12345678:

What was done to make your site https?

HTTPS certificate has been installed at hosting level.
I modified the configuration files and enabled https.

Site is https://www.hbhorses.be

hbhorses:

HTTPS certificate has been installed at hosting level.
I modified the configuration files and enabled https.

Site is https://www.hbhorses.be
While I could go look at the site and probably identify what had been changed, it helps to hear it from the source. What changes were made in the includes/configure.php file. What was added or mosified?

hbhorses:

Hello

I modified my site to https. All seems to be ok. The only thing i have discovered is that the different sitemap files contain still the http links and not the https links.

Any idea what could be causing this?

Thank you

hbhorses:

HTTPS certificate has been installed at hosting level.
I modified the configuration files and enabled https.

Site is https://www.hbhorses.be

mc12345678:

While I could go look at the site and probably identify what had been changed, it helps to hear it from the source. What changes were made in the includes/configure.php file. What was added or mosified?
Not seeing a response (possibly late localy), went to site. Looks like the value of ENABLE_SSL was set to 'true' and that was all that was changed. To get your sitemap records to point to the https: version of the links, the software (not just sitemap) needs to consider that all links are to be https not just the ones where action should be taken to protect information. That is covered in this FAQ if you read to the bottom: https://www.zen-cart.com/content.php?56-how-do-i-enable-ssl-after-i-have-installed-zen-cart

Effectively need to modify HTTP_SERVER to begin with https:.

I am geeeting this in log file

PHP Fatal error: 1054:Unknown column 'SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY' in 'order clause' ::

PHP Warning: Use of undefined constant SITEMAPXML_CHECK_DUPLICATES - assumed 'SITEMAPXML_CHECK_DUPLICATES'

php 1.5.6.a and php 7.2

Please help

diptimoy:

I am geeeting this in log file

PHP Fatal error: 1054:Unknown column 'SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY' in 'order clause' ::

PHP Warning: Use of undefined constant SITEMAPXML_CHECK_DUPLICATES - assumed 'SITEMAPXML_CHECK_DUPLICATES'

Did you upload all the files that need to be uploaded?
Before you uploaded files, did you remember to change the name of the "YOUR_Admin" folder to whatever your admin login folder is named?

This is defined in /YOUR_Admin/includes/languages/english/sitemapxml.php - but if you forgot to rename "YOUR_Admin" before uploading, it is not in the right place. Without that file, you will generate these errors.

The english file has

define('CFGTITLE_SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY', 'Products Reviews - order by');

define('CFGTITLE_SITEMAPXML_CHECK_DUPLICATES', 'Check Duplicates');
define('CFGDESC_SITEMAPXML_CHECK_DUPLICATES', 'true - check duplicates,<br />mysql - check duplicates using mySQL (used to store a large number of products),<br />false - don't check duplicates');

diptimoy:

PHP Fatal error: 1054:Unknown column 'SITEMAPXML_PRODUCTS_REVIEWS_ORDERBY' in 'order clause' ::

PHP Warning: Use of undefined constant SITEMAPXML_CHECK_DUPLICATES - assumed 'SITEMAPXML_CHECK_DUPLICATES'

Looking into this further, it looks like there may be an error or omission in
/YOUR_ADMIN/includes/modules/sitemapxml_install.php

I am not receiving this error, but I am receiving a similar error that TABLE_SITEMAPXML_EXTRAURLS is not defined.

One thing I did find is that on line 24 and 25, it appears that SITEMAPXML_CHECK_DUPLICATES is spelled SITEMAPXML_CHECK_DUBLICATES (note the "B" instead of the "P"). I don't know if this is the cause of the error, or if it is even actually an error.

However, this file appears to both define the variables you are running into errors with, and be the only references I am finding to those variable names...

Regarding url rewriters...

Native url: https://www.site.com/index.php?main_page=product_info&cPath=1_5_1847&products_id=2309
Friendly url: https://www.site.com/widgets/widget1

I would have thought the best option would be to always submit the native url (doesn't change) instead of the friendly url, to avoid links becoming obsolete with minor name changes, which I do often.

What does the panel think?