Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    I have just used the tutorial "I want to move my Zen cart installation to another host or different server" the idea being to use it on my localhost, using Xampp.
    I need to correct numerous errors made sometime ago before I 'Upgrade'.
    I believe I followed the instructions to the letter, but obviously got it wrong somewhere as I get an error on loading in the browser.

    The error is
    "1146 Table 'beeworks_zc1.configuration' doesn't exist
    in:
    [select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]"

    I would appreciate an explanation and a fix if possible! If not I start again, and again, and again ad nauseam. By which you'll gather I've had my share of problems.
    The 'beeworks_zc1' is my database.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Literally, it means "the table named 'configuration' inside the database named 'beeworks_zc1' can't be found", and thus the program can't find the data it needs, and thus cannot continue running.

    In the tutorial you mentioned, it tells you to pay attention to database names and also table-prefixes ("DB_PREFIX"). Usually the error message you quoted is a result of not properly indicating the correct database name and table-prefix in the configure.php files of the server that's showing the error message. The FAQ article does cover all the steps ... and still many people miss some of the things mentioned there for one reason or another.
    .

    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.

  3. #3
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Quote Originally Posted by DrByte View Post
    Literally, it means "the table named 'configuration' inside the database named 'beeworks_zc1' can't be found", and thus the program can't find the data it needs, . The FAQ article does cover all the steps ... and still many people miss some of the things mentioned there for one reason or another.
    Thank you, you're right, sorry for wasting your time.
    I just checked my setup again. I had selected the wrong database file.
    Back to the drawing board.

  4. #4
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Quote Originally Posted by DrByte View Post
    In the tutorial you mentioned, it tells you to pay attention to database names and also table-prefixes ("DB_PREFIX"). Usually the error message you quoted is a result of not properly indicating the correct database name and table-prefix in the configure.php files of the server that's showing the error message.
    I hate to be a pain, but after loading and unloading so many times I could do it with my eyes shut, I have to say 'It's not working'.
    To date. Using ZC 1.3.7 and Xampp two versions 1.4 and 1.7 and being super/super careful with every entry, every comma and period correct, I continue to get the same error.
    Is there any other way to download and run a 'live' site on localhost? Any other suggestions? Please.

  5. #5
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    If you "continue to get the same error", and that error is "1146 Table 'beeworks_zc1.configuration' doesn't exist", then the problem is that your local install either doesn't have a database entitled "beeworks_zc1", or if it does, then that database doesn't have a table named "configuration" inside it.
    .

    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.

  6. #6
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Quote Originally Posted by DrByte View Post
    If you "continue to get the same error", and that error is "1146 Table 'beeworks_zc1.configuration' doesn't exist", then the problem is that your local install either doesn't have a database entitled "beeworks_zc1", or if it does, then that database doesn't have a table named "configuration" inside it.
    Ummm! There is the problem, the database is beeworks_zc1 and there is a table called 'configuration. These are the items I checked so diligently before I posted this thread!
    Any other way to achieve what I need, as this is getting boring for all concerned. Please!
    I have to correct errors as I didn't use the overides when I first built the site, so now I cannot upgrade.

  7. #7
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Please disregard the previous post, I've fixed it, with reservations.
    I assumed in my ignorance that not selecting SSL in the install wouldn't make any difference. Seems I was wrong.
    My apologies for any inconvenience.
    Now I've got "Session start and Header errors". Never stops does it?

  8. #8
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Using SSL or not for a local test install should have no bearing whatsoever on whether the database can be connected.
    .

    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.

  9. #9
    Join Date
    Jul 2009
    Posts
    18
    Plugin Contributions
    0

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    Quote Originally Posted by DrByte View Post
    Using SSL or not for a local test install should have no bearing whatsoever on whether the database can be connected.
    OK. I'm not in a position to argue, but it was the only thing I changed from the previous 6 installs!
    Subject closed?

  10. #10
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "1146 Table 'beeworks_zc1.configuration' doesn't exist" when moving my site

    No worries. Just adding comments for those who might read this discussion later and go trying something on supposition.

    Glad you got it working for your needs.
    .

    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.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. 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
  2. "1146 Table 'zen_project_version' doesn't exist, dns error
    By joleady in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 5 Aug 2010, 05:34 AM
  3. edit order error: "1146 Table 'google_orders' doesn't exist
    By icehokz in forum Addon Payment Modules
    Replies: 3
    Last Post: 25 Feb 2010, 05:06 PM
  4. Replies: 6
    Last Post: 7 Apr 2009, 12:30 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