Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Brisbane, Australia
    Posts
    9
    Plugin Contributions
    0

    Default 1146 Table DB.configuration does not exist

    I'm fairly notice at PHP , mysql


    testing locally on new install of version 1.3.9h

    using DB from online store version 1.3.9g but had upgrade to 1.3.9h

    had initial issue with DB and fixed by adding prefix in admin/includes/configure.php

    define('DB_PREFIX',' znc_'); which must have been the online install default

    can now access admin page , but when I use online catalogue to view the site I get the following error:

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

    I assume I need to change an additional file somewhere to have the DB prefix defined as I did in
    admin/includes/configure ('DB_PREFIX',' znc_');


    is there a separate configure file as I can't see anywhere in the admin/includes/configuration .php code where it's clear I might need to change the prefix

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: 1146 Table DB.configuration does not exist

    You have 2 configuration files:
    /includes/configure.php
    /admin/includes/configure.php

    And, to make changes to them, you need to make them writable, since they're normally set to read-only. You can't upload or save changes to a read-only file.
    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.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Oct 2010
    Location
    Brisbane, Australia
    Posts
    9
    Plugin Contributions
    0

    Default Re: 1146 Table DB.configuration does not exist

    Thank you so much! so simple and yet it had me dumfounded !

 

 

Similar Threads

  1. 1146:Table 'configuration' doesn't exist
    By moesoap in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 25 May 2012, 12:00 PM
  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 'gra10000_zencart.admin_comments' does not exist
    By Grandpolar in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 19 Jan 2009, 10:44 AM

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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR