re-hosted the site; now doesn't work

Hi -

Today we moved our ZC from its temporary location to its new home. I did the following steps:

1. uploaded all the ZC files to the new location
2. backed up the DB from the old location
3. created a DB in the new location
4. assigned a user to the DB
5. restored the DB from the backup
6. changed /includes/configure.php and /admin/includes/configure.php to reflect the new location/usernames.

When I try to navigate to the website, I get the "Hello. Thank you for loading Zen Cart™." page, suggesting that my new install isn't complete. Do I need to run zc_install in the new location?

Thanks.

Sounds like you've not put the correct paths into the various fields in your configure.php files.

If you use zc_install to build the configure.php files it'll save you a lot of guesswork about how your server is set up. That's why this FAQ article was written on how to move from one server to another: https://www.zen-cart.com/tutorials/index.php?article=100

Awcrud. OK, I'll do it the right way. I have a minor problem with the steps, though: it appears that my server doesn't support the FTP MFMT command, so when I upload the fresh ZC install, it gets all-new file modification times. The only way I can upload my modifications is to upload everything, which will essentially wipe out the fresh copy. Can you foresee a problem with this?

Thanks.

I am following the steps in the FAQ article cited above. The newly-created DB functions, but when I do the drop and the import, I then get this error message:

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

What did I do wrong?

Thanks.

I just took a closer look at the tables in my DB. If I'm reading them correctly (which admittedly is a big if; I know very little about mySQL), the database's tables are all prefixed with "zen_". I started this instantiation from someone else's template, so I never went through the install.

So, what's the fix for this...do the install again, and put a "zen_" prefix in during the DB section?

So, I tried my idea, and it seems to have worked 50%. The store now displays properly (and appears to operate properly, though I haven't rigorously tested it). But, my admin section still seems not to expect that prefix, as evinced by this message I get when I try to visit the admin page:

1146 Table 'cindere8_znc1.project_version' doesn't exist

So, now I truly don't know what to do. Any suggestions, please?

Thanks.

Another thought came to me: is it possible to strip off the "zen_" prefix on the old database? Then, when I do the install, I won't have to add the prefix, and the abovementioned admin call would presumably go to the correct table in the DB.

Thanks for any input...I'm kind of in a bind on this one.

In the FAQ article I mentioned, step 2a has an important note, which applies in your case:> 2. Go to your NEW host and upload (FTP) a fresh NEW install using the same version files that you built your other site on.... this will make sure that you get the proper settings in your configure.php files...

While installing, allow it to install the demo products, so that you can test and be sure that it's working nicely.
a. Install (when asked about the database-table-prefix during Database-Setup, use the same prefix that your old store uses)
...

Hey, Doc –

I missed that step on my first try, but I did that on my second effort. As I mentioned above, the shop now comes up OK, but the admin page doesn't.

You have 2 configure.php files, and both require that the DB_PREFIX setting be the same in each. Perhaps you've not made the same change in your admin version of the file?

Ahhh. Yes, indeed. Somewhere in my haste yesterday, I must have failed to download the admin configure.php file before modifying it, and lost the prefix that the install put in there.

Thanks a ton, Doc. Now I can move on to payment processing (which should be filled with lots of excitement, from what I've read in the forums).