Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Location
    Canton, Ohio
    Posts
    24
    Plugin Contributions
    0

    Default 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. #2
    Join Date
    Jan 2008
    Location
    Canton, Ohio
    Posts
    24
    Plugin Contributions
    0

    Default 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

  3. #3
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,845
    Plugin Contributions
    25

    Default Re: How many Tables in Standard Zen Cart Database

    A fresh install gives me 93 tables

  4. #4
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default 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/i...hp?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?
    .

    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.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 19 Mar 2013, 01:58 AM
  2. How many concurrent shoppers can Zen Cart support?
    By fharju in forum General Questions
    Replies: 2
    Last Post: 8 Oct 2009, 11:47 PM
  3. How many products can zen cart handle ?
    By funfuntimer in forum General Questions
    Replies: 8
    Last Post: 2 Mar 2009, 08:22 PM

Posting Permissions

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