-
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)
-
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.
-
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,:blush: 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
-
Re: test site for upgrades
Quote:
Originally Posted by
sash
Correct
Quote:
Originally Posted by
sash
and not a seperate folder on it's own (testsite).
Er... the folder "testsite" is separate... www.mysite.co.uk/testsite
-
Re: test site for upgrades
Quote:
Originally Posted by
schoolboy
:blush::smile:
Knew it was a dumb question lol, :lamo:
Make a new folder www.mysite.co.uk/testsite
not just a folder "testsite"
-
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??
-
Re: test site for upgrades
You are probably trying to CREATE a NEW USER with the same name. All you need do is associate the new database with the EXISTING user. (The existing user for the original database).
If you are using proper C-Panel, scroll down to the bottom of the MySQL manager screen. There you will see a dropdown with the existing user and another dropdown with the databases. Your NEW database should appear. Simply SELECT the existing user, and associate that user with the NEW database. You need to give ALL PRIVILEGES to the user, for the new database.
-
Re: test site for upgrades
Quote:
Originally Posted by
schoolboy
You are probably trying to CREATE a NEW USER with the same name. All you need do is associate the new database with the EXISTING user. (The existing user for the original database).
If you are using proper C-Panel, scroll down to the bottom of the MySQL manager screen. There you will see a dropdown with the existing user and another dropdown with the databases. Your NEW database should appear. Simply SELECT the existing user, and associate that user with the NEW database. You need to give ALL PRIVILEGES to the user, for the new database.
My Bad , that did it, thanks
-
Re: test site for upgrades
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.)
Came unstuck at the bits in bold , Can you tell me the exact places to change in the file/ obviuosly i done it wrong
-
Re: test site for upgrades
Got further, I can access admin on test site , but if i type in the url of the test site, it gives me a 404 page not found message?
I added the test site url into ht.access to see if it would help, but it didnt??
-
Re: test site for upgrades
Quote:
Originally Posted by
sash
Got further, I can access admin on test site , but if i type in the url of the test site, it gives me a 404 page not found message?
I added the test site url into ht.access to see if it would help, but it didnt??
Edit above, I can access the test site, but if i click on a category it become a 404 not found,
Plus i'm supposed to password protected and that doesn't work, I just get straight through.
-
Re: test site for upgrades
The site shows up just fine,it's only if i click on any category i get the "Custom" 404 page, not the typical google 404 error page,??
-
Re: test site for upgrades
Where in my instructions do I say you need to mess about with htaccess?
If your TEST site does not work, then you have not followed my instructions... and it is possible that if you continue, you could end up messing up your LIVE site. :shocking:
Follow my instructions. There should be no 404 errors, no htaccess tweaks...
If you get errors, then you have not followed my instructions
-
Re: test site for upgrades
Quote:
Originally Posted by
schoolboy
Where in my instructions do I say you need to mess about with htaccess?
If your TEST site does not work, then you have not followed my instructions... and it is possible that if you continue, you could end up messing up your LIVE site. :shocking:
Follow my instructions. There should be no 404 errors, no htaccess tweaks...
If you get errors, then you have not followed my instructions
Hi, I did follow the instructions, everything works, as in the admin, url to the test site, It's just that small error somewhere, I just added the testsites url to the ht.access to see if it would help, (But it didnt) so i took it out,
-
Re: test site for upgrades
Quote:
Originally Posted by
sash
Hi, I did follow the instructions, everything works, as in the admin, url to the test site, It's just that small error somewhere, I just added the testsites url to the ht.access to see if it would help, (But it didnt) so i took it out,
did you figure it out - perhaps a wrong path in the configure files?
-
Re: test site for upgrades
Quote:
Originally Posted by
schoolboy
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?
-
Re: test site for upgrades
Quote:
Originally Posted by
ShopVille
... 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';
-
Re: test site for upgrades
Followed your instructions, i successfully deleted all information, however how do i do this:
Quote:
Originally Posted by
lhungil
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
-
Re: test site for upgrades
Quote:
Originally Posted by
ShopVille
however how do i do this:
Admin->Configuration->Email Options->Send Emails? yes/no
Quote:
Originally Posted by
ShopVille
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?
-
Re: test site for upgrades
Quote:
Originally Posted by
DrByte
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?
Right, i'm asking if there's a way to incorporate it in the live site for the future so that whenever i'm doing a clone copy for testing purposes it should automatically consider the subfolder
-
Re: test site for upgrades
Quote:
Originally Posted by
ShopVille
Right, i'm asking if there's a way to incorporate it in the live site for the future so that whenever i'm doing a clone copy for testing purposes it should automatically consider the subfolder
In order for the links to be "generated" by Zen Cart (using information in configure.php and the database), one needs to call the zen_href_link() function using PHP code.
For EZ-Pages the answer is no. EZ-Pages do not allow the execution of PHP code (they only allow static html).
For other pages (such as categories, products, and "define pages"), you can add a PHP snippet (calling zen_href_link) to generate the link.
-
Re: test site for upgrades
Hello,
I've just created a new testsite. The catalog works fine but I cannot access the admin. When I enter the login and password, the page becomes blank with the following URL in the browser:
https://www.MYSITE.com/testsite/MYADMIN/login.php
I created a testsite last year and all worked fine. Do you know what could be the problem? Perhaps a wrong path in the configure files –see my settings below?
ADMIN
define('HTTP_SERVER', 'http://www.MYSITE.com/testsite'); define('HTTPS_SERVER', 'https://www.MYSITE.com/testsite'); define('HTTP_CATALOG_SERVER', 'http://www.MYSITE.com/testsite'); define('HTTPS_CATALOG_SERVER', 'https://www.MYSITE.com/testsite'); define('DIR_WS_ADMIN', '/MYADMIN/'); define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_ADMIN', '/MYADMIN/'); define('DIR_WS_HTTPS_CATALOG', '/');
CATALOG
define('HTTP_SERVER', 'http://www.MYSITE.com/testsite');
define('HTTPS_SERVER', 'https://www.MYSITE.com/testsite'); define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_CATALOG', '/');
-
Re: test site for upgrades
Quote:
Originally Posted by
Thannaree
ADMIN
define('HTTP_SERVER', 'http://www.MYSITE.com/testsite'); define('HTTPS_SERVER', 'https://www.MYSITE.com/testsite'); define('HTTP_CATALOG_SERVER', 'http://www.MYSITE.com/testsite'); define('HTTPS_CATALOG_SERVER', 'https://www.MYSITE.com/testsite'); define('DIR_WS_ADMIN', '/MYADMIN/'); define('DIR_WS_CATALOG', '/'); define('DIR_WS_HTTPS_ADMIN', '/MYADMIN/'); define('DIR_WS_HTTPS_CATALOG', '/');
Not sure why you've put that all on one line without any line-breaks.
Since your whole Admin area is relatively sensitive data, and not high-traffic, make it SSL by adding the "s" as shown (yes, makes HTTP_SERVER match the HTTPS_SERVER). Only for the ADMIN. NOT for catalog.
define('HTTP_SERVER', 'https://www.MYSITE.com/testsite');
define('HTTPS_SERVER', 'https://www.MYSITE.com/testsite');
-
Re: test site for upgrades
Quote:
Originally Posted by
DrByte
Not sure why you've put that all on one line without any line-breaks.
Since your whole Admin area is relatively sensitive data, and not high-traffic, make it SSL by adding the "s" as shown (yes, makes HTTP_SERVER match the HTTPS_SERVER). Only for the ADMIN. NOT for catalog.
define('HTTP_SERVER', 'https://www.MYSITE.com/testsite');
define('HTTPS_SERVER', 'https://www.MYSITE.com/testsite');
Yes it's difficult to read. I actually did put it all with line-breaks, but then copied/pasted from Ms word ...
A thousand thanks for your answer! This fixed the issue.
I also made the Admin for www.MYSITE.com SSL by adding the "s"
-
Re: test site for upgrades
I'm again experiencing the same issue. I just created a new testsite folder for my new site. The catalog works fine but I cannot access the admin. When I enter the login and password, the page becomes blank with the following URL in the browser:
www.MYSITE.com/TESTSITE/MYADMIN/login.php ... (and not the index.php file.)
In the admin/configure.php file, I have well updated the database info and only changed as indicated below:
define('HTTP_SERVER', 'http://www.MYSITE.com/TESTSITE');
define('HTTPS_SERVER', 'https://www.MYSITE.com/TESTSITE');
define('HTTP_CATALOG_SERVER', 'http://www.MYSITE.com/TESTSITE');
define('HTTPS_CATALOG_SERVER', 'https://www.MYSITE.com/TESTSITE');
define('DIR_FS_CATALOG', '/home/thai1/public_html/TESTSITE/');
define('DIR_FS_LOGS', '/home/thai1/public_html/TESTSITE/logs');
define('DIR_FS_SQL_CACHE', '/home/thai1/public_html/TESTSITE/cache');
Am I missing something?
-
Re: test site for upgrades
Quote:
Originally Posted by
Thannaree
I'm again experiencing the same issue. I just created a new testsite folder for my new site. The catalog works fine but I cannot access the admin. When I enter the login and password, the page becomes blank with the following URL in the browser:
www.MYSITE.com/TESTSITE/MYADMIN/login.php ... (and not the index.php file.)
In the admin/configure.php file, I have well updated the database info and only changed as indicated below:
define('HTTP_SERVER', 'http://www.MYSITE.com
/TESTSITE');
define('HTTPS_SERVER', 'https://www.MYSITE.com
/TESTSITE');
define('HTTP_CATALOG_SERVER', 'http://www.MYSITE.com/TESTSITE');
define('HTTPS_CATALOG_SERVER', 'https://www.MYSITE.com/TESTSITE');
define('DIR_FS_CATALOG', '/home/thai1/public_html/TESTSITE/');
define('DIR_FS_LOGS', '/home/thai1/public_html/TESTSITE/logs');
define('DIR_FS_SQL_CACHE', '/home/thai1/public_html/TESTSITE/cache');
Am I missing something?
Since the Zen Cart v1.5.0+ admin configure.php file "auto-computes" the values for DIR_WS_ADMIN and DIR_WS_HTTPS_ADMIN based on the current directory, perhaps changing to the following would work:
Code:
define('HTTP_SERVER', 'http://www.MYSITE.com');
define('HTTPS_SERVER', 'https://www.MYSITE.com');
Don't change the definitions for the catalog-servers, though!
-
Re: test site for upgrades
Thanks lat9. I've tried that but unfortunately still get the blank pages.
In either case I get the following errors in the logs:
Accessing the Admin:
Code:
PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cookie - headers already sent by (output started at /home/thai1/public_html/test/MYADMIN/includes/classes/logger.php:127) in /home/thai1/public_html/test/includes/functions/sessions.php on line 113
PHP Warning: session_start() [<a href='function.session-start'>function.session-start</a>]: Cannot send session cache limiter - headers already sent (output started at /home/thai1/public_html/test/MYADMIN/includes/classes/logger.php:127) in /home/thai1/public_html/test/includes/functions/sessions.php on line 113
PHP Warning: Cannot modify header information - headers already sent by (output started at /home/thai1/public_html/test/MYADMIN/includes/classes/logger.php:127) in /home/thai1/public_html/test/MYADMIN/includes/init_includes/init_templates.php on line 55
Accessing the Catalog:
Code:
PHP Warning: require(DIR_WS_TEMPLATEStemplate_default/common/html_header.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/thai1/public_html/test/index.php on line 85
PHP Warning: require(DIR_WS_TEMPLATEStemplate_default/common/html_header.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/thai1/public_html/test/index.php on line 85
PHP Fatal error: require() [<a href='function.require'>function.require</a>]: Failed opening required 'DIR_WS_TEMPLATEStemplate_default/common/html_header.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/thai1/public_html/test/index.php on line 85
-
Re: test site for upgrades
I've reloaded all the files and now am able to access the admin normally. I still get the blank page when accessing the catalog.
-
Re: test site for upgrades
I've reloaded the database and the catalog files and now all works normally, without any error in the logs.
I don't know what happened yesterday when I uploaded the files. Internet was on and off but I also could have made a mistake.
Thanks lat9 for your reply!
-
Re: test site for upgrades
Internet hiccups suck! I'm glad you got it sorted out.
-
Re: test site for upgrades
Quote:
Originally Posted by
schoolboy
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.
Thanks for a great guide. I have followed step by step and am very confused why I am having these issues as it seems that both test and live are looking at the same database somehow even though the configure files have been changed to show the new database?
In test site admin shows fine. My test site looks fine if I manually type in the address
Problem 1
When I set the test site to down for maintenance, it also puts my live site in the same state!? Configure.php in admin and includes have both been changed to reflect the new test database created
Problem 2
When clicking on storefront in admin on test site, it is taking me to my live storefront??:rant:
Any help would be very appreciated!
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
Thanks for a great guide. I have followed step by step and am very confused why I am having these issues as it seems that both test and live are looking at the same database somehow even though the configure files have been changed to show the new database?
In test site admin shows fine. My test site looks fine if I manually type in the address
Problem 1
When I set the test site to down for maintenance, it also puts my live site in the same state!? Configure.php in admin and includes have both been changed to reflect the new test database created
Problem 2
When clicking on storefront in admin on test site, it is taking me to my live storefront??:rant:
Any help would be very appreciated!
These symptoms indicate that you're using the same config for both sites.
Sometimes the culprit is that the configure.php files were read-only when you tried to upload changes to them, and the upload didn't take.
-
3 Attachment(s)
Re: test site for upgrades
Quote:
Originally Posted by
DrByte
These symptoms indicate that you're using the same config for both sites.
Sometimes the culprit is that the configure.php files were read-only when you tried to upload changes to them, and the upload didn't take.
Hi, these are my live sites files, I have compared them and can't see what the problem can be. Are you able to have a look please? I will upload the test files on another post.
Many thanks
-
3 Attachment(s)
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
Hi, these are my live sites files, I have compared them and can't see what the problem can be. Are you able to have a look please? I will upload the test files on another post.
Many thanks
Sorry, previous attachments were the test files and these files are the live site.
Thanks
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
Sorry, previous attachments were the test files and these files are the live site.
Thanks
In your test site do you have a configure.php file in YOUR_ADMIN/includes/local?
-
Re: test site for upgrades
Quote:
Originally Posted by
mc12345678
In your test site do you have a configure.php file in YOUR_ADMIN/includes/local?
No I only have skip_version_check.ini in the local folder?
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
No I only have skip_version_check.ini in the local folder?
Somewhat back on what DrByte was saying about updating the file(s), while I can not reproduce it 100% of the time, I have come across situations where I "save" the change, I close out the file, I open it up again and it "looks" refreshed. I access the file another way and find that it has not actually saved it to the server... This has happened to me if I have in a hurry used like a web-based method of accessing the file instead of a quality ftp program.
What of any of that might seem to apply to your situation? The database shown on the images appears to be different between the catalog and admin.
-
Re: test site for upgrades
Quote:
Originally Posted by
mc12345678
Somewhat back on what DrByte was saying about updating the file(s), while I can not reproduce it 100% of the time, I have come across situations where I "save" the change, I close out the file, I open it up again and it "looks" refreshed. I access the file another way and find that it has not actually saved it to the server... This has happened to me if I have in a hurry used like a web-based method of accessing the file instead of a quality ftp program.
What of any of that might seem to apply to your situation? The database shown on the images appears to be different between the catalog and admin.
I'm not sure if I've found something.... theres an configure.php file in admin/includes/configure.php, which I guess should not be there?!
As for the files, i've downloaded using filezilla, changed in dreamweaver, deleted the original file and uploaded the new. Im so confused :(
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
I'm not sure if I've found something.... theres an configure.php file in admin/includes/configure.php, which I guess should not be there?!
As for the files, i've downloaded using filezilla, changed in dreamweaver, deleted the original file and uploaded the new. Im so confused :(
Now I see what you mean about configure in local. Yes I did. Ive removed that one and adjusted the one in admin/includes. I can get onto the admin login page but cant use my normal login details. I want to cry now :frusty:
-
Re: test site for upgrades
-
Re: test site for upgrades
That condition seems unusual though if the database being referenced is a backup copy of your live site where you typically login...
That said, because the backup copy of the site used an admin/includes/local/configure.php file, it would seem that if the database backed up wasn't the one referenced in that file, then it would explain why the password attempted didn't work...
Ok, I know that's confusing. This point of having four or in your case 6 files can get crazy...
Basically, the database that should be your testing database, should have been a backup of the database used on your live site. Revisit the above instructions to consider using whatever database is referenced in admin/includes/local/configure.php from your live site.
-
Re: test site for upgrades
Quote:
Originally Posted by
mc12345678
That condition seems unusual though if the database being referenced is a backup copy of your live site where you typically login...
That said, because the backup copy of the site used an admin/includes/local/configure.php file, it would seem that if the database backed up wasn't the one referenced in that file, then it would explain why the password attempted didn't work...
Ok, I know that's confusing. This point of having four or in your case 6 files can get crazy...
Basically, the database that should be your testing database, should have been a backup of the database used on your live site. Revisit the above instructions to consider using whatever database is referenced in admin/includes/local/configure.php from your live site.
Thank you for all your help. I can't get it fixed, even after deleting and starting again, so I am going to stick with my original database and just have a testsite for the files :(
Thanks again
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
Thank you for all your help. I can't get it fixed, even after deleting and starting again, so I am going to stick with my original database and just have a testsite for the files :(
Thanks again
If you're upgrading, you do not want to use your new files on your live site that is still accessing the database with an old fileset. It could cause database issues.
-
Re: test site for upgrades
Quote:
Originally Posted by
mc12345678
If you're upgrading, you do not want to use your new files on your live site that is still accessing the database with an old fileset. It could cause database issues.
Hi, I'm not upgrading my site at the moment, I just wanted to run a test site. I don't know what other options I have? :/
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
Hi, I'm not upgrading my site at the moment, I just wanted to run a test site. I don't know what other options I have? :/
Here's perhaps something that will work assuming the plugin is available to support your version of ZC.
Get mysql database backup. Install on your live site. Backup the database from there.
Your new temp site. Install it or point it to your test database, remove all of the tables from the temp database via myphpadmin (be absolutely sure you are in the correct database). Run zc_install to install a new store to your temp database. Install the plugin in your temp store. Transfer the file from the live store to your temp store. Restore that database to your temp store...
There are a number of other ways to accomplish this task of copying the live store database to your temp store database. At least that method doesn't really require you to know which was the *real* live database considering you know which one is your test store...
The only other thing of concern is if that admin/includes/local/configure.php defined a DB_PREFIX different than what you have in your temp store...
-
Re: test site for upgrades
Quote:
Originally Posted by
lindsey80
Hi, I'm not upgrading my site at the moment, I just wanted to run a test site. I don't know what other options I have? :/
i do not recommend running a test site on a live dataset. you are now not running a test site. you are running 2 live sites. as the data is the core component of the live v test site.
you have a multitude of options:
- keep on trying yourself.
- have someone here do it.
it is possible your hosting plan only allows 1 database - which means you would need another hosting plan.
BUT, you need 2 databases if you want a testsite. more so than 2 sets of files.
good luck.
-
Re: test site for upgrades
Quote:
Originally Posted by
carlwhat
i do not recommend running a test site on a live dataset. you are now not running a test site. you are running 2 live sites. as the data is the core component of the live v test site.
you have a multitude of options:
- keep on trying yourself.
- have someone here do it.
it is possible your hosting plan only allows 1 database - which means you would need another hosting plan.
BUT, you need 2 databases if you want a testsite. more so than 2 sets of files.
good luck.
Not entirely true, a DB_PREFIX can be used that would support two or more sets of datatables being on one server, sure it requires some data manipulation, but it is possible to have one database and more than one system reference the database with each being independently operational.
-
Re: test site for upgrades
Quote:
Originally Posted by
mc12345678
Not entirely true, a DB_PREFIX can be used that would support two or more sets of datatables being on one server, sure it requires some data manipulation, but it is possible to have one database and more than one system reference the database with each being independently operational.
ok. technically true.
but NOT a situation that i would recommend implementing. for anyone.
best.
-
Re: test site for upgrades
Quote:
Originally Posted by
carlwhat
ok. technically true.
but NOT a situation that i would recommend implementing. for anyone.
best.
Amen, 100% agree. Just one more of those options in a time of need.
