Multi-Language Support for EZ-Pages

In response to a question in the 'Customization from the Admin' forum, I found some time and played with some code...there is a zip file attached to this post that contains a complete drop-in contribution to make the EZ-Pages fully multi-language capable just as the category and product titles and descriptions are.

There are installation instructions included in the readme.txt file

Note: this contribution is designed for v1.3.0+ only. If you want to try it on an earlier version of the cart, feel free to do so at your own risk but don't expect support for it.


USE THIS LINK TO DOWNLOAD: http://www.zen-cart.com/index.php?ma...roducts_id=113






MODERATOR NOTE:THE FILE ATTACHED HERE CONTAINS SOME BUGS. You should download using the link above.

Thanks for your effords and quick response! Naturally I was hoping for a solution, but never expected it this fast ...............

Of course I tried out your solution immediately. Unfortunately I get the following error:
1146 Table 'hairsho_pmzen.zenpm_ezpages_text' doesn't exist
in:
[select count(*) as total from zenpm_ezpages e, zenpm_ezpages_text et where e.pages_id = et.pages_id and et.languages_id = '2']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

In the new SQL query the new table is defined as ezpages_content and the php file is looking for the ezpages_text. We tried to resolve this by changing the table name into ezpages_content but still (about) same error.
We will now try to ajust the SQL query now but all help is welcome of course. I will report back later.

A
We first changed the table name in the SQL query and the EZ pages panel within admin is now working again! If we now add a new EZ page a multi-langual form opens and in both English (admin panel) and Dutch the correct title from EZpage is shown.

However, the EZ pages do not show in the shop at all! The sidebox does show so the program 'knows' that there is a page, but does not provide the title/link in the sidebox.

B
New approach: adjusted the following files:
1. includes/extra_datafiles/ezpages_multilangauge_database_names.php
2. admin/includes/extra_datafiles/ezpages_multilangauge_database_names.php
In both files we made the following changes:
from: define('TABLE_EZPAGES_TEXT', DB_PREFIX . 'ezpages_text');
to: define('TABLE_EZPAGES_TEXT', DB_PREFIX . 'ezpages_content');

Same result unfortunately! The sidebox does show as soon as an EZ page has been made, but the EZ page itself does not show (no title/link in sidebox)

:blush: Sorry, we screwed up

We forgot to do the "files to over-ride" section of the README
Now that we did - together with step B from previous mail- everything works fine.

Thanks again!!:smile:

apologies for the error in the table name...the result of a last-minute change of mind about the table name.

It works fine for me on two separate installations - but if there was some original content in the ezpages table that was copied into the new table by the sql patch I provided, you need to manually add the rows for the additional languages (else you just get the word Array in place of the link). I may have to rethink the inclusion of that in the sql patch and perhaps include a php install file that will populate the new table for all installed languages (but each page will have the same title/content for each language until edited).

That may be true and I can see your point, but for us it works perfectly at the moment!

Many thanks!

Hello bunyip,

I installed the multi ez pages with the same error accoured to femky, fixed that by editing the two rows for the table names and the pages show up correctly in multi language.

However, I can't save the new (or edited) pages. Get always an error:
Page title for English is required
Page title for Greek is required

I'm running 3 languages: Eng, German, Greek
My default languge is English
Default editor: FCKEDITOR

Wonder why there is no error for the German Page title

Dimi

Pivey - deselect FCKEDITOR and use HTMLAREA or None and let me know if you still get the errors.

Yes, still the same. I tried with Htmlarea, none..the same!

Error: Page title required. (English)
Error: Page title required. (Greek)

Dimi

I think I found the problem:

in admin/ezpages.php find this line of code:

Code:

---

if (empty($_POST['pages_title'][$i])) {

---

change it to this:

Code:

---

if (empty($_POST['pages_title'][$languages[$i]['id']])) {

---

there's actually another place a couple of lines above that has the same problem.

This line of code:

Code:

---

if ($_POST['pages_html_text'][$i] !='' and strlen(trim($_POST['pages_html_text'][$i])) > 6) {

---

should be changed to this:

Code:

---

if ($_POST['pages_html_text'][$languages[$i]['id']] !='' and strlen(trim($_POST['pages_html_text'][$languages[$i]['id']])) > 6) {

---

I'll update the file in the downloads section to correct thes two lines.

:thumbsup: Perfect!

I buy you a beer when you are in Greece....and Thank You!
Dimi

Hi, I have downloaded a new version of multilanguage support and done all steps. But there is a problem that I can not get new EZ page working. the old ez pages are still there but the content disapeared? I guess something got wrong... is there a way how to solve it?
see the page: www.mozaika.org
All Ez pages which you can see there have not the pages in admin/tools/ezpages... the whole page in tools/ezpages is empty... so I can not even delete the old ezpages.. pls help..
Oldrich Svec

PS: always I run this the pages disapear from admin but they are still on main page:

DROP TABLE IF EXISTS `ezpages_content`;
CREATE TABLE IF NOT EXISTS `ezpages_content` (
`pages_id` int(11) NOT NULL default '0',
`languages_id` int(11) NOT NULL default '1',
`pages_title` varchar(64) NOT NULL default '',
`pages_html_text` text NOT NULL,
KEY `idx_ezpages_content` (`pages_id`,`languages_id`)
) TYPE=MyISAM;

#################

## This next section copies your page titles and content across from the existing ezpages table into the new ezpages_content table
#NEXT_X_ROWS_AS_ONE_COMMAND:3
INSERT INTO ezpages_content (pages_id, pages_title, pages_html_text)
SELECT pages_id, pages_title, pages_html_text
FROM ezpages;

#################

## You don't need to do this next step, it just serves to remove the now unused fields in the ezpages table.
## To run the query, remove the comment marks from each line
##ALTER TABLE `ezpages` DROP `languages_id` ,
##DROP `pages_title` ,
##DROP `pages_html_text` ;

If I go to your site and select English as the language, I see all the content for the ezpages. If I select Czech then the content is blank.

The sql tool I provided with the module takes your original content and adds it as english only in the new table. You'll need to add the Czech content separately.

From your Admin panel, try selecting English as your language, then go to Tools > Ezpages and see what is there. You should be able to add the Czech titles/content.

I see... I did so and I tried to edit one of the files but when I pressed update, it behaved normaly but when I looked in the file again all the czech content disapeared. And if I create new file and put some content in it, it saves it correctly but nothing is seen on the main page:

EZPages :: :: Shared :: Zen Cart

I am newbie in this so I am sorry if it is a trivial question.
Thank you very much for your help.
Oldrich Svec

I think I've figured out what the problem is for your Czech titles and content not being saved - I'll have a fix for that shortly.

As for the titles not being displayed on your store, I don't think you installed the mod correctly. If you extracted all of the zip file you should have had a folder includes/modules/CUSTOM/ that had two files in it. That CUSTOM folder should have been renamed to match your custom template folder name before you uploaded the files.

The failure of titles and content not being saved for additional languages was because of the way the update process was implemented.

After installing the module, you would have a datarow in TABLE_EZPAGES_TEXT for each page, but only for a single language. The update process was effectively trying to update a datarow that didn't exist for additional languages. I've now included checking for that so if the datarow doesn't exist, it gets inserted.

(This will also allow for a situation where additional languages are added to your store after this contribution is installed)

I've updated the module in the Downloads section, but it will take a little while to get processed before it's available. In the meantime, replace your copy of admin/ezpages.php with the new file from the attachment to this post.

I did above and now I have this

Parse error: parse error, unexpected T_VARIABLE, expecting '(' in /home/fwebsolu/public_html/demo001/admin/ezpages.php on line 204

lost admin altogether.

I just spent 5 days doing the french language upgrade and this would be a great addon tool.

Fantastic work.

Thanks

Peter

at line 204 of admin/ezpages.php, change this code:

Code:

---

if $check_query->RecordCount() > 0) {

---

to this

Code:

---

if ($check_query->RecordCount() > 0) {

---

Thanks

I was just poking around myself to see it there was a missing bracket.

Anyway that solves the error message. I will play with Ezpages now for a while in french and english and see if all is fine.

Again thanks for the quick response.

Peter

thanks a lot! It solved all my problems!
Oldrich Svec

Hi, one more problem, but probably this is not due to multilanguage support. When I want to add internal or external link I create new file. I put the English and Czech name and the external or internal link. But there is an error:

you have defined multiple settings when only one may be defined per Link ...
Only define either: HTML Content -or- Internal Link URL -or- External Link URL

But I promise I dont put a letter to the HTML box and I put the internal link or external link, not both together. Any idea what is wrong?

I have tested this feature (multi-language ez-pages zc v1.3.x) extensively.
Here are my results:

- There is no way to create or edit a link for the ez-pages section in the shop
(e.g. header, sidebox, ...). After the clicking the "INSERT" (or "UPDATE) button,
the same site will appear with empty page title fields.
(in Tools->EZ-Pages->edit/new_file ->insert/update))

- The footer (with the ez-pages) do not appears in the shop. I have used suitable
settings, e.g. EZ-Pages Settings (configure menu)

Maybe this can help you a little bit.

Alex

Oldrich: I found the problem thats causing your error message - edit admin/ezpages.php
find this line:

Code:

---

if (pages_html_url_flag) {

---

and put a $ sign in front of pages_html_url_flag so it reads:

Code:

---

if ($pages_html_url_flag) {

---

Alex: I'm working on that problem - I believe its an issue with having more than one language when the mod is installed, and only getting link titles and page content inserted for a single language. I'm working on a new 'fix table' script that will set up and/or fix the extra database table. Hopefully I'll get it sorted out and the script available in the next 24 hrs.

There's a new version of this contribution available in the Downloads section, under Other Modules.

This latest update adds a new page to the Admin panel that simplifies the install/uninstall process and ensures a smooth transition to the multi-language ez-pages.
That new page also provides a fix/repair facility for the new database table to resolve any problems that may have occurred as a result of incomplete installation of the initial release version.

IF YOU ARE UPGRADING FROM AN EARLIER VERSION, YOU WILL NEED TO UPLOAD THE NEW FILES, THEN USE THE UNINSTALL FUNCTION, AND THEN THE INSTALL FUNCTION from Admin > Tools > Install/Uninstall Multi-Language EZ-Pages. This is because of a change in the structure and indexing of the ezpages_content table

How do I uninstall this, I don't seem to have that option, there is just an install sql option, when I use this I can't seem to save anything under Japanese, Just in English it lets me save. I think I need to do a clean install and yes I have the latest version of everything

bug fix:
open file /includes/modules/ezpages_bar_header.php

modify line 24 from:

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, et.pages_title

---

to:

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, et.pages_title, toc_chapter

---

This will display TOC correctly.

Hi!

I create 2 EZ Pages, one on Greek one on English. However, in the sidebox, I am seeing both links and on Greek and on English version.

I will try to clarify:

My EZ Sidebox look like this:

====================
My Greek Title for EZ Pages

Greek Link
English Link
====================


====================
My Enlish Title for EZ Pages

Greek Link
English Link
====================

I am trying to do this:


====================
My Greek Title for EZ Pages

Greek Link
====================

and:

====================
My Enlish Title for EZ Pages

English Link
====================



Any help?


Regards, Zoreli

Hi

I download the module multilanguage_ezpages_ from download section
and I also read the thread:

http://www.zen-cart.com/forum/showth...guage+EZ-PAges

Everything is fine except that I cant see the content of my ez pages.


Can anyone give me idea what I am doing wrong?

I try install & uninstall Multi Language EZ Pages, I try fix Fix/Repair Multi-Language EZ-Pages database table, nothing, content on Both English & Greek Page is still not visible, while the page is there, but empty...

Thanks, Zoreli

Quote:

---

Originally Posted by neteasy

bug fix:
open file /includes/modules/ezpages_bar_header.php

modify line 24 from:

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, et.pages_title

---

to:

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, et.pages_title, toc_chapter

---

This will display TOC correctly.

---

hi bunyip and neteasy,

I did download the new version, and do all u tell. However, i got problems:

1. The language is display only 1 language.
2. I can't find this line:

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, et.pages_title

---

What i got is:

Code:

---

  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title");

---

Could you please help me to solve the problems:

Thanks,

chipus

hix, i don't know why i can't edit my post.

Another problem is:

3. It keep appearing the string (translate me), even I have removed the "(translate me)".

I think there is a problem with header multilanguage ezpages

Go to the file:
includes/modules/ezpages_bar_header.php

Find the code (line 21)

Code:

---

$page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title");

---

and replace by

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, et.pages_title, e.toc_chapter
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

---

Hope that help!

Hi buniyip,
installed ezpages multilanguages (latest version) an it's beautiful!!! Thank You! Just one little teardrop:
I have lined all my pages via ezpages into the top- and bottom-Navigation as I don't want to use the columns left and right. It works great, it's only that if the site is being loaded for the first time, the NavBarstyle gets shrinked. After pressing the browsers reload-button everything comes back into their correct position...

So I was checking my css and tried different settings, finally with no solution. Do You have an Ideaabout what's wrong here???

Thanks in advance, ciao jens

HELP! Everything gone on my multi-language ez-page when I edited the page and cannot input any information after upgrade to 1.3.5. :cry:

I have a page with english, traditional chinese and simplified chinese translation. It worked before in 1.3.0.2. After upgrade to 1.3.5, I add words in the page and updated. Everything gone on the page. Everytime I edited the same page and updated, nothing will show except 'p' in English textarea.

I used the Fix/Repair Multi-Language EZ-Pages database table. 'p' will show in the English textarea, (translate me) will show in both traditional and simplified chinese textarea. Then I edited the content and updated. Everything vanished except 'p' in english textarea, '>' or '/' or 'p' will show in traditional and simplified chinese textarea.

Other pages without editing is alright to show in website. I didn't dare to edit anything in ez-pages because I am afraid the content will gone suddenly.

Please help! :down:

Is this module compatible to 1.3.5 ? (or will it be ?)

/Typhoon

So sorry for this bump, but... If this contribution is not 1.3.5 supported, anyone know how to use EZ-Pages in 2 different languages depending on what language the user want to use ?

/Typhoon

I couldn't get this contrib to work under 1.3.5; I guess it is not compatible so far. It is really a pitty the ezweb system was implemented on zen-cart without the possibility to use multi-languages, while zen-cart itself was built to handle multiple languages.

sanji

Hi,

I have no problems at all running this mod with Zen-Cart 1.3.5
After upgrading i had to place the overrides back (from the CUSTOM directory's)
I am running multilanguage ezpages on three sites now, so i am sure it will work.
Please check if all of the files of the contribution are in place.
Copy the files from the CUSTOM directory's in your own override template dir.

Ronald.

Quote:

---

Originally Posted by azrahn

Hi,

I have no problems at all running this mod with Zen-Cart 1.3.5
After upgrading i had to place the overrides back (from the CUSTOM directory's)
I am running multilanguage ezpages on three sites now, so i am sure it will work.
Please check if all of the files of the contribution are in place.
Copy the files from the CUSTOM directory's in your own override template dir.

Ronald.

---

I can imagine that it works but there have been some changes from 1302 to 135. I haven't had time to sort through all the differences but for example the ezpage.php in the admin directory has at least six sections with changes. Any idea if an upgrade of the contrib is in the works?

Hi ryanp,
(beautiful tepmplate ;->)

You could download the full fileset with already integrated ez-multilingual via the german support-site at www.zen-cart.at (Version from 20060926) Maybe that helps?

ciao, jens

Hi Jens,

I downloaded the german version of 1.35 last week. Unfortunately, it includes some things that I don't want (ajax attributes for one). I would much prefer a simple translation of a vanilla zen-cart as it makes support easier. That way I can add mods as I need them directly from the developer.

Thanks anyway for the idea.

Patrick

Is Multi-Language Support for EZ-Pages work with v 1.3.6 Zen cart?

Thanks.

Hi!
I've successfully installed this mod on 1.3.6 and everything seems to work fine exept for one little thing.

I think I've done everything right but I guess I must have missed one little thing to get it to work perfectly.

The problem should be in the ezpages_bar_header.php and ezpages_bar_footer.php file but I'm not shure. When I load my site, the link reads as follow:

[...]/index.php?main_page=page&id=1&chapter=

The chapter number is missing so the TOC won't show.

Anyone can help me on this one? I'm sure the solution is really simple but I basically don't know anything to PHP!

Thanks!

Ok, just ignore my last post, I found the problem and fixed it.

Now when I edit the content of my pages the result won't show up when I hit the refresh button.

Any idea?

Hi, I have installed the ZC 1.3.7 with CZECH (default), ENGLISH and GERMAN language. I installed also the Multi-Language EZ-Pages latest pack doing these steps:

1. unzip the archive
2. copied all files to ADMIN and INCLUDE directories
3. the file ezpages_multilanguage_defines.php I copied to these locations:
\admin\includes\languages\english\extra_definitions
\admin\includes\languages\german\extra_definitions
\admin\includes\languages\czech\extra_definitions
but I do not understand this "- then edit the two define statements
in the file to suit your language." :no:
4. I run the instalation in the shop admin center - Tools - Install/Uninstall Multi-Language EZ-pages - the instalation was correct

After these steps I found in my Tools - EZ Pages three boxes for the EZ Pages title - CZECH, ENGLISH, GERMAN. I translated e.g. My Account to czech and german and click update button.
If I swith the language in admin part e.g. to czech, than the "My Account" in EZ-pages list is written in czech, if i choose germna, it is in german and english is also OK.

But In my shop header and footer line it still working in one language. If I choose czech, everything is OK, but if I click ENG flag, then only first link (HOME) is in English and the same situation is in German, only Startseite link is in German, all other links are in Czech (bad character coding). :cry:
The links in header/footer works correctly. E.g. if I choose czech language and I click My Account in footer I go to czech login page. If I choose german language and click My Account in footer I go to German login page.

Any idea how to resolve this problem ?

Hi

I have multi language ez pages installed.

But when I add a new site with HTML content, the HTML content dosent show up at the shop.
In the admin while choosing edit, I can still see the content.
I can use the link options without any problems.

If I then go to admin, uninstall Multilanguage ez pages and install it again, then the content, which couldnt be seen before, is being showed at the shop.
But then I have to translate all ezpages.

What can the problem be?

Anybody???

Hi Backstage - I'm having the same problem; I have 1.3.7 installed. I figured out that while the ezpages_content db is being updated (hence the reason we can see our page content in the admin section - and view our changes), it seems that the pages (in the shop side) are being pulled from the old html_content in the ezpages table instead of from the ezpages_content table. I'm not that proficient in PHP so I don't think I can fix this - maybe bunyip can update her mod for 1.3.7???? :D

I found my problem reason. I dind not copy the files from the CUSTOM folders to their right location:blush: Isn` t it the reason for your problem ?

I don't think so - I renamed the CUSTOM folder to my template name and uploaded the files....any help would be MUCH appreciated - I really want this mod to work!!

My headings on the ezbar header show the appropriate translated names (I'm using English & French), but when I click on either language, it shows the old EZPages data from before the install on the ezpages table (not ezpages_content). This content is now non-editable - and all the same language. I can update the ezpages_content via the admin section no problem - I just can't get my links to work and to display the new content. If anyone can help, I would be so greatfull :yes:

Hi Please help with a solution to make ez pages run with multi language for 1.3.6 and 1.3.7

eweb writes this:
I figured out that while the ezpages_content db is being updated (hence the reason we can see our page content in the admin section - and view our changes), it seems that the pages (in the shop side) are being pulled from the old html_content in the ezpages table instead of from the ezpages_content table. I'm not that proficient in PHP so I don't think I can fix this - maybe bunyip can update her mod for 1.3.7????

Maybe someone will help us :)

I had multilanguage EZ pages working correctly in my 1.3.6 shop. However now I´m upgrading to 1.3.7 and multilanguage EZ pages doesn´t seem to work anymore. I have added all the files...

I upgraded the database to 1.3.7. I don´t know if I have to install Multilanguage EZ pages again or Fix/Repair. I tried both but with no satisfactory results. The EZ pages are all blank, even though in the admin I added the content and it looks all fine.

Please advise me how to proceed. I can´t get it to work.
Thanks,
Carol

I am having some crazy problems with 1.3.7 too, I have Japanese and it will only work in Japanese...it pulls the database info from the Japanese side when I change it to English, then I unistalled and reinstalled it and it caused the English in the Admin section of the edit page to turn to Japanese. Really a pain in the ######## as this is one of my favorite contributions.

Is Bunyip not around??? It looks to be almost a month since Bunyip has posted anything....HELP!

Does anyone know what the update in 1.3.6 to 1.3.7 that changed this? I am looking at the change log but can't find what might have done it, but then again I am not really sure what I am looking for.

Chapter error.

ezpages_bar_footer.php:
Find

Code:

---

  // query modified for multi-language support
//  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
  $page_query = $db->Execute("select e.pages_id, 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, et.pages_title");
  // end of modification

---

Replace by

Code:

---

  // query modified for multi-language support
//  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
  $page_query = $db->Execute("SELECT e.*, et.pages_title
                                                        FROM  " . TABLE_EZPAGES . " e
                                                          LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
                                                        WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
                                                                AND e.status_footer = 1
                                                                AND e.footer_sort_order > 0
                                                        ORDER BY e.header_sort_order, et.pages_title");
  // end of modification

---

ezpages_bar_header.php:
Find:

Code:

---

  // query modified for multi-language support
//  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_header = 1 and header_sort_order > 0 order by header_sort_order, pages_title");
  $page_query = $db->Execute("select e.pages_id, 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

---

Replace by

Code:

---

  // query modified for multi-language support
//  $page_query = $db->Execute("select * from " . TABLE_EZPAGES . " where status_footer = 1 and footer_sort_order > 0 order by footer_sort_order, pages_title");
  $page_query = $db->Execute("SELECT e.*, et.pages_title
                                                        FROM  " . TABLE_EZPAGES . " e
                                                          LEFT JOIN " . TABLE_EZPAGES_TEXT . " et ON (e.pages_id = et.pages_id)
                                                        WHERE et.languages_id = '" . (int)$_SESSION['languages_id'] . "'
                                                                AND e.status_header = 1
                                                                AND e.header_sort_order > 0
                                                        ORDER BY e.header_sort_order, et.pages_title");
  // end of modification

---

This is great if this fixes it, tested?

ok, well this still isn't working for me. It's pulling in the english language on ezpages that I already had up and not pulling in anything but the title for new pages I make.

Think I am just going to go down to 1.3.6 until this gets fixed

Quote:

---

Originally Posted by godspeed27

ok, well this still isn't working for me.

---

Does not working in what? You read this?

Quote:

---

Originally Posted by a_berezin

Chapter error.

---

I implemented the fixes to the files you listed above, but it didn't fix it for me. (not to say it didn't fix something, just not what I noticed 1st.)

I also tried the normal module it on a fresh install of 1.3.6 but ezpages are being weird on that.

When I edit the ezpages and then go to the Japanese side of my pages it pulls the html area from the English side. This is in 1.3.7

In 1.3.6 I have not changed the code that you listed above, if I make an ezpage before I install the module and then translate it, it works, but then if I try to make a new site, it doesn't work.

I am to the point where I am going to go back down to 1.3.0.2 as I have to have the ezpages working in both languages.

Quote:

---

Originally Posted by a_berezin

Does not working in what? You read this?

---

Once more.
You apply this patch and links to ez-pages in footer and header does not contains chapter number?

Man, I'm sorry, I don't even get what your asking me here.

Quote:

---

Originally Posted by a_berezin

Once more.
You apply this patch and links to ez-pages in footer and header does not contains chapter number?

---

This patch not for you. This patch for those, who understand what is chapter number in ez-pages.
P.S. Why you think what all are anxious only with your problem?

Man, Whats your deal, sorry I didn't understand that you were asking for. Thought this site was about community and helping.
"This patch not for you" ok fine....didn't know I was offending you by asking a question. Why am I so anxious, b/c I have a site that I am trying to update and this is a major hold back on me and I have vacation right now, so trying to get it worked out. Really what did I do to you?

Quote:

---

Originally Posted by a_berezin

This patch not for you. This patch for those, who understand what is chapter number in ez-pages.
P.S. Why you think what all are anxious only with your problem?

---

Also you said
"Once more.
You apply this patch and links to ez-pages in footer and header does not contains chapter number?"

Man, I think your English is wrong here, not to give you a hard time about that as I am sure its your 2nd language, but really it doesn't make since to me.

Update
Had a slight error in the install. My error.
I have 1.3.6 running with this now, seems to be fine. Just 1.3.7 thats not.

Quote:

---

Originally Posted by CzechBoy

Hi, one more problem, but probably this is not due to multilanguage support. When I want to add internal or external link I create new file. I put the English and Czech name and the external or internal link. But there is an error:

you have defined multiple settings when only one may be defined per Link ...
Only define either: HTML Content -or- Internal Link URL -or- External Link URL

But I promise I dont put a letter to the HTML box and I put the internal link or external link, not both together. Any idea what is wrong?

---

I have the same problem :cry:
I didn't type anything in the html box and it says I have defined multiple settings HTML & Internal link url.... !!!
I only have the Internal Link URL with letters !!

Please help me :sadwalk:

Many thanks

Hey Godspeed, I bet you want to use this with the new jappack right?

I just did my first install of both the jappack and this multilanguage easy pages and its working

... I dont know what to tell you mate... I installed the multilanguage pack posted here: http://www.zen-cart.com/index.php?ma...roducts_id=113 on July 09 2006 and followed the readme. I didnt previously have any ezpages.
So I guess I can confirm that (so far) its working in 1.3.7


Just a note for BUNYIP. Mate great work!
But please can you attend to the update you added here: http://www.zen-cart.com/index.php?ma...roducts_id=113 on October 12 2006. It confused the heck out of me because all the files in that download are floating around in the root folder and all the readme file says is 'Only the original files are stored here which have been changed.' To Please post your updates as the full, proper install with readme file! It wouldve saved me hours :)

Thanks again.
R

Bunyip, I apologise, I see the October 14 2006 update was added by fweb, not your good self!


...of course, I was still confused so would someone (fweb?) like to look at cleaning that up or rewording the October 14 2006 update so we know its not the full install. Or at least writing a real readme file for that download?

Thanks

I'm having a problem with this module and I'm not sure what to do! If I create new EZ-Pages, the link is there, but there's no content at all...not even the EZ-Page heading. There's content set up for at least one of the pages (Galleries), so there should definitely be something there, although the fact that the page heading/title don't appear is a big sign that something's amiss.

I've never installed this mod before, but it was working until just a few days ago. I moved the site over to the final hosting server, but I'm not sure if that has much to do with it or not. =/

Any ideas??

sweetlittlemonkey.com/index.php

(it's the Galleries and Babywearing links that I can't get to work)

Whew! I think I figured it out. I had to get into the database and manually reset the settings for about half of the EZ-Pages in the ezpages table. Pretty much all of the settings were missing, so when I added them back in, the links started working again! I have no idea what the problem was that caused it, but at least it's fixed now. =)

Scratch that, it's not fixed. The pages are showing up, but you can't edit the content in the admin. The changes don't seem to be taking hold in the database. =(

Hey,

something is definitely missing from the file ezpages.php (the sidebox one) since some text comes as code to the site under the links and when you look the file starting from the line 76, it goes like this:

} // test for display
?>
atus_toc':
zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'status_toc');
$messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
break;
case 'insert':
case 'update':
// start modification for multi-language support
ETC.

The start is quite surely "status_toc" but what else is missing there?

Elli

Actually that seems to be a mix up with the other file of ezpages.php that is for admin. So, from this ezpages file that belongs to the folder of sideboxes I removed everything under this:

}
} // test for display
?>

(so, the above still stays, all else goes away under from this file)

...and it seems to work now... using 1.3.7 here.

Just wanted to update that I was having the same issue as many others here in that the EZ-Pages weren't being updated, but I fixed it by reinstalling the mod, but I installed the June 9th version this time. Everything SEEMS to be working great now! I'll update as soon as I hear back from my client.

I guess the "update" actually breaks the mod, at least on 1.3.6. =/

Is this module compatible with 1.3.7?

Some people seem to be having trouble with it. Others are running it without problem, and it's even built into the German language pack for 1.3.7. So the answer would appear to be yes, but make sure that you install it very carefully.

thank you!

I have problems also to integrate multilanguage EZPages into my upgraded zencart (1.3.7)

The pack at http://www.zen-cart.com/index.php?ma...roducts_id=113 on October 14 2006 contain a set of files in the root folder ....

Is there any solution to get this complete pack ?

Thanks for reply

You can grab the release before the October one.

The October one didn't work for me anyway (after merging it with the June release), but after I reinstalled it with the June release, it works perfectly. This is on 1.3.6, BTW.

I tried hard to get this multilanguage support for ezpages running.

First everything was easy. I took the download from Jun 09 2006 and installed everything as it was written in the ReadMe.

In admin I found the possibility to have a translation into my second language.

On the shopside there wasn't shown the translation that I made in the admin.

The TOC and the foot navigation disappeared when I switched to the second language.

Then I tried to make several changes in ezpages_bar_header as it was told in this thread before.

The result was that my page didn't built up at all except of the logo.

Now I deinstalled the ezpages in the admin and tried to reinstall but it doesn't work. After installation now I don't even have the possibility to fill in the second language on the admin side.

Edit: I downloaded the last update from Oct 14 2006 but in this zip-file I couldn't find any folders and so I don't know where to put the different files with the same name.

Can anybody give me a hint what I could try next?

THX Smartsoul

Quote:

---

Originally Posted by Smartsoul

Now I deinstalled the ezpages in the admin and tried to reinstall but it doesn't work. After installation now I don't even have the possibility to fill in the second language on the admin side.
THX Smartsoul

---

This problem is fixed, cause I found the right ezpages.php to load on the server before the reinstallation of the mod.

Another problem is solved but not in a very nice way.

The disappearing top and foot menus when I switched to second language was because of an error in the database query.

The variable TABLE_EZPAGES_TEXT wasn't resolved by the system and so the table ezpages_content couldn't be found.

Now I helped myself by hardcoding ezpages_content into the the query of ezpages_bar_header.php and ezpages_bar_footer.

Maybe someone can tell me about a more elegant way to solve this problem?

At least there is still one point left. The content of my multilanguage ezpages is still taken from the wrong table (ezpages instead of ezpages_content).

Where do I have to make the change in the query or in which file I should search or replace?

THX for your help!

I'm sorry, but again me.

I forgot to put header_php.php from update package multilanguage_ezpages_1.3.0.5v2.zip onto the server.

Then after hardcoding again the database table in this file it works fine.

THX, hope you didn't feel too much disturbed by my posts ;-)

Quote:

---

Now I helped myself by hardcoding ezpages_content into the the query of ezpages_bar_header.php and ezpages_bar_footer.

Maybe someone can tell me about a more elegant way to solve this problem?

---

Does anybody know anything?

Hey every body great mod. I just wanted to let people know that I just merged it w/ zen cart 1.3.7.01. and submited it to the down loads section. Its not up yet. but I would forget to post about it if I waited.
This mod will make it so that it will work w/ what ever WYSIWIG you want to use
you can see it in action at vitalityrainforest.com

Lets bug the admins to make this a standard part of the code base for a next release.

JOsh

Quote:

---

Originally Posted by ##########################

Lets bug the admins to make this a standard part of the code base for a next release.
JOsh

---

Would be sooo nice, if they would do so! :cool:

I just was sent an email telling me that the mod is live at http://www.zen-cart.com/index.php?ma...roducts_id=113

Hi,

I have just downloaded the contribution and dropped in the php files as directed.

When I try to run the tools/create option to create the database file, it returns me to the admin log-in page without creating the file. No error message!

Can anyone help.

Quote:

---

Originally Posted by MANXMAN

Hi,

I have just downloaded the contribution and dropped in the php files as directed.

When I try to run the tools/create option to create the database file, it returns me to the admin log-in page without creating the file. No error message!

---

Please post you zen cart version as well as PHP and Mysql version that is on your server. it will enable people to help you better.

Hi,

Zencart: 1.3.7

PHP: 4.4.7
MYSQL: 4.1.20
Hosted on HOSTEXCELLENCE.com
IIS

System is located in a sub directory http://www.nutrisearch.eu/shop/ were we are trying to build a 4-language cart.

Thanks.

Hi.

I've had this to a few times.
Most of the times i would login again and logout immediately. Reset my browser cache and login again and then it would work.

I think you are loosing your session somehow.

Maybe you could try different url. like shop.com or www.shop.com.

Are you using SSL?

Ronald.

Hi Ronald,

Your onto something - I cleared the cache, and tried from different computers without success - BUT - there is no session info! Normally when hover over a link you see the link + session. In my case - sessions for all except the ex-pages multilanguage. eg

https://www.nutrisearch.eu/shop/admi...action=install

Thanks
Terry

Hi
Maybe there is something in .htaccess that is rewritting or something?
Do you have any other mods installed?
Is there any info to be found in the php errorlog?
Ronald.

In my experince when you get booted back to the login page it is the ZC admins ver of a 404 error. you should check that all the muiti lingual files were uploaded properly, w/ the correct permissions. (644 should be good)

I don't get this thing :blink:

I downloaded the latest, had not add a ez-page yet, thinking it would be better to first mod the cart knowing it would be possible to make it multilingual. It went wrong right there. some weird codes of empty tables (sorry forgot to copy the code)

Then added some ez-pages. Have clicked all options back and forth from install to uninstall and also the fix button. But nothing seems to work. The link is not visible and now content from one ez pages comes back in another ezpage.

what is wrong with this mod :shocking:

uninstalling and installing again, the link apeared. Then I changed the (translate) titles and content. Saved the file and the links disappear again. ?

Ok the full story:

I started with this download:
http://www.nevjwebdesign.com/zen_mod...ge_ezpages.zip at the beginning of this topic.

Again I had not made any ez-pages, thinking it would be better to mod it first.

I dropped this SQL in the tools > sql patches:

DROP TABLE IF EXISTS `ezpages_content`;
CREATE TABLE IF NOT EXISTS `ezpages_content` (
`pages_id` int(11) NOT NULL default '0',
`languages_id` int(11) NOT NULL default '1',
`pages_title` varchar(64) NOT NULL default '',
`pages_html_text` text NOT NULL,
KEY `idx_ezpages_content` (`pages_id`,`languages_id`)
) TYPE=MyISAM;

#################

## This next section copies your page titles and content across from the existing ezpages table into the new ezpages_content table
#NEXT_X_ROWS_AS_ONE_COMMAND:3
INSERT INTO ezpages_content (pages_id, pages_title, pages_html_text)
SELECT pages_id, pages_title, pages_html_text
FROM ezpages;

After that. I could not make ezpages at all, and it came with probably this error:

1146 Table 'lagomera_zc1.zen_ezpages_content' doesn't exist
in:
[select count(*) as total from zen_ezpages e, zen_ezpages_content et where e.pages_id = et.pages_id and et.languages_id = '1']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

This is also the message I get, after uninstalling the new mod.

What I did after my first install, is download the mod, that is available in the downloads section at the zencart site. Installed that one and now it is not working anymore.

Does anyone know a solution? Uninstalling brings me back to the message 1146... installing makes the ezpages invisible...

Hi NRG!

Look into your database if there is the table "ezpages_content" that you should have installed with your SQL-statement.

Before you go any further you should make a backup of your database. You should do this all the time, when you want to make changes. Maybe you still have one from the time before you started to implement the multi-language support for EZ-Pages.

Rename the table with "lagomera_zc1.zen_ezpages_content" and then do this via the SQL-interface:

## This next section copies your page titles and content across from the existing ezpages table into the new lagomera_zc1.zen_ezpages_content table
#NEXT_X_ROWS_AS_ONE_COMMAND:3
INSERT INTO lagomera_zc1.zen_ezpages_content (pages_id, pages_title, pages_html_text)
SELECT pages_id, pages_title, pages_html_text
FROM ezpages;

Maybe this will help you. But no guarantee from my side.

:blush:

Smartsoul

it's time for me to learn how that works! I have no idea how to look into the database. So far I managed to install it all and get it working. I do make backups. So I'll surf the web and expand my knowledge on this subject. thanks for the suggestions Smartsoul :)

I installed the newst Multipages from the download section on my 1.3.7 shop. Now the admin area has got the old ezpages as I created them + the (translate me). So I translated a few of my pages, and what happens, is that the links in the header diappear! Will this go away when all pages are translated or is there more to this?

Go to http://www.ecuras.fi/zencart to see the missing links.

The links are also missing in all three languages after updating the translated ezpages. The first link should be 'Home' and the 5th should be Services. The others I haven't started to translate yet since I noticed that the links in the header disappeared, so they have the Finnish link texts and content, since the multilingual ezpages put all content as english, though all content was finnish by 'default'.:blink: