Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    37
    Plugin Contributions
    0

    Default moving to new host, getting a db_cache error after importing database

    I've followed the directions here
    and after I import the backed-up database from the old host, I get this error when trying to access the site:
    1146 Table 'ltkmama_zencart.zencart_db_cache' doesn't exist
    in:
    [db_cache table]

    Any ideas on what the problem might be? I'm lost!

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: moving to new host, getting a db_cache error after importing database

    ltkmama_zencart.zencart_db_cache

    That is alot of prefix on a table

    I would check your db table names - specifically for the db_cache one

    It is most likely zencart_db_cache
    Zen-Venom Get Bitten

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

    Default Re: moving to new host, getting a db_cache error after importing database

    The part of the prefix before the "." is the name of your database.
    Thus, it seems your store is set up to look at tables using "zencart_" as the DB_PREFIX setting.
    Is that what your configure.php files contained on your old host?

    Are you sure that your database import completed without errors?
    .

    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.

  4. #4
    Join Date
    Mar 2007
    Posts
    37
    Plugin Contributions
    0

    Default Re: moving to new host, getting a db_cache error after importing database

    excellent! It's fixed - the DB-prefix should have been zencart not zencart_
    thanks to you oth - I'd never have found that without your promptings :)

 

 

Similar Threads

  1. Error importing old database to the new database
    By wmorris in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 3 Jan 2012, 08:27 AM
  2. SO stuck on moving database to new host
    By myemmadoodle in forum Installing on a Linux/Unix Server
    Replies: 9
    Last Post: 27 Oct 2009, 01:51 AM
  3. Moving to new host and I am getting asked to install again?
    By MCanes in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 14 Feb 2008, 07:05 AM
  4. getting error after importing db backup
    By trillian in forum Installing on a Linux/Unix Server
    Replies: 6
    Last Post: 1 Mar 2007, 05:47 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