Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011
    Posts
    169
    Plugin Contributions
    0

    application error TABLE_EZPAGES_TEXT' doesn't exist

    Hello,

    I have tried installing this mod Set EZPage as Home Page as i want to have a different homepage for a while...

    After installing i get an error in my admin on the ezpages.php file and non of my ezpages show up

    Code:
    1146 Table '#########.TABLE_EZPAGES_TEXT' doesn't exist
    in:
    [select count(*) as total from ezpages e, TABLE_EZPAGES_TEXT et where e.pages_id = et.pages_id and et.languages_id = '1']
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
    Can someone help out - i am figuring that the issue is in the ezpages.php file as it has TABLE_EZPAGES_TEXT in it but i don't know what to change it to.....

  2. #2
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    5,049
    Plugin Contributions
    6

    Default Re: TABLE_EZPAGES_TEXT' doesn't exist

    Did you do the change to the database described in the readme.txt file? This is looking for a define rather than a table.

    The sitemap is looking for a defined TABLE_EZPAGES_TXT. Perhaps the mod does not properly address the sitemap requirement.
    Did you read the posting tips?!?
    Things We've Done
    MOD: Scheduled Events

  3. #3
    Join Date
    Jun 2011
    Posts
    169
    Plugin Contributions
    0

    Default Re: TABLE_EZPAGES_TEXT' doesn't exist

    Quote Originally Posted by dbltoe View Post
    Did you do the change to the database described in the readme.txt file?
    Yes i did the SQL mod..

    The sitemap is looking for a defined TABLE_EZPAGES_TXT. Perhaps the mod does not properly address the sitemap requirement
    What do you mean? Do i need to edit the TABLE_EZPAGES_TEXT defines in ezpages.php to TABLE_EZPAGES_TXT or?????

  4. #4
    Join Date
    Jan 2004
    Posts
    58,464
    Blog Entries
    3
    Plugin Contributions
    111

    Default Re: TABLE_EZPAGES_TEXT' doesn't exist

    TABLE_EZPAGES_TEXT is a constant, which requires a define in order for it to be recognized.

    So, just like ANY case of seeing the name of a constant instead of its defined value, it means you don't have a define() statement for that constant.

    Either the addon you're trying to install isn't designed for what you're trying to make it do, or is missing an important component, or you've not uploaded all the files associated with it.
    Or maybe the code you're using is ASSUMING that you've got ANOTHER addon ALSO installed, such as multi-language-ezpages ... which apparently uses the same tablename as what you're posting about.

    One of the files should contain a define('TABLE_EZPAGES_TEXT', DB_PREFIX . 'ezpages_text'); statement someplace. And probably has more in it that you also need. And if this addon relies on stuff from another addon, you probably should be installing that other addon too.

    Or revisit whether you need the complexities of that other addon. Maybe you should revise this addon to be much simpler and not require the other one?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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.

  5. #5
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    5,049
    Plugin Contributions
    6

    Default Re: TABLE_EZPAGES_TEXT' doesn't exist

    Bad keyboard
    Gotta get one that can type. Should be TEXT -- AND, that variable is not in the standard ezpages.php file. Strange that it's in the sitemap.
    Couldn't find a support thread so you might want to PM the author.
    Did you read the posting tips?!?
    Things We've Done
    MOD: Scheduled Events

 

 

Similar Threads

  1. Table TABLE_EZPAGES_TEXT' doesn't exist
    By willstyle in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 14 Apr 2012, 05:12 PM
  2. .TABLE_CEON_URI_MAPPINGS' doesn't exist
    By crlannen in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 25 Nov 2009, 11:00 AM
  3. 1146 Table 'ram_zc1.TABLE_EZPAGES_TEXT' doesn't exist
    By ram336ram in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 13 Sep 2009, 11:26 AM

Bookmarks

Posting Permissions

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