Zen Cart Logo
Forums / Upgrading from 1.3.x to 1.3.9 / test site for upgrades

test site for upgrades

Views: 56,042

Results 41 to 49 of 49
24 Jan 2018, 10:08 PM
#41
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

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.

25 Jan 2018, 8:39 PM
#42
lindsey80 avatar

lindsey80

New Zenner

Join Date:
Apr 2010
Location:
Essex, UK
Posts:
77
Plugin Contributions:
0

Re: test site for upgrades

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

25 Jan 2018, 9:06 PM
#43
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: test site for upgrades

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.

25 Jan 2018, 9:39 PM
#44
lindsey80 avatar

lindsey80

New Zenner

Join Date:
Apr 2010
Location:
Essex, UK
Posts:
77
Plugin Contributions:
0

Re: test site for upgrades

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? :/

25 Jan 2018, 9:52 PM
#45
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: test site for upgrades

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

27 Jan 2018, 2:15 AM
#46
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,967
Plugin Contributions:
8

Re: test site for upgrades

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.

27 Jan 2018, 2:59 AM
#47
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: test site for upgrades

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.

27 Jan 2018, 3:06 AM
#48
carlwhat avatar

carlwhat

zennedOut

Join Date:
Nov 2005
Location:
los angeles
Posts:
2,967
Plugin Contributions:
8

Re: test site for upgrades

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.

27 Jan 2018, 4:42 AM
#49
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: test site for upgrades

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.