Results 1 to 10 of 22

Hybrid View

  1. #1
    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?

  2. #2
    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?

  3. #3
    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...

  4. #4
    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

  5. #5
    Join Date
    Jan 2004
    Posts
    66,445
    Plugin Contributions
    81

    Default Re: Database error after moving hosts

    Since all your tablenames start with "zen_", that would be the prefix.
    .

    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
    Apr 2006
    Posts
    26
    Plugin Contributions
    0

    Default Re: Database error after moving hosts

    take 4.
    i will do the whole process again with the zen_ prefix at setup.
    I WILL get it and post when i do.
    Appreciate the help.

    Last time I did this it was easy...lol

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

    Default Re: Database error after moving hosts

    zen_ prefix was the problem.
    I feel like an idiot.
    Don't comment on that last statement please :-)
    Many thanks for all your time and effort!!!!!!!

 

 

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

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