ZCA Bootstrap 4 Template [Support Thread]

[keneso]

change them to

Thank you.
No luck, same error in the log.
Also forgot in the previous post: the page loads only the top navbar with only the "login" button visible, if that might help.

I get this in admin when changing to ZCA:
? ZCA_BOOTSTRAP_CONFIG_WARNING

I'll try to see if there are other ezpages related snips, and language files maybe?

[keneso]

Here is what I found more:

includes/pages/page/header.php
has this

$sql = "select * from " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et 
        where e.pages_id = et.pages_id 
          and et.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
          and e.pages_id = " . (int)$ezpage_id;
// comment the following line to allow access to pages which don't have a status switch set to Yes:
$sql .= " AND (e.status_toc > 0 or e.status_header > 0 or e.status_sidebox > 0 or e.status_footer > 0)";

// Check to see if page exists and is accessible, retrieving relevant details for display if found
$var_pageDetails = $db->Execute($sql);
// redirect to home page if page not found (or deactivated/deleted):
if ($var_pageDetails->EOF) {
  require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
  $messageStack->add_session('header', ERROR_PAGE_NOT_FOUND, 'caution');
  header('HTTP/1.1 404 Not Found');
  zen_redirect(zen_href_link(FILENAME_DEFAULT));
}

//check db for prev/next based on sort orders
$pos = (isset($_GET['pos'])) ? $_GET['pos'] : 'v';  // v for vertical, h for horizontal  (v assumed if not specified)
$vert_links = array();
$toc_links = array();
//  $pages_order_query = "SELECT pages_id FROM " . TABLE_EZPAGES . " WHERE status = 1 and vertical_sort_order <> 0 ORDER BY vertical_sort_order, horizontal_sort_order, pages_title";
//  $pages_order_query = "SELECT * FROM " . TABLE_EZPAGES . " WHERE ((status_sidebox = 1 and sidebox_sort_order <> 0) or (status_footer = 1 and footer_sort_order <> 0) or (status_header = 1 and header_sort_order <> 0)) and alt_url_external = '' ORDER BY header_sort_order, sidebox_sort_order, footer_sort_order, pages_title";

// next query modified for multi-language support
$pages_order_query = "SELECT e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.header_sort_order, e.sidebox_sort_order, 
                      e.footer_sort_order, e.toc_sort_order, e.toc_chapter, e.status_header, e.status_sidebox, e.status_footer, status_toc, et.pages_title, 
                      et.pages_html_text  
                      FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et 
                      WHERE ((status_toc = 1 and toc_sort_order <> 0) and toc_chapter= :chapterID )
                      AND alt_url_external = '' and alt_url = '' 
                      AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
                      AND e.pages_id = et.pages_id
                      ORDER BY toc_sort_order, pages_title";
// end modification 

I changed last line to

ORDER BY toc_sort_order, et.pages_title"; 

But no joy.

Then there are these other modified files:

admin/ezpages.php
which I don't know how, too many changes for my comprehension.

includes/extra_datafiles/ezpages_multilangauge_database_names.php
admin/includes/extra_datafiles/ezpages_multilangauge_database_names.php
these two are the same, and I'd guess are not the issue

<?php
/**
 * @package admin
 * @copyright Copyright 2003-2006 Zen Cart Development Team
 * @copyright Portions Copyright 2003 osCommerce
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: ezpages_multilangauge_database_names.php 2006-05-16 Neville Kerr $
 */
if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}

define('TABLE_EZPAGES_TEXT', DB_PREFIX . 'ezpages_content');
?>

[keneso]

I get this in admin when changing to ZCA:
? ZCA_BOOTSTRAP_CONFIG_WARNING

Ok this is not an issue I copied the extra definition file to the Italian directory.

[rbarbour]

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:

[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

Does it have to do with these:

includes/modules/ezpages_bar_header.php

  // 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/ezpages_bar_footer.php

  // 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 

includes/modules/sideboxes/ezpages.php

    // 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 

How to fix it?

Thank you

This error is telling me that a column "pages_title" in your table "ezpages" doesn't exist. Did this plugin alter the ezpages table?

Second it is finding this error in /includes/templates/bootstrap/common/tpl_offcanvas_menu.php, which can be found here https://github.com/zcadditions/ZCA-B...anvas_menu.php

and reads
line 152

    $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_sidebox = 1 and sidebox_sort_order > 0 order by sidebox_sort_order, pages_title"); 

this line will have to be updated to include the plugins altered query.

I think, I don't use zen-cart language packages, I add google translate
https://translate.google.com/manager/website/?hl=en-GB

[Design75]

Be aware that Zen cart 1.5.6 has the multi language ez pages installed by default. This has implications for the template

[keneso]

Thank you.

Indeed I checked, and in the package it has been moved to another table, couldn't check if is the same with the plugin (Design75 might shed a light), or the plugin has been modified and adapted for other reasons.

The package I referenced has the following two tables:
ezpages and ezpages_content
the pages_title is in the latter.

Could you please suggest how should I alter the suggested /includes/templates/bootstrap/common/tpl_offcanvas_menu.php?

I attach the two tables.

[rbarbour]

This Bootstrap template requires a fix to the /includes/templates/bootstrap/common/tpl_offcanvas_menu.php file for 1.5.6 changes the table structure.

Around Line 152, find

    $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_sidebox = 1 and sidebox_sort_order > 0 order by sidebox_sort_order, pages_title"); 

change to

// BOE - Bootstrap for 1.5.6     
    $page_query = $db->Execute("SELECT e.*, ec.*
                                FROM " . TABLE_EZPAGES . " e,
                                     " . TABLE_EZPAGES_CONTENT . " ec
                                WHERE e.pages_id = ec.pages_id
                                AND ec.languages_id = " . (int)$_SESSION['languages_id'] . "
                                AND e.status_sidebox = 1
                                AND e.sidebox_sort_order > 0
                                ORDER BY e.sidebox_sort_order, ec.pages_title");   
    
// old code for 1.5.5:
//    $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_sidebox = 1 and sidebox_sort_order > 0 order by sidebox_sort_order, pages_title");
// EOE - Bootstrap for 1.5.6 

[keneso]

This Bootstrap template requires a fix to the /includes/templates/bootstrap/common/tpl_offcanvas_menu.php file for 1.5.6 changes the table structure.

Thank you.
Did as suggested, but no joy, still blank page after the login button in the top navbar, and this error:

[15-Dec-2018 23:21:18 Europe/Rome] Request URI: /bsnew/, IP address: ::1
#1  trigger_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:167]
#2  queryFactory->show_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:139]
#3  queryFactory->set_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:266]
#4  queryFactory->Execute() called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php:160]
#5  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php) called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_header.php:84]
#6  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_header.php) called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_main_page.php:120]
#7  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_main_page.php) called at [C:\htdocs\bsnew\index.php:97]


[15-Dec-2018 23:21:18 Europe/Rome] PHP Fatal error:  1146:Table 'bsnew.table_ezpages_content' doesn't exist :: SELECT e.*, ec.*
                                FROM ezpages e,
                                     TABLE_EZPAGES_CONTENT ec
                                WHERE e.pages_id = ec.pages_id
                                AND ec.languages_id = 2
                                AND e.status_sidebox = 1
                                AND e.sidebox_sort_order > 0
                                ORDER BY e.sidebox_sort_order, ec.pages_title ==> (as called by) C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php on line 160 <== in C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php on line 167

[rbarbour]

Thank you.
Did as suggested, but no joy, still blank page after the login button in the top navbar, and this error:

[15-Dec-2018 23:21:18 Europe/Rome] Request URI: /bsnew/, IP address: ::1
#1  trigger_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:167]
#2  queryFactory->show_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:139]
#3  queryFactory->set_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:266]
#4  queryFactory->Execute() called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php:160]
#5  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php) called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_header.php:84]
#6  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_header.php) called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_main_page.php:120]
#7  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_main_page.php) called at [C:\htdocs\bsnew\index.php:97]


[15-Dec-2018 23:21:18 Europe/Rome] PHP Fatal error:  1146:Table 'bsnew.table_ezpages_content' doesn't exist :: SELECT e.*, ec.*
                                FROM ezpages e,
                                     TABLE_EZPAGES_CONTENT ec
                                WHERE e.pages_id = ec.pages_id
                                AND ec.languages_id = 2
                                AND e.status_sidebox = 1
                                AND e.sidebox_sort_order > 0
                                ORDER BY e.sidebox_sort_order, ec.pages_title ==> (as called by) C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php on line 160 <== in C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php on line 167

Thank you.
Did as suggested, but no joy, still blank page after the login button in the top navbar, and this error:

[15-Dec-2018 23:21:18 Europe/Rome] Request URI: /bsnew/, IP address: ::1
#1  trigger_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:167]
#2  queryFactory->show_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:139]
#3  queryFactory->set_error() called at [C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php:266]
#4  queryFactory->Execute() called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php:160]
#5  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php) called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_header.php:84]
#6  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_header.php) called at [C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_main_page.php:120]
#7  require(C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_main_page.php) called at [C:\htdocs\bsnew\index.php:97]


[15-Dec-2018 23:21:18 Europe/Rome] PHP Fatal error:  1146:Table 'bsnew.table_ezpages_content' doesn't exist :: SELECT e.*, ec.*
                                FROM ezpages e,
                                     TABLE_EZPAGES_CONTENT ec
                                WHERE e.pages_id = ec.pages_id
                                AND ec.languages_id = 2
                                AND e.status_sidebox = 1
                                AND e.sidebox_sort_order > 0
                                ORDER BY e.sidebox_sort_order, ec.pages_title ==> (as called by) C:\htdocs\bsnew\includes\templates\bootstrap\common\tpl_offcanvas_menu.php on line 160 <== in C:\htdocs\bsnew\includes\classes\db\mysql\query_factory.php on line 167

This fix is for 1.5.6

I believe I read somewhere you were using 1.5.5e

I am not familiar with the language package you are using.

Look in: includes/modules/sideboxes/ezpages.php to see the query being used by the language pack.

[keneso]

This fix is for 1.5.6
I believe I read somewhere you were using 1.5.5e
I am not familiar with the language package you are using.
Look in: includes/modules/sideboxes/ezpages.php to see the query being used by the language pack.

Yes, using 155e.
The query in includes/modules/sideboxes/ezpages.php was this:

    // 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"); 

I tried both of the following, and yet same error

    $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_CONTENT . " ec
                                WHERE e.pages_id = ec.pages_id
                                AND ec.languages_id = " . (int)$_SESSION['languages_id'] . "
                                AND e.status_sidebox = 1
                                AND e.sidebox_sort_order > 0
                                ORDER BY e.sidebox_sort_order, ec.pages_title"); 

    $pages_query = $db->Execute("SELECT e.*, ec.*
                                FROM " . TABLE_EZPAGES . " e,
                                     " . TABLE_EZPAGES_CONTENT . " ec
                                WHERE e.pages_id = ec.pages_id
                                AND ec.languages_id = " . (int)$_SESSION['languages_id'] . "
                                AND e.status_sidebox = 1
                                AND e.sidebox_sort_order > 0
                                ORDER BY e.sidebox_sort_order, ec.pages_title");