TABLE_EZPAGES_TEXT' doesn't exist

[gazag]

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

[dbltoe]

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.

[gazag]

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

[DrByte]

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?

[dbltoe]

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.