a_berezin:
Chapter error.
ezpages_bar_footer.php:
Find
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
$page_query = $db->Execute("select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
where e.pages_id = et.pages_id
and et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and status_footer = 1
and footer_sort_order > 0
order by footer_sort_order, et.pages_title");
// end of modification
> Replace by
> ```
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
$page_query = $db->Execute("SELECT e.*, et.pages_title
FROM " . TABLE_EZPAGES . " e
LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
AND e.status_footer = 1
AND e.footer_sort_order > 0
ORDER BY e.header_sort_order, et.pages_title");
// end of modification
ezpages_bar_header.php:
Find:
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title");
$page_query = $db->Execute("select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, et.pages_title
from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
where e.pages_id = et.pages_id
and et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
and status_header = 1
and header_sort_order > 0
order by header_sort_order, pages_title");
// end of modification
> Replace by
> ```
// query modified for multi-language support
// $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
$page_query = $db->Execute("SELECT e.*, et.pages_title
FROM " . TABLE_EZPAGES . " e
LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
AND e.status_header = 1
AND e.header_sort_order > 0
ORDER BY e.header_sort_order, et.pages_title");
// end of modification
Does the above rectify the problem below?
Running ZC 1.3.8 with Multilanguage EZ-Pages 1.3.05v2.01
I have sorted out most of the errors that I have had with the mod by this thread. However, I am having issues where the mod seems to be ignoring Chapter and TOC settings. At some point after I first installed the mod, this was working correctly.
I looked here https://www.zen-cart.com/tutorials/index.php?article=117 for some indication of how to indicate main and subordinate pages and it seems a little ambiguous. Also, I did not change any settings from before when it was working.
The site can be looked at http://www.pheniks.net/zen/
What you would be looking for is the fact that in the footer, there are a bunch of links that are supposed to be on Chapter and TOC.
For instance, "Our Candles" is supposed to be the parent page that will contain "You Breathe What You Burn," "Hand Carved," and "Guarantee." Also, "Events" is supposed to contain "Calendar."
Thanks in advance.