Quote Originally Posted by a_berezin View Post
Chapter error.

ezpages_bar_footer.php:
Find
Code:
  // 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
Code:
  // 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:
Code:
  // 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
Code:
  // 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/i...hp?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.