Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Problems during hosting server move

    I'm following your Wiki instructions for moving my existing Zencart from one server to another. I have uploaded & installed 1.3.7 to my new server & now when I go to the store to test it before I go to step 3, I get this error:

    1146 Table 'bsdzencart.db_cache' doesn't exist
    in:
    [db_cache table]

    I cannot figure out how to fix this error. Help?

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

    Default Re: Problems during hosting server move

    Have not looked at the wiki for this is a while but as this is the cache (temp data), if you have phpmyadmin - load this DB check the cache scroll to the botttom and fro the drop to select "with selected" do this?? select "empty" and go.

    This will clear any data from the old install that may be sending this install awry.

    Opps!! bsdzencart.db_cache is the bsdzencart a prefix?? when in the phpmyadmin look at the table names and see if the db_cache is there and/or if bsdzencart.db_cache is there compare to other tables if there is a prefix or not.
    Last edited by kobra; 27 Mar 2007 at 06:23 AM. Reason: Additional Information
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: Problems during hosting server move

    This is a fresh install - I haven't moved my db over yet, so there are no tables in the database at all.

  4. #4
    Join Date
    Sep 2005
    Posts
    52
    Plugin Contributions
    0

    Default Re: Problems during hosting server move

    After reading some other threads, I tried this fix of pasting this query into MySql on the phpMyAdmin:

    DROP TABLE IF EXISTS db_cache;
    CREATE TABLE db_cache (
    cache_entry_name varchar(64) NOT NULL,
    cache_data blob,
    cache_entry_created int(15),
    PRIMARY KEY (cache_entry_name)
    ) TYPE=MyISAM;

    Now I'm getting this error:
    1146 Table 'bsdzencart.configuration' doesn't exist
    in:
    [db_cache table]

    I did a full install of 1.3.7 - NOT an upgrade. It all installed fine, but when I click on the Zen Cart Setup Finished - "Click here to go to store" button, I get the error.

    I'm panicking here. Can someone please help me solve this?

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

    Default Re: Problems during hosting server move

    Peek at this thread about blob and some servers:
    http://www.zen-cart.com/forum/showth...highlight=BLOB
    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!]
    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!

  6. #6
    Join Date
    Jun 2007
    Location
    Norway
    Posts
    3
    Plugin Contributions
    0

    Default Re: Problems during hosting server move

    My host moved my zen cart from one server to another, and this has caused that I can no longer add products to my zehn store. Well - I can add them - but the download attribute does not work. And since this is a download-shop I'm really starting to get stressed out!

    My host suggested to add a php.ini file into the download directory of zen cart, and explained that the only difference between the servers is a setting: short_open_tag = enabled. I have tried this but with no luck.

    Can anyone please help me out?

 

 

Similar Threads

  1. v139g Server resources - hosting problems - MySQL
    By kevmartin in forum General Questions
    Replies: 11
    Last Post: 4 Dec 2012, 09:36 AM
  2. Replies: 0
    Last Post: 28 Jun 2008, 01:41 AM
  3. Problems during hosting server move
    By maggiesmom1 in forum General Questions
    Replies: 0
    Last Post: 26 Mar 2007, 11:19 PM
  4. SSL Server is different to the hosting server
    By danieljohnlewis in forum General Questions
    Replies: 1
    Last Post: 18 Jul 2006, 03:53 PM

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