SitemapXML v.2

diamond1:

Thanks

Is there something ready, I do not know program.

Sincerelyno.. but if this something you need/want and do not have the skill set to create it yourself you may have to hire an developer to create it for you..

diamond1:

I do not know program.
You can manually do it. Or use a third party service. If you can afford to spend on it's own time.

Do you know someone who can do it? I do not cost much?

I am using the latest version of SitemapXML. The issue I am having is that sitemapproducts.xml is not generated completely, I have about 18k products, the file ends around 1k. Please any idea on how to resolve this issue? Thanks.

saderogba:

I am using the latest version of SitemapXML. The issue I am having is that sitemapproducts.xml is not generated completely, I have about 18k products, the file ends around 1k. Please any idea on how to resolve this issue? Thanks.

One of two options: either the memory is not enough or time restrictions. In directory cach/logs there are any messages?

Thanks for your response. I don't see any information in the log or cache folder. In either case please what do you recommend to fix this problem? I am launching daily using this format **curl -s 'http://your_domain/index.php?main_page=sitemapxml&rebuild=yes&ping=yes' **

saderogba:

Thanks for your response. I don't see any information in the log or cache folder. In either case please what do you recommend to fix this problem? I am launching daily using this format **curl -s 'http://your_domain/index.php?main_page=sitemapxml&rebuild=yes&ping=yes' **

I don't use http for this task - only CLI interface. The http-interface has additional restrictions.

how much memory should this script need to run??

I keep getting php memory errors when producing sitemaps when i have a vps with 4gb of available ram (unsused ram)

php config memory set to -1 so should be able to use all the ram....

[27-Jun-2014 17:34:23 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select p.products_id, p.master_categories_id
from products p
where p.products_id = '3814' limit 1 in /home/***/public_html/includes/classes/db/mysql/query_factory.php on line 120
[27-Jun-2014 17:34:23 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count() as total
from sessions
where sesskey = 'a21e966c4fea93934404bd9335450509' in /home//public_html/includes/classes/db/mysql/query_factory.php on line 120

how ever i can get the sitemaps to produce with no issue if CEON URL plugin is turned off.

kitcorsa:

how much memory should this script need to run??

I keep getting php memory errors when producing sitemaps when i have a vps with 4gb of available ram (unsused ram)

php config memory set to -1 so should be able to use all the ram....

[27-Jun-2014 17:34:23 Europe/London] PHP Fatal error: 2008:MySQL client ran out of memory :: select p.products_id, p.master_categories_id
from products p
where p.products_id = '3814' limit 1 in /home/***/public_html/includes/classes/db/mysql/query_factory.php on line 120
[27-Jun-2014 17:34:23 Europe/London] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count() as total
from sessions
where sesskey = 'a21e966c4fea93934404bd9335450509' in /home//public_html/includes/classes/db/mysql/query_factory.php on line 120

how ever i can get the sitemaps to produce with no issue if CEON URL plugin is turned off.

It's a MEMORY LEAK ERROR.. has NOTHING to do with your VPS or the amount of memory you have configured.. See the responses in the Ceon URI post on how to address..

Hi Diva,

DivaVocals:

It's a MEMORY LEAK ERROR.. has NOTHING to do with your VPS or the amount of memory you have configured.. See the responses in the Ceon URI post on how to address..
Thanks for your support :)

I don't use http for this task - only CLI interface. The http-interface has additional restrictions.

Please can you demonstrate how to use the CLI interface via cron? Thank you very much for your help.

saderogba:

I don't use http for this task - only CLI interface. The http-interface has additional restrictions.

> 
> Please can you demonstrate how to use the CLI interface via cron? Thank you very much for your help.

Exactly as written in the example in the README:

28 03 * * * /usr/local/bin/php -f /home/xxxxxxxxxx/data/www/site.com/cgi-bin/sitemapxml.php rebuild=yes ping=yes

But you must understand that the format of the command and the file path is specific to each hosting!!! It is therefore necessary to consult with the support of your hoisting.

Thanks. The CLI interface works great.

Hi,

saderogba:

Thanks. The CLI interface works great.
Excellent! I am glad that my advice helped.

Version 5.1
Hey all, I just installed and I get the following...

Any help would be great! Thanks.

dxxxxmed.com (replace x's with o's

doooomed:

Version 5.1
Hey all, I just installed and I get the following...

Any help would be great! Thanks.

Have you set the sitemap directory setting from the configuration?
Admin->Configuration->Sitemap XML->Sitemap Directory

If you have, then check the permissions on those files to make sure they are writable by the server.

weif:

Have you set the sitemap directory setting from the configuration?
Admin->Configuration->Sitemap XML->Sitemap Directory

If you have, then check the permissions on those files to make sure they are writable by the server.

Thanks for the reply. I do not have Sitemap XML->Sitemap Directory under config.

doooomed:

Thanks for the reply. I do not have Sitemap XML->Sitemap Directory under config.

From Tools->Sitemap XML, what version of Sitemap XML do you have installed?

weif:

From Tools->Sitemap XML, what version of Sitemap XML do you have installed?

No sitemap XML under tools either...

It is version 2.1 though

doooomed:

No sitemap XML under tools either...

It is version 2.1 though

the current version of Sitemap XML is 3.2.12 available from http://www.zen-cart.com/downloads.php?do=file&id=367

Check that you have the current version and that you installed correctly. You should have this entry in the tools menu and in the configuration menu in ZC 1.5.1

Your output looks like you just don't have the plugin configured, and possibly not completely installed...