Page 1 of 2 12 LastLast
Results 1 to 10 of 49

Hybrid View

  1. #1
    Join Date
    Jul 2010
    Posts
    99
    Plugin Contributions
    0

    Default test site for upgrades

    Hi Sorry if this is in the wrong place, seems relevant a little,

    I said in a previous post that i was running 1.9h, It's not it's only 1.39d, So really need to get move on and get upgrading,

    Before i could attempt it, i would like to go for a test site, so i can see if i'm upgrading it correctly, and not destroy my live site,

    Could someone tell me how to set up a practice site that won't interfere with the live site at all, (without techy terms if possible),

    I reckon on even my capabilities i could upgrade my live site to at least 1.39h without much of a problem, I've upgraded Ceon mapping from the originally installed module (probably 4 or 5 upgrades away from the new one out now),

    So i have some capabilities, but would like a practice site first (Just in case)

  2. #2
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: test site for upgrades

    You could create a SUB-FOLDER on your current install (call the folder "testsite"), and create a CLONE of your current site that runs out of that folder.

    You will need to create copies of:

    1. The FOLDERS and FILES
    2. The DATABASE.

    All of this can be done in C-Panel (assuming you are with a host that runs a proper C-Panel).

    MAKE A BACKUP OF EVERYTHING FIRST... AND THEN...

    In the C-Panel FILE MANAGER, COPY the current zencart installation into your new testsite folder.

    Create a NEW database (name eg: testsite) and apply the SAME database user and database password to that database, as you have on your current database.

    In phpMy Admin, you can COPY your existing database to the NEW one you just created. (I think the copy function is under the OPERATIONS tab).

    Now you have your CLONE.

    Final steps are to EDIT the two configure.php files (you may need to change the CHMOD permissions to 644 in order to edit them) to show the new SUB-FOLDER in the path locations, and the new DATABASE NAME. (remember... the USER and PASS should not need changing, as you have assigned the same user to the cloned database.)

    After editing, change their CHMOD back to 444.

    You should be able to login to the copied site's admin panel using the same username and password as the live site. REMEMBER the admin login for the clone will be in the sub-folder location!

    After logging in you need to adjust the SESSIONS path (Admin >>> Configuration >>> Sessions)...

    ... and the LOGGING path (Admin >>> Configuration >>> logging)...

    This just requires that you insert the name of the subfolder (testsite) into the paths.

    I then set the testsite DOWN FOR MAINTENANCE, so nobody can access it (including search engines).

    What I do... IMMEDIATELY AFTER THE ABOVE, is give the cloned site a NEW HEADER LOGO that says in bright red text "YOU ARE IN THE CLONED SITE". I do the same for its ADMIN PANEL, so I immediately know I am in the TEST SITE and not the LIVE SITE.

    What you don't want to do, is think you are in the testsite, when in fact you are in the LIVE site...

    REMEMBER... the test site is a SNAPSHOT of the database as it was the minute you made a copy of it. After you have played around on it and tested things, you SHOULD NOT turn it into a live site... Its database will be very different from your LIVE site, and "merging" the two later on will cause huge problems.

    SO... you will make DETAILED NOTES of everything you do in the test site, because later, some of thie things you do will have to be done again when you modify or upgrade the LIVE site.

    When you are done with testing and practicing, and you are ready to upgrade and reconfig your LIVE site. you should DELETE COMPLETELY the test site and its database.

    Refer to your DETAILED NOTES for procedures you can now apply to the live site.

    We routinely create test sites, and the whole process (above) should take no longer than 20 minutes.
    19 years a Zencart User

  3. #3
    Join Date
    Jul 2010
    Posts
    99
    Plugin Contributions
    0

    Default Re: test site for upgrades

    Thanks Schoolboy, Appreciate the detailed reply, my site sits at www.mysite.co.uk so the test site would be www.mysite.co.uk/testsite and not a seperate folder on it's own (testsite).

    Seems a dumb question, but even in the the year i've been playing with websites, i've realised the slightest wrong detail , even as little as a missing (comma) somewhere, like i found in my meta tag file, can take a website down and can completely baffle a "newbie" like me lol

    I'm sure i can follow your details ( i hope lol)

    I've brought a wordpress back to life by replacing databases, so i'm sure i can do this (he says) lol

  4. #4
    Join Date
    Jun 2005
    Location
    Cumbria, UK
    Posts
    10,262
    Plugin Contributions
    3

    Default Re: test site for upgrades

    Quote Originally Posted by sash View Post
    my site sits at www.mysite.co.uk so the test site would be www.mysite.co.uk/testsite
    Correct

    Quote Originally Posted by sash View Post
    and not a seperate folder on it's own (testsite).
    Er... the folder "testsite" is separate... www.mysite.co.uk/testsite
    19 years a Zencart User

  5. #5
    Join Date
    Jul 2010
    Posts
    99
    Plugin Contributions
    0

    Default Re: test site for upgrades

    Quote Originally Posted by schoolboy View Post
    Correct



    Er... the folder "testsite" is separate... www.mysite.co.uk/testsite


    Knew it was a dumb question lol,

    Make a new folder www.mysite.co.uk/testsite
    not just a folder "testsite"

  6. #6
    Join Date
    Jul 2010
    Posts
    99
    Plugin Contributions
    0

    Default Re: test site for upgrades

    Create a NEW database (name eg: testsite) and apply the SAME database user and database password to that database, as you have on your current database.

    Schoolboy, It won't allow me to have the same username as my original database??

  7. #7
    Join Date
    Aug 2012
    Posts
    331
    Plugin Contributions
    0

    Default Re: test site for upgrades

    Quote Originally Posted by schoolboy View Post
    You could create a SUB-FOLDER on your current install (call the folder "testsite"), and create a CLONE of your current site that runs out of that folder.

    You will need to create copies of:

    1. The FOLDERS and FILES
    2. The DATABASE.

    All of this can be done in C-Panel (assuming you are with a host that runs a proper C-Panel).

    MAKE A BACKUP OF EVERYTHING FIRST... AND THEN...

    In the C-Panel FILE MANAGER, COPY the current zencart installation into your new testsite folder.

    Create a NEW database (name eg: testsite) and apply the SAME database user and database password to that database, as you have on your current database.

    In phpMy Admin, you can COPY your existing database to the NEW one you just created. (I think the copy function is under the OPERATIONS tab).

    Now you have your CLONE.

    Final steps are to EDIT the two configure.php files (you may need to change the CHMOD permissions to 644 in order to edit them) to show the new SUB-FOLDER in the path locations, and the new DATABASE NAME. (remember... the USER and PASS should not need changing, as you have assigned the same user to the cloned database.)

    After editing, change their CHMOD back to 444.

    You should be able to login to the copied site's admin panel using the same username and password as the live site. REMEMBER the admin login for the clone will be in the sub-folder location!

    After logging in you need to adjust the SESSIONS path (Admin >>> Configuration >>> Sessions)...

    ... and the LOGGING path (Admin >>> Configuration >>> logging)...

    This just requires that you insert the name of the subfolder (testsite) into the paths.

    I then set the testsite DOWN FOR MAINTENANCE, so nobody can access it (including search engines).

    What I do... IMMEDIATELY AFTER THE ABOVE, is give the cloned site a NEW HEADER LOGO that says in bright red text "YOU ARE IN THE CLONED SITE". I do the same for its ADMIN PANEL, so I immediately know I am in the TEST SITE and not the LIVE SITE.

    What you don't want to do, is think you are in the testsite, when in fact you are in the LIVE site...

    REMEMBER... the test site is a SNAPSHOT of the database as it was the minute you made a copy of it. After you have played around on it and tested things, you SHOULD NOT turn it into a live site... Its database will be very different from your LIVE site, and "merging" the two later on will cause huge problems.

    SO... you will make DETAILED NOTES of everything you do in the test site, because later, some of thie things you do will have to be done again when you modify or upgrade the LIVE site.

    When you are done with testing and practicing, and you are ready to upgrade and reconfig your LIVE site. you should DELETE COMPLETELY the test site and its database.

    Refer to your DETAILED NOTES for procedures you can now apply to the live site.

    We routinely create test sites, and the whole process (above) should take no longer than 20 minutes.
    Hello,

    I followed your detailed instructions, thanks so much it works great, i now have a site to do testing, however according to your instructions i copied the complete data from the main site database to the new database i created for the test site, so now all customers, orders etc. are showing in the test site admin, i do not need this information how can i delete all orders/customer details?

  8. #8
    Join Date
    Feb 2012
    Location
    mostly harmless
    Posts
    1,809
    Plugin Contributions
    8

    Default Re: test site for upgrades

    Quote Originally Posted by ShopVille View Post
    ... i copied the complete data from the main site database to the new database i created for the test site, so now all customers, orders etc. are showing in the test site admin, i do not need this information how can i delete all orders/customer details?
    Additional Considerations
    Just to be on the safe side, you may wish to disable the email subsystem prior to manipulating anything with customer data (just to be on the safe side if you have existing orders / customer data)...

    If you plan to test sending email, I'd recommend changing the store name (and / or the email address they are sent to). This makes identifying emails easier.

    Safe Way
    This method is tried, true, and safe. Use the Zen Cart admin folder to remove all unnecessary data. This includes orders, customers, admin users, etc.

    Fast Way
    While this method is fast, any mistakes made when directly modifying the database can break things.

    Use phpMyAdmin to TRUNCATE (will empty the table) the following database tables: address_book, customers, customers_basket, customers_basket_attributes, customers_info, orders, orders_products, orders_products_attributes, orders_products_download, orders_status, orders_status_history, and orders_total.
    Code:
    TRUNCATE `address_book`;
    Afterwards use something similiar to the following to remove all administrative users except admin.
    Code:
    DELETE FROM `admin` WHERE NOT `admin_name` = 'admin';
    The glass is not half full. The glass is not half empty. The glass is simply too big!
    Where are the Zen Cart Debug Logs? Where are the HTTP 500 / Server Error Logs?
    Zen Cart related projects maintained by lhûngîl : Plugin / Module Tracker

  9. #9
    Join Date
    Aug 2012
    Posts
    331
    Plugin Contributions
    0

    Default Re: test site for upgrades

    Followed your instructions, i successfully deleted all information, however how do i do this:

    Quote Originally Posted by lhungil View Post
    Additional Considerations
    Just to be on the safe side, you may wish to disable the email subsystem prior to manipulating anything with customer data
    ?

    Also, i have a lot of links on my site (in ezpages etc.) which the full link is incorporated in the html therefore resulting them in being opened in the regular site instead of in the test site, is there a way to add the links dynamically it should automatically consider the subfolder if in the test site? i tried having them as /index.php?main_page=index&cPath=2 but it still took it to the regular site
    Last edited by ShopVille; 3 Jun 2013 at 11:38 PM.

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

    Default Re: test site for upgrades

    Quote Originally Posted by ShopVille View Post
    however how do i do this:
    Admin->Configuration->Email Options->Send Emails? yes/no

    Quote Originally Posted by ShopVille View Post
    Also, i have a lot of links on my site (in ezpages etc.) which the full link is incorporated in the html therefore resulting them in being opened in the regular site instead of in the test site, is there a way to add the links dynamically it should automatically consider the subfolder if in the test site? i tried having them as /index.php?main_page=index&cPath=2 but it still took it to the regular site
    You would have to manually edit every link that you had hard-coded into an ez-page.
    Or, just don't click on those links because you know they're gonna point to the wrong site. Instead use the normal site-provided navigation.
    This is a TEST site, right? so only you will be using it, and it's all experimental and will never be the actual "live" site. Right?
    .

    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.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 Configuring SQL Database for test site
    By narata in forum General Questions
    Replies: 1
    Last Post: 10 Mar 2014, 10:10 PM
  2. Module for site wide attributes/upgrades?
    By makenoiz in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 21 Jul 2008, 04:06 PM
  3. Problem Moving Test Site - Switches to test site folder
    By bullseye in forum Installing on a Linux/Unix Server
    Replies: 3
    Last Post: 1 Jan 2008, 10:47 PM
  4. Best setup for test and live site on same server?
    By sjg0526 in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 24 Oct 2007, 06:53 PM

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