Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2010
    Posts
    21
    Plugin Contributions
    0

    Default Possible to Upgrade Database Only?

    I have 2 different carts I am using

    1 is a live site with 1.3.7 and the other is a test site using latest 1.3.9

    The test site is where I am making all my changes with add-ons, customizations etc...

    I plan on moving this all to the Live site when I am done.

    On the test site I am using a test database and not the live one.

    I would like to change my configures on the test site to use the database of the live site but cannot do that because of the live site using an old database version 1.3.7

    --------------------------------------------
    So my question is this:

    Can I just upgrade the database on the live site without new pages being added/updated without any adverse effects?

    Any thoughts on this?

  2. #2
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Possible to Upgrade Database Only?

    You're sort of doing things backwards. What you should have done was:

    1. Upload the latest version of Zen Cart to the test site.
    2. Create a new blank database for the test site.
    3. Import your old database into it.
    4. Reconfigure the two configure.php files for the test site address, database, MySQL User Name and Password.
    5. Go to the test site address plus /zc_install and then select the "Upgrade Database Only"option.
    6. You'd then have a test site using the latest Zen Cart with your database upgraded to the latest level. You could then test this all out, add your add-ons and test those before putting it all live.

    However, as your live site has probably had new customers, new products added, and orders since you started this work, you will have to bite the bullet and upgrade the live database.

    But you should only do this when you are certain that the test site is all working.

    Then you put the live site "Down For Maintenance" while you copy all the test site folders and files to the live site (except for the two configure.php files), upload the zc_install folder for the test site version of Zen Cart to the live site, and run it selecting the "Upgrade Database Only" option.

    Vger

  3. #3
    Join Date
    Nov 2010
    Posts
    21
    Plugin Contributions
    0

    Default Re: Possible to Upgrade Database Only?

    I know I am doing this backwards but I am doing that for a couple different reasons.

    The test site is using the latest 1.3.9 version as I stated above.

    I just need to know if I can upgrade the database without upgrading the zen cart on a site is all? Another words with the files from ZC 1.3.7 work with Database Version ZC 1.3.9

    I may just have to create another test site to see if it is possible until I can finish with all the modifications.

  4. #4
    Join Date
    Nov 2004
    Location
    Norfolk, United Kingdom
    Posts
    3,036
    Plugin Contributions
    2

    Default Re: Possible to Upgrade Database Only?

    The test site is using the latest 1.3.9 version as I stated above.
    Yes, and that's why I said you should import the old database into the new version and upgrade it there to 1.3.9+ - and then add your add-ons all over again, making sure they are the latest versions which are 1.3.9+ compatible. No point in reinstalling add-ons if they are not 1.3.9+ compatible.

    It's still not too late. Take a backup of the live database. Access the test site database using phpMyAdmin, and "drop" all the tables. Import the old database and run the new version zc_install on the test site selecting the "Upgrade Database Only" option (the two configure.php files have to be writeable during this procedure). Any changes you made to the test site database for any add-ons you have set up on the test site will have to be redone.

    No, you cannot just upgrade the database on the live site without updating the file set.

    Vger

  5. #5
    Join Date
    Nov 2010
    Posts
    21
    Plugin Contributions
    0

    Default Re: Possible to Upgrade Database Only?

    Quote Originally Posted by Vger View Post
    No, you cannot just upgrade the database on the live site without updating the file set.

    Vger
    Ok thats what I needed to know.

    Thank you.

  6. #6
    Join Date
    Jan 2012
    Posts
    27
    Plugin Contributions
    0

    Default Re: Possible to Upgrade Database Only?

    Quote Originally Posted by Vger View Post

    No, you cannot just upgrade the database on the live site without updating the file set.

    Vger
    And that's just nuts--especially for the minor point upgrades. Essentially, you're having people rebuild their entire sites even for minor upgrades like (in my case currently) 1.5.4 to 1.5.5a. A 1.5.4 database works with a storefront and admin on 1.5.5 so why should I have to completely rebuild the site with all the risk and disruption that could cause?

    More than once I've gotten half-way through the zc_install process only to find that I've not been offered the "upgrade" option. (Yes, I've done this on test instances to test out the concept before going live.)

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Possible to Upgrade Database Only?

    Quote Originally Posted by acmaurer View Post
    And that's just nuts--especially for the minor point upgrades. Essentially, you're having people rebuild their entire sites even for minor upgrades like (in my case currently) 1.5.4 to 1.5.5a.
    While going from v154 to v155 is listed as a "minor point update", the changes are actually VERY significant: big core code changes to improve security, provide significant enhancements to empower mobile/responsive templates, big database changes which require matching PHP code changes (so if you didn't apply them you'd get lots of errors), and more. Some could argue with some degree of accuracy that it shouldn't have been a "minor point upgrade" ... and they'd be right in several points. But it wasn't called "1.5.4b". it was called "1.5.5", which denotes that there ARE some changes that are MORE than just a couple database SQL statements to run.

    You don't "have to rebuild" your site. But you DO need to carefully inspect all the changes and apply them against all your own files (customized or not).


    The Zen Cart development team are working hard on a number of (very big) architectural code changes which, while they will be big when making the first jump, will make future upgrades VERY MINOR, almost trivial, because core code files won't need touching for most customizations (unless you choose to, in which case you're creating your own challenges not driven by the architecture). The jump to v160 will include some of this "pain", but will make the future much easier to manage.
    In the meantime, because of the older architecture which Zen Cart inherited when it forked from osC, the 1.5.x upgrades are less pleasant than we would like. We're working on fixing that.
    Until then, I recommend: http://www.zen-cart.com/entry.php?3-...d-of-upgrading
    .

    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.

 

 

Similar Threads

  1. upgrade only part of 1.3.8 database to 1.3.9h
    By bonnit in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 18 Mar 2011, 08:04 PM
  2. Upgrade ONLY one database table?
    By BKKcanuck in forum Upgrading from 1.3.x to 1.3.9
    Replies: 3
    Last Post: 23 Jun 2010, 03:58 PM
  3. Move only database to a new server?! Possible?
    By dachilla in forum General Questions
    Replies: 1
    Last Post: 25 Nov 2008, 08:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR