Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

    Default 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 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.
    Last edited by inteltronics; 8 Jun 2012 at 08:51 AM.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

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

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

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

  4. #4
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

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

  5. #5
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

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

  6. #6
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

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

    Quote Originally Posted by inteltronics View Post
    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.

  7. #7
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

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

    Try turning off your URL mod
    Zen-Venom Get Bitten

  8. #8
    Join Date
    Jan 2004
    Posts
    66,444
    Plugin Contributions
    279

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

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  9. #9
    Join Date
    Apr 2012
    Posts
    25
    Plugin Contributions
    0

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

  10. #10
    Join Date
    Jul 2005
    Location
    Upstate NY
    Posts
    22,010
    Plugin Contributions
    25

    Default 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

 

 

Similar Threads

  1. EZ Pages disappeared and get "Table 'ezpages_content' doesn't exist" error
    By ilmarchez in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 19 Nov 2011, 05:34 AM
  2. Replies: 6
    Last Post: 7 Apr 2009, 12:30 AM
  3. Replies: 7
    Last Post: 18 Jul 2007, 05:09 PM
  4. error message says database 'address book' doesn't exist
    By Ken Joy in forum Installing on a Linux/Unix Server
    Replies: 8
    Last Post: 9 Mar 2007, 04:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg