Multi-Language Support for EZ-Pages

[lat9]

@DarkMan, when you see the message WARNING: An Error occurred, please refresh the page and try again., there is a myDEBUG-*.log file present in your /logs directory that contains the details of the error.

Note: If a file's name starts with myDEBUG-adm-, then that file identifies an admin-related issue and includes your secret admin folder name. If you post the contents of one of those files (using the #/CODE button in the menu-bar when you are writing your post), make sure to xxx-out that admin-folder-name!

[DarkMen]

This is complete LOG:

[18-Mar-2017 16:40:06 Europe/Prague] Request URI: /eshop155/test-001-ezp-1.html, IP address: 31.47.97.52
#1 trigger_error() called at [/hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/hosting/www/domain.com/www/web/includes/modules/pages/page/header_php.php:49]
#5 require(/hosting/www/domain.com/www/web/includes/modules/pages/page/header_php.php) called at [/hosting/www//domain.com/www/web/index.php:36]



[18-Mar-2017 16:40:06 Europe/Prague] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)1
AND et.languages_id = '5'
AND e.pages_id = etpages_id ' at line 3 :: SELECT e.*, et.*
FROM ezpages e, ezpages_content et
WHERE e.pages_id = (int)1
AND et.languages_id = '5'
AND e.pages_id = etpages_id AND (e.status_toc > 0 OR e.status_header > 0 OR e.status_sidebox > 0 OR e.status_footer > 0) ==> (as called by) /hosting/www/domain.com/www/web/includes/modules/pages/page/header_php.php on line 49 <== in /hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php on line 167

[Design75]

See this page for the corrected code. I will upload a new version to the downloads asap.

This is complete LOG:

[18-Mar-2017 16:40:06 Europe/Prague] Request URI: /eshop155/test-001-ezp-1.html, IP address: 31.47.97.52
#1 trigger_error() called at [/hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/hosting/www/domain.com/www/web/includes/modules/pages/page/header_php.php:49]
#5 require(/hosting/www/domain.com/www/web/includes/modules/pages/page/header_php.php) called at [/hosting/www//domain.com/www/web/index.php:36]



[18-Mar-2017 16:40:06 Europe/Prague] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)1
AND et.languages_id = '5'
AND e.pages_id = etpages_id ' at line 3 :: SELECT e.*, et.*
FROM ezpages e, ezpages_content et
WHERE e.pages_id = (int)1
AND et.languages_id = '5'
AND e.pages_id = etpages_id AND (e.status_toc > 0 OR e.status_header > 0 OR e.status_sidebox > 0 OR e.status_footer > 0) ==> (as called by) /hosting/www/domain.com/www/web/includes/modules/pages/page/header_php.php on line 49 <== in /hosting/www/domain.com/www/web/includes/classes/db/mysql/query_factory.php on line 167

[lat9]

@Design75, isn't there an additional change required? Lines 29-37 of the file you referenced currently read:

/* BOF Multilingual EZ Pages 1 of 3 */
$sql = "SELECT e.*, et.*
        FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
        WHERE e.pages_id = " . (int)$ezpage_id . "
        AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
        AND e.pages_id = " . et.pages_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)";
/* EOF Multilingual EZ Pages 1 of 3 */

and should be changed, I think, as follows to prevent the log that @DarkMen identified:

/* BOF Multilingual EZ Pages 1 of 3 */
$sql = "SELECT e.*, et.*
        FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
        WHERE e.pages_id = " . (int)$ezpage_id . "
        AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
        AND e.pages_id = et.pages_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)";
/* EOF Multilingual EZ Pages 1 of 3 */

[DarkMen]

I think so, there must be some other change for to function properly. I tried to change code as LAT9 write and system now don't write
"WARNING: An Error occurred, please refresh the page and try again." error now there the page is opened, but there is no text for
the the EZ page.

Does anybody know?

@Design75, isn't there an additional change required? Lines 29-37 of the file you referenced currently read:

/* BOF Multilingual EZ Pages 1 of 3 */
$sql = "SELECT e.*, et.*
        FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
        WHERE e.pages_id = " . (int)$ezpage_id . "
        AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
        AND e.pages_id = " . et.pages_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)";
/* EOF Multilingual EZ Pages 1 of 3 */

and should be changed, I think, as follows to prevent the log that @DarkMen identified:

/* BOF Multilingual EZ Pages 1 of 3 */
$sql = "SELECT e.*, et.*
        FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
        WHERE e.pages_id = " . (int)$ezpage_id . "
        AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
        AND e.pages_id = et.pages_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)";
/* EOF Multilingual EZ Pages 1 of 3 */

[mc12345678]

I think so, there must be some other change for to function properly. I tried to change code as LAT9 write and system now don't write
"WARNING: An Error occurred, please refresh the page and try again." error now there the page is opened, but there is no text for
the the EZ page.

Does anybody know?

What is the condition of status for any of the options for that or any of your ez-pages? Ie. Table of contents, header, sidebox, or footer. Which if any are enabled?

[gernot]

This fixes it for me, I had the same trouble:

1. Last line fixed as above
2. 3rd line fixed in red

$sql = "SELECT e.*, et.*
        FROM  " . TABLE_EZPAGES . " e, " . TABLE_EZPAGES_TEXT . " et
        WHERE e.pages_id = '" . (int)$ezpage_id . "'
        AND et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
        AND e.pages_id = et.pages_id";