SitemapXML v.2

[a_berezin]

Hi Isaacola,

Thanks Andrew for this upgrade! I installed Version 3.0.2 and everything went well as expected except for the sitemap generation. When the sitemapmanufacturers.xml is generated it's only showing 434 manufacturers even though we have more than 3,000+ I am not sure how to troubleshoot this issue.

Thanks!

Very strange. I even can not be assumed in what could be the problem. There's so simple that there is nothing to break.

If possible, I could see and solve the problem on this site.
Of course to do that I need ftp access.

[BlessIsaacola]

Hi Isaacola,


Very strange. I even can not be assumed in what could be the problem. There's so simple that there is nothing to break.

If possible, I could see and solve the problem on this site.
Of course to do that I need ftp access.

I guess another question is in generating manufacturer is the query limited by product type? I know that music product type usually doesn't have manufacturer (but we actually populated our manufacturer field for the music product type (for a functionality that we needed on our site a while back). If the query is based on product type, that might explain the issue I am having.

If this is not the case I can email you a temporary ftp access for troubleshooting purpose but I will need you to email me your IP address since our server access is restricted by IP address.

Thanks!

[a_berezin]

I guess another question is in generating manufacturer is the query limited by product type?

No. I take ALL manufacturers from the tables:

    $manufacturers = $db->Execute("SELECT m.manufacturers_id, GREATEST(m.date_added, IFNULL(m.last_modified, '0001-01-01 00:00:00')) AS last_date, mi.languages_id
                              FROM " . TABLE_MANUFACTURERS . " m
                                LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi ON (mi.manufacturers_id = m.manufacturers_id)
                              WHERE mi.languages_id IN (" . $zen_SiteMapXML->getLanguagesIDs() . ") " .
                              (SITEMAPXML_MANUFACTURERS_ORDERBY != '' ? "ORDER BY " . SITEMAPXML_MANUFACTURERS_ORDERBY : ''));

By the way, what value have SITEMAPXML_MANUFACTURERS_ORDERBY ?

Have you check /cache/myDEBUG-*.log files?

If this is not the case I can email you a temporary ftp access for troubleshooting purpose but I will need you to email me your IP address since our server access is restricted by IP address.

I have dynamic IP's and use DynDns.com service for it.

[BlessIsaacola]

No. I take ALL manufacturers from the tables:

    $manufacturers = $db->Execute("SELECT m.manufacturers_id, GREATEST(m.date_added, IFNULL(m.last_modified, '0001-01-01 00:00:00')) AS last_date, mi.languages_id
                              FROM " . TABLE_MANUFACTURERS . " m
                                LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi ON (mi.manufacturers_id = m.manufacturers_id)
                              WHERE mi.languages_id IN (" . $zen_SiteMapXML->getLanguagesIDs() . ") " .
                              (SITEMAPXML_MANUFACTURERS_ORDERBY != '' ? "ORDER BY " . SITEMAPXML_MANUFACTURERS_ORDERBY : ''));

By the way, what value have SITEMAPXML_MANUFACTURERS_ORDERBY ?

Have you check /cache/myDEBUG-*.log files?


I have dynamic IP's and use DynDns.com service for it.

The SITEMAPXML_MANUFACTURERS_ORDERBY is last_date DESC

No error in the log at the moment.

[a_berezin]

The SITEMAPXML_MANUFACTURERS_ORDERBY is last_date DESC

No error in the log at the moment.

Then there is only one way - debug on the site.

[a_berezin]

Version 3.0.3 is available for download - http://www.zen-cart.com/index.php?ma...roducts_id=544

[marauders56]

How do I get this to work having it export my URL's from MagicSEO ?

[noKnots]

It looks like you may be missing a ? in readme.txt, Tips:

0 5 * * * php -f <path to shop>/cgi-bin/sitemapxml.php rebuild=yes

Thank you for this!

[a_berezin]

How do I get this to work having it export my URL's from MagicSEO ?

You use MagicSEO and links in sitemap is not SEO?

[noKnots]

Why edit is disabled is beyond me...

GET 'http://your_domain/index.php?main_page=sitemapxml'

worked for me - thanks again!