Quote Originally Posted by keneso View Post
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"
); 
Sounds like you may have set this up with a database prefix bsnew.table_

check your
/includes/configure.php
/admin/includes/configure.php