Zen Cart Logo
Forums / Upgrading to 1.5.x / Database Error: 'ezpages_content' doesn't exist

Database Error: 'ezpages_content' doesn't exist

Views: 1,937

Results 1 to 10 of 10
8 Jun 2012, 7:45 AM
#1
inteltronics avatar

inteltronics

New Zenner

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

Database Error: 'ezpages_content' doesn't exist

Hello to all,
i have installed magic seo url and multilanguage ezpages, ( i use english / italian )

my site is https://www.inteltronics.it i have upgrade it from 1.38 to 1.50, and all gone well,

after i have noted that ezpages not work, i see only http://www.inteltronics.it/ecommerce/array-ezp-8.html if click i go back to index,
i go in my admin panel but there was not multilanguage ez page panel, so i logen in in old panel to uninstall it, after i have done it i get this error in my site:

WARNING: An Error occurred, please refresh the page and try again. ( and missing expages )

this error if i go in old panel:

WARNING: An Error occurred, please refresh the page and try again.
Fatal error: 1146:Table 'scontoso_zc1.zen_ezpages_content' doesn't exist :: select pages_id, pages_title, pages_html_text from zen_ezpages_content where languages_id = '2' in /home/scontoso/public_html/ecommerce/includes/classes/db/mysql/query_factory.php on line 101

and if i go in new admin panel i can't see buttons to add new ezpages or edit.

for sure is database error, any friend can help me?

i have restore database is ok now but ezpages not work: http://www.inteltronics.it/ecommerce/array-ezp-8.html

Wbr, Carmelo.

8 Jun 2012, 7:52 AM
#2
drbyte avatar

drbyte

Sensei

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

Re: Database Error: 'ezpages_content' doesn't exist

Yes, it's a database error caused by the multi-language ez-page addon looking for a table which doesn't exist in your database.

Further, your URLs which say "/ecommerce/array-ezp-4.html" are using the word "array" because of an error in either your ez-page addon or your URL-rewriter addon.

8 Jun 2012, 8:06 AM
#3
inteltronics avatar

inteltronics

New Zenner

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

Re: Database Error: 'ezpages_content' doesn't exist

Thank You for fast reply,

if i put direct link manual work: http://www.inteltronics.it/ecommerce/index.php?main_page=page&id=8
if i click from ezpages not work, maybe .htaccess bad configuration and seo url cause this?
if i go to seo panel and add ezpages in ( Enter pages to allow rewrite ) i get all links to work correctly but i lost html output :(

any solution how i can uninstall multi language ezpage and afetr correct database table?

Wbr. Carmelo.

8 Jun 2012, 9:15 AM
#4
inteltronics avatar

inteltronics

New Zenner

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

Re: Database Error: 'ezpages_content' doesn't exist

i have resolved it, i have add this line in: .htaccess file

RewriteRule ^(.*)-ezp-([0-9]+).html$ index.php?main_page=page&id=$2&%{QUERY_STRING} [L]

now the link is the same; http://www.inteltronics.it/ecommerce/array-ezp-8.html but now i go not to index but to correct page.
i can use multilanguage ezpages in version 1.5.0

Thank You anyway for support and maybe will be useful for others.

Wbr, Carmelo.

8 Jun 2012, 9:23 AM
#5
inteltronics avatar

inteltronics

New Zenner

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

Re: Database Error: 'ezpages_content' doesn't exist

Now my question is how to rename output name : http://www.inteltronics.it/ecommerce/array-ezp-8.html

so array-ezp-33.html

to be example: whoweare.html for google effects.

Any idea?

Wbr, Carmelo.

5 Oct 2012, 3:05 PM
#6
inteltronics avatar

inteltronics

New Zenner

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

Re: Database Error: 'ezpages_content' doesn't exist

inteltronics:

Now my question is how to rename output name : http://www.inteltronics.it/ecommerce/array-ezp-8.html

so array-ezp-33.html

to be example: whoweare.html for google effects.

Any idea?

Wbr, Carmelo.

Hello, no idea how to correct this error array-ezp

example here is the link: http://www.inteltronics.it/ecommerce/array-ezp-8.html
in fact ezpage name is "Chi Siamo" but the link is array-ezp-8.html
any mode to correct this,

Thank You.

5 Oct 2012, 3:11 PM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Database Error: 'ezpages_content' doesn't exist

Try turning off your URL mod

5 Oct 2012, 4:37 PM
#8
drbyte avatar

drbyte

Sensei

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

Re: Database Error: 'ezpages_content' doesn't exist

Correct. Your url-rewrite mods are causing you problems, both for this issue and also for the admin login issue you posted elsewhere.

14 Oct 2012, 7:15 AM
#9
inteltronics avatar

inteltronics

New Zenner

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

Re: Database Error: 'ezpages_content' doesn't exist

Hello, thank You for Your help anytime.
Yes i have correct it, the problem as i think was when i upgrade from 1.3.8 to 1.3.9 and than 1.5.0 i have not upgrade multi-language EZ Pages, so the script was not able to refresh Ez Page name on database for Italian and English and than replace the tittle with array and ezpage number, once removed the script, replaced original files back now is ok, i have not anymore multi-labguage ezpages but i have not anymore database errors. this is grate for me, maybe i will add again later a new version but important is to have clean ezpage names.

Thank You agan friends.

14 Oct 2012, 1:29 PM
#10
gjh42 avatar

gjh42

Black Belt

Join Date:
Jul 2005
Location:
Upstate NY
Posts:
21,876
Plugin Contributions:
8

Re: Database Error: 'ezpages_content' doesn't exist

Multi-Language EZ-Pages was recently upgraded to be compatible with v1.5.x.

http://www.zen-cart.com/downloads.php?do=file&id=36