Results 1 to 10 of 10
  1. #1
    Join Date
    Oct 2008
    Posts
    407
    Plugin Contributions
    0

    Default 1146 Table 'xxxxx_xxx.configuration' doesn't exist

    Hi All,

    Recently moved my site to a new server. All was fine until this morning I saw this message when trying to access my site:

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

    Not sure if it occurred before or after canceling the old account.

    Any ideas how I can fix this?

    Thanks!

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,655
    Plugin Contributions
    25

    Default Re: Error message with mysql table

    Does you database have a prefix in front of the tables? e.g. zen_configuration?
    See and test drive Zen Cart's free templates at zencarttemplates.info

    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Oct 2008
    Posts
    407
    Plugin Contributions
    0

    Default Re: Error message with mysql table

    Hi Kuroi,

    Yes it does.

  4. #4
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,655
    Plugin Contributions
    25

    Default Re: Error message with mysql table

    Then you will need to add that prefix to your includes/configure.php and admin/includes/configure.php files.

    Look for the lines that read
    define('DB_PREFIX', '');
    and insert your prefix between the two quotes after the comma.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  5. #5
    Join Date
    Oct 2008
    Posts
    407
    Plugin Contributions
    0

    Default Re: Error message with mysql table

    thanks so much! Will give that a shot

  6. #6
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,655
    Plugin Contributions
    25

    Default Re: 1146 Table 'xxxxx_xxx.configuration' doesn't exist

    We've also seen a number of reports over the past 24 hours of configuration tables, with and without prefixes, simply disappearing. One hosts name seems to be involved in each case, either directly or as the possible ultimate host behind a reseller.

    If your configuration table is missing, the above solution won't work for you. please post back here with details of your host and the version of Zen Cart that you are using.
    See and test drive Zen Cart's free templates at zencarttemplates.info

    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  7. #7
    Join Date
    Oct 2008
    Posts
    407
    Plugin Contributions
    0

    Default Re: 1146 Table 'xxxxx_xxx.configuration' doesn't exist

    HI Kuroi,

    I was actually able to get my front end up by deleting the database and restoring a backup.

    However, I still can't get into my admin area. Getting error message:

    1146 Table 'xxxx_t4k.xxxxproject_version' doesn't exist
    in:
    [select * from xxxxproject_version WHERE project_version_key = 'Zen-Cart Database' ]
    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.

    Checked the config files and all seems fine with the paths

    Trying to access using path:
    http://mysite.com/admin/

    no success

    P.S. I transfered my site over to hostgator. Hosted a couple of other sites with them for some time now and never had an issue. Hope they are not the source of the problem.

    Also I'm still using version 1.3.8

    Thanks!

  8. #8
    Join Date
    Jan 2004
    Posts
    58,257
    Blog Entries
    3
    Plugin Contributions
    106

    Default Re: 1146 Table 'xxxxx_xxx.configuration' doesn't exist

    Does the DB_PREFIX for your /admin/includes/configure.php match the DB_PREFIX in your /includes/configure.php ?

    Does that prefix match the names of your tables in your database?
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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.

  9. #9
    Join Date
    Oct 2008
    Posts
    407
    Plugin Contributions
    0

    Default Re: 1146 Table 'xxxxx_xxx.configuration' doesn't exist

    OK, think I know what i did wrong. My database has a prefix, but my tables in my mysql doesn't.

    So when I took out that prefix name from

    define('DB_PREFIX', '');

    it worked!

    Looks like I got the DB_Database and DB_Prefix mixed up.

    Thanks for the help...would of taking me hours to figure that one out!!

    Ciao!

  10. #10
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    64,697
    Plugin Contributions
    6

    Default Re: 1146 Table 'xxxxx_xxx.configuration' doesn't exist

    Quote Originally Posted by mw4kids View Post
    Also I'm still using version 1.3.8
    Using that very old version of Zen Cart ... have you applied all of the Known Bug Fixes ...
    http://www.zen-cart.com/forum/showthread.php?t=82619

    and Security Patches and Updates ...
    http://www.zen-cart.com/forum/showthread.php?t=131115

    NOTE: upgrading to the current Zen Cart on our Home page has all of this and more ...

    And have you looked through your site for signs of hacks in your files and database?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.1]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

 

 

Similar Threads

  1. 1146 Table DB.configuration does not exist
    By pippa_oz in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 1 Nov 2010, 07:50 AM
  2. 1146 Table 'configuration' doesn't exist
    By Friedrich72 in forum Installing on a Linux/Unix Server
    Replies: 8
    Last Post: 15 Aug 2010, 05:28 PM
  3. 1146 Table 'sportrec_shop.configuration' doesn't exist
    By sportrecovery in forum Upgrading from 1.3.x to 1.3.9
    Replies: 0
    Last Post: 6 Jul 2010, 04:01 PM
  4. 1146 Table 'mynewdatabase.configuration' doesn't exist in:
    By marymortis in forum General Questions
    Replies: 8
    Last Post: 14 Oct 2009, 10:04 PM
  5. 1146 Table 'retail_nailspaandbeauty_com.configuration' doesn't exist
    By aiss in forum Installing on a Windows Server
    Replies: 3
    Last Post: 22 Jun 2006, 01:04 PM

Bookmarks

Posting Permissions

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