Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> v2.3 RN Issues
Author Message
dad7732
RavenNuke(tm) Development Team



Joined: Mar 18, 2007
Posts: 1242

PostPosted: Wed Feb 04, 2009 3:51 pm Reply with quote

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. Smile

'bout it. And of course will have a backup just prior to the upgrade.

Cheers
 
View user's profile Send private message
dad7732







PostPosted: Wed Feb 04, 2009 4:07 pm Reply with quote

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
 
fkelly
Former Moderator in Good Standing



Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Wed Feb 04, 2009 4:37 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website
dad7732







PostPosted: Wed Feb 04, 2009 4:53 pm Reply with quote

Yah thanks. The only addin is the new Content Plus and I know to leave that intact without overwriting it. Smile

And yes, I read all the instructions but was just warming up the cold feet sorta talking to myself. Cool

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
 
fkelly







PostPosted: Wed Feb 04, 2009 6:17 pm Reply with quote

Cheers to you Dad and good luck. It sounds like you have your process well planned.
 
dad7732







PostPosted: Wed Feb 04, 2009 6:25 pm Reply with quote

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
 
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam

PostPosted: Thu Feb 05, 2009 11:45 am Reply with quote

If you want to scare yourself you can also load the file_migration23.php script hidden in the Utilities directory.
 
View user's profile Send private message Send e-mail
dad7732







PostPosted: Thu Feb 05, 2009 11:51 am Reply with quote

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
 
Guardian2003







PostPosted: Thu Feb 05, 2009 12:00 pm Reply with quote

Let me know if you lose any more hair afterwards.
 
dad7732







PostPosted: Thu Feb 05, 2009 12:01 pm Reply with quote

Yowza, found 111 files that can be removed on one test site recently updated to 2.3 .. interesting.

Cheers
 
Guardian2003







PostPosted: Thu Feb 05, 2009 12:13 pm Reply with quote

Older *nuke migrations to RN will find some scary stuff but so long as you have found it useful Wink
 
dad7732







PostPosted: Fri Feb 06, 2009 7:50 pm Reply with quote

Success !!! Smile

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







PostPosted: Fri Feb 06, 2009 9:07 pm Reply with quote

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.
 
dad7732







PostPosted: Fri Feb 06, 2009 9:11 pm Reply with quote

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 ... Smile

Cheers
 
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Sun Feb 08, 2009 9:48 am Reply with quote

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! 
View user's profile Send private message Visit poster's website
dad7732







PostPosted: Sun Feb 08, 2009 10:11 am Reply with quote

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.
 
Palbin
Site Admin



Joined: Mar 30, 2006
Posts: 2583
Location: Pittsburgh, Pennsylvania

PostPosted: Sun Feb 08, 2009 11:45 am Reply with quote

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. 
View user's profile Send private message
montego







PostPosted: Sun Feb 08, 2009 11:55 am Reply with quote

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.
 
dad7732







PostPosted: Sun Feb 08, 2009 12:38 pm Reply with quote

Same here, "user_theme" is blank for all users whereas "theme" is the one that is/was populated.
 
fkelly







PostPosted: Sun Feb 08, 2009 1:56 pm Reply with quote

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.
 
Palbin







PostPosted: Sun Feb 08, 2009 3:33 pm Reply with quote

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
 
dad7732







PostPosted: Sun Feb 15, 2009 11:01 am Reply with quote

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


Last edited by dad7732 on Mon Feb 16, 2009 7:02 am; edited 1 time in total 
montego







PostPosted: Mon Feb 16, 2009 6:23 am Reply with quote

Always nice to hear. THANK YOU!
 
dad7732







PostPosted: Mon Feb 16, 2009 7:05 am Reply with quote

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
 
montego







PostPosted: Tue Feb 17, 2009 5:54 pm Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> v2.3 RN Issues

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©