How to upgrade from v2.02.02 to v2.30?

Worker Joined: Aug 02, 2004 Posts: 165

What would be the easiest way to do the upgrade?

A) Should I run some upgrade scripts so 2.0.2 would be upgraded?

B) Does it work if I just backup current SQL DB and then unzip all v2.30 files to the server (+ point 2.30 to use the DB)?

C) Something else?

I hope that you could tell my how to proceed. Step by step guide would be best Smile

.

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Did you see the Only registered users can see links on this board! Get registered or login! section in the How To Install guide?

Posted: Fri Oct 24, 2008 1:02 am

kguske wrote:

Did you see the Only registered users can see links on this board! Get registered or login! section in the How To Install guide?

Thanks, I have to check this out!

Direct link to upgrade section:
http://www.ravennuke.com/HowToInstall/upgrade.html

registered · Posted: Fri Oct 24, 2008 6:06 am

There is a ton of text there, but most of it is there to just get you to think about the impacts so you can plan accordingly. If you are pretty much a "stock" 2.0.2, its a breeze to upgrade. We took extra time with the upgrade scripts to make sure they go back that far and will take care of all the DB changes needed.

Just always remember these key things:

1. Always take a complete back up of files and DB FIRST and set those aside

2. If you can run through the upgrade process on your local PC using a copy of your web site on XAMPP, you will/could save yourself any potential issues!

Good luck. If you get stuck, search the forums and ask for help if you need to.

Posted: Fri Oct 24, 2008 8:27 am

montego wrote:

Good luck. If you get stuck, search the forums and ask for help if you need to.

I succeed to install v2.30 to my development server. However, I got below error messages.

First two could be ignored (by the installation doc) but what about the third one?

Code:

1) ALTER TABLE nuke_users ADD `user_login_tries` smallint(5) unsigned NOT NULL default '0' AFTER `last_ip`; FAILED.    MySQL reported: Unknown column 'last_ip' in 'nuke_users'





2) ALTER TABLE nuke_users ADD `user_last_login_try` int(11) NOT NULL default '0' AFTER `user_login_tries`; FAILED.    MySQL reported: Unknown column 'user_login_tries' in 'nuke_users'

Code:




3)ALTER TABLE nuke_banner ADD INDEX `bid` (bid); FAILED.    MySQL reported: Duplicate key name 'bid'


CREATE TABLE nuke_banner_clients (`cid` int(11) NOT NULL auto_increment, `name` varchar(60) NOT NULL default '', `contact` varchar(60) NOT NULL default '', `email` varchar(60) NOT NULL default '', `login` varchar(10) NOT NULL default '', `passwd` varchar(10) NOT NULL default '', `extrainfo` text NOT NULL default '', PRIMARY KEY (`cid`), KEY `cid` (`cid`)) TYPE=MyISAM AUTO_INCREMENT=1 Succeeded.

I also met a compatibility problems with a block-User_Info.php. I have to quote out every command before webpage started a work. I'll post a separate message of this one.

registered · Posted: Fri Oct 24, 2008 3:04 pm

1 and 2 may create problems with your forums

You should add the following fields manually using phpMyAdmin

Here's how they are defined

Code:




`last_ip` varchar(15) NOT NULL default '0',


`user_login_tries` smallint(5) unsigned NOT NULL default '0',


`user_last_login_try` int(11) NOT NULL default '0',

The third error is fine - it should not be a problem.

Posted: Sat Oct 25, 2008 1:02 am

evaders99 wrote:

1 and 2 may create problems with your forums

You should add the following fields manually using phpMyAdmin

Here's how they are defined

Code:




`last_ip` varchar(15) NOT NULL default '0',


`user_login_tries` smallint(5) unsigned NOT NULL default '0',


`user_last_login_try` int(11) NOT NULL default '0',

How should I do this? I'm not so familiar with SQL things... I'm using "Navicat 8 Lite" (win) for MySQL maintenance.

Any tips how to do this?

http://mysql.navicat.com/download.html

Posted: Sat Oct 25, 2008 2:10 pm

crypto, I have to believe there is help or a manual which describes how to add a field to a table... We don't have time to download different tools.

Posted: Sat Oct 25, 2008 7:05 pm

I have un upgrade problem too. I know that I'm running RN, but for the life of me, I can't remember what version. When I run the upgrade, I get the message

"Error in Configuration Value

The valid values of the configuration field for updating by this program are rn2.02.00, rn76v2.02, rnv2.02.02, rn2.10.00, rn2.10.01, rn2.20.00, and rn2.20.01. Your system does not have one of those values. Please check this out - but this program cannot be used to upgrade other versions. The configuration field is stored in the config table in your MYSQL database in a field called Version_Num. Your system is reporting a value of 7.6."

I tried to grab the 2.02 patch, but the downloads area says it isn't on the server. Do I need to do a full install of old versions to then upgrade to 2.30 now?

Posted: Sat Oct 25, 2008 10:21 pm

Use phpMyAdmin and find the version number in your config table

Posted: Sun Oct 26, 2008 7:58 am

I looked, and it does say 7.6, but I know that I installed RN before. I guess that I need to install as if RN isn't installed then?

Posted: Sun Oct 26, 2008 3:27 pm

Well, that is definitely not one of our supported version numbers. I suspect that you may actually not have been on RN as we update the version number with each upgrade. You might want to try installing a fresh copy of the latest RN and then use something like mySQLDiff to see what the table differences are. Or, you can follow the HowToInstall manual's steps on Migrating from Other PHP-Nuke systems. But, do this only on a local copy of your site using something like XAMPP.

Posted: Tue Oct 28, 2008 1:55 pm

evaders99 wrote:

Here's how they are defined

Code:




`last_ip` varchar(15) NOT NULL default '0',


`user_login_tries` smallint(5) unsigned NOT NULL default '0',


`user_last_login_try` int(11) NOT NULL default '0',

Does following look right?

[Screenshot removed]

What is the purpose of the

`user_login_tries` smallint(5) unsigned NOT NULL default '0',
`user_last_login_try` int(11) NOT NULL default '0',

Those both are "0" at the SQL-database (IP-address has been updated to the DB). I tried also login with wrong passwd, but those values are still "0".

// Edit: Screenshot removed

Posted: Tue Oct 28, 2008 2:34 pm

I may well be corrected but I think those specific fields are for tracking automated bots trying to registered through the forum (as against registering through *nuke).
In RN at least, we have pretty much blocked anything that might try to register through the forum registration process by redirecting them to the nuke process (remember that the forum is essential an add-on to nuke).

Posted: Tue Oct 28, 2008 5:45 pm

Looks fine to me. They are both use in phpBB2's login system. phpNuke itself does not use them.

Posted: Thu Oct 30, 2008 1:18 am

evaders99 wrote:

Looks fine to me. They are both use in phpBB2's login system. phpNuke itself does not use them.

Thanks, the I'll go with those settings. Cool