Page 1 of 1
Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Thu Nov 23, 2023 11:28 am
by 14Steve14
I am nearly ready to update my current 1.0.7.11 website to the latest release 1.0.8.20. Most of the coding work is done on the test site. Only a few modules need updating still but that can be arranged at a later date.
My big worry is updating the database. I can find all the updates on Github, or even from this site, which start at the very first CE phoenix version, but cannot find any of the earlier updates whist still part of oscommerce.
Is there anywhere where I can find all the older update packages?
I want to do a trial run on the database before doing any final changes, and will list any database changes to make it easier when the time comes. Is this the right approach to take?
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Thu Nov 23, 2023 11:56 am
by raiwa
I have a compilation of all database updates from 1.0.0.0 to current 1.0.8.20 merged into one file.
You can just delete the parts you do not need and apply all updates at once or go step by step, if you prefer.
Versions which have no sql update have a comment but no script.
1.0.0.0-1.0.8.20.zip
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Thu Nov 23, 2023 12:23 pm
by 14Steve14
@raiwa You are an absolute star. That will save a lot of work. Just need the ones up to the first version now.
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Mon Nov 27, 2023 10:11 am
by 14Steve14
Does anyone have links to the earlier updates before Phoenix. I cant find them all, even on Github.
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Mon Nov 27, 2023 6:05 pm
by Dan Cole
Steve did you have a look at Zipur’s Migration Utility? I used it to update an old OSC database and as far as I know it worked as advertized.
Dan
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Mon Nov 27, 2023 6:47 pm
by 14Steve14
Dan Cole wrote: ↑Mon Nov 27, 2023 6:05 pm
Steve did you have a look at Zipur’s Migration Utility? I used it to update an old OSC database and as far as I know it worked as advertized.
Dan
I did have a look at that and it looked really complicated to use. I may have to give it a try.
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Mon Nov 27, 2023 9:06 pm
by Dan Cole
14Steve14 wrote: ↑Mon Nov 27, 2023 6:47 pm
I did have a look at that and it looked really complicated to use. I may have to give it a try.
It can't be too complicated Steve...I got it to work.
Dan
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Tue Dec 05, 2023 12:32 am
by Dan Cole
Steve, how are you getting along updating your database? I was doing some work on my database earlier today and came across this file [sql_changes_ms2.2_to_2.3.3.sql] which I downloaded from the osc website some where along the way....likely before I discovered Zipur’s Migration Utility. In any case if you think that would be of any help to you just let me know.
Dan
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Fri Apr 26, 2024 7:29 am
by raiwa
raiwa wrote: ↑Thu Nov 23, 2023 11:56 am
I have a compilation of all database updates from 1.0.0.0 to current 1.0.8.20 merged into one file.
You can just delete the parts you do not need and apply all updates at once or go step by step, if you prefer.
Versions which have no sql update have a comment but no script.
1.0.0.0-1.0.8.20.zip
There was an error from the first version of the 1.0.8.4 update script included.
The zone update line 596 should be:
Code: Select all
UPDATE configuration SET set_function = 'Config::select_zone_by(STORE_COUNTRY, ' WHERE set_function = 'tep_cfg_pull_down_zone_list(';
Here the fixed version with added scripts for 1.0.8.21 and 1.0.9.1:
1.0.0.0-1.0.9.1..zip
Re: Update database from 1.0.7.11 to latest 1.0.8.20/21
Posted: Fri Apr 26, 2024 8:12 am
by 14Steve14
Dan Cole wrote: ↑Tue Dec 05, 2023 12:32 am
Steve, how are you getting along updating your database? I was doing some work on my database earlier today and came across this file [sql_changes_ms2.2_to_2.3.3.sql] which I downloaded from the osc website some where along the way....likely before I discovered Zipur’s Migration Utility. In any case if you think that would be of any help to you just let me know.
Dan
Dan sorry for the delay in replying. I eventually fount time to have atrial run with a copy of the database and everything went really well. Apart from a few little niggles which were mainly me forgetting to copy any sql updates for some addons. I have those changes no, so hopefully when the real time comes in the next few weeks it should be an easy job.