Forums / Upgrading from 1.3.x to 1.3.9 / 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

1.3.2 to 1.3.5 upgrade with fresh install and old DB.

Locked

Started by linkedla on 15 Sep 2006, 3:00 AM · Views: 4,325

Results 1 to 15 of 15
This thread is locked. New replies are disabled.
15 Sep 2006, 3:00 AM
#1
linkedla avatar

linkedla

New Zenner

Join Date:
Mar 2005
Location:
Bogotá, Colombia
Posts:
32
Plugin Contributions:
1

1.3.2 to 1.3.5 upgrade with fresh install and old DB.

I want to make a fresh install and after this upload the DB backup into the new DB creeated for the fresh install, now... I need to know how to do this i mean the cleaning of the junk data in the actual DB, whit this for example i did install the quick updates mod, but it never work on my 1.3.2 instalation, so i do not want the modifications from this mod intoo the new one, also the exeptions table and the seo table because i want to install the updates mods for this version.

I hope you can unsderstand me and help me on this issue, since i am not a programmer y do not know where to find some stuff like this. :blush:
Thanks in advance.

Visit https://www.colombianhandcrafts.org, we are in the fair trade move!

19 Sep 2006, 3:56 PM
#2
confusediam avatar

confusediam

New Zenner

Join Date:
Nov 2005
Posts:
27
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

Hi,
I would also like to know if this way is good if a store has not been taken 'live.' Would the fresh install make the change of any required things to an old database (from whatever version it was created for) so entries would not have to be reentered?
Thanks,
Rand

19 Sep 2006, 4:45 PM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,511
Plugin Contributions:
176

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

confusedIam:

Hi,
I would also like to know if this way is good if a store has not been taken 'live.' Would the fresh install make the change of any required things to an old database (from whatever version it was created for) so entries would not have to be reentered?
Thanks,
Rand
Running zc_install/index.php with your "old" database active, will provide you with a database-upgrade button (beside the Install button), which will bring your database up to date.

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

20 Sep 2006, 2:58 AM
#4
confusediam avatar

confusediam

New Zenner

Join Date:
Nov 2005
Posts:
27
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

Thank you very much. I am off to download the newest full install to do after deleting all the old files.
Rand

20 Sep 2006, 3:58 AM
#5
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,896
Plugin Contributions:
21

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

Just out of curiosity, how in the world are you getting > I am off to download the newest full install to do after deleting all the old files. from any advice on this forum. No one in this thread has even hinted at deleting old files as a start to an upgrade.:shocking:

Standard advice is create a NEW directory, install newest update with new DB. Remove the new database and replace with a copy of the old DB. Run ZC_Install once more for "Database Upgrade". Either move the new cart into the live directory or redirect from the live directory to the new directory.

AFTER, AND ONLY AFTER, these are working to your satisfaction do you even THINK about deleting old files.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

20 Sep 2006, 2:51 PM
#6
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

i'm not a programist. Please help me in these:
my environment: windows xp; xampp for windows version 1.5.4 (with php 5.1.6, apache 2.2.3, mysql 5.0.24a-community-nt);

host=localhost;

during the installation /not upgrade/ the zen 1.3.5 it asked for database, and after some trial attempts it could accept htdocs/mysql folder only. i can't login to the admin either.
now i'm going to un- and re- install them again.

how can i install zen to a new directory named 'zen' in a easy way /using windows explorer not ftp, 'cos i havn't use ftp at all/. :(

Thanks in advance

save nature = save water

20 Sep 2006, 4:25 PM
#7
confusediam avatar

confusediam

New Zenner

Join Date:
Nov 2005
Posts:
27
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

dbltoe:

Just out of curiosity, how in the world are you getting from any advice on this forum. No one in this thread has even hinted at deleting old files as a start to an upgrade.:shocking:

Maybe I wasn't clear in the question what I wanted to do. By 'fresh install' I meant could I just install the new release (as if I had never had a store) and use an old database that was done with an earlier version so I would not have to enter all the items that was entered with an older store. The store was never live so I thought if the new fresh install would just 'update' the old database instead of having to create a new database, too, that would save me entering all the items again. I am not worried about any template changes I had done, I would rather just start over from the beginning, except the database, if that was possible. I hadn't made that many custom changes anyway.Do you mean the 'fresh install' will not update/fix/secure the old database?
Thanks,
Rand

20 Sep 2006, 6:02 PM
#8
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

ive just accidentally installed the 1.3.5 on my localhost.
the template site and admin pages work. lemme try to remember how it was done:

  • install xampp for windows version 1.5.4 (with php 5.1.6, apache 2.2.3, mysql 5.0.24a-community-nt)
  • unzip zen1.3.5 to xampp/htdocs/, i renamed the zen1.3.5 to simply 'zen'
  • in your internet browser type //localhost/zen/zc_install + enter
  • follow the instructions. dont change physical and virtual addresses and so on. set other features as you decide. in the 'database name' field just put 'mysql'. the process will be completed after several step onward. you can see the template site now with address: localhost/zen/index.php. it might be all, but i did the next.
    in windows explorer i made a new folder named 'zen' in xampp/mysql/data/ and copied all the files from xampp/mysql/data/mysql folder with prefix zen_ to there. After i deleted the whole zen folder in htdocs/. there i repeated the process of installing 1.3.5 again but with correction of database name into 'zen' in my case.
    its all upto now.
    next, my problem is as you noted: how to input saved files to that system that recognizes them in turn.

save nature = save water

20 Sep 2006, 6:14 PM
#9
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,896
Plugin Contributions:
21

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

I was hoping that was it but needed to comment so others would not delete possibly needed files.

Here's what will work best for you. Create a new database without structure and let the new Zc_install propagate the database. Delete the new database and put a copy of the old database in its place. Run zc_install again and do just "Database Upgrade".

That will bring the database up to 1.3.5 although you may need to do the fix at http://www.zen-cart.com/forum/showpost.php?p=257358&postcount=6

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

20 Sep 2006, 6:22 PM
#10
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,896
Plugin Contributions:
21

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

Banyan,
What version of XP are you using? If it is XP Pro, your problem could be that you have IIS running and it will fight xampp tooth and nail.

If you're running XP home, use the phpmyadmin that came with xampp to create a database for your cart.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

21 Sep 2006, 1:41 AM
#11
lostsheep avatar

lostsheep

Inactive

Join Date:
Aug 2006
Location:
ulaanbaatar
Posts:
94
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

windows version on my machine: windows xp professional 5.1
is it with iis or not, how cn i check for it?
tnxs

save nature = save water

21 Sep 2006, 4:08 AM
#12
confusediam avatar

confusediam

New Zenner

Join Date:
Nov 2005
Posts:
27
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

dbltoe:

Here's what will work best for you. Create a new database without structure and let the new Zc_install propagate the database. Delete the new database and put a copy of the old database in its place. Run zc_install again and do just "Database Upgrade".

That will bring the database up to 1.3.5 although you may need to do the fix at http://www.zen-cart.com/forum/showpost.php?p=257358&postcount=6

Thanks for your help. I really appreciate it.

3 Oct 2006, 2:11 PM
#13
confusediam avatar

confusediam

New Zenner

Join Date:
Nov 2005
Posts:
27
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

dbltoe:

I was hoping that was it but needed to comment so others would not delete possibly needed files.

Here's what will work best for you. Create a new database without structure and let the new Zc_install propagate the database. Delete the new database and put a copy of the old database in its place. Run zc_install again and do just "Database Upgrade".

That will bring the database up to 1.3.5 although you may need to do the fix at http://www.zen-cart.com/forum/showpost.php?p=257358&postcount=6

Hi,
I hope I haven't done something stupid. I did a fresh install of the newest release. All seems to be working fine with it. But I was going through the secure steps of the site and deleted the zc_install folder so can I just upload that again and swap out the new database that was created for this install with an older database with all real categories needed and run that installer to do the database upgrade part only?
Thank you.
Rand

3 Oct 2006, 4:02 PM
#14
dbltoe avatar

dbltoe

Totally Zenned

Join Date:
Jan 2004
Location:
N of San Antonio TX
Posts:
9,896
Plugin Contributions:
21

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

You're fine. For you and those reading, I generally keep the install folder but rename it something I would remember. The system will work just fine if the zc_install folder is renamed fribbitt.
This also let's me do a quick compare with the newest release and my current install using winmerge.

Need a hand with Zen Cart? Hire the team at myZenCartZone.com for upgrades, repairs, and custom plugins.
Zen Cart Certified hosting at myZenCartHost.com

3 Oct 2006, 11:11 PM
#15
confusediam avatar

confusediam

New Zenner

Join Date:
Nov 2005
Posts:
27
Plugin Contributions:
0

Re: 1.3.2 to 1.3.5 upgrade with fresh install and old DB.

dbltoe:

You're fine. For you and those reading, I generally keep the install folder but rename it something I would remember. The system will work just fine if the zc_install folder is renamed fribbitt.
This also let's me do a quick compare with the newest release and my current install using winmerge.

First, thanks for your help.
I uploaded the zc_install folder again. Went to the address to do the upgrade. Got an error about two config files. In my feeble mind I figured it was because permissions didn't allow writing but since I wasn't going to install the cart again thought maybe that didn't matter. Went to phpMyadmin place I saw the new database but nothing allowing me to 'import' my old one. So, jumping in deep water, I had remembered reading something about pointing the includes/configuration.php and admin/includes/configuration.php files to the database so I went in those two docs and changed the name/username/password of the 'new' database to the old, thinking then I would go back and take the browser to the zc_install ..... place and do the upgrade on that database. Is that going to work? If not, can you 'import' an old database through phpmyadmin windows? I am not sure I understand importing. Is that just replacing another (new one created for fresh install) or actually importing data from the old database into the new database?
Thanks,
Rand

PS After changing the database info in the config files I checked the site, for kicks, and was told Sorry, there was a problem connecting to our database and to wait a minute.