SitemapXML v.2

[danielosko]

Hello everyone,

Just did a clean install of Zen-Cart 1.5.4 and installed Sitemap XML (version 21 and Module version 3.2.13). However, no matter how I set up the includes/classes/sitemapxml.php file..., I can only create a maximum of about 12,500 products in my sitemapproducts.xml file. (I actually have around 30,000 products)

define('TABLE_SITEMAPXML_TEMP', DB_PREFIX . 'sitemapxml_temp');
define('SITEMAPXML_MAX_ENTRYS', 5000);
define('SITEMAPXML_MAX_SIZE', 10000000); // 10485760

define('SITEMAPXML_CHECK_URL', 'false');

Also my php.ini file seems to have enough memory and execution time..., and also does change anything.

max_execution_time = 300
max_input_time = 180
memory_limit = 512M

Here is the result I get in my Sitemap File List:


Here is the result after forcing a rebuild:
(however I have over 800 categories, not 640, unless not all of the categories are showing up because not all of the products are being listed)


Here is the result of my log file:

[11-Dec-2015 08:52:43 America/Chicago] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_type from products where products_id = '12441' ==> (as called by) /home4/oskopool/public_html/includes/functions/functions_lookups.php on line 522 <== in /home4/oskopool/public_html/includes/classes/db/mysql/query_factory.php on line 155
[11-Dec-2015 08:52:43 America/Chicago] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = '147d0a2b7e06aa68ea26b7ce12d9f9fd' ==> (as called by) /home4/oskopool/public_html/includes/functions/sessions.php on line 66 <== in /home4/oskopool/public_html/includes/classes/db/mysql/query_factory.php on line 155

Any ideas? Anyone?
Thanks all,
Danny

[a_berezin]

Hi,

Here is the result of my log file:

[11-Dec-2015 08:52:43 America/Chicago] PHP Fatal error: 2008:MySQL client ran out of memory :: select products_type from products where products_id = '12441' ==> (as called by) /home4/oskopool/public_html/includes/functions/functions_lookups.php on line 522 <== in /home4/oskopool/public_html/includes/classes/db/mysql/query_factory.php on line 155
[11-Dec-2015 08:52:43 America/Chicago] PHP Fatal error: 2013:Lost connection to MySQL server during query :: select count(*) as total
from sessions
where sesskey = '147d0a2b7e06aa68ea26b7ce12d9f9fd' ==> (as called by) /home4/oskopool/public_html/includes/functions/sessions.php on line 66 <== in /home4/oskopool/public_html/includes/classes/db/mysql/query_factory.php on line 155

I recently ran into this situation on site with 30,000 products. The reason - the query caching. Write to me in private, I'll send you the latest version.

[danielosko]

Thanks Andrew!!!

I appreciate it very much. I PM'd you

Danny

[Michigan Flower Farm]

I just want to say thank you for this awesome plugin and all your work here in the forum. I got SitemapXML installed and functioning with all the help here. My biggest problems were an error in my config file and expecting the updates to Cpanel to be immediate - sometimes it takes a few seconds. In the meantime it was throwing errors at me.

Thank you so much!

[frank18]

Hi,

I recently ran into this situation on site with 30,000 products. The reason - the query caching. Write to me in private, I'll send you the latest version.

Andrew, could you please pm me a copy of the latest version or upload it to the Plugins?

Thanks / Frank

[a_berezin]

Hi Frank,

Andrew, could you please pm me a copy of the latest version or upload it to the Plugins?

Thanks / Frank

Upload last version to the Plugins.

[frank18]

Hi Frank,

Upload last version to the Plugins.

Thanks Andrew! Much appreciated.

[a_berezin]

Hi,

I just want to say thank you for this awesome plugin and all your work here in the forum.

Thanks!
Happy New Year! :)

[a_berezin]

Thanks Andrew! Much appreciated.

I look forward to feedback - bugs, suggestions, comments...

[carlwhat]

andrew,
i had basically no problems with the install... i had to modify a few things due to my cart and other mods, but so far so good....

HOWEVER, i wanted to point out something that just caused me some problems.... and in my opinion very needlessly...

part of the install process has a file called:

-install-sitemapxml.php

now i suppose you have your reasons why you would want a file to start with a dash, ie '-' perhaps you would care to share them? it causes problems if one is attempting to execute a shell command from the directory where that file is.

frankly, i would rename that file so that it does not begin with a dash.

best.