Hi
Using 1.55e
https://sourceforge.net/projects/zencart-italia/
It has some changes to comply with local rules, and some other "minor" ones
Anyhow when activated the template I get this:
Does it have to do with these:Code:[14-Nov-2018 22:31:48 Europe/Rome] Request URI: /benessere/index.php?main_page=login, IP address: ::1 #1 trigger_error() called at [C:\htdocs\newbs\includes\classes\db\mysql\query_factory.php:167] #2 queryFactory->show_error() called at [C:\htdocs\newbs\includes\classes\db\mysql\query_factory.php:139] #3 queryFactory->set_error() called at [C:\htdocs\newbs\includes\classes\db\mysql\query_factory.php:266] #4 queryFactory->Execute() called at [C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_offcanvas_menu.php:152] #5 require(C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_offcanvas_menu.php) called at [C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_header.php:84] #6 require(C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_header.php) called at [C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_main_page.php:120] #7 require(C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_main_page.php) called at [C:\htdocs\newbs\index.php:97] [14-Nov-2018 22:31:48 Europe/Rome] PHP Fatal error: 1054:Unknown column 'pages_title' in 'order clause' :: select * from ezpages where status_sidebox = 1 and sidebox_sort_order > 0 order by sidebox_sort_order, pages_title ==> (as called by) C:\htdocs\newbs\includes\templates\bootstrap\common\tpl_offcanvas_menu.php on line 152 <== in C:\htdocs\newbs\includes\classes\db\mysql\query_factory.php on line 167
includes/modules/ezpages_bar_header.php
includes/modules/ezpages_bar_footer.phpPHP Code:// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.toc_chapter, 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
includes/modules/sideboxes/ezpages.phpPHP Code:// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.toc_chapter, 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, pages_title");
// end of modification
How to fix it?PHP Code:// query modified for multi-language support
$page_query = $db->Execute("select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.sidebox_sort_order,
e.footer_sort_order, e.toc_sort_order, e.toc_chapter, e.page_open_new_window,
e.page_is_ssl, 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_sidebox = 1
and sidebox_sort_order > 0
order by sidebox_sort_order, pages_title");
// end of modification
Thank you


Reply With Quote
