SitemapXML v.2

[showren]

Hi lat9,

Thank you for your prompt response! I have followed your suggestion and successfully resolved the issue in SitemapXML v4.0.4. Here’s what I did:

1. Modifying init_sitemapxml.php
I located the SITEMAPXML_EZPAGES_ORDERBY configuration in:
/YOUR_Admin/includes/init_includes/init_sitemapxml.php

Originally, it was set as:

'SITEMAPXML_EZPAGES_ORDERBY' => [
'EZPages order by',
'p.sidebox_sort_order ASC, p.header_sort_order ASC, p.footer_sort_order ASC',
'',
60,
null,
null
],
To fix the issue, I removed the redundant ASC and updated it as:

'SITEMAPXML_EZPAGES_ORDERBY' => [
'EZPages order by',
'p.sidebox_sort_order, p.header_sort_order, p.footer_sort_order',
'',
60,
null,
null
],
2. Adjusting the ORDER BY Processing Logic
In init_sitemapxml.php, the following logic was present:

$order_by_elements = explode(',', str_replace(' ', '', SITEMAPXML_EZPAGES_ORDERBY));
foreach ($order_by_elements as $i => $element) {
if (strpos($element, 'p.') !== 0 && strpos($element, 'pt.') !== 0) {
$order_by_elements[$i] = 'p.' . $element;
}
}
$order_by = implode(', ', $order_by_elements);
This was removing all spaces, potentially causing ORDER BY p.sidebox_sort_orderASC (without a space).

To prevent this, I modified the logic:

$order_by_elements = explode(',', SITEMAPXML_EZPAGES_ORDERBY);
foreach ($order_by_elements as $i => $element) {
$element = trim($element); // Ensure spaces are preserved
if (strpos($element, 'p.') !== 0 && strpos($element, 'pt.') !== 0) {
$order_by_elements[$i] = 'p.' . $element;
}
}
$order_by = implode(', ', $order_by_elements);
Now, the ORDER BY clause correctly formats its output.

3. Updating the Database Configuration
Since Zen Cart saves configuration settings in the database, I executed the following SQL query to update the SITEMAPXML_EZPAGES_ORDERBY value:

UPDATE configuration
SET configuration_value = 'p.sidebox_sort_order, p.header_sort_order, p.footer_sort_order'
WHERE configuration_key = 'SITEMAPXML_EZPAGES_ORDERBY';
This ensures that existing settings do not retain the incorrect ASC formatting.

4. Testing and Verifying
Cleared the Zen Cart cache via Admin Panel (Tools → Template Cache → Reset).
Rebuilt the Sitemap using:

https://*******/index.php?main_page=...ml&rebuild=yes
Checked error logs (php_error.log & myDEBUG*.log), confirming that the MySQL 1054 Unknown Column error was resolved.
Everything is now working smoothly!
Thanks again for your guidance—I appreciate your continued support in maintaining and improving Zen Cart.

Best regards,
Showren

[generikz]

Checked error logs (php_error.log & myDEBUG*.log), confirming that the MySQL 1054 Unknown Column error was resolved.
Everything is now working smoothly!

PHP Fatal error: MySQL error 1054: Unknown column 'p.sidebox_sort_orderASC' in 'order clause'

I had the same issue and the fix above worked for me as well, thanks!

Julien

[wmorris]

If I am not mistaken that this mode will get your products and website to all 3 major search engines like (Google, Yahoo and Bing).

[lat9]

If I am not mistaken that this mode will get your products and website to all 3 major search engines like (Google, Yahoo and Bing).

The plugin creates a collection of sitemap files which, if pointed to by the site's robots.txt file, can be found by all search engines.

[nicksab]

Using 4.0.3 with ZC 2.0.1,

Is it possible to have this plugin add all the EZ pages added to the corresponding sitemap file (i.e sitemap/sitemapezpages.xml )?

Most of my EZ pages are set as visible but are not active in footer, header or sidebox. The reason for that is for the EZ pages to be accessible via direct link but not necessarily showing in footer, sideboxes or header.

Because of this, Sitemap does not include the extra EZ pages to the file.

Of course, i could turn on all the ezpages in footer, rebuild the sitmeap then turn off the ezpages in footer. However, this is becoming a bit tedious.

Is there a way to have Sitemap includes the EZ-page as long as they are set to visible?

Hope my question makes sense and thank you for your help

[Shop Suey]

is sort order >0?

[lat9]

Using 4.0.3 with ZC 2.0.1,

Is it possible to have this plugin add all the EZ pages added to the corresponding sitemap file (i.e sitemap/sitemapezpages.xml )?

Most of my EZ pages are set as visible but are not active in footer, header or sidebox. The reason for that is for the EZ pages to be accessible via direct link but not necessarily showing in footer, sideboxes or header.

Because of this, Sitemap does not include the extra EZ pages to the file.

Of course, i could turn on all the ezpages in footer, rebuild the sitmeap then turn off the ezpages in footer. However, this is becoming a bit tedious.

Is there a way to have Sitemap includes the EZ-page as long as they are set to visible?

Hope my question makes sense and thank you for your help

Your question does make sense. I've created a GitHub issue (https://github.com/lat9/sitemapxml/issues/57) to track the change.

is sort order >0?

@nicksab is requesting that otherwise-hidden EZ-Pages be included in the sitemap. Those pages are displayed on the storefront so long as the page is defined in the admin, even though its footer/header/sidebox status causes it not to be displayed as a link on the site.

[nicksab]

is sort order >0?

sort order does seem to change anything unfortunately. If any header/sidebox/footer are off, sitemap plugin won't pick it up regardless of sort order

[nicksab]

Your question does make sense. I've created a GitHub issue (https://github.com/lat9/sitemapxml/issues/57) to track the change.


@nicksab is requesting that otherwise-hidden EZ-Pages be included in the sitemap. Those pages are displayed on the storefront so long as the page is defined in the admin, even though its footer/header/sidebox status causes it not to be displayed as a link on the site.

Thank you lat9

[Shop Suey]

I see.
I was able to do the workaround activating "sideboxes" because I don't use sideboxes.
But you probably do.