running upgrade19-20.php

Posted: Wed Jul 12, 2006 2:04 pm

I have just tried to upgrade to version 2.0.20 from 2.0.19. I uploaded the files but for some strange reason upgrade19-20.php will not run from the browser. I put it in the correct area,, where mainfile.php is located and I was running it logged in as administrator of the site. I just get 'The page cannot be found'

Am I doing something stupid?

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

Not sure. Check the installation instructions - you may need to put upgrade19-20.php in a different directory, rather than in the Nuke root directory.

Posted: Thu Jul 13, 2006 2:30 am

No, it should be in the same directory as mainfile.php as the first line is
include("mainfile.php"); This has me baffled. I thought it might be a permissions problem. I chmod the file from 644 to 777, but same result.

I downloaded the manual upgrade. To upgrade the DB it says to do the following. I assume I can do this with phpMyAdmin. Not sure though what it means about "IF YOU ARE USING A DIFFERENT DB-PREFIX, THEN REPLACE nuke_ prefix with your own prefix" Also do I add each line below seperately into phpMyAdmin. Apologies for all the questions, its just that I dont want to mess this up.

# ------- [ DB Upgrade ] --------
#
# COMMENT: IF YOU ARE USING A DIFFERENT DB-PREFIX, THEN REPLACE nuke_ prefix with your own prefix
#

ALTER TABLE nuke_bbsearch_results ADD COLUMN search_time int(11) DEFAULT '0' NOT NULL;
INSERT INTO nuke_bbconfig (config_name, config_value) VALUES ('search_flood_interval', '15');
INSERT INTO nuke_bbconfig (config_name, config_value) VALUES ('rand_seed', '0');
UPDATE nuke_bbconfig SET config_value='.0.20' WHERE config_name='version';

Posted: Thu Jul 13, 2006 4:26 am

If all your existing tables start with 'nuke_' then you can simply add the content of the manual update file to the SQL query window in phpmyadmin.
If you are using a different prefic you will need to change 'nuke_' to whatever your prefix is.
If you are not sure you can look at your exisiting tables or look what is set in your config.php file.

Posted: Thu Jul 13, 2006 8:49 am

Guardian,

I followed your instructions and the DB seems to have upgraded successfully. The result was:

Your SQL query has been executed successfully

ALTER TABLE nuke_bbsearch_results ADD COLUMN search_time int( 11 ) DEFAULT '0' NOT NULL ;# Affected rows: 2
INSERT INTO nuke_bbconfig( config_name, config_value )
VALUES (
'search_flood_interval', '15'
);# Affected rows: 1
INSERT INTO nuke_bbconfig( config_name, config_value )
VALUES (
'rand_seed', '0'
);# Affected rows: 1

Thank you very much for taking the time to help.

Posted: Thu Jul 13, 2006 8:59 am

Not a problem, we are always glad to help where we can.
Thank you for feedback though, it is most appreciated. It helps us enormously when we have confirmation that a solution worked.