Re: ZCA Bootstrap Template
Quote:
Originally Posted by
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?
Re: ZCA Bootstrap Template
Here is what I found more:
includes/pages/page/header.php
has this
PHP Code:
$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
PHP Code:
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 Code:
<?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');
?>
Re: ZCA Bootstrap Template
Quote:
Originally Posted by
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.
Re: ZCA Bootstrap Template
Quote:
Originally Posted by
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:
Code:
[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 Code:
// 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
PHP Code:
// 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 Code:
// 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-B...anvas_menu.php
and reads
line 152
PHP Code:
$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
Re: ZCA Bootstrap Template
Be aware that Zen cart 1.5.6 has the multi language ez pages installed by default. This has implications for the template
1 Attachment(s)
Re: ZCA Bootstrap 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.
Re: ZCA Bootstrap 4 Template [Support Thread]
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
PHP Code:
$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
PHP Code:
// 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
Re: ZCA Bootstrap 4 Template [Support Thread]
Quote:
Originally Posted by
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:
Code:
[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
Re: ZCA Bootstrap 4 Template [Support Thread]
Quote:
Originally Posted by
keneso
Thank you.
Did as suggested, but no joy, still blank page after the login button in the top navbar, and this error:
Code:
[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
Quote:
Originally Posted by
keneso
Thank you.
Did as suggested, but no joy, still blank page after the login button in the top navbar, and this error:
Code:
[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.
Re: ZCA Bootstrap 4 Template [Support Thread]
Quote:
Originally Posted by
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:
PHP Code:
// 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
PHP Code:
$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");
PHP Code:
$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");