ZCA Bootstrap 4 Template [Support Thread]

[rbarbour]

I'm having the devil of a time getting checkbox inputs to show as table-column elements.

In the responsive_classic and classic templates, the element is "coded" as

                    <tr>
                        <td><?php echo TEXT_GROUP_PUBLIC; ?></td>
                        <td><?php echo zen_draw_checkbox_field("group_public[$favorites_group_id]", '', ($group_info['is_public'] == 1)); ?></td>
                    </tr>

For the bootstrap template, I've wrapped the table with a <div class="table-responsive"> and added the classes "table table-bordered" to the table itself. Then, I modified the checkbox column to read:

                    <tr>
                        <td><?php echo TEXT_GROUP_PUBLIC; ?></td>
                        <td><div class="custom-control custom-checkbox"><?php echo zen_draw_checkbox_field("group_public[$favorites_group_id]", '', ($group_info['is_public'] == 1)); ?></div></td>
                    </tr>

... but still no checkbox is displayed.

Anyone have any suggestions?

Cindy,

https://getbootstrap.com/docs/4.0/co...#custom-styles

The ZCA Bootstrap Template uses custom forms.

An ID must be added to the check box

And a label must be created
<label class="custom-control-label" for="***ID****">

[lat9]

Thanks, @rbarbour. That corrected the issue I was having.

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

[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

[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.

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

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