Not an issue (yet- I hope!)

AndyB · Posted: Thu Feb 25, 2010 7:19 am

Wish me luck Rolling Eyes

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 Laughing

Raven · 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 Smile

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 Wink

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 Very Happy

)

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

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 Very Happy

)- 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 to the forums!

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 to the forums!

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 to the forums!

random header image (as per club members site based on joomla)

Only registered users can see links on this board!
Get registered or login to the forums!

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 · 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.... Shocked

)

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... Very Happy

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 to the forums!

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 Smile

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 Very Happy

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

.

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 Smile

.

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

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 to the forums!

and finish my third cuppa Wink

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 Twisted Evil

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 to the forums!

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 to the forums!

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

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! Laughing

helps when I upload the new admin.php file... Rolling Eyes

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

sorry, duplicate post.

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