Update database from 1.0.7.11 to latest 1.0.8.20/21

[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?

[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

[14Steve14]

@raiwa You are an absolute star. That will save a lot of work. Just need the ones up to the first version now.

[14Steve14]

Does anyone have links to the earlier updates before Phoenix. I cant find them all, even on Github.

[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

[14Steve14]

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.

[Dan Cole]

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

[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

[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

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

[14Steve14]

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.