16 Dec 2018, 1:33 AM
Totally Zenned
- Join Date:
- Feb 2010
- Posts:
- 2,159
- Plugin Contributions:
- 10
ZCA Bootstrap 4 Template [Support Thread]
keneso:
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
> ```php
$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
