ezpages not showing

I found suddenly a problem that would explain why my bouncing rate is growing up day by day.
The ez pages are not shown,
Clicking on a ez page this is what you get
1146 Table 'acquatua_zenen.ezpages_content' doesn't exist
in:
[select e.pages_id, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, e.header_sort_order, e.sidebox_sort_order, e.footer_sort_order, e.toc_sort_order, e.toc_chapter, e.status_header, e.status_sidebox, e.status_footer, status_toc, et.pages_title, et.pages_html_text from ezpages e, ezpages_content et where e.pages_id = et.pages_id and et.languages_id = '2' and e.pages_id = 10]

I do not know since when this happens and I am not sure why it happens.

acquatua_zenen is the name of my db.

The ez pages are there in the admin section and I can see and mod them.
I am runnig 1.39h
If you want to watch my site is www. a c q u a t u a.it

I really do not have any clue on waht to look for.
I am not asking for a solution from, instead I look for a suggestion on which file/s I should look for. I do not rememeber I have mod anything related to ezpages.

Which files are involved in the ezpages management?

Please help, the ezpages are important for my site.
Thanks
enzo

Where do you have them set to be shown??

Header, sidebox or footer?

Hi,
thanks for your answer.
They are set to be shown in header only.
I have solved partially the problem.
Now when clicking on a ezpage link, instead of the error you get a blank page.
The error was due to the files included in the italian version calling a table that exists only in the italian version of the database.
I still have to solve the fact that now when clicking on a ez page title you get tha site structure but the area where you should see the ezpage content is blank.
I have overwritten all the files containing the word ezpages in their names using the original 139h version files but with no results.
May be there are other files needing to be overwritten, but I do not know which one.
I need further help.
Thanks
enzo

EDIT
I have also tried to create a new ezpage and the link shows in the header, but if I click on it, like for the others, it shows a blank page.

I have activated the debugging.
The file log says:
[22-Feb-2011 07:05:10] PHP Fatal error: Call to a member function RecordCount() on a non-object in /home7/acquatua/public_html/includes/templates/template_default/templates/tpl_page_default.php on line 32

So I have overwritten also tpl_page_default.php with the original version file, but no changes.
No surprise because the file in the site and the original were identical.
But now I am really stuck.
I have no more ideas to apply.
I wait for your comments.
thanks
enzo

Try switching to the classic template and see if they appear

That will narrow your searching to only those files in your desired template

Good idea, but unfortunately it did not work.
Using the classic template nothing changed.
One more please!!!:smile:
Thanks
enzo

I have this problem too.

When I click on an EZ Page it isn't showing any content and when I go into debug it show

Call to a member function RecordCount() on a non-object in tpl_page_default.php on line 32

I've checked tpl_page_default.php and it would appear to be somewhere in this code:

<?php if (EZPAGES_SHOW_PREV_NEXT_BUTTONS=='2' and $counter > 1) { ?> <div id="navEZPageNextPrev"> <a href="<?php echo $prev_link; ?>"><?php echo $previous_button; ?></a> <?php echo zen_back_link() . $home_button; ?></a> <a href="<?php echo $next_link; ?>"><?php echo $next_item_button; ?></a> </div> <?php } elseif (EZPAGES_SHOW_PREV_NEXT_BUTTONS=='1') { ?> <div id="navEZPageNextPrev"><?php echo zen_back_link() . $home_button . '</a>'; ?></div> <?php } ?> <?php // vertical TOC listing // create a table of contents for chapter when more than 1 page in the TOC if ($pages_listing->RecordCount() > 1 and EZPAGES_SHOW_TABLE_CONTENTS == '1') {?>

I've been in the database and checked there, uploaded an ORIGINAL zen cart 1.5.3 tpl_page_default.php, tried overwriting includes/modules/pages/page/header_php.php with an original file. Still no luck!

Looking at the html code on the page it stops just after <div class="centerColumn" id="ezPageDefault"> and is blank.

Can you shed any light on this please?

Thank You

Nick

Nick1973:

I have this problem too.

When I click on an EZ Page it isn't showing any content and when I go into debug it show

Call to a member function RecordCount() on a non-object in tpl_page_default.php on line 32

I've checked tpl_page_default.php and it would appear to be somewhere in this code:

<?php if (EZPAGES_SHOW_PREV_NEXT_BUTTONS=='2' and $counter > 1) { ?> <div id="navEZPageNextPrev"> <a href="<?php echo $prev_link; ?>"><?php echo $previous_button; ?></a> <?php echo zen_back_link() . $home_button; ?></a> <a href="<?php echo $next_link; ?>"><?php echo $next_item_button; ?></a> </div> <?php } elseif (EZPAGES_SHOW_PREV_NEXT_BUTTONS=='1') { ?> <div id="navEZPageNextPrev"><?php echo zen_back_link() . $home_button . '</a>'; ?></div> <?php } ?> <?php // vertical TOC listing // create a table of contents for chapter when more than 1 page in the TOC if ($pages_listing->RecordCount() > 1 and EZPAGES_SHOW_TABLE_CONTENTS == '1') {?>

I've been in the database and checked there, uploaded an ORIGINAL zen cart 1.5.3 tpl_page_default.php, tried overwriting includes/modules/pages/page/header_php.php with an original file. Still no luck!

Looking at the html code on the page it stops just after <div class="centerColumn" id="ezPageDefault"> and is blank.

Can you shed any light on this please?

Thank You

Nick

This is a bug with 1.5.3. I have seen a fix posted for this on the forum. If you do a search you will find the thread. I'll try to find it also. A bandaid fix would be to upload the includes/modules/pages/page/header_php.php file from version 1.5.1

Thanks,

Anne

Yeah I tried that Anne, didn't work unfortunately. Thanks for the reply.

Nick1973:

Yeah I tried that Anne, didn't work unfortunately. Thanks for the reply.

Hi Anne, I have resolved this now.

I came back to it with a fresh head and tried uploading a 1.5.1 version of includes/modules/pages/page/header_php.php and it worked.

I think I probably had a caching issue which was probably stopping the change showing up in my browser. I also deleted the 1.5.3 version of the above file first rather than overwriting it as I found that trying to overwrite it didn't do anything.

However, while this fixes the issue it is obviously a bug and I would have thought needs addressing as I did notice differences in the 1.5.3 file.

picaflor-azul:

This is a bug with 1.5.3. I have seen a fix posted for this on the forum. If you do a search you will find the thread. I'll try to find it also. A bandaid fix would be to upload the includes/modules/pages/page/header_php.php file from version 1.5.1

Thanks,

Anne
I think this may be the fix you were meaning ... but I'm not sure it fixes the posted issue https://github.com/zencart/zencart/pull/152/files

I don't believe the symptoms posted in this thread are actually a ZC bug, but merely an incompatibility between versions.

The ez-pages template for v1.5.1 is NOT compatible with v1.5.3, because of core changes to ez-pages required to fix other errors that were troublesome in 151.

So, if you're using a custom template built for v1.5.1 on a v1.5.3 site, you'll need to re-customize your tpl_page_default.php file ...

// vertical TOC listing// create a table of contents for chapter when more than 1 page in the TOC
  if ($pages_listing->RecordCount() > 1 and EZPAGES_SHOW_TABLE_CONTENTS == '1') {?>
<div id="navEZPagesTOCWrapper">
<h2 id="ezPagesTOCHeading"><?php echo TEXT_EZ_PAGES_TABLE_CONTEXT; ?></h2>
<div id="navEZPagesTOC">
<ul>
<?php while (!$pages_listing->EOF) {
// could be used to change classes on current link and toc (table of contents) links
      if ($pages_listing->fields['pages_id'] == $_GET['id']) { ?>


<li><?php echo CURRENT_PAGE_INDICATOR; ?><a href="<?php echo zen_ez_pages_link($pages_listing->fields['pages_id']);?>"><?php echo $pages_listing->fields['pages_title']; ?></a></li>


<?php } else { ?>


<li><?php echo NOT_CURRENT_PAGE_INDICATOR; ?><a href="<?php echo  zen_ez_pages_link($pages_listing->fields['pages_id']); ?>"><?php echo $pages_listing->fields['pages_title']; ?></a></li>
<?php
      }
      $pages_listing->MoveNext();
    } ?>
```becomes ```
// vertical TOC listing
// create a table of contents for chapter when more than 1 page in the TOC
  if (sizeof($toc_links) > 1 and EZPAGES_SHOW_TABLE_CONTENTS == '1') {?>
<div id="navEZPagesTOCWrapper">
<h2 id="ezPagesTOCHeading"><?php echo TEXT_EZ_PAGES_TABLE_CONTEXT; ?></h2>
<div id="navEZPagesTOC">
<ul>
<?php foreach($toc_links as $link) {
// could be used to change classes on current link and toc (table of contents) links
      if ($link['pages_id'] == $_GET['id']) { ?>


<li><?php echo CURRENT_PAGE_INDICATOR; ?><a href="<?php echo zen_ez_pages_link($link['pages_id']);?>"><?php echo $link['pages_title']; ?></a></li>


<?php } else { ?>


<li><?php echo NOT_CURRENT_PAGE_INDICATOR; ?><a href="<?php echo zen_ez_pages_link($link['pages_id']); ?>"><?php echo $link['pages_title']; ?></a></li>
<?php
      }
    } ?>

I will keep this in mind for future reference.

However, I'm not sure this is totally an incompatibility issue as it happened on a clean install with the correct PHP version and Mysql version.