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