Zen Cart Logo
Forums / General Questions / How many Tables in Standard Zen Cart Database?

How many Tables in Standard Zen Cart Database?

Views: 1,321

Results 1 to 4 of 4
2 Mar 2011, 4:38 PM
#1
klingstedtbrothers avatar

klingstedtbrothers

New Zenner

Join Date:
Jan 2008
Location:
Canton, Ohio
Posts:
24
Plugin Contributions:
0

How many Tables in Standard Zen Cart Database?

I'm getting the following error after doing a migration on GoDaddy servers:

1146 Table 'msp0918105455728.zen_product_type_layout' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from zen_product_type_layout]

I've checked the database and I have 17 tables under "Information Schema" and 44 under the actual database name. This seems low to me. The last table alphabetically is "zen_media_types" All the tables have "zen_" before it.

Can anyone verify how many tables I should have in a standard installation?

2 Mar 2011, 4:56 PM
#2
klingstedtbrothers avatar

klingstedtbrothers

New Zenner

Join Date:
Jan 2008
Location:
Canton, Ohio
Posts:
24
Plugin Contributions:
0

Re: How many Tables in Standard Zen Cart Database?

okay we got a restore. 96 was the correct number of tables. The front end is back up and running bit the back end is giving me this error:

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/m/s/p/mspexpress/html/admin/includes/classes/logger.php:127) in /home/content/m/s/p/mspexpress/html/includes/functions/sessions.php on line 108

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/m/s/p/mspexpress/html/admin/includes/classes/logger.php:127) in /home/content/m/s/p/mspexpress/html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/content/m/s/p/mspexpress/html/admin/includes/classes/logger.php:127) in /home/content/m/s/p/mspexpress/html/admin/includes/init_includes/init_templates.php on line 71

Warning: Cannot modify header information - headers already sent by (output started at /home/content/m/s/p/mspexpress/html/admin/includes/classes/logger.php:127) in /home/content/m/s/p/mspexpress/html/admin/includes/functions/general.php on line 41

2 Mar 2011, 5:25 PM
#3
design75 avatar

design75

Totally Zenned

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

Re: How many Tables in Standard Zen Cart Database?

A fresh install gives me 93 tables

2 Mar 2011, 10:57 PM
#4
drbyte avatar

drbyte

Sensei

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

Re: How many Tables in Standard Zen Cart Database?

93 base, plus any additional tables created by enabled features or added addons.

Your "cannot modify header" messages are being caused by output info or an error message that's being displayed before the main content can be output.

You're changing host servers, so maybe some of this article applies? https://www.zen-cart.com/tutorials/index.php?article=100 Esp the fix_cache_key part.

And/or maybe your /admin/includes/classes/logger.php file has extra blank lines at the bottom?