re-hosted the site; now doesn't work

24 Mar 2010, 18:53

#1

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

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.

24 Mar 2010, 18:56

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: re-hosted the site; now doesn't work

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

24 Mar 2010, 21:53

#3

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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.

24 Mar 2010, 23:29

#4

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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.

24 Mar 2010, 23:55

#5

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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?

25 Mar 2010, 00:55

#6

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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.

25 Mar 2010, 03:12

#7

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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.

25 Mar 2010, 14:48

#8

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: re-hosted the site; now doesn't work

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)
...

25 Mar 2010, 15:05

#9

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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.

25 Mar 2010, 15:06

#10

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: re-hosted the site; now doesn't work

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?

25 Mar 2010, 15:31

#11

mzimmers

Zen Follower

Join Date:: May 2008
Posts:: 453
Plugin Contributions:: 0

Re: re-hosted the site; now doesn't work

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).