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

Table TABLE_EZPAGES_TEXT' doesn't exist

Views: 2,298

Results 1 to 12 of 12
18 Dec 2011, 6:35 PM
#1
willstyle avatar

willstyle

New Zenner

Join Date:
Jan 2009
Posts:
7
Plugin Contributions:
0

Table TABLE_EZPAGES_TEXT' doesn't exist

Afternoon all

Have set up a new hosting (3 year old website) and will be transfering to it soon.

had someone move it over for me due to me going on holiday for a few weeks and i have been creating a new look etc. the products and customer base was moved over

the database was moved from 1.3.8.a to 1.3.9h (where i think the problem is)

well im trying to access ez pages in admin and getting the following

1146 Table '*****_zc1.TABLE_EZPAGES_TEXT' doesn't exist
in:
[select count(
) as total from zen_ezpages e, TABLE_EZPAGES_TEXT et where e.pages_id = et.pages_id and et.languages_id = '1']

and way of getting this to work as currently i do want to use ez pages in the header and this is kinder stopping that :laugh:

18 Dec 2011, 10:29 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

TABLE_EZPAGES_TEXT is from an addon, perhaps the multi-language ez-pages addon?
The error you're getting suggests that you're missing pieces of that addon, such as the part that defines what TABLE_EZPAGES_TEXT actually refers to.

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

14 Apr 2012, 4:12 PM
#3
windsurfer avatar

windsurfer

Zen Follower

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

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

Just wondering if you have this issue resolved ?

If you wait to do everything until you're sure it's right, you'll probably never do much of anything !!!

22 Jul 2013, 8:14 AM
#4
amandavz avatar

amandavz

Zen Follower

Join Date:
Mar 2009
Location:
Crockett, Texas
Posts:
139
Plugin Contributions:
0

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

Hi...I recently installed both Sitemap XML and CEON URI modules and I am getting this error on my EZ Pages:

1146 Table 'london_zc5.TABLE_EZPAGES_TEXT' doesn't exist
in:
[select count(*) as total from zen_ezpages e, TABLE_EZPAGES_TEXT et where e.pages_id = et.pages_id and et.languages_id = '5']
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.

Any ideas? I do not have Multilanguage EZPages installed...my Zen cart is 1.3.9h. Thanks.

Amanda Vande Zande
AllClipART.info
Lonestar Princess

22 Jul 2013, 9:16 AM
#5
picandnix avatar

picandnix

Totally Zenned

Join Date:
Dec 2010
Location:
UK
Posts:
1,780
Plugin Contributions:
2

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

hmm, this thread is dotted with same errors http://www.zen-cart.com/showthread.php?35883-Multi-Language-Support-for-EZ-Pages&p=837891&highlight=TABLE_EZPAGES_TEXT%27+doesn%27t+exist#post837891
could the mod be preinstalled in your template?
Perhaps the ZC guru advertised on your own site could help? http://allclipart.info/shop/zen-cart-assistance

22 Jul 2013, 9:23 AM
#6
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

Since you are using CEON Uri mapping, did you in stall the file from the folder "third_party_module_integration\multilanguage_ezpages_1.3.0.5v2.02\1.3.5\admin" ?
These files contain the code you mentioned, and if you did not install the ez page multi language mod you will get the error you mentioned.

22 Jul 2013, 9:35 AM
#7
picandnix avatar

picandnix

Totally Zenned

Join Date:
Dec 2010
Location:
UK
Posts:
1,780
Plugin Contributions:
2

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

Design75:

Since you are using CEON Uri mapping, did you in stall the file from the folder "third_party_module_integration\multilanguage_ezpages_1.3.0.5v2.02\1.3.5\admin" ?
These files contain the code you mentioned, and if you did not install the ez page multi language mod you will get the error you mentioned.

Well spotted Design75, sorry Amanda for guiding you away from the Ceon thread for this issue.

22 Jul 2013, 1:04 PM
#8
amandavz avatar

amandavz

Zen Follower

Join Date:
Mar 2009
Location:
Crockett, Texas
Posts:
139
Plugin Contributions:
0

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

Design75:

Since you are using CEON Uri mapping, did you in stall the file from the folder "third_party_module_integration\multilanguage_ezpages_1.3.0.5v2.02\1.3.5\admin" ?
These files contain the code you mentioned, and if you did not install the ez page multi language mod you will get the error you mentioned.

I did install this page in my admin, maybe I am not needing it and should try uninstalling it?

Amanda Vande Zande
AllClipART.info
Lonestar Princess

22 Jul 2013, 2:17 PM
#9
design75 avatar

design75

Totally Zenned

Join Date:
Dec 2009
Location:
Amersfoort, The Netherlands
Posts:
2,862
Plugin Contributions:
5

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

amandavz:

I did install this page in my admin, maybe I am not needing it and should try uninstalling it?

If not using the multilanguage ezpages => YES

22 Jul 2013, 2:34 PM
#10
amandavz avatar

amandavz

Zen Follower

Join Date:
Mar 2009
Location:
Crockett, Texas
Posts:
139
Plugin Contributions:
0

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

Design75:

If not using the multilanguage ezpages => YES

Hey...That worked!!! Thanks so much for all your help. :)

Amanda Vande Zande
AllClipART.info
Lonestar Princess

22 Jul 2013, 3:58 PM
#11
picandnix avatar

picandnix

Totally Zenned

Join Date:
Dec 2010
Location:
UK
Posts:
1,780
Plugin Contributions:
2

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

amandavz:

Hey...That worked!!! Thanks so much for all your help. :)

So you did actually have it installed?

22 Jul 2013, 4:04 PM
#12
amandavz avatar

amandavz

Zen Follower

Join Date:
Mar 2009
Location:
Crockett, Texas
Posts:
139
Plugin Contributions:
0

Re: Table TABLE_EZPAGES_TEXT' doesn't exist

I have just recently installed the module but I did in fact load the ezpage.php into my admin folder. I uploaded the old ezpages.php without the CEON Uri info and it went back to normal. The Template did not come pre-installed with the module.

BTW - I am the Zen Cart Guru from the web link. I only became that through trial and error and reading the forums. LOL. Thanks for all your help. Have a great week!!! :)

Amanda Vande Zande
AllClipART.info
Lonestar Princess