Page 1 of 3 123 LastLast
Results 1 to 10 of 22
  1. #1
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Database error after moving hosts

    You guys have prob had this one a million times before.
    I have moved hosts and as per instructions on the FAQ section but I get the following...

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

    I have checked the 2 config files and the database names match up.
    I also used the fix key script which worked on another migration a few months back but no go for this one...

  2. #2
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    i should say i went from version Zen Cart 1.3.0.1
    to 1.3.8.
    Maybe that is my problem??

  3. #3
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    well i just redid the whole thing again with same version and exactly the same probelm.
    any help appreciated.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Database error after moving hosts

    If it's saying that the "configuration" table doesn't exist, then it's connecting to a database somewhere, but not the one that contains Zen Cart tables.

    So, make sure that you've properly set the database server/host name, database name, username/password properly for the new server.

    If you've followed the FAQ on moving to a new server ( https://www.zen-cart.com/tutorials/i...hp?article=100 ) then before you imported your data, the store should have been working. If not, then you've got an "installation" problem, not a "move" problem.

    Additionally, if you're importing data from another server, it's important, as mentioned in the FAQ, to use the SAME setting for DB_PREFIX on the new server as you had on the old server. Otherwise you're telling it to point to a set of tables in your database that may be incorrect or don't exist at all.
    .

    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.

  5. #5
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    Can you explain what the prefix is pls.
    Everything else checks ok.
    It works fine with the orig database.
    The prob is there when I upload the old database.
    And when I reload the new one back up again it all works fine again...

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Database error after moving hosts

    DB_PREFIX is defined in your configure.php files.

    If it's defined as blank, then Zen Cart assumes there is no prefix added to table names.
    If it's defined as some value, then Zen Cart adds that prefix to the start of all table names when it generates a query to extract data from the database.

    So, in the case of the "configuration" table, if the prefix is left blank, then Zen Cart looks for a table named "configuration". If the prefix is defined as "storedata_" then Zen Cart looks for a table named "storedata_configuration".

    That's why the FAQ about moving hosts tells you to make sure you use the same DB_PREFIX setting in your new site as you did in your old site. That way when you import your data from the old server to the new one, your new store will be able to find the tables used for Zen Cart.
    .

    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.

  7. #7
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    Thanks Dr.
    I am pretty sure they are blank at the moment.
    Can I just adjust this in the 2 config files or better to reinstall the right way?

  8. #8
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    I will start again I think.
    So my old database file was named for example...
    blabla_zc1

    When I install new setup I insert blabla_ for the prefix section?
    Correct?

  9. #9
    Join Date
    Mar 2008
    Location
    Cape Town & London (depends on the season)
    Posts
    2,975
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    Don't confuse the database NAME with the table PREFIX.

    (The "prefix" in the NAME is often your host login name).

    Try opening your database in phpMyAdmin and looking to see if the tables have a prefix. If they do, then that is the prefix you insert into the configure.php files as pointed out by DrByte above...

  10. #10
    Join Date
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    Attached is my database file.
    Can you please tell me the prefix I should be using because I am still having trouble.
    Last edited by DrByte; 21 May 2008 at 05:50 AM. Reason: removed attachment for privacy

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. Can't access database after moving to GoDaddy
    By daneh in forum General Questions
    Replies: 14
    Last Post: 29 Sep 2011, 04:57 AM
  2. sessions error after changing hosts
    By delia in forum General Questions
    Replies: 6
    Last Post: 29 Jul 2011, 08:47 PM
  3. DataBase problem after moving site!!!!!!
    By PetesTown in forum Upgrading from 1.3.x to 1.3.9
    Replies: 17
    Last Post: 6 Nov 2008, 07:59 PM
  4. moving to new host, getting a db_cache error after importing database
    By littleturtlemama in forum Installing on a Windows Server
    Replies: 3
    Last Post: 19 Jun 2008, 11:18 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR