Zen Cart Logo
Forums / Installing on a Linux/Unix Server / EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

Views: 5,228

Results 1 to 13 of 13
22 Jan 2012, 2:58 AM
#1
jeff768 avatar

jeff768

New Zenner

Join Date:
Jan 2012
Posts:
25
Plugin Contributions:
0

EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

Just installed zen cart a few days ago. went well. installed Ceon URI and Bloom template by pixemus/12leaves. been working away with edits and I go to Tools -> EZ Pages and ...

EZ-Pages Select a page ...
WARNING: An Error occurred, please refresh the page and try again.

I've refreshed, no avail. Is there a different way to get to the EZ-Pages menu? Is there a way to check the error log?

22 Jan 2012, 5:55 AM
#3
jeff768 avatar

jeff768

New Zenner

Join Date:
Jan 2012
Posts:
25
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

[21-Jan-2012 22:39:53] PHP Fatal error: 1146:Table 'bp.TABLE_EZPAGES_TEXT' doesn't exist :: select count(*) as total from ezpages e, TABLE_EZPAGES_TEXT et

I looked it up in the forums and there is no real clear answer.

22 Jan 2012, 6:12 AM
#4
jeff768 avatar

jeff768

New Zenner

Join Date:
Jan 2012
Posts:
25
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

I looked at simply creating the table in the database and i would need to know the number of columns and such. a bit past my skills. anyone have the structure info for TABLE_EZPAGES_TEXT ?

looking thru the forums there seems to be something with NOT selecting multi language support on install. which i did not install multi language support.

22 Jan 2012, 6:21 AM
#5
jeff768 avatar

jeff768

New Zenner

Join Date:
Jan 2012
Posts:
25
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

Here is the whole error message

[21-Jan-2012 23:14:00] PHP Fatal error: 1146:Table 'buyingca_zcvcp.TABLE_EZPAGES_TEXT' doesn't exist :: select count(*) as total from ezpages e, TABLE_EZPAGES_TEXT et where e.pages_id = et.pages_id and et.languages_id = '1' in /vcp/includes/classes/db/mysql/query_factory.php on line 101

22 Jan 2012, 1:51 PM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

Apparently you've added PHP code for an ez-pages addon but haven't put all the PHP file updates on your server. Namely the define('TABLE_EZPAGES_TEXT', .... statement is missing from your server's files.
Put all the required addon files on your server and things will work better.

10 Mar 2012, 9:17 PM
#7
ogonju avatar

ogonju

New Zenner

Join Date:
Feb 2010
Posts:
2
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

You might have installed CEON url mapper just grab admin/ezpage.php from the orginal zencart 1.5.0 and override the one on your ftp
Hope this helps

30 Jul 2012, 8:36 AM
#8
4jdesigns avatar

4jdesigns

Zen Follower

Join Date:
Jul 2011
Posts:
106
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

Yes, Ogonju is correct, it gets your ez-pages back but removes the option for Ceon's URI Mapping. If you run the mapping installation check you will be told about errors within the ezpages file...

...So if you using CEON URI Mapping then rather copy the 'ezpages.php' from the 'modified_core_files' folder for the URI Mapping. I did it and it seems to work.

Why it happens in the first place? I do not know as I have not replaced nor altered this file...but its fixed.

5 Aug 2012, 4:21 PM
#9
giuly avatar

giuly

Zen Follower

Join Date:
May 2007
Location:
Italy
Posts:
438
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

hello I have same problem, until yesterday it worked perfectly but now today I update all files with italian version of zencart (before and now 1.5.0)
I access to admin page correctly, but I have this error
WARNING: An Error occurred, please refresh the page and try again.
On italian default template I see link to login, on a template that I downloaded free I see only that error.
I attach here message of debug, but I don't know how to solve

[05-Aug-2012 15:14:36 UTC] PHP Fatal error:  1146:Table 'mysitezencart150.ezpages_content' doesn't exist :: select e.pages_id, e.toc_chapter, e.page_open_new_window, e.page_is_ssl, e.alt_url, e.alt_url_external, et.pages_title 							 from  ezpages e, ezpages_content et  
							 where e.pages_id = et.pages_id 
	                         and et.languages_id = '1'  
							 and status_header = 1 
							 and header_sort_order > 0 
							 order by header_sort_order, pages_title in /var/www/mysite.com/www/ingrosso/includes/classes/db/mysql/query_factory.php on line 101



please any advice?
thanks

5 Aug 2012, 5:49 PM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

giuly:

1146:Table 'ezpages_content' doesn't exist
When an error message says "table doesn't exist", it means exactly that. There is no table by that name in your database.
And the only way it would be looking for a table that doesn't exist is if you've added PHP code that looks for that table but haven't made the required changes in the database for the PHP script to be able to run. (Or the PHP code wasn't written in a way that automatically makes the required database changes for you.)

It looks like you're trying to use an addon like "multi-language ez-pages" but haven't followed all the installation instructions for it.
Or whatever new PHP code you added today was written on the assumption that your site is already using that addon.

6 Aug 2012, 8:16 AM
#11
giuly avatar

giuly

Zen Follower

Join Date:
May 2007
Location:
Italy
Posts:
438
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

I see that message, but before upload new files of italian version (same version of zencart 1.5.0) that error didn't exist, so I am sure that if I re upload american version it will be ok (my problem is that italian version has component like VAT deposit bank and other that american doesn't have).
Please do you have any idea how to solve?
Have I to create manually that table? or delete something to solve? Please I wouldn't install again, also because maybe with italian version problem it would be again...
Please if you have any idea :(

6 Aug 2012, 10:32 AM
#12
giuly avatar

giuly

Zen Follower

Join Date:
May 2007
Location:
Italy
Posts:
438
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

solved copying files
ezpages_bar_footer.php
ezpages_bar_header.php
on includes>modules>classic
and includes>modules>mytemplate
:smile:

6 Aug 2012, 11:11 AM
#13
giuly avatar

giuly

Zen Follower

Join Date:
May 2007
Location:
Italy
Posts:
438
Plugin Contributions:
0

Re: EZ - Pages WARNING: An Error occurred, please refresh the page and try again.

sorry I have to add that for non american downloads, for example italian download
delete files on admin
ezpages.php and ezpages.php.bak
and substitute with ezpages.php of the american version.