ZCA Bootstrap 4 Template [Support Thread]

[lat9]

@dellchase, what version of Zen Cart are you using?

[dellchase]

@dellchase, what version of Zen Cart are you using?

I'm using v1.5.5 now.

I do have hundreds of gift certificates over the years. I think I started using ZenCart some time during v1.3

[dellchase]

I can't replicate the issue what other order total modules do you have installed

Group Discount
Low Order Fee
Shipping
Sub-Total
Tax
Total

are all enabled.

All my stuff is up to date except one thing. I use a very old shipping module. Percent. It was released years ago and hasn't been updated. I don't even think its on the plugin page anymore.

http://collabedit.com/kxsrk

[lat9]

I'm using v1.5.5 now.

I do have hundreds of gift certificates over the years. I think I started using ZenCart some time during v1.3

Right, but which sub-version of v1.5.5? That database function (ExecuteNoCache) was introduced in Zen Cart 1.5.5f; if you're using a prior version, you'll need to patch your version of ot_gv.php.

[dellchase]

Right, but which sub-version of v1.5.5? That database function (ExecuteNoCache) was introduced in Zen Cart 1.5.5f; if you're using a prior version, you'll need to patch your version of ot_gv.php.

Well thats the problem! I'm not using f. Thank you!

v1.5.5 [2016-04-22 03:00:51] (Version Update 1.5.4->1.5.5)
v1.5.4 [2016-04-22 03:00:51] (Version Update 1.5.3->1.5.4)
v1.5.3 [2016-04-22 03:00:50] (Version Update 1.5.2->1.5.3)
v1.5.2 [2016-04-22 03:00:50] (Version Update 1.5.1->1.5.2)
v1.5.1 [2013-12-05 05:48:47] (Version Update 1.5.0->1.5.1)
v1.5.0 [2013-12-05 05:48:47] (Version Update 1.3.9->1.5.0)
v1.3.9h [2011-08-14 11:41:12] (Version Update 1.3.8->1.3.9h)
v1.3.8 [2009-03-21 19:09:40] (Fresh Installation)
v1.3.8 [2009-03-21 19:09:40] (Fresh Installation)

[Georgecy]

Hi guys,
How can we add additional product images in this template?

[dbltoe]

Hi guys,
How can we add additional product images in this template?

Not really a function of a template.

There are mods for additional images and standard info at https://www.zen-cart.com/content.php...s-to-a-product

[Georgecy]

Thank you for the reply. I was aware of the instructions for the multiple images but even though they worked with the responsive classic, I was not able to get them to work in the ZCA template.

[keneso]

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

[Design75]

change them to

  // 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, et.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, et.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, et.pages_title");
    // end of modification