Forums / All Other Contributions/Addons / TABLE_EZPAGES_TEXT' doesn't exist

TABLE_EZPAGES_TEXT' doesn't exist

Views: 1,295

Results 1 to 5 of 5
18 Aug 2012, 5:41 PM
#1
gazag avatar

gazag

Zen Follower

Join Date:
Jun 2011
Posts:
195
Plugin Contributions:
0

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

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.....:no:

18 Aug 2012, 6:00 PM
#2
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,867
Plugin Contributions:
19

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.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

18 Aug 2012, 6:15 PM
#3
gazag avatar

gazag

Zen Follower

Join Date:
Jun 2011
Posts:
195
Plugin Contributions:
0

Re: TABLE_EZPAGES_TEXT' doesn't exist

dbltoe:

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?????:unsure:

18 Aug 2012, 6:43 PM
#4
drbyte avatar

drbyte

Sensei

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

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

18 Aug 2012, 6:46 PM
#5
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,867
Plugin Contributions:
19

Re: TABLE_EZPAGES_TEXT' doesn't exist

Bad keyboard:censored:
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.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com