ZCA Bootstrap 4 Template [Support Thread]

[rbarbour]

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

Sounds like you may have set this up with a database prefix bsnew.table_

check your
/includes/configure.php
/admin/includes/configure.php

[keneso]

Thank you for your patience.

Both configure files:

define('DB_TYPE', 'mysql'); // always 'mysql'
define('DB_PREFIX', ''); // prefix for database table names -- preferred to be left empty
define('DB_CHARSET', 'utf8'); // 'utf8' or 'latin1' are most common
define('DB_SERVER', 'localhost'); // address of your db server
define('DB_SERVER_USERNAME', 'root');
define('DB_SERVER_PASSWORD', 'mypassword');
define('DB_DATABASE', 'bsnew');

[rbarbour]

Thank you for your patience.

I don't think this has anything to do with this template but could be wrong

in /includes/templates/bootstrap/common/tpl_header.php'

find:

<?php require($template->get_template_dir('tpl_offcanvas_menu.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_offcanvas_menu.php');?>

comment it out

<?php //require($template->get_template_dir('tpl_offcanvas_menu.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_offcanvas_menu.php');?>

We'll see if the rest of the site loads. Try to eliminate the issue first

[DrByte]

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

Keneso,
Your error is: "[15-Dec-2018 23:21:18 Europe/Rome] PHP Fatal error: 1146:Table 'bsnew.table_ezpages_content' doesn't exist"
NOTE: That's telling me that the constant for TABLE_EZPAGES_CONTENT is not defined, because if it were defined it would be to 'ezpages_content', not 'table_ezpages_content'.
So, if you're expecting multilingual ezpages, then you need to have that constant defined. In v1.5.6 it's in /includes/filenames.php, but if you're still using v1.5.x then it'll be in whatever file that plugin put those defines. Do what matches your environment.
Or, if you're not using multilingual ezpages, then you shouldn't have any of the code for it in your template in the first place.

[rbarbour]

I took a look at this plugin or (complete 1.5.5e install with language package) and in:
includes/extra_datafiles/ezpages_multilangauge_database_names.php

it reads:

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

so the edit provided in post #77 should work with 1 minor edit, changing TABLE_EZPAGES_CONTENT to TABLE_EZPAGES_TEXT

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

Thank you DrByte

There are only four differences between the 1.5.5 and 1.5.6 includes/filenames.php at the following lines

29
define('FILENAME_AJAX', 'ajax');
41
define('FILENAME_CATEGORY_PRODUCT_LISTING', 'category_product_listing');
56
define('FILENAME_COUPON_ADMIN_EXPORT', 'coupon_admin_export');
162
define('FILENAME_STATS_SALES_REPORT_GRAPHS', 'stats_sales_report_graphs');

The ezpages are these two, and are present in both versions
82
define('FILENAME_EZPAGES', 'page');
83
define('FILENAME_EZPAGES_ADMIN', 'ezpages');

Am I missing something?

We'll see if the rest of the site loads. Try to eliminate the issue first

By commenting it out the site loads fine.

[keneso]

I took a look at this plugin or (complete 1.5.5e install with language package) and in:
includes/extra_datafiles/ezpages_multilangauge_database_names.php

it reads:

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

so the edit provided in post #77 should work with 1 minor edit, changing TABLE_EZPAGES_CONTENT to TABLE_EZPAGES_TEXT

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

Sorry I had not refreshed the page.
Indeed that fixes it.

[keneso]

New error, navigating to "catalog (all products)", does not load after the filter listing; same with product listing of specific category, i.e. hardware>graphic-cards

PHP Fatal error: Class 'zca_splitPageResults' not found in C:\bsnew\includes\modules\bootstrap\product_listing.php on line 32

[rbarbour]

New error, navigating to "catalog (all products)", does not load after the filter listing; same with product listing of specific category, i.e. hardware>graphic-cards

PHP Fatal error: Class 'zca_splitPageResults' not found in C:\bsnew\includes\modules\bootstrap\product_listing.php on line 32

Check to make sure it was uploaded correctly or uncorrupted

includes/classes/zca/zca_split_page_results.php

original can be found here:
https://github.com/zcadditions/ZCA-B...ge_results.php

[lankeeyankee]

Sounds like you don't have includes/classes/zca/zca_split_page_results.php.