Author |
Message |
dad7732
RavenNuke(tm) Development Team
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Mar 18, 2007
Posts: 1242
|
Posted:
Wed Feb 04, 2009 3:51 pm |
|
Will be upgrading a critical production site from RN 2.20.01 to 2.3. Cold feet? yah, just a little.
Clarification: Upload the 2.3 files to the site and THEN run the upgrade php file? Yes, I read instructions but just want/need a warm and fuzzy feeling.
'bout it. And of course will have a backup just prior to the upgrade.
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Wed Feb 04, 2009 4:07 pm |
|
Well, I guess I can answer my own question unless there is another upgrade script to run other than to upgrade the core DB Tables.
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
fkelly
Former Moderator in Good Standing
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY
|
Posted:
Wed Feb 04, 2009 4:37 pm |
|
I would urge you to read through the upgrade section of the HowToInstall manual carefully. You are basically correct that you run the rndb_upgrade.php file but there are many individual circumstances that are covered in the manual that can't be covered adequately here. For instance, depending on your previous Gcal version you might need to run a Gcal install program. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Wed Feb 04, 2009 4:53 pm |
|
Yah thanks. The only addin is the new Content Plus and I know to leave that intact without overwriting it.
And yes, I read all the instructions but was just warming up the cold feet sorta talking to myself.
Actually I have only upgraded once, and only installed a new version of 2.3 on other test domains. This particular domain is an upgrade from 6.5 to 2.20.01 and still only one module in use from 6.5 (Sections) and that's because there is no way to migrate several hundred FAQS. I am in the process of re-writing them to the new C-Plus and then the upgrade to 2.3. Other than that I don't have any customized modules or add-ons as it is primarily a support site with FAQS and the forum. Oops, forgot about the cartoon module but that is sooo standalone, it doesn't matter if it stays or goes. I actually have support users that get irritated if it burps every once in a while.
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
fkelly
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Wed Feb 04, 2009 6:17 pm |
|
Cheers to you Dad and good luck. It sounds like you have your process well planned. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Wed Feb 04, 2009 6:25 pm |
|
Yah, I upgraded from 6.5 to 2.20 to 2.20.01 without problems with the exception of having to figure out how to get the Sections module back. Gettting ready to join the rest of the planet with 2.3 devoid of stone-age modules, etc. Will be much easier to upgrade to the next version(s).
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Guardian2003
Site Admin
![](modules/Forums/images/avatars/125904890252d880f79f312.png)
Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam
|
Posted:
Thu Feb 05, 2009 11:45 am |
|
If you want to scare yourself you can also load the file_migration23.php script hidden in the Utilities directory. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Thu Feb 05, 2009 11:51 am |
|
That's ok ... on social security, medicare and receding hairline (nice shade of lite gray) ... don't need any more scary things in what's left of my days of breathing air ... However, I WIILL try that on a non-production site ..
Cheers ![Cheers](modules/Forums/images/smiles/cheers.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Guardian2003
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Thu Feb 05, 2009 12:00 pm |
|
Let me know if you lose any more hair afterwards. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Thu Feb 05, 2009 12:01 pm |
|
Yowza, found 111 files that can be removed on one test site recently updated to 2.3 .. interesting.
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Guardian2003
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Thu Feb 05, 2009 12:13 pm |
|
Older *nuke migrations to RN will find some scary stuff but so long as you have found it useful ![Wink](modules/Forums/images/smiles/icon_wink.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Fri Feb 06, 2009 7:50 pm |
|
Success !!!
Only ONE gray hair added. We're now totally 2.3 dependent, no more 6.5 anything left.
Only one little hanger. 2000+ reg'd users with maybe less than 100 used a theme compatile up to RN 2.20x but not with 2.3.
What happens now is that a user with an incompatible theme will get a blank page and figure we're gone! Not good. And I don't have the time OR patience to peruse the DB for each user's theme choice.
Any ideas as to how to proceed with this. SOME users actually paid attention to the announcement and emailed me to blank out the theme in their personal configuration so that the default RavenIce would appear.
???
Cheers
Note: Maybe we could do a MySQL query for "theme" in the USERS table and blank out all themes which will then be RavenIce by default ?? |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
fkelly
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Fri Feb 06, 2009 9:07 pm |
|
Dad, that should work and you could probably do it with PHPmyadmin too. I just noticed that there is a user_theme field and a theme field in the users table but you are right that the theme field appears to be the one used. As you know, this assumes that you've set ravenice to be your site's default theme in preferences, settings.
Sounds like you might have the dreaded dbi problem with the older themes. There is a quick fix to mainfile if that turns out to be the problem (see threads on dbi) but you might still be better off migrating the users to one of the more recent "standard" themes.
Many older themes have tons of validation problems in addition to requiring dbi. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Fri Feb 06, 2009 9:11 pm |
|
Thanks, what my ultimate goal is to have RavenIce as the only theme, no customs at all. But first I have to blank out any customs somehow OR just wait until I get email from puzzled users as to why their theme doesn't work ...
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
montego
Site Admin
![](modules/Forums/images/avatars/0c0adf824792d6d341ef4.gif)
Joined: Aug 29, 2004
Posts: 9457
Location: Arizona
|
Posted:
Sun Feb 08, 2009 9:48 am |
|
Within phpMyAdmin you can accomplish these things.
If you want to blank out all custom theme selections to where everyone will now get the default theme for the site set within Preferences, do this (of course, adjust the prefix is you had changed that):
Code:
UPDATE nuke_users SET theme = ''
|
If you want to change from one theme to another, or blank out only certain ones, you simply expand upon the SQL. This example is changing all "NonRavenIce" to "RavenIce":
Code:
UPDATE nuke_users SET theme = 'RavenIce' WHERE theme = 'NonRavenIce'
|
|
_________________ Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Feb 08, 2009 10:11 am |
|
Tried it from your suggestion above on two test domains and that works, both do . However, we're a little late to the party on the production DB. Had nothing better to do at work yesterday, so I manually blanked out each user's "theme" selection. Interesting to note that "subSilver" was the most used custom theme followed by Odyssey.
Cheers and THANKS for the suggestion, added to my "notes" for future use. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Palbin
Site Admin
![](modules/Forums/images/avatars/Dilbert/Dilbert_-_Dogbert_King.gif)
Joined: Mar 30, 2006
Posts: 2583
Location: Pittsburgh, Pennsylvania
|
Posted:
Sun Feb 08, 2009 11:45 am |
|
Maybe a little late to this conversation, but I figured i'd chime in with a little fact. The "user_theme" is used for the nuke theme and the "theme" is used for the board theme in forums. I'm like 99% sure on this. |
_________________ "Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it." — Brian W. Kernighan. |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
montego
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Feb 08, 2009 11:55 am |
|
Weird. That is not what I am seeing on my site, but I am not an expert on the phpBB side. However, not sure that is right as "user_theme" is int(3). I have always done the above to reset user's selected themes. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Feb 08, 2009 12:38 pm |
|
Same here, "user_theme" is blank for all users whereas "theme" is the one that is/was populated. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
fkelly
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Feb 08, 2009 1:56 pm |
|
If you look in mainfile's get_theme function and also in Your_Account/public/savetheme.php you will see that the field 'theme' is used to store the user's selected theme (which is also stored in a cookie). Interesting that mainfile checks for a themepreview. I haven't looked further but I don't recall any themepreview capability in RN. It could be obsolete code that doesn't do any harm except eating a few nanoseconds on every pass. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Palbin
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Feb 08, 2009 3:33 pm |
|
montego wrote: | Weird. That is not what I am seeing on my site, but I am not an expert on the phpBB side. However, not sure that is right as "user_theme" is int(3). I have always done the above to reset user's selected themes. |
It must be the other way around then. That what I get for not looking ![Smile](modules/Forums/images/smiles/icon_smile.gif) |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Sun Feb 15, 2009 11:01 am |
|
Whilst in this "Upgrade" thread/discussion, let me make one observation after upgrading to 2.3.
EVERYone should pay attention to this !!! In the RN 2.3 distro bits, there is a /UtilityFiles/File_Compare/ directory with the file file_migration23.php included. Upload it to your RN root directory and run it. Depending on how many previous versions upgraded to 2.3 you will be absolutely amazed at the number of files that are no longer needed AND which ones pose a security threat if left behind.
I had eleven, yes ELEVEN printed pages of files and directories that were no longer needed, etc etc.
After removing the selected files, my production support site loaded and displayed notably faster. I am now 100% RN 2.3.
Cheers and THANKS to all ...
![RavensScripts](modules/Forums/images/smiles/ravensphpscripts.gif) |
Last edited by dad7732 on Mon Feb 16, 2009 7:02 am; edited 1 time in total |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
montego
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Mon Feb 16, 2009 6:23 am |
|
Always nice to hear. THANK YOU! |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
dad7732
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Mon Feb 16, 2009 7:05 am |
|
Yes, access was very much better performance wise but more important was the security factor which I can't stress enough. 41 "filter" blocked last night on just ONE domain. There seems to be a concentrated effort as of late to break in to anything out there. Attempted breakins to my server have increased at least twofold in the last 30 days.
Cheers |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
montego
![](modules/Forums/images/avatars/gallery/blank.gif)
|
Posted:
Tue Feb 17, 2009 5:54 pm |
|
You might want to consider ModSecurity to keep from many of these hitting your sites. It doesn't stop everything, of course, and at times, it can be a bit aggressive, but the rules can be tweaked. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
|