It's actually better to LEAVE GoDaddyQuote:
Originally Posted by a_berezin
Printable View
It's actually better to LEAVE GoDaddyQuote:
Originally Posted by a_berezin
That is probably true, especially since they are not being any more help than a_berezin is at this point.Quote:
Originally Posted by schoolboy
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.
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
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
Hi Tim,
Looks like it's the limitations of your hosting.Quote:
Originally Posted by nuganics
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.
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
Hi Tim,
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.Quote:
Originally Posted by nuganics
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 makes no sense to frequently update sitemap by cron. Just once, at night.Quote:
Originally Posted by nuganics
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.:P
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
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