Help with 2.5 upgrade

New Member Joined: Jan 19, 2009 Posts: 13

Hi All,

Hope this post is in the right place. I am currently working through an upgrade from Ravens 2.3-->2.5 on my local machine (win 7/latest XAMPP) in prep for a live site upgrade. I did get a few errors in the db migration part of the installation but everything seems very much ok so far except:

I am having an issue with only one item in the Administration Menu.

The "Themes" icon in the Administration Menu just gives me an "Access Denied" message on the resulting page. It makes no difference if I remove all of the security (.htaccess files etc) and turn of Sentinel or login as god/superusers. I guess its no coincidence that this is the new function in my Admin menu (having previously managed themes from Preferences).

Any tips on where to look would be welcome. Thanks!

Posted: Sun Jan 29, 2012 7:44 am

I'm pretty sure themes did at least one database upgrade. You might want to turn database error reporting on and look in dblog after trying to access themes and see if anything is showing up. Rnconfig has instructions for this; set loglevel to 1. The table_compare directory in the distribution has a program to compare the "official" 2.5 database with whatever you have installed. Instructions are in the program. Normally, discrepancies should be resolved but you can post any you find here to get an opinion.

The program that themes admin is trying to run is in /admin/modules/themes.php. You might want to make sure that is set up on your server properly. Since it's new any kind of FTP error may have omitted installing it. Make sure it's permissions are the same as the other files in that directory.

registered · Posted: Sun Jan 29, 2012 10:26 am

candiman wrote:

I did get a few errors in the db migration part of the installation

Did you happen to take a copy of these from the page? There may also be clues in those as well.

Posted: Sun Jan 29, 2012 10:32 am

candiman, are all the files fresh or did you just insert the new files over the old? I do not really have any ideas just trying to get all the facts.

Posted: Sun Jan 29, 2012 6:02 pm

Thanks for the quick replies. I did keep a copy of the database migration errors so will take a closer look at that.

I will turn on the logging to see if I can see any related database errors.

For the installation I used the upgrade option. So I assume the old tables and data remain with any new required tables added.

I have switched the theme to an included version by copying renaming a theme directory as the old theme (Kalgash Dreams) is broken with 2.5.

There should be no FTP errors as the 2.5 installation was downloaded from here and unpacked directly over a working test copy of my site on my home PC. As mentioned everything else seems to be working so far.

I will report back after looking at the database logging and reviewing migration error data again.

EDIT - It looks like the "nuke_themes" table and inserts suceeded in the install.

Cheers

Posted: Sun Jan 29, 2012 6:10 pm

Quote:

For the installation I used the upgrade option. So I assume the old tables and data remain with any new required tables added.

That SHOULD BE true but the other steps will verify it.

Odd things can happen when you "unpack over". For one thing, old files may not get replaced or may be left in place where you don't want them. You also do need to verify your /admin/modules/themes.php file. That is new and needs to be there ... that's what themes administration uses.

Posted: Sun Jan 29, 2012 6:59 pm

OK, themes.php seems to be fine. The dblog definately shows errors related to the install errors. Here is an example:

From install report:

SHOW TABLES LIKE 'nuke_nsnpj_config' Succeeded.

CREATE TABLE `nuke_nsnpj_config` (`config_name` varchar(255) NOT NULL default '', `config_value` text NOT NULL) TYPE=MyISAM AUTO_INCREMENT=1 FAILED. MySQL reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 1

From dblog log:

January 30, 2012, 1:35 am File: C:\xampp\htdocs\ansiteupgrade\db\mysqli.php - Line: 201
Code: 1146 - Message: Table 'ansquad.nuke_nsnpj_config' doesn't exist
SQL was: SELECT config_name, config_value FROM nuke_nsnpj_config
remote addr: 127.0.0.1

Having never really used SQL before I am not sure how to remedy. I tried to rerun the CREATE TABLE as above and got the same error. Tips?

EDIT - I created a new database using the 2.5 installation. I have now imported the missing tables into my site upgrade database. Its cool because the errors are all gone in the rnlog file... but still Access Denied to the admin Themes module.

Posted: Sun Jan 29, 2012 10:29 pm

Fixed.

After adding the tables to the database I neglected to log out/in my admin user and refresh page properly. After doing that all is working perfectly.

Last comment:

Our site has been using Raven Nuke since mid 2009 and have not had any security issues at all. Prior to that we were getting hacked about every month or two and ultimately gave up and resorted to a single html page until we found a secure nuke CMS. One of our site members (steptoe in the forums here) pointed me in your direction for a solution. I started from scratch not ever having done any web stuff but the RN instructions and forums history have been great.

Thank you very much!

Posted: Mon Jan 30, 2012 6:28 am

Nice to hear steptoe is still active. RavenNuke is the best decision if you have concerns and issues with website security.