SitemapXML v.2

[schoolboy]

It is better to ask Godaddy.

It's actually better to LEAVE GoDaddy

[masterrusty]

It's actually better to LEAVE GoDaddy

That is probably true, especially since they are not being any more help than a_berezin is at this point.

I am experiencing the typical finger pointing crap that you get when you try to operate one system on another person's system. GoDaddy is now telling me that the script is failing.

I wish someone would at least attempt to provide a functional solution rather than just place blame. Solutions are so much more peaceful, and pleasant.

BTW - I have no reason to believe that leaving Godaddy would solve anything at this point because the cron job doesn't work, and therefore, it probably won't work anywhere else.

[nuganics]

Hi Andrew and others,
Great addon.

I currently have thousands of products listed.

I have the below issue:

2/ I keep getting the below error. I am on Hostgator reseller. I have selected compress sitemap and tired uncompressed also.
Products Sitemap

WARNING: An Error occurred, please refresh the page and try again.

Running version 3.2.6 17.06.2012 16:13 on zen cart 1.5.1. Any help/ideas will be much appreciated.

Kind regards
Tim

[nuganics]

I looked in the log and found the below for this error.

[12-Dec-2012 23:36:12] PHP Fatal error: 0: :: select products_type from zen_products where products_id = '72519' in /home/XXXX/public_html/includes/classes/db/mysql/query_factory.php on line 120
[12-Dec-2012 23:36:12] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from zen_sessions
where sesskey = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' in /home/XXXX/public_html/includes/classes/db/mysql/query_factory.php on line 120

[a_berezin]

Hi Tim,

I looked in the log and found the below for this error.

[12-Dec-2012 23:36:12] PHP Fatal error: 0: :: select products_type from zen_products where products_id = '72519' in /home/XXXX/public_html/includes/classes/db/mysql/query_factory.php on line 120
[12-Dec-2012 23:36:12] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from zen_sessions
where sesskey = 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' in /home/XXXX/public_html/includes/classes/db/mysql/query_factory.php on line 120

Looks like it's the limitations of your hosting.
Sitemap XML - a heavy script, a lot of requests to the database. If you use SEO URL, the number of requests has grown significantly.
If you use images urls generation in the sitemap and you have installed IH, then the server load increases significantly.

[nuganics]

Hi Andrew,
Thanks for the reply. I don't use SEO URL/image urls or IH. It does about 16,000 urls but that is about half. Maybe have a option to split sitemap into 10,000 urls then it reloads to avoid the timeout or maybe use the code in big dump http://www.ozerov.de/bigdump/ that breaks it into parts on the file and reloads so timeouts can be avoided. It won't put as much stress on larger servers also as I guess some people run the cron frequently. I can't really afford to upgrade again so would a donation help to get this feature added and if so how much?
Kind regards
Tim

[a_berezin]

Hi Tim,

It does about 16,000 urls but that is about half. Maybe have a option to split sitemap into 10,000 urls then it reloads to avoid the timeout

No, and not planned - a big store requires a lot of resources, a powerful server that sitemap is working properly. You - the first who tells me about such problems.
There were problems with memory allocation for a large number of goods. To solve this problem was added option Check Dublicates. Try to set it:
Check Dublicates = mysql

It won't put as much stress on larger servers also as I guess some people run the cron frequently.

It makes no sense to frequently update sitemap by cron. Just once, at night.

[masterrusty]

After a bit of trial and error, and a post to a Linux forum, I have the answer to the failed cron command. Apparaently it was as simple as removing the double quotes (") that Godaddy says to use in a cron command. The correct command is:

/web/cgi-bin/php5 /[path to home]/cgi-bin/sitemapxml.php rebuild=yes ping=yes token=xxxxx

Person who helped me on the Linux Forum didn't know this script, or that I was using Godaddy. They just knew what they were doing a little more than some other people.

[nuganics]

Hi Andrew,
I tried mysql for duplicates and turning it to false but no luck. I decided to time a forced sitemap and the script seems to stop after about 8 seconds. I guess there is mysql limits (connection time and memory) that I am reaching. I don't have access to change these. I'll think i'll stick with the products I have in the sitemap and save up for a vps.

Cheers
Tim

[nuganics]

Hi Andrew,
I installed Xampp locally and imported the database. I then find and replace localhost with my url and ftp up the xml. Worked great.

Cheers
Tim