Upgraded from 7.0 to 7.5 got some admin issues

Guest

Im just going to list whats wrong and what erros im getting and see where to go from there.

Adding Admins - no longer works just leads to white page. This is of course my biggest problem

=============

Web links- Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/includes/sql_layer.php on line 286
Access Denied

I did delete the old weblink related files and copy over all existing files aswell as uploaded the new ones

=========

qshoutblck admin - MYSQL Fetch row error , not sure what to do about this.

=========

newletter - not having any issue with it working but however would like it in the modules admin as I have one person who does the newsletter and nothing else and would like to keep it like that.

=============

some misc admin links still have a Access Denied error at top left of page. Ive noticed that ince the old admin files were deleted and the new ones were added to the module folder it usually disappeared. how ever some did not (news,surveys,exc). Some also arent default files from nuke and cant be uploaded over with newer files.

Thanks for any insight.

Site Admin Joined: Aug 17, 2003 Posts: 12383

Read this: http://www.nukeresources.com/ftopict-1425.html

Guest

I would but it doesnt seem to want to open. I did however go in via http://www.nukeresources.com fine and find the topic in question its just being stubborn. Care to copy and paste it? Ill keep trying to get it to open aswell

Posted: Fri Nov 12, 2004 5:15 pm

Well still wont open in IE or mozilla for some reason. however I did save the page and open it on my desk top. Upgly but readable.

However that didnt answer anything. Ive uploaded the files that needed to be uploaded in the admin section aswell as deleted those that were required to be deleted. Still no change

Posted: Sat Nov 13, 2004 1:02 am

Weblinks has been fixed but im still having the following issues:

Admin as stated above - biggest problem

qshout - same as above

and the newsletter question has nothing to do with errors but would like a response to that aswell

Guest

Any other ideas? I still really need help with not being able to admins. Thats really the only thing I need help with. Ive deleted and added the correct files after the upgrade but have yet to see a resolution

Guest

Hate to bump but the not being able to add admins is really making things difficult.

If you need more info from me let me know and ill provide it.

Guest

I got nuke 7.6 to see if that would resolve error. I deleted every single admin related file and put it in fresh. If i hit the add author button i still
get the white page. But if i hit it with no name it gives me an error

Author's Creation Error

You must complete all compulsory fields

I can also edit current admins if that helps narrow it down some but thats not doing me any good on adding new ones

Posted: Thu Nov 18, 2004 8:44 am

If you install 7.6 over another version, especially one older than 7.5, you will have to replace ALL the files. Versions 7.5 and 7.6 have a different database structure than earlier versions.

Please tell us what original version you had. And provide a URL so we can check it out.

Guest

Im totally aware of what files need to be replaced and which need to be completely removed aswell as the changes with in the database.

I think that point is being missed. there are several topics in discussion here , and found on google, about the same exact problem and no ones received an answer that worked from what Ive seen. A url would do no one any good considering its an admin only issue. I have no problems on any other aspect of the site.

Dont worry about answering here Im going to ask elsewhere or check in on the many other posts and see if they ever get a resolution.

Thanks anyways

Posted: Thu Nov 18, 2004 9:20 pm

Well, I may have a solution to some of your problems. Are the cranky modules in the admin menu only those left by the earlier version of nuke? Nuke 7.5 deals with modules admin differently than older versions.

At the top of a module script in admin/modules, look for something like this code from sections.php

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT radminsection, radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if (($row['radminsection'] == 1) OR ($row['radminsuper'] == 1)) {

Nuke 7.5 does not use the field radminsection, or anything other than radminsuper (that I can tell, anyway). When it can't find the field, it jumps to the Access Denied instruction.

So, if you remove the references to radminsection (or whatever), you can get rid of that annoying Access Denied message. Like so,

Code:

$row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if ($row['radminsuper'] == 1) {

This seems to work, and doesn't seem to break anything else. Even so, back up your files before changing them.

And BTW don't take offense at my earlier suggestions. It just seems that most guests here are total noobs and need a lot of handholding.

Guest

Quote:

And BTW don't take offense at my earlier suggestions. It just seems that most guests here are total noobs and need a lot of handholding.

Its no problem. Ive just seen some really ignorant replies :p I found the main issue. Seems there was aconflict with protector which has been replaced with sentinel now and im able to add admins fine.

The only issue thats still hanging around is the shout block problem. It did have radmin references but I had already removed them. Seems to cause it to just refresh itself. It may be a hassle but i can deal with editing it via the db til i find a more perm fix for it.

Posted: Sun Nov 13, 2005 12:12 pm

Not sure if you have found a fix for this yet. But the problem lies in the admin check code at the top of the ShoutBlock.php file under admin/modules....

Replace :

Code:

// if (!eregi("admin.php", $PHP_SELF)) { die ("Access Denied"); }
// $result = sql_query("select radminfaq, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
// list($radminfaq, $radminsuper) = sql_fetchrow($result, $dbi);
// if (($radminfaq==1) OR ($radminsuper==1)) {

With :

Code:

if (!eregi("admin.php", $_SERVER['PHP_SELF'])) { die ("Access Denied"); }
global $prefix, $db;
$aid = substr("$aid", 0,25);
$row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if ($row['radminsuper'] == 1) {

That seemed to work fine for me and now the Admin page for Qshout loads just fine....

One thing I haven't figured out yet is the fact that the block isnt seeing me as logged in when logged in as a registered user. So I cant post... still working on that one.