ZCA Bootstrap 4 Template [Support Thread]

[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 

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

[ikirin]

http://www.zcadditions.com

header_php_shopping_cart_zca_bootstrap.php

if (!zca_bootstrap_active()) {
    return;
}

// This should be first line of the script:
$zco_notifier->notify('NOTIFY_HEADER_START_SHOPPING_CART');

require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
$breadcrumb->add(NAVBAR_TITLE); 

//$breadcrumb->add(NAVBAR_TITLE);

[ikirin]

index.php?main_page=create_account

Uncaught TypeError: Cannot set property 'className' of null