| Author |
Message |
AndyB
Worker
Joined: Jun 03, 2004
Posts: 231
Location: Torrevieja, Spain
|
 Posted:
Thu Feb 25, 2010 7:19 am |
|
Wish me luck   
After a few "issues" of late, I've decided I'm not going to leave the site "as is" (my main site)- we've been "playing" with RN 2.4.x on a dev bed- initially to change from Joomla on another site we're working on. A result of this has shown that the site can stay on Joomla- we're going to upgrade my "baby" from 7.6 nuke (patched) to RN....
I think I've got most of it sorted; we've backed the site up- will disable the main site Saturday night and back up the DB, ready to start the upgrade path Sunday morning....
Wish me luck- it could be painful |
| |
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
| Posted:
Fri Feb 26, 2010 1:41 am |
|
Please keep a log that would be detailed enough that we, or someone, could develop/write upgrade scripts fro those (of us) who have a heavily modified v7.6 site  |
| |
|
|
|
|
AndyB
|
| Posted:
Fri Feb 26, 2010 2:34 am |
|
here's a basic "overview" (may help others)- I'll try to document what I did, and any issues. Most of the "hard work" with regards documentation you guys already have in place 
Some of this is only relevant to my site (www.audifans.net), but some things I'm looking at after I've done may interest some people (I did a few searches on here yesterday  )
The ONLY advice I can offer any one else- right now- is plan first. Then double check. Then triple check. This list below- lets say it's in it's FIFTH revision.... 
To start with, I've advised users of the downtime; the site files will not change between now and when I take the site offline, with the exception of .htaccess (Sentinel) and any photo's uploaded to gallery. I've already warned users about possible loss from gallery should the worse happen- I've also advised them to make sure they have any pertinent information they need from PM's, etc.
The files were backed up by Mark (can't remember his name on here) via SFTP, and he'll burn copies to DVD and post me one )- 30,145 files
Total of 2.14gb - Only took the whole morning to download.... (I suspect the DB will be as big...)
For reference, plan as follows:
| Quote: | Saturday evening:
disable site using Sentinel switch
Phpmyadmin- back up the database
Sunday morning:
download local copies of:
blocks (with images as required)- amazon, cafepress, advertisers, paypal donations, expanding/ collapsing centre forums block, main page; news pagination (main page);
theme files, topic icons/ forum headers, logo ;
Modified core sentinel files/ main file with "tweaks" for gallery;
.htaccess file; legal notices, etc., dis errors, news pagination, topic icons, forum header images, swear filter configurations (forums), diserror, iptracking (maybe installed by default), resend email
Visit this page:
[ Only registered users can see links on this board! Get registered or login! ]
Make note of uploading the files, AND the upgrade for BBtoNuke
Follow install/ upgrade instructions.
Quick test.
Find the script for "resetting" all users theme preference
Decide on theme/ tweak as required with colours/ logos, etc.
Double check user ranks/ titles- reset if required (most will be covered/ replaced with Groups options in RN)
check groups- set up moderators groups etc. accordingly
install additional scripts not included/ configured in core RN:
live chat; nukeC as well as blocks (centre forum, centre latest classifieds, etc.)
Transfer legal documents from old version (docs) to new (RN built in).
Make sure diserrors, or equivalent is installed
check Gallery integration- may require "tweaks" to cope with new abstract layer of Db/ Sentinel- check original thread created and then read note on upgrade here:
[ Only registered users can see links on this board! Get registered or login! ] then re-apply any new tweaks as required (if required, create a post in the support section on RN).
Configure new forum additions/ tweaks.
Configure new banner locations
Check previous added components are re-uploaded(if required) and work.
Check all ok BEFORE working on theme tweaks/ integration.
Random header- code integration in theme- read:
[ Only registered users can see links on this board! Get registered or login! ]
random header image (as per club members site based on joomla)
[ 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! ]
[ Only registered users can see links on this board! Get registered or login! ] |
I'll follow up on this thread any particular issues/ things to watch for. As noted above- if Gallery & Sentinel don't play happy, I'll start a new thread (my old one is locked), advising what tweaks are required to get gallery 1 to work with RN (It may already work "out of the box" but I'm covering all eventualities, I hope!)
Feedback welcome- thanks for input- and thanks (again) for all the effort you guys put into RN/ Sentinel. |
| |
|
|
|
|
Guardian2003
Site Admin
Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam
|
| Posted:
Fri Feb 26, 2010 4:26 am |
|
Your missing BigDump, you WILL need this if something goes Pete Tongue and you have to restore the DB. The size of the bb_searchword table alone will be enough to cause a timeout in phpMyAdmin |
| |
|
|
|
AndyB
|
| Posted:
Fri Feb 26, 2010 4:41 am |
|
| Guardian2003 wrote: | | Your missing BigDump, you WILL need this if something goes Pete Tongue and you have to restore the DB. The size of the bb_searchword table alone will be enough to cause a timeout in phpMyAdmin |
I'll use cpanel to just dump the DB- I used it on another site yesterday to do a snap shot of a home directory on another site. I expected that to time out, but it didn't (took about an hour or so- tar file was ~245mb....  )
If that doesn't work, any suggestions where I can get that from, please?
I may also create a copy of the Db in phpmyadmin (if it will do it without timing out)- that way I'm double secured... |
| |
|
|
|
|
Guardian2003
|
| Posted:
Fri Feb 26, 2010 6:06 am |
|
phpMyAdmin is usually fine for creating/downloading the database back-up but can be a problem when trying to import big databases. In fact, I can pretty much guarantee that yours at ~245mb will definitely fall over if it's in one file.
Here's the link to BigDump - [ Only registered users can see links on this board! Get registered or login! ]
It's really easy to use, just remember when you 'export' your back up, DO NOT use the 'extended inserts' option in phpMyAdmin.
I normally set BigDump to to use about 100 lines at a time, with a gap of a few seconds between each run. You can get away with larger files but I'm never really in enough of a rush to get the job done. I'd sooner wait 10 minutes for BigDump to do it's job than spend hours and hours trying to split up a SQL file into small chunks to be able to execute them - thats of course if you can even find an editor that will open a file that big!!
Try it out though |
| |
|
|
|
|
AndyB
|
| Posted:
Fri Feb 26, 2010 7:01 am |
|
lol. 245mb is regarding a home page back up of another site, minus Db....
I'm expecting fans Db to be MUCH bigger than that- thanks for the heads up- I'll install that sf and get it to run Saturday night while I'm asleep (lets hope the PC doesn't install an update and reboot this time like the other night) lol |
| |
|
|
|
|
Raven
|
| Posted:
Fri Feb 26, 2010 9:34 am |
|
If you have root access to your server, you can also directly access your /var/lib/mysql/ folder (or wherever yours is stored) and just copy the *.frm, *MYD, and *.MYI files from your old db to your new db. Another way, if you have shell access to line mode mysql, is to export your db using mysql or phpMyAdmin and then import the file via mysql. Using this method you can used extended inserts and speed up the process . |
| |
|
|
|
|
AndyB
|
| Posted:
Fri Feb 26, 2010 10:04 am |
|
| Raven wrote: | | If you have root access to your server, you can also directly access your /var/lib/mysql/ folder (or wherever yours is stored) and just copy the *.frm, *MYD, and *.MYI files from your old db to your new db. Another way, if you have shell access to line mode mysql, is to export your db using mysql or phpMyAdmin and then import the file via mysql. Using this method you can used extended inserts and speed up the process . |
most of that went straight over my head, lol.
I don't play with shell access.... I could possibly use the other method, though. |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 5:21 am |
|
Progress so far..
2 cups of tea....
Last night:
Logged into admin, sentinel control panel, deactivated site.
Logged into Cpanel, "files" > "Backup". This gave me several options:
I did several: "download or generate a full website backup"- this gave me everything. (website settings, mail server settings, mysql databases)
I also did the option for "home directory backup" and a separate mysql backup.
Just to double make sure, I also went into phpmyadmin, and went to my database, and backed up a non zipped backup, AND a gzipped back up.
What did I end up with? Everything, probably more than once. My biggest file is 2,133,920kb as a zipped file (the whole website) mysql databases on their own were a 60mb zipped file for the database, and a 241mb unzipped sql file. Basically, if it all goes "tits up", I'm covered.
I then logged in using FTP, and grabbed files I need after the upgrade (saves me waiting for the compressed file to be unzipped)
all themes
modules- diserror, iptracking and docs
blocks- cafepress, amazon
downloaded "bigdump" (in case it's needed later.)
Downloaded the latest stable release of RN (2.4.0) (although I see notes for 2.4.1?)
Now about to follow this:
[ Only registered users can see links on this board! Get registered or login! ]
and finish my third cuppa |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 6:46 am |
|
ok;
note: when doing the bbtonuke upgrade, files need to be in the ROOT directory (not in a separate directory below root)
I then altered the DB value, as per instructions, then uploaded the INSTALLATION folder, and ran the script.
Here are the errors 
| Quote: |
ALTER TABLE nuke_bbsearch_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL FAILED. MySQL reported: Duplicate column name 'search_time'
ALTER TABLE nuke_subscriptions CHANGE `userid` `userid` INT(10) NOT NULL DEFAULT '0' FAILED. MySQL reported: Table 'afnet_nuke1.nuke_subscriptions' doesn't exist
INSERT INTO nuke_bbconfig (config_name, config_value) VALUES ('search_flood_interval', '15') FAILED. MySQL reported: Duplicate entry 'search_flood_interval' for key 1
INSERT INTO nuke_bbconfig (config_name, config_value) VALUES ('rand_seed', '0') FAILED. MySQL reported: Duplicate entry 'rand_seed' for key 1
ALTER TABLE nuke_banner ADD INDEX `bid` (bid); FAILED. MySQL reported: Duplicate key name 'bid'
INSERT INTO `nuke_modules` VALUES(NULL, 'Advertising', 'Advertising', 0, 0, '', 1, 0, '') FAILED. MySQL reported: Column count doesn't match value count at row 1In rn21001
INSERT INTO `nuke_modules` VALUES(NULL, 'Legal', 'Legal', 1, 0, '', 0, 0, '') FAILED. MySQL reported: Column count doesn't match value count at row 1
ALTER TABLE `nuke_counter` ADD PRIMARY KEY (`type`(20),`var`(20)) FAILED. MySQL reported: Duplicate entry 'browser-Firefox' for key 1
INSERT INTO `nuke_modules` VALUES(NULL, 'ErrorDocuments', 'ErrorDocuments', 0, 0, '', 0, 0, '') FAILED. MySQL reported: Column count doesn't match value count at row 1
SHOW COLUMNS FROM nuke_nsngr_users LIKE 'uname' FAILED. MySQL reported: Table 'afnet_nuke1.nuke_nsngr_users' doesn't exist
INSERT INTO `nuke_modules` VALUES (NULL, 'nukeNAV', 'NukeNav', 1, 0, '', 0, 0, ''); FAILED. MySQL reported: Column count doesn't match value count at row 1
ALTER TABLE nuke_seo_subscriptions CHANGE `type` `type` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
ALTER TABLE nuke_seo_subscriptions CHANGE `image` `image` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
ALTER TABLE nuke_seo_subscriptions CHANGE `icon` `icon` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
ALTER TABLE nuke_seo_subscriptions CHANGE `url` `url` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist |
any suggestions?
I'm thinking that error documents and firefox gave errors because of previous tweaks I did (forgot about the firefox one) |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 10:33 am |
|
quick update: uploaded all files via ftp; modified/ checked my config file first, removed INSTALL folder, then went to the site.
I had the strange characters, top left ( ) - quick check (had this on the dev site) gave me this:
[ Only registered users can see links on this board! Get registered or login! ]
Problem fixed.
Next issue- going into admin gives me a white screen: this is due to not changing my theme (my bad)- the theme I had was from Disipals site, I think, based on charcoal - missign bits for the admin. I changed my theme, all ok... so far.... |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 11:36 am |
|
ok- using file utility (file_migration24.php) fails- file needs tweaking;
line 27- Code:Parse error: syntax error, unexpected ';' in /home/afnet/public_html/file_migration24.php on line 27
|
There's a missing ')" before the ;
line 41- missing '); at the end of the line (gave me an error message for line 42 ) |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 12:55 pm |
|
bugger! Can't get onto [ Only registered users can see links on this board! Get registered or login! ]
Anyone else having the issue?
I'm finding I'm "limited" with the themes... I know what I want (colours not _that_ important, layout is- so I don't really want to pay for it... lol |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 1:31 pm |
|
BIG PROBLEM- can't get into admin; or rather directly into admin; if I click, say "waiting links" it shows the admin screen ok. Clicking "administration" just gives me a blank screen.... |
Last edited by AndyB on Sun Feb 28, 2010 4:09 pm; edited 1 time in total |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 1:40 pm |
|
| AndyB wrote: | | BIG PROBLEM- can't get into admin; or rather directly directly into admin; if I click, say "waiting links" it shows the admin screen ok. Clicking "administration" just gives me a blank screen.... |
I'm an ar$e!
helps when I upload the new admin.php file... |
| |
|
|
|
|
Raven
|
| Posted:
Sun Feb 28, 2010 3:05 pm |
|
| AndyB wrote: | ok- using file utility (file_migration24.php) fails- file needs tweaking;
line 27- Code:Parse error: syntax error, unexpected ';' in /home/afnet/public_html/file_migration24.php on line 27
|
There's a missing ')" before the ;
line 41- missing '); at the end of the line (gave me an error message for line 42 ) |
Andy,
I have tested and retested this application and there are no errors in it. Try reloading and rerunning it.
Raven |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 3:26 pm |
|
I got it to work- it gave me errors as mentioned- once I'd "tweaked" them it was ok?
The version I downloaded today from this website as part of the package.
I'm having fun with "themes" right now. They're beginning to p me off... lol
It could be my mis-match- any ideas with regards my errors earlier on from the db upgrade? Dis errors doesn't work- and neither does error docs (I've hard coded a "hack" at the top of my .htaccess file for now that redirects to the main page of the site) |
| |
|
|
|
|
Guardian2003
|
| Posted:
Sun Feb 28, 2010 3:41 pm |
|
| Quote: | | MySQL reported: Duplicate column name |
This means the column in the table already exists so can be safely ignored.
| Quote: | | Table 'afnet_nuke1.nuke_...... |
The table didn't exist. Are you by any chance using a different value in your config.php file for $prefix and $user_prefix ?
I'm curious what you were doing. Were you doing a clean install or were you running the db_upgrade script on your existing database?? |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 4:07 pm |
|
db upgrade script
in the config.php file I copied old values across to new file... |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 4:43 pm |
|
oh;
attachment mod: gives an error when trying to add an attachment:
| Quote: | | File Type mismatch: expected png but gif given. |
|
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 4:43 pm |
|
I'm thinking it may be a file/ folder permission issue? |
| |
|
|
|
|
AndyB
|
| Posted:
Sun Feb 28, 2010 4:46 pm |
|
|
|
|
|
AndyB
|
| Posted:
Mon Mar 01, 2010 5:02 am |
|
| Guardian2003 wrote: | | Quote: | | MySQL reported: Duplicate column name |
This means the column in the table already exists so can be safely ignored.
| Quote: | | Table 'afnet_nuke1.nuke_...... |
The table didn't exist. Are you by any chance using a different value in your config.php file for $prefix and $user_prefix ?
I'm curious what you were doing. Were you doing a clean install or were you running the db_upgrade script on your existing database?? |
OK;
going through the Db upgrade path bits (better now I've had some sleep)- if I ignore the duplicates as mentioned above, I'm left with:
Code:ALTER TABLE nuke_subscriptions CHANGE `userid` `userid` INT(10) NOT NULL DEFAULT '0' FAILED. MySQL reported: Table 'afnet_nuke1.nuke_subscriptions' doesn't exist
INSERT INTO `nuke_modules` VALUES(NULL, 'Advertising', 'Advertising', 0, 0, '', 1, 0, '') FAILED. MySQL reported: Column count doesn't match value count at row 1In rn21001
INSERT INTO `nuke_modules` VALUES(NULL, 'Legal', 'Legal', 1, 0, '', 0, 0, '') FAILED. MySQL reported: Column count doesn't match value count at row 1
INSERT INTO `nuke_modules` VALUES(NULL, 'ErrorDocuments', 'ErrorDocuments', 0, 0, '', 0, 0, '') FAILED. MySQL reported: Column count doesn't match value count at row 1
SHOW COLUMNS FROM nuke_nsngr_users LIKE 'uname' FAILED. MySQL reported: Table 'afnet_nuke1.nuke_nsngr_users' doesn't exist
INSERT INTO `nuke_modules` VALUES (NULL, 'nukeNAV', 'NukeNav', 1, 0, '', 0, 0, ''); FAILED. MySQL reported: Column count doesn't match value count at row 1
ALTER TABLE nuke_seo_subscriptions CHANGE `type` `type` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
ALTER TABLE nuke_seo_subscriptions CHANGE `image` `image` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
ALTER TABLE nuke_seo_subscriptions CHANGE `icon` `icon` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
ALTER TABLE nuke_seo_subscriptions CHANGE `url` `url` varchar(255) NOT NULL FAILED. MySQL reported: Table 'afnet_nuke1.nuke_seo_subscriptions' doesn't exist
|
I'm guessing I need to try to manually enter the table and data into the database for:
afnet_nuke1.nuke_seo_subscriptions
afnet_nuke1.nuke_nsngr_users
ErrorDocuments - I'm guessing is due to diserrors (so drop/ clear the table?
Any suggestions? I suppose, in a way, it's a good job the theme doesn't work properly, so I can try to fix these issues first. Anybody any ideas re. clan themes, etc? (ie. is it just me having issues getting to their website?)
Thanks for help/ feedback/ guidance provided so far. |
| |
|
|
|
|
Palbin
Site Admin
Joined: Mar 30, 2006
Posts: 2583
Location: Pittsburgh, Pennsylvania
|
| Posted:
Mon Mar 01, 2010 5:41 am |
|
I will try and catch up on this topic tonight, but your problem doesn't look to bad.
| Quote: |
SHOW COLUMNS FROM nuke_nsngr_users LIKE 'uname' FAILED. MySQL reported: Table 'afnet_nuke1.nuke_nsngr_users' doesn't exist
|
Don't worry about this one. I will give more info tonight if you haven't figured it out. |
_________________
"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.
Last edited by Palbin on Mon Mar 01, 2010 7:14 am; edited 1 time in total |
|
|
|
|
|
|
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
