Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
I am wanting to upgrade from 1.5.1 to 1.5.3 and I have copied all files across and are at the part of wanting to upgrade the dB by running the zc_install. For some reason I am not getting presented with the option to upgrade database (only fresh install).
I have checked config files and reinstated 1.5.1 config files and also made sure they not read only. My install log file states inspect: FATAL. It then continues to list the system inspect details.
Can anyone think of what I may be missing? Its been a while since I have upgraded so I'm hoping its a late night silly mistake.
Would I be better just to re-install from fresh now and cut my losses? (I have backups)
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Hopefully the above link provided some insight; however, to provide help we may need a little more information.
Path of functional 1.5.1 version as it relates to the domain name.
Path of problem 1.5.3 version as it relates to the domain name.
Were the various file paths updated in the includes/configure.php and admin/includes/configure.php to account for the difference between the "old" location and the "new" location?
The database, it appears from the description that there is/was no backup of the database, and that the installation being performed is using the same database as the original store. Do the two configure.php files reference the same database as the original, a newly creaated database, two different databases, etc?
Effectively if the install can see that there is an existing install, then it will offer the option to upgrade the database, if not, then it offers a new install.
Are you using a temporary uri for example?
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Many thanks for your help. There was an error in the config files in the localhost area. Upgraded today OK. Took me longer than expected to find
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Quote:
Originally Posted by
sydmich
Many thanks for your help. There was an error in the config files in the localhost area. Upgraded today OK. Took me longer than expected to find
Devil in the details. :) congratulations, continued happy zenning.
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Hi,
I am using this thread because the title is perfect ofr my questions.
For reasons that woul be too long to explain I want to keep the 1.5.1 file set for my store and upgrade only the db from 1.5.1 to 1.5.3
I tryed to use the zc_install to do that but the when I hit upgrade I get a message saying that the file mysql_upgrade_zencart_151_to_153.sql is not found.
I then (in my test site) copied the content of the file mysql_upgrade_zencart_151_to_153.sql (that is exactly were it should be) and pasted it in the patch database windows in the admin.
The database was updated without any problem (44 statment processed) and I do not see any loss of data of apparent problem.
Now, my questions are:
1) Is it possible that with the procedure above I created damages that I do not see at the moment but that will come out later? In other words, is it safe what I did?
2) Will I have any problem (if I keep the db 1.5.3) when later I will update also the file set to 1.5.3?
Thanks for your help.
Ciao from Italy
enzo
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Quote:
Originally Posted by
enzo-ita
Hi,
I am using this thread because the title is perfect ofr my questions.
For reasons that woul be too long to explain I want to keep the 1.5.1 file set for my store and upgrade only the db from 1.5.1 to 1.5.3
I tryed to use the zc_install to do that but the when I hit upgrade I get a message saying that the file mysql_upgrade_zencart_151_to_153.sql is not found.
I then (in my test site) copied the content of the file mysql_upgrade_zencart_151_to_153.sql (that is exactly were it should be) and pasted it in the patch database windows in the admin.
The database was updated without any problem (44 statment processed) and I do not see any loss of data of apparent problem.
Now, my questions are:
1) Is it possible that with the procedure above I created damages that I do not see at the moment but that will come out later? In other words, is it safe what I did?
2) Will I have any problem (if I keep the db 1.5.3) when later I will update also the file set to 1.5.3?
Thanks for your help.
Ciao from Italy
enzo
The answer is yes.. which is why deviations from the upgrade path are not supported, and you will find that very little assistance will be provided in walking down this path.. What kinds of issues you may ask?? The answer to that is you will have to tell us as you have ventured down an upgrade path that is not recommended or supported, and probably UNTESTED..
The real question is WHY do this at all.. If it's a matter of modules and customizations needing updating, I suggest waiting or hire someone to upgrade them for you..
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
I have a similar question. Not only why do this, but what benefit do you perceive to gain by upgrading the database using every upgrade instruction that is applied when upgrading the software as well?
I can perceive a few minor things that might be worthwhile, say if there were some new indices added to tables to improve their performance, okay, no real impact on anything that is a code interface, but consider a broader upgrade, say from 1.3.9h to 1.5.0. From the onset, 1.5.0 has a different table structure for the admin table. Take a look at the sql in the FAQ for forgotten passwords. Two different statements required for the same action on the same table.
In this case you may be lucky (1.5.1 to 1.5.3) for now, but if the thought is/was that the database runs better under 1.5.3, well the next change to the database made by 1.5.1 in that area will defeat/undo that gain... I mean right now if you were to look at the result of the version page information, you will see that the store has version 1.5.1 and the database has 1.5.3. I'm thinking that in that configuration it is possible some plugins won't work because they may use that database version to perform actions, for example to try to access the database using ZC builtin functions that expect to use mysqli_ functions instead of mysql_ functions...
Like Diva is identifying, you go to a support forum because the plugin doesn't work as such a result and the answer more than likely would be to rebuild your site or fully upgrade it... I doubt that someone would modify the code provided to/for the masses to program with this deviation in mind. I know I haven't and have no plans to.
As I expect one other to chime in on this, I consider this a bad idea. Perhaps a "fun" experiment, but only that and should not be a normal practice or used in a production environment if you value your income/business.
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Quote:
Originally Posted by
mc12345678
I consider this a bad idea. Perhaps a "fun" experiment, but only that and should not be a normal practice or used in a production environment if you value your income/business.
BOOM!!!
**nods in agreement**:yes:
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Thanks DivaVocals and mc12345678
Ok OK I was not trying to invent something. I was just trying to find a workaround to the problem I have with the installer that does not find the file mysql_upgrade_zencart_151_to_153.sql which instead is exactly were it should be having uploaded the zc_install completely in the sub dir were the test file set is stored. (public_html/sub/test/
Can you help me with that problem?
If not, can you tell me how to start from scratch with a new set of files and db and then import the data from my old_db to the new_db?
Thanks.
Ciao from Italy.
enzo
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
So a fresh copy of the zc_install folder can be obtained by download ZC 1.5.3 (hotfix 1) from http://www.zen-cart.com/getit (or any previously released version for the most part) then after the checksums are confirmed (validating that all of the data made it intact with no changes) the sql file for 1.5.1 to 1.5.3 should be available to upload again. It is possible that the file did not fully/successfully transfer and just. Needs to be uploaded again. This happens sometimes. But there is still a fix supposedly to apply to that set of files to modify I think itis the functions_general.php file but if that is not where the "originals" came from, then that too could be the cause.
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Quote:
Originally Posted by
mc12345678
So a fresh copy of the zc_install folder can be obtained by download ZC 1.5.3 (hotfix 1) from
http://www.zen-cart.com/getit (or any previously released version for the most part) then after the checksums are confirmed (validating that all of the data made it intact with no changes) the sql file for 1.5.1 to 1.5.3 should be available to upload again. It is possible that the file did not fully/successfully transfer and just. Needs to be uploaded again. This happens sometimes. But there is still a fix supposedly to apply to that set of files to modify I think itis the functions_general.php file but if that is not where the "originals" came from, then that too could be the cause.
I think my question was not clear enough.
I know were to find the setup files and I would like to start from that.
What I need to know is how, once created the fresh install, to transfer the data from my data base to the new data base.
Thanks
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Quote:
Originally Posted by
enzo-ita
I think my question was not clear enough.
I know were to find the setup files and I would like to start from that.
What I need to know is how, once created the fresh install, to transfer the data from my data base to the new data base.
Thanks
I usually use backup mysql available for download in the plugins. Easiest if both databases use the same database prefix. Backup from one site, transfer file to new "loading area", restore the database. Otherwise use myphpadmin, export all tables, could include the delete table option so that the table is deleted just before being inserted. And then upload that file through myphpadmin as well to the new database. A number of ways to do.
Re: Upgrade from 1.5.1 to 1.5.3 - upgrade option not being offered
Quote:
Originally Posted by
enzo-ita
I think my question was not clear enough.
I know were to find the setup files and I would like to start from that.
What I need to know is how, once created the fresh install, to transfer the data from my data base to the new data base.
Thanks
Simple upgrade starting process..
Create a dev/test site (location for files and a dev/test database)
Export live/prod DB
Import the live/prod DB into the new dev/test DB
Copy Zen Cart install files to dev/test site
Run the install of VANILLA Zen Cart in new dev/test site
Choose UPGRADE
During the install you SHOULD be prompted to upgrade your DB
Now if you are doing things JUST LIKE this then you WILL see the upgrade options.. If you DEVIATE you will not..
