SitemapXML v.2

Hi Isaacola,

Quote:

---

Originally Posted by BlessIsaacola

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.

Quote:

---

Originally Posted by a_berezin

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!

Quote:

---

Originally Posted by BlessIsaacola

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

---

No. I take ALL manufacturers from the tables:

Code:

---

    $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?

Quote:

---

Originally Posted by BlessIsaacola

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.

Quote:

---

Originally Posted by a_berezin

No. I take ALL manufacturers from the tables:

Code:

---

    $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.

Quote:

---

Originally Posted by BlessIsaacola

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.

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

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

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!

Quote:

---

Originally Posted by marauders56

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?

Why edit is disabled is beyond me...

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

worked for me - thanks again!