ADMIN Failure in 2.5 Upgrade

Posted: Thu Nov 01, 2012 7:46 am

Greetings Good People,
I have completed upgrading all of my RaveNuke sites and for the most part the upgrades have been flawless. In one site however I have had an admin upgrade failure. The site still functions. I can manage advertising and everything in the lower part of the admin section. The upper portion however is unavailable.
If I attempt to go to Themes I get access denied. If I log out and back in the condition remains the same.

I received no errors during the upgrade:

Code:

Updating based on config value of rn2.40.01 


ALTER TABLE `nuke_bbforums` ADD `attached_forum_id` MEDIUMINT( DEFAULT "-1" NOT NULL Succeeded. 





ALTER TABLE `nuke_bbtopics` ADD INDEX (topic_last_post_id) Succeeded. 





ALTER TABLE `nuke_mail_config` ADD `smtp_encrypt` tinyint(4) NOT NULL DEFAULT '0' AFTER `sendmail_path`, ADD `smtp_encrypt_method` tinyint(4) NOT NULL DEFAULT '0' AFTER `smtp_encrypt`, ADD `reply_to` varchar(255) NOT NULL DEFAULT '' AFTER `smtp_encrypt_method`, ADD `debug_level` tinyint(4) NOT NULL DEFAULT '0' AFTER `reply_to`, DROP `qmail_path`; Succeeded. 





CREATE TABLE IF NOT EXISTS `nuke_themes` (`theme` varchar(25) NOT NULL default "",`themename` varchar(25) NOT NULL default "",`active` tinyint(1) NOT NULL default "0",`default` tinyint(1) NOT NULL default "0",`guest` tinyint(1) NOT NULL default "0",`moveableblocks` tinyint(1) NOT NULL default "0",`collapsibleblocks` tinyint(1) NOT NULL default "0",`compatible` tinyint(1) NOT NULL default "0",PRIMARY KEY (`theme`)) ENGINE=MyISAM; Succeeded. 





INSERT INTO `nuke_themes` (`theme`, `themename`, `active`, `default`, `guest`, `moveableblocks`, `collapsibleblocks`, `compatible`) VALUES ("3D-Fantasy", "3D-Fantasy", "1", "0", "0", "0", "0", "0"),("Blue_Blog", "Blue_Blog", "1", "0", "0", "0", "0", "0"),("DeepBlue", "DeepBlue", "1", "0", "0", "0", "0", "0"),("fisubice", "fisubice", "1", "0", "0", "0", "0", "0"),("jlajax", "jlajax", "1", "0", "0", "0", "0", "0"),("RavenIce", "RavenIce", "1", "0", "0", "0", "0", "0"),("RickTido", "RickTido", "1", "0", "0", "0", "0", "0"),("Sand_Journey", "Sand_Journey", "1", "0", "0", "0", "0", "0"),("SimplyBlue", "SimplyBlue", "1", "0", "0", "0", "0", "0") Succeeded. 





UPDATE `nuke_themes` SET `default`="1", `guest`="1" WHERE `theme`="DeepBlue" Succeeded. 





CREATE TABLE IF NOT EXISTS `nuke_tags` (`tag` varchar(25) NOT NULL,`cid` int(10) NOT NULL default "0",`whr` int(1) NOT NULL default "0") ENGINE=MyISAM; Succeeded. 





CREATE TABLE IF NOT EXISTS `nuke_tags_temp` (`tag` varchar(25) NOT NULL,`cid` int(10) NOT NULL default "0",`whr` int(1) NOT NULL default "0") ENGINE=MyISAM; Succeeded. 





CREATE TABLE IF NOT EXISTS `nuke_ton` (`newsrows` int(1) NOT NULL default "0",`bookmark` int(1) NOT NULL default "0",`rblocks` int(1) NOT NULL default "0",`linklocation` varchar(6) NOT NULL default "0",`articlelink` int(1) NOT NULL default "0",`artview` varchar(3) NOT NULL default "0",`TON_useTitleLink` int(1) NOT NULL default "0",`TON_usePDF` int(1) NOT NULL default "0",`TON_useRating` int(1) NOT NULL default "0",`TON_useSendToFriend` int(1) NOT NULL default "0",`showtags` int(1) NOT NULL default "0",`TON_useCharLimit` int(1) NOT NULL default "0",`TON_CharLimit` int(3) NOT NULL default "0",`topadact` int(1) NOT NULL default "0",`topad` int(3) NOT NULL default "0",`bottomadact` int(1) NOT NULL default "0",`bottomad` int(3) NOT NULL default "0",`usedisqus` int(1) NOT NULL default "0",`shortname` varchar(25) NOT NULL default "0",`googlapi` varchar(44) NULL,`usegooglsb` int(1) NOT NULL default "0",`usegooglart` int(1) NOT NULL default "0") ENGINE=MyISAM; Succeeded. 





INSERT INTO `nuke_ton` ( `newsrows`, `bookmark`, `rblocks`, `linklocation`, `articlelink`, `artview`, `TON_useTitleLink`, `TON_usePDF`, `TON_useRating`, `TON_useSendToFriend`, `showtags`, `TON_useCharLimit`, `TON_CharLimit`, `topadact`, `topad`, `bottomadact`, `bottomad`, `usedisqus`, `shortname`, `googlapi`, `usegooglsb`, `usegooglart`) VALUES ("1", "1", "1", "top", "1", "new", "1", "1", "1", "1", "0", "0", "240", "0", "0", "0", "0", "0", "Short Name", "", "0", "0"); Succeeded. 





SHOW TABLES LIKE 'nuke_nsngd_config' Succeeded. 





CREATE TABLE `nuke_nsngd_accesses` (`username` varchar(60) NOT NULL default "",`downloads` int(11) NOT NULL default "0",`uploads` int(11) NOT NULL default "0",PRIMARY KEY (`username`) )ENGINE=MyISAM DEFAULT CHARSET=utf8; Succeeded. 





CREATE TABLE `nuke_nsngd_categories` (`cid` int(11) NOT NULL auto_increment,`title` varchar(50) NOT NULL default "",`cdescription` text NOT NULL,`parentid` int(11) NOT NULL default "0",`whoadd` tinyint(2) NOT NULL default "0",`uploaddir` varchar(255) NOT NULL default "",`canupload` tinyint(2) NOT NULL default "0",`active` tinyint(2) NOT NULL default "1",PRIMARY KEY (`cid`),KEY `cid` (`cid`),KEY `title` (`title`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; Succeeded. 





CREATE TABLE `nuke_nsngd_config` (`config_name` varchar(255) NOT NULL default "",`config_value` text NOT NULL,PRIMARY KEY (`config_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Succeeded. 





INSERT INTO `nuke_nsngd_config` (`config_name`, `config_value`) VALUES ("admperpage", "50"),("blockunregmodify", "1"),("dateformat", "D M j G:i:s T Y"),("mostpopular", "25"),("mostpopulartrig", "0"),("perpage", "10"),("popular", "500"),("results", "10"),("show_links_num", "0"),("usegfxcheck", "0"),("show_download", "0"),("version_number", "1.1.3"),("version_db", "100"); Succeeded. 





CREATE TABLE `nuke_nsngd_downloads` ( `lid` int(11) NOT NULL auto_increment,`cid` int(11) NOT NULL default "0",`sid` int(11) NOT NULL default "0",`title` varchar(100) NOT NULL default "",`url` varchar(255) NOT NULL default "",`description` text NOT NULL,`date` datetime NOT NULL default "0000-00-00 00:00:00",`name` varchar(100) NOT NULL default "",`email` varchar(100) NOT NULL default "",`hits` int(11) NOT NULL default "0",`submitter` varchar(60) NOT NULL default "",`sub_ip` varchar(16) NOT NULL default "0.0.0.0",`filesize` bigint(20) NOT NULL default "0",`version` varchar(20) NOT NULL default "",`homepage` varchar(255) NOT NULL default "",`active` tinyint(2) NOT NULL default "1",PRIMARY KEY (`lid`),KEY `lid` (`lid`),KEY `cid` (`cid`),KEY `sid` (`sid`),KEY `title` (`title`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; Succeeded. 





CREATE TABLE `nuke_nsngd_extensions` (`eid` int(11) NOT NULL auto_increment,`ext` varchar(6) NOT NULL default "",`file` tinyint(1) NOT NULL default "0",`image` tinyint(1) NOT NULL default "0",PRIMARY KEY (`eid`), KEY `ext` (`eid`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21; Succeeded. 





INSERT INTO `nuke_nsngd_extensions` (`eid`, `ext`, `file`, `image`) VALUES (1, ".ace", 1, 0),(2, ".arj", 1, 0),(3, ".bz", 1, 0),(4, ".bz2", 1, 0),(5, ".cab", 1, 0),(6, ".exe", 1, 0),(7, ".gif", 0, 1),(8, ".gz", 1, 0),(9, ".iso", 1, 0),(10, ".jpeg", 0, 1),(11, ".jpg", 0, 1),(12, ".lha", 1, 0),(13, ".lzh", 1, 0),(14, ".png", 0, 1),(15, ".rar", 1, 0),(16, ".tar", 1, 0),(17, ".tgz", 1, 0),(18, ".uue", 1, 0),(19, ".zip", 1, 0),(20, ".zoo", 1, 0); Succeeded. 





CREATE TABLE `nuke_nsngd_mods` (`rid` int(11) NOT NULL auto_increment,`lid` int(11) NOT NULL default "0",`cid` int(11) NOT NULL default "0",`sid` int(11) NOT NULL default "0",`title` varchar(100) NOT NULL default "",`url` varchar(255) NOT NULL default "",`description` text NOT NULL,`modifier` varchar(60) NOT NULL default "",`sub_ip` varchar(16) NOT NULL default "0.0.0.0",`brokendownload` int(3) NOT NULL default "0",`name` varchar(100) NOT NULL default "",`email` varchar(100) NOT NULL default "",`filesize` bigint(20) NOT NULL default "0",`version` varchar(20) NOT NULL default "",`homepage` varchar(255) NOT NULL default "",PRIMARY KEY (`rid`),UNIQUE KEY `rid` (`rid`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; Succeeded. 





CREATE TABLE `nuke_nsngd_new` (`lid` int(11) NOT NULL auto_increment,`cid` int(11) NOT NULL default "0",`sid` int(11) NOT NULL default "0",`title` varchar(100) NOT NULL default "",`url` varchar(255) NOT NULL default "",`description` text NOT NULL,`date` datetime NOT NULL default "0000-00-00 00:00:00",`name` varchar(100) NOT NULL default "",`email` varchar(100) NOT NULL default "",`submitter` varchar(60) NOT NULL default "",`sub_ip` varchar(16) NOT NULL default "0.0.0.0",`filesize` bigint(20) NOT NULL default "0",`version` varchar(20) NOT NULL default "",`homepage` varchar(255) NOT NULL default "",PRIMARY KEY (`lid`),KEY `lid` (`lid`),KEY `cid` (`cid`),KEY `sid` (`sid`),KEY `title` (`title`) )ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; Succeeded. 





UPDATE `nuke_hnl_cfg` SET `cfg_val` = "nsngd" WHERE `cfg_nm` = "dl_module" Succeeded. 





ALTER TABLE `nuke_users_temp` ADD `femail` varchar(255) NOT NULL DEFAULT "" AFTER `user_email`, ADD `user_website` varchar(255) NOT NULL DEFAULT "" AFTER `femail`, ADD `user_icq` varchar(15) DEFAULT NULL AFTER `user_regdate`, ADD `user_occ` varchar(100) DEFAULT NULL AFTER `user_icq`, ADD `user_from` varchar(100) DEFAULT NULL AFTER `user_occ`, ADD `user_interests` varchar(150) NOT NULL default "" AFTER `user_from`, ADD `user_sig` varchar(255) DEFAULT NULL AFTER `user_interests`, ADD `user_viewemail` tinyint(2) default NULL AFTER `user_sig`, ADD `user_aim` varchar(1 DEFAULT NULL AFTER `user_viewemail`, ADD `user_yim` varchar(25) DEFAULT NULL AFTER `user_aim`, ADD `user_msnm` varchar(25) DEFAULT NULL AFTER `user_yim`, ADD `bio` tinytext NULL DEFAULT NULL AFTER `user_msnm`, ADD `newsletter` int(1) NOT NULL DEFAULT "0" AFTER `bio`, ADD `user_allow_viewonline` tinyint(1) NOT NULL DEFAULT "1" AFTER `newsletter`, ADD `user_sig_bbcode_uid` varchar(10) DEFAULT NULL AFTER `user_allow_viewonline`, ADD `admin_approve` BOOL NOT NULL DEFAULT "0" Succeeded. 





INSERT INTO `nuke_hnl_cfg` VALUES ("version_db", "100") Succeeded. 





UPDATE `nuke_hnl_cfg` SET `cfg_val` = "1.4.0" WHERE `cfg_nm` = "version" Succeeded. 





UPDATE `nuke_seo_config` SET `config_value` = "1.1.1" WHERE `config_type` = "Feeds" AND `config_name` = "version_number" Succeeded. 





UPDATE `nuke_seo_config` SET `config_value` = "1.1.1" WHERE `config_type` = "Feeds" AND `config_name` = "version_newest" Succeeded. 





ALTER TABLE `nuke_nsnst_ip2country` DROP PRIMARY KEY Succeeded. 





ALTER TABLE `nuke_nsnst_ip2country` DROP INDEX `c2c` Succeeded. 





ALTER TABLE `nuke_nsnst_ip2country` DROP INDEX `date` Succeeded. 





ALTER TABLE `nuke_nsnst_ip2country` ADD PRIMARY KEY (`ip_lo`,`ip_hi`,`c2c`) Succeeded. 





ALTER TABLE `nuke_nsnst_ip2country` ADD UNIQUE `c2c` (`c2c`,`ip_hi`,`ip_lo`) Succeeded. 





UPDATE `nuke_config` SET `Version_Num`='rn2.50.00' Succeeded. 





UPDATE `nuke_bbconfig` SET `config_value`=".0.23" WHERE `config_name`="version" Succeeded.

Suggestions? Comments? Solutions? Ideas?

RavensScripts

Posted: Thu Nov 01, 2012 9:08 am

The screen shot you posted indicates that in some places the system is not finding your language constants. For instance, _ADVERTISING is defined in the \admin\language directory and when you go into the ACP it looks the constant up there. If it can't be found then the system just echoes out _ADVERTISING. Same for _THEMES etc.

This would indicate to me that maybe your FTP of the updated files did not work properly. You might use a program such as Beyond Compare to compare the distribution files that you've downloaded with those that are on your server and make corrections or you might just try re-uploading the distribution.

You can also make sure dblogging (settings in rnconfig) is turned on to show errors and check your dblog file ... though what you posted looks more like an incomplete FTP process.

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

I thinnk fkelly hit the nail on the head. BeyondCompare (among other comparison tools) can help confirm the missing / incomplete files.

Posted: Thu Nov 08, 2012 3:32 pm

You have to be the main administrator (god) to access the theme selector, but with a simple line edit you can do the trick.

Posted: Wed Mar 13, 2013 11:22 am

I dumped everything and installed fresh new installation. Love the new release so many refinements and fixes.

RavensScripts

registered · Posted: Thu Mar 21, 2013 7:14 am

You haven't seen anything yet! Wait until you see the brand new (yes... "new") CMS being worked on... *sorry for the teaser* Smile