Multi-Language Support for EZ-Pages

[Design75]

Version 1.6 has een submitted to the plugins section, and will be available once released.

- Files updated files for Zen Cart 1.5.5a
- Renamed CUSTOM folders to YOUR_TEMPLATE
- Renamed admin folder to YOUR_ADMIN
- Updated some sql queries
- Added comments to mark code change more clearly

[DarkMen]

Dear Friends,
I would like to ask. I installed this module to ZC 1.5.5, made everything as author write in README file and now, when I click to EZ page name (in header or footer menu), web write only: WARNING: An Error occurred, please refresh the page and try again.
I tried complete clear of EZPAGES tables in SQL, but there is no change.

I really don't know, what to do. Can someone help me? Thanks in advance

[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 */