Problem upgrading into new sql database

[schoolboy]

Upgrading is relatively straightforward, but it looks like you shifted the LOCATION of your site as well.

If you moved the site to a diferent directory level (up or down, makes no difference) then the information in the two configure.php files MUST reflect that new location

You initial post suggest a SUB-DOMAIN as the first location.

Now you want to get it into the main domain.

So, BEFORE you do any upgrades, make sure ALL the zc folders and files are located in the ROOT of your main domain, and that the configure.php DEFINES reflect the true paths to all the specified directories.

When the site (not yet upgraded) operates as intended, then you go about upgrading.

You cannot put the cart before the horse. Get everything at the right directory level... Then upgrade.

[cpaulson]

Upgrading is relatively straightforward, but it looks like you shifted the LOCATION of your site as well.

If you moved the site to a diferent directory level (up or down, makes no difference) then the information in the two configure.php files MUST reflect that new location

You initial post suggest a SUB-DOMAIN as the first location.

Now you want to get it into the main domain.

So, BEFORE you do any upgrades, make sure ALL the zc folders and files are located in the ROOT of your main domain, and that the configure.php DEFINES reflect the true paths to all the specified directories.

When the site (not yet upgraded) operates as intended, then you go about upgrading.

You cannot put the cart before the horse. Get everything at the right directory level... Then upgrade.

Let's see if I can explain this clearly. I did not make a sub-domain. I put the new folder in my main domain. The real store is in a sub-domain and always has been. They are parallel folders on my hosting space. The instructions said to make a totally new folder and put the new download into it, add my customized files to the templates folder, etc. Also, it said to create a brand new sql database and copy my original sql files into it. With the help of my host, I did that, too.

I copied both of the configure files into the new upload (Zen 1.3.8 with the installer). I updated the config. files to reflect the path to the new folder within my main domain as above. Everything is pointing to the right places. That's why I'm so stumped!

I'm wondering now if the installer thinks it must be a new install since it is a whole new folder and whole new location??? Is that possible? Will I be actually doing a new install and then, if it works, just put in the rest of my customizations or reinstall the couple add-ons to be sure all is there and change from the original store to this "new" one?

Whew! This stuff sure is confusing.

[schoolboy]

OK... lets see where you are.

You have a new database right? and it's an "exact copy" of your old database - it just has a different name.
(This was not necessary to do, but you can treat this copy as a "backup")

Is public_html your domain's ROOT directory? Or is it www? Or what is it? (Answer this question before I move on)

[cpaulson]

Root directory is home/MY_NAME/
Within that root are two domains, the main one that I used before making a zen store and the one I created a couple years ago to house my store. The two domains are parallel folders within the root. So the main domain (stitchinthyme.com) holds the new installation folder.

The instructions for upgrading said I had to make the new database and new folder, etc. so I could test the upgrade before I took a chance on messing up my store (which is already messed up due to the hack and a couple things I couldn't seem to repair)

[schoolboy]

On my server, the ROOT directory is home/public_html, so my installation is:-

home
-|_ public_html
---|_ admin
---|_ cache
---|_ download
---|_ editors
---|_ email
---|_ extras
---|_ images
---|_ includes
---|_ media
---|_ pub

[cpaulson]

I'll try again. I hope this visual makes sense, but this is how it is set up. I could add more subdomains and each one would look like a separate directory in my /home/ area.

This is how my web hosting is set up. The caps for USERNAME and ADMIN indicate that I replace them with the actual names.

/home/USERNAME/
logs
mail
public
stitchinthyme(this one holds a few other folders not related to Zen. I have not listed those)
/store_new
_admin
_cache
_docs
_download
_editors
_email
_extras
_images
_includes
_pub
_zc_install

store.stitchinthyme
_ADMIN
_cache
_docs
_download
_editors
_email
_extras
_images
_includes
_pub

[cpaulson]

I am still struggling with this upgrade. As noted, I made a new database in a different directory.

Now I have installed Zen as a new store to test it. The problem now is that I can't access the admin area. I have checked and rechecked both configure.php files and I can't find anything I've forgotten to update.

When I can go back to the page where I set up the upgrade, there are two links... one is a link to see the store. That shows a default store, no customizations.
The other link says it will go to the admin area. When I click on that, I get the following error:
Parse error: syntax error, unexpected T_STRING in /home/USERNAME/stitchinthyme.com/store_new/admin/includes/configure.php on line 43

I do not know what a T_STRING is. Here is line 43 of that config file
define('DIR_WS_CATALOG', '/store_new/');

Can you see anything I should change/fix in the line?

[cpaulson]

By comparing with my backup, I found some extra characters and a blank line above line 43. I deleted those, but now I get this error instead.

Not Found
The requested URL /admin/login.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I don't understand what is missing. I have the paths right...or at least I think I do. I really don't understand php code.

[schoolboy]

I'm puzzled as to why this is turning out to be so problematic, and my suggestion is that you retrace the steps.

I manage to "clone" a full zencart install (usually moving it up and down the directory tree) in a matter of minutes. I hope I don't come across as being "smug", because I really want to help here... it just seems odd that you are having such problems.

Fundamentally, moving a website (whether up or down or even "across" the directory structure - or even to a different host/url) involves little more than the following.

1. Copying all folders and files and "inserting" them into the new location (in their proper places of course).

2. Copying the database and populating a new database with the data.

3. Editing the two configure.php files to reflect the new PATHS and the new DATABASE

4. Running fix_cache_key.php to make sure the database reference for caching is correct. (This can also be done manually using phpMyAdmin).

... and that's it really.

I think that you are stumbling at step 3 and that the configure.php files are not showing the proper paths. The 404 error is indicative of that, or possibly because you have not ensured that ALL folders and files are properly copied over.

[cpaulson]

Hi again and thanks for keeping trying to help.

I think I am stumbling at the part where I have to put the files from my original site and the files from the new installer together. I have no idea how to do this. The tutorial talks about putting the original files into the new folder (along with the ones in the installer ??? I don't know how that could be. Also, if my site still has some defects due to the hack (some images and links weren't showing), then I wouldn't want to take a chance on causing those changes to go into the new files.

Here is what I have for the new install:


Within the stitchinthyme folder:
store_new (the newly installed store)
zencart the folder with the fileset for the 1.3.8 installer

The turorial says to put them together, but that makes no sense to me. I'm sorry I sound so dumb on this, but I am totally baffled. I suppose I'm just making it more complex than I need to, but don't know any simple way.
The instructions sound so complex, saying to go over every line of every file and find all the differences and change them. Well, if I change them, I may change the wrong things and put errors from my original store into the new install.

I have the original store backed up in a folder called "store_backup" just to be sure I don't mess it up any further.

I don't understand what this means:

4. Running fix_cache_key.php to make sure the database reference for caching is correct. (This can also be done manually using phpMyAdmin).

I don't know what it means to "run" something...or where or how to try.

The database reference seems to be correct, because the install found it and the path is right.

I know the data is in there because my host made the backup for me and I looked at it in php my admin. The files are there. It is a copy of my original database, just in a different directory.

I am at the point that I'd pay someone to come and do it for me if I knew anyone who could do such a thing. No one near me knows as much about computers as I do and that isn't saying a lot.