[keg01]

So, thinking that i'm cleverer than the average bear I'm thinking I'll do a manual upgrade (in test environment) from 9.8.2 -> RC 1.0.

I know the recommended approach would be to upgrade to 9.9.5 first and then run an automated 9.9.5 -> 1.0 RC upgrade. However, I have some tightly integrated custom code in 9.8.2 and will have to replicate those customizations with both the 9.9.5 and the 1.0RC upgrades.

I'm looking for validation (or repudiation!) from the Pligg elders on the Forum ... my thinking is that I should simply run the fresh 1.0 RC install and then write sql to "upgrade" my 9.8.2 data directly to the newly installed db. Then, I can make my mods 1 time in the 1.0RC instead of having to do it twice.

So, am I crazy? The Pligg data schema seems relatively straight forward to me and the idea of migrating the data from 9.8.2 to 1.0RC is less intimidating to me than migrating the codebase twice.

Thoughts? Suggestions? Rotten fruit? Thanks!

[wediggcouk]

if you site has been running and has members mate i would not chance installing rc1 at the moment mate,

my wedigg.co.uk site is running 9.5.5 and its staying like that untill alot of the bugs gets found and ive took the new rc1 for a test run...

just my advice..

[keg01]

Right! I'm with you on that advice. I'm looking to do a bit of my own integration testing with 1.0RC before using it in production. So, the manual upgrade I'm contemplating is for getting a test 9.8.2 to a 1.0RC without having to go through 9.9.5. make sense?

[Yankidank]

The upgrade.php file should make the database changes that you need automatically. Running it should perform all of the database updates that you need for you. The upgrade script doesn't change any files, just the database.

[keg01]

Wow. For 9.8.2 schema as well? I'm going to give that a spin in my testbed and I'll update this thread. Thanks for a great RC - I've been running through the config of a default install and it looks like a dream. The Groups is going to take my community to the next level.

[keg01]

Upgrade seemed to go smoothly - thanks for steering me back on the straight and narrow. 9.8.2 upgrade done in testbed ... impressive!

[argh2xxx]

Keg01 can you do a comparison for db of 9.9.5 or 9.82 against db of 1.0CR1? Example, like the pligg's prefix stay the same? Don't have to be exact, but if you can inform us what you know, it will be a great help for folks like us who want to do exactly like what you have done . Thank you brave one!

[keg01]

Originally Posted by argh2xxx

Keg01 can you do a comparison for db of 9.9.5 or 9.82 against db of 1.0CR1? Example, like the pligg's prefix stay the same? Don't have to be exact, but if you can inform us what you know, it will be a great help for folks like us who want to do exactly like what you have done . Thank you brave one!

I have to tell you I didn't do much of anything clever (except work on a backup copy). Yes, 1.0RC has the same default table prefix (pligg_). There are additional data tables in 1.0RC. You can see a screen shot of my modified 9.8.2 table list (i run pageview and rss import) and the default 1.0RC table list list below.

Also, if you look in 1.0RC at ./install/upgrade.php, you can see each sql statement the upgrade process executes to alter, update, or create table data. Enjoy! .

[Yankidank]

note: the table_tag_cache needs to have the pligg_ prefix, we missed that one until after the RC1 release. Thats what release candidates are for though I guess.