ezpages not showing

[enzo-ita]

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

[kobra]

Where do you have them set to be shown??

Header, sidebox or footer?

[enzo-ita]

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.

[enzo-ita]

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

[kobra]

Try switching to the classic template and see if they appear

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

[enzo-ita]

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

[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

[picaflor-azul]

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

[Nick1973]

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.