Disaster! My Ez-pages disappeared after upgrade to 1.5.3

[gachogavacho]

Dang, everything seemed to work so well with this upgrade. After searching, I understand that the EZ-pages are stored in the database? Well, after the database upgrade to 1.53 and installing the new version of zencart, my EZ pages info is only showing the Page titles only but are empty. the pages have the name of the page "page title" but when you open the document they are blank! I did get an error with the database import but I don't think this is related to my issue:

When upgrading in install of Zen Cart, I got the following errors across the top of the screen:

32 statements processed.
62 statements processed.
Note: 4 statements ignored. See "upgrade_exceptions" table for additional details.
13 statements processed.
34 statements processed.
16 statements processed.

And then at the very bottom of the screen:

SKIPPED: Cannot drop index page_accessed on table admin_activity_log because it does not exist.
SKIPPED: Cannot drop index access_date on table admin_activity_log because it does not exist.
SKIPPED: Cannot add index idx_page_accessed_zen to table admin_activity_log because it already exists.
SKIPPED: Cannot add index idx_access_date_zen to table admin_activity_log because it already exists.

Preliminary questions:
What version of Zen Cart are you using? Previously 1.38a, upgrading to 1.53
install via FTP.
I'm not sure if I have any plugins/addons other than the table shipping and 'free shipping' modules, that and paypal.
My SQL Server version: 5.1.73-log - MySQL Community Server (GPL)
PHP Version information: 4.1.14.2

[gachogavacho]

I looked for the EZ pages listing in my database and found info! Before I much up this more, It looks like I can copy the html form the database. But I'd have to do this for EVERY page. Thank god the info is there. IS there an easier way to fix this? And if anyone knows, how did this happen? strange. Thanks for any help!

[gachogavacho]

OK, now i'm really confused.

I can see my EZ page with and ID of '1' if I go to the website and click a link to that page.
If I pull up the page in my database, I can see it there.
When I try to edit it in EZ pages it's blank?

I'll await help before proceeding (I hope google doesn't spider my site in the meantime)

[gachogavacho]

I found this thread that talks about the character set in the database. Is this my issue?

[gachogavacho]

The previously mentioend thread I do not think is an appropriate solution since my files for language in admin/includes/language and in /includes/lanauge for english all show UTF-8, and my databases are all UTF-8 so i'm not sure what is causing this. Since my spouse who died a few months back maintained this site, i'm finding modificaiton as I go. I did see there was an EZ pages META tags add on. When I added the 1.5 version addon, it populated info from the database for those fields but I think there is another unidentified add on that needs to be upgraded which is affecting es pages. How can I tell what it is?

[vickilapp]

I have a similar problem, and imagine that they are related. I hope it is appropriate to post here, if this may help those who are looking to fix this problem.

I just upgraded from 1.5.1 to 1.5.3 and am also having an EZ-Page problem. Some of the EZ pages are OK. Some others are also "blank" in the "HTML content" area. I have many EZ-pages that do not show a link in the side bar, but have a link to it from another page in the website. For the ones where they are not showing a link in the sidebar, these pages are inaccessible, and the links do not work.

My site is http://beadinspirations.com.

A page with a link to an ez-page is: http://beadinspirations.com/dragonfl...c-231_186.html

The link is: Step by step instructions: Click here
which should go to
http://beadinspirations.com/instruct...ce-ezp-92.html.

It just opens a blank page, unless I make the link visible in the sidebox. I don't want to make all my ez pages visible in the side box. What to do?

Thank you!
Vicki

[mc12345678]

Wondering how is the link formatted in the location where it shows/follows as it compares to the locations that it doesn't? Ie, what is the actual php code that gets the guest/customer there?

Is one hard coded: http: / / mystore.com and the other made using the zen_href_link function?

Gachogavacho, this has been a long day for you. Is there possibly some error log(s) generated such as if the database has characters in it that likely cause problems because they are not escaped? (Instead of: he's here, should read: he\'s here.)

[mc12345678]

The previously mentioend thread I do not think is an appropriate solution since my files for language in admin/includes/language and in /includes/lanauge for english all show UTF-8, and my databases are all UTF-8 so i'm not sure what is causing this. Since my spouse who died a few months back maintained this site, i'm finding modificaiton as I go. I did see there was an EZ pages META tags add on. When I added the 1.5 version addon, it populated info from the database for those fields but I think there is another unidentified add on that needs to be upgraded which is affecting es pages. How can I tell what it is?

You may not be able to tell what it is, but you may be able to tell what it does and find a plugin that does that now (or perhaps it is already incorporated into the code), but if you download from this website the same version as what you were running, compare that version to yours, you can atleast identify what was changed about the core code. Then if you compare your template folder(s) to the default folder(s) you can further tell what has been installed. Usually either the filenames, notes in the code, or variable names will lead to identify what was installed. Again, some things like admin access control is already in the core ZC code and should not at all be incorporated into 1.5.x as it will cause trouble.

[stellarweb]

Dr. Byte - should this go into bug fixes for 1.5.3?

I have inspected her code on the ezPage and the category page and it is fine..... This particular site mentioned below is a fresh install of 1.5.3 and mods added after the database was upgraded.

I have a similar problem, and imagine that they are related. I hope it is appropriate to post here, if this may help those who are looking to fix this problem.

I just upgraded from 1.5.1 to 1.5.3 and am also having an EZ-Page problem. Some of the EZ pages are OK. Some others are also "blank" in the "HTML content" area. I have many EZ-pages that do not show a link in the side bar, but have a link to it from another page in the website. For the ones where they are not showing a link in the sidebar, these pages are inaccessible, and the links do not work.

My site is http://beadinspirations.com.

A page with a link to an ez-page is: http://beadinspirations.com/dragonfl...c-231_186.html

The link is: Step by step instructions: Click here
which should go to
http://beadinspirations.com/instruct...ce-ezp-92.html.

It just opens a blank page, unless I make the link visible in the sidebox. I don't want to make all my ez pages visible in the side box. What to do?

Thank you!
Vicki

[RixStix]

Does this thread have any relevance?

http://www.zen-cart.com/showthread.php?214007-Page-not-found-when-incorrect-EZPage-link