Nuke Resources » Forums » Random Thoughts » ms analysis

apophis · Resource Newbie

I have just moved our Nuke site to a new server and have two problems;

1 When trying to access MS Analysis all I get is 'This file can't be
accessed directly'. I have tried re-installing but it is just the same.

2 All the posts prior to the swap do not show up in the forums, when
viewing the .sql file for the database via a text editor I can see them
but that is as far as it goes. All the tables are present and populated.

Dean

Evaders99 · Resource Master

1) What version are you using? PHPNuke and MS_Analysis

2) So all the tables were merged and have data in them?
Did you do any code changes? Or changed phpNuke versions?

apophis · Resource Newbie

Hi

It's Nuke version 7.7 and MS Analysis 2.1.1.

All the tables have data in them and the only change I made was in config.php to amend the database name, username and password.
I did not change the Nuke version.

Dean

Evaders99 · Resource Master

I use MS_Analysis 2.3

In modules/MS_Analysis/index.php

there should be code like

apophis · Resource Newbie

Here is the code as requested

if(! eregi( "modules.php", $_SERVER['SCRIPT_NAME'] ) ) {
die( "You can't access this file directly..." );

Dean

Evaders99 · Resource Master

Try using what I posted

or

apophis · Resource Newbie

Just tried that and no luck I'm afraid.

Regarding the missing posts I now have some but not others. I
changed the nsqlconfig.php to point to the same database tonight, not
sure if that made any difference but are there any other files I need to
change regarding the database.

I also tried this I found;

SELECT nuke_bbposts.poster_id, nuke_users.username
FROM nuke_bbposts
LEFT JOIN nuke_users
ON nuke_bbposts.poster_id = nuke_users.user_id
WHERE (nuke_users.username IS NULL)

and got the following;

Query Results

poster_id username
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1

although the table went on in the same manner for well over 200 rows.

It looks as though all the users that have been deleted in the past have been set to -1 as I ran the following query;

SELECT * FROM nuke_bbposts
WHERE poster_id = "-1" ;

which gave me their names, not sure how to fix this though.

Dean

apophis · Resource Newbie

I have also updated to the latest version of MS Analysis, dropped all the tables and started again but still to no avail. Any ideas?

Dean

Evaders99 · Resource Master

Hmm missing posts? Did you convert from phpBB? phpNuke uses a different anonymous user_id (instead of -1 its 1)

apophis · Resource Newbie

No I did not convert it was a straight server swap. Is there any way to convert the -1 to 1 or would that make it worse?

Dean

Evaders99 · Resource Master

So no changes to the software itself? I don't understand how you would have anything with a poster_id = -1
You could try poster_id = 1 and see if that works

apophis · Resource Newbie

Ok I will try that but before I go ahead, would the following be the correct code to use?

UPDATE nuke_bbposts
SET poster_id = '1'
WHERE poster_id = '-1'

Dean

PS Any ideas on how to get MS Analysis working and thanks for your help
so far.

Dean

Evaders99 · Resource Master

Yes that should work.

Nope, I'm not really sure what is wrong with MS_Analysis.

apophis · Resource Newbie

I changed the code from this;

if( !stristr( $_SERVER['SCRIPT_NAME'], "modules.php" ) ) {
die( "You can't access this file directly..." );
}

to this;

if(!defined('MODULE_FILE') ) {
die( "You can't access this file directly..." );
}

I can now access MS Analysis from the Main Menu but not from the Admin Panel.
Any ideas what I may need to add to make it work from the Admin Panel?

Dean

Evaders99 · Resource Master

All the scripts in modules/MS_Analysis/admin/ need to use