ZCA Bootstrap 4 Template [Support Thread]

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

lat9:

@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

rbarbour:

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

dellchase:

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.

lat9:

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)

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

Georgecy:

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?100-how-do-i-add-multiple-images-to-a-product

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.

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

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

Design75:

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?

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.

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
> ```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
> ```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-Bootstrap-Template/blob/master/includes/templates/bootstrap/common/tpl_offcanvas_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

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

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.

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 

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.

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:

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:**
>
> 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.

rbarbour:

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