Results 1 to 10 of 10

Hybrid View

  1. #1
    Join Date
    Oct 2008
    Posts
    45
    Plugin Contributions
    0

    Default SO stuck on moving database to new host

    Ok..i followed the directions on moving to a new host.

    The part I'm stuck at is #6 sorta.

    I know my problem at this point is the config files and they aren't pointing to the right path. HOW do i find out what the right path should be?? My old host I can't even get into my cpanel anymore to look at the path for that one.

    I have a feeling I didn't name the new one the same either.

    for example in one of the directions I read it said:

    (path/to/your/webspace/public_html/zen/cache)

    so this is an old one:

    (home/content/p/m/t/pmtws/pmtws/html/zencart/cache)

    I don't understand it?? Lol I don't know what the home stands for because I don't have a "folder" named home?? I am no pro with website stuff so this may be obvious to someone else and thats why i'm coming here for advice and help.

    then the "content" part, again..no idea

    Does someone have any insight they can share?

    thank you in advance !

  2. #2
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: SO stuck on moving database to new host

    If you're referring to step #6 in this article: https://www.zen-cart.com/tutorials/i...hp?article=100
    ... then ...just follow the instructions as listed, because step 2 made the correct settings for the new server inside your configure.php files. If you didn't delete or replace them, then you should have the info required. Either way, if those files were preserved on the server as instructed, the fix_cache_key.php utility will read the settings for you and act accordingly.
    .

    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
    Oct 2008
    Posts
    45
    Plugin Contributions
    0

    Default Re: SO stuck on moving database to new host

    ok..then if thats true. I must have another problem. Because i did that part and after I ran it.. it didn't display anything like it said in the "fix cache key" directions. On number 4 it says that "the cache setting from your configure.php file with be displayed"

    It didn't display anything so I was assuming it wasn't right still.

    Plus my store still didn't show.

    This is so frustrating its not even funny. I have a feeling I have to start all over since I don't know where to look for the problem. UGH

  4. #4
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: SO stuck on moving database to new host

    a quick solution would be to contact the host and ask them what the path to the root of your site is
    Zen cart PCI compliant Hosting

  5. #5
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: SO stuck on moving database to new host

    Quote Originally Posted by myemmadoodle View Post
    Plus my store still didn't show.
    Can you elaborate?
    What does "didn't show" mean?
    If you're getting a blank page, then there's another FAQ article for troubleshooting that: https://www.zen-cart.com/tutorials/index.php?article=82
    .

    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
    Oct 2008
    Posts
    45
    Plugin Contributions
    0

    Default Re: SO stuck on moving database to new host

    ok thank you both ! i will try those two suggestions next.

  7. #7
    Join Date
    Oct 2008
    Posts
    45
    Plugin Contributions
    0

    Default what does this error mean?

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

    Above is what i get when i run the fix_cache_key.php file.

    I'm not sure what it means. I did double check the DIR_FS_SQL_CACHE path and it looks right to me.

    Any help greatly appreciated.

  8. #8
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: what does this error mean?

    It means that you don't have a table called configuration in your database.

    Since this is a key Zen Cart table, most likely you are using a database prefix. so your table is actually called something like zen_configuration.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  9. #9
    Join Date
    Oct 2008
    Posts
    45
    Plugin Contributions
    0

    Default Re: what does this error mean?

    ok..i just looked and found that my DB prefix was zen_ and I didn't have that set... now I fixed that and that particular error is gone.

    But when I run the fix_cache_key.php again then I just have a blank page. Shouldn't I have something that comes up ?

    I also see my store now..but its not showing me my products even though they are on my FTP.

    I think I'm still missing something. Any ideas??

  10. #10
    Join Date
    Jun 2008
    Location
    Canada
    Posts
    134
    Plugin Contributions
    0

    Default Re: SO stuck on moving database to new host

    I just had my server move all my files to a new dns and now I think I really messed up or they did.
    I didn't find the 6 step thing or even thought to look for it. I assumed they would be able to do all the necessary things.
    I've saved my old configure files and tried to change it to point to
    my new database but it doesn't seem to be working.
    I do have my old backup...but things are already moved by the server.
    Is there something else I should be thinking of?

    0 DB_ERROR_NOT_CONNECTED
    in:
    [select * from zen_project_version WHERE project_version_key = 'Zen-Cart Database' ]

 

 

Similar Threads

  1. Replies: 1
    Last Post: 2 Jun 2011, 01:19 AM
  2. Moving site contents to different host, but keeping the same database?
    By yelow in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 10 Feb 2009, 05:10 PM
  3. 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