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

[jeff768]

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?

[DrByte]

https://www.zen-cart.com/tutorials/i...hp?article=412

[jeff768]

[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.

[jeff768]

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.

[jeff768]

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

[DrByte]

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.

[ogonju]

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

[4jDesigns]

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.

[giuly]

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

[DrByte]

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.