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 !

If you're referring to step #6 in this article: https://www.zen-cart.com/tutorials/index.php?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.

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

a quick solution would be to contact the host and ask them what the path to the root of your site is

myemmadoodle:

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

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

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.

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.

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??

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' ]