Cant add admins

Hangin' Around Joined: Dec 27, 2003 Posts: 45

hello

i got phpnuke 7.1 and i cant add other admins its just goes blank after i try to add them.

any help please.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

This is usually an indication that either your nuke_authors table has been modified (like by calendar or something) and the corresponding SQL code in the admin folder has not been updated. Is that possible?

Posted: Mon Mar 22, 2004 4:49 am

well nothing changed on 7.1 i didint touch any of tables and none of the admin folder/

i just cannot add admin..strange but true.

Posted: Mon Mar 22, 2004 5:21 am

If it is a virgin install and you have this problem, I would delete everything and reinstall.

Posted: Sat Apr 03, 2004 6:43 pm

its not a vergin install its an upgrade

Posted: Sat Apr 03, 2004 7:25 pm

Well, if it's an upgrade, did you replace all of your files with the 7.1 files?

Posted: Sat Apr 03, 2004 7:57 pm

yeah

Posted: Sat Apr 03, 2004 9:03 pm

And then did you reapply all of your customizations?

Posted: Sat Apr 03, 2004 9:18 pm

no

P.S

check your P.M's.

Posted: Sat Apr 03, 2004 9:21 pm

Well, if you did not add your customizations back in, then if your nuke_authors table is not the virgin install, that is your problem. Count the number of columns in your nuke_authors table and compare that with the default 7.1. They are probably at least 1 number off.

I have read all my PM's (and yours) and am not prepared to respond at this point.

Client Joined: Jan 29, 2004 Posts: 624

Do you think that's the problem- not redoing the customizations? I also can't add admins or superusers, I get a blank page.

Posted: Mon Apr 26, 2004 9:52 pm

That what it sounds like. Your insert statements are probably not in sync with the table schema.

Posted: Mon Apr 26, 2004 10:32 pm

Oooh... I don't know if I can even remember the customizations and mods I've done, my record keeping isn't too good. Fortunately I don't really need other admins on my site, but I'll look through things and see what customizations I can find.

Posted: Tue Apr 27, 2004 4:11 am

Compare your nuke_authors table layout (schema) to the default schema for your version. Whatever the added fields are might alert you to which addon you need to reapply.

Posted: Tue Apr 27, 2004 9:55 am

The second new thing I've learned from you today, the other being that the word 'script' is blocked... I'll go check my nuke_authors table.

Posted: Wed Apr 28, 2004 2:22 pm

On my fresh install 7.2 with cs fixes ... I installed Protector (maybe I shouldn't be so attached to it) according to directions, no edit admin problem. Then I installed Event Calendar and edited the files myself, according to directions. I ran into the edit admin problem right after that.

I've been looking at it for a couple of days now and I'm even more confused than I ever was before. Take the the authors.php file... and the modifyadmin() for a good example. I've got several questions. And the blank page result from attempting Edit Admin seems to indicate that this is the function that doesn't play nice.

One more thing ... the Protector install instructions say nothing about editing the ModifyAdmin() only changes to the GraphicAdmin(). I may be completely clueless on all this.

Code:

function modifyadmin($chng_aid) {


    global $prefix, $db, $multilingual;


    include("header.php");


    GraphicAdmin();


    OpenTable();


    echo "<center><font class=\"title\"><b>" . _AUTHORSADMIN . "</b></font></center>";


    CloseTable();


    echo "<br>";


    OpenTable();


    echo "<center><font class=\"option\"><b>" . _MODIFYINFO . "</b></font></center><br><br>";


    $adm_aid = $chng_aid;


    $adm_aid = trim($adm_aid);


    $row = $db->sql_fetchrow($db->sql_query("SELECT aid, name, url, email, pwd, radminarticle,radmintopic,radminuser,radminsurvey,


radminsection,radminlink,radminephem,radminfaq,radmindownload,


radminreviews,radminnewsletter,radminforum,radmincontent,


radminency,radminsuper,admlanguage from " . $prefix . "_authors where aid='$chng_aid'"));

Does that select require all the fields in the db? So if there are fields for radminCalendarAdmin, radminblocker, radmingroup, (and whatever) are they all not required to be in that select statement?

Code:

$chng_aid = $row['aid'];


    $chng_name = $row['name'];


    $chng_url = stripslashes($row['url']);


    $chng_email = stripslashes($row['email']);


    $chng_pwd = $row['pwd'];


    $chng_radminarticle = intval($row['radminarticle']);


    $chng_radmintopic = intval($row['radmintopic']);


    $chng_radminuser = intval($row['radminuser']);


    $chng_radminsurvey = intval($row['radminsurvey']);


    $chng_radminsection = intval($row['radminsection']);


    $chng_radminlink = intval($row['radminlink']);


    $chng_radminephem = intval($row['radminephem']);


    $chng_radminfaq = intval($row['radminfaq']);


    $chng_radmindownload = intval($row['radmindownload']);


    $chng_radminreviews = intval($row['radminreviews']);


    $chng_radminnewsletter = intval($row['radminnewsletter']);


    $chng_radminforum = intval($row['radminforum']);


    $chng_radmincontent = intval($row['radmincontent']);


    $chng_radminency = intval($row['radminency']);


    $chng_radminsuper = intval($row['radminsuper']);


    $chng_admlanguage = $row['admlanguage'];


    $chng_aid = substr("$chng_aid", 0,25);


    $aid = $chng_aid;

The above requires the additional fields radminCalendarAdmin, radminblocker, radmingroup, (and whatever), right?

<snip the form>

Now here is where things get totally interesting ...

Code:

echo "<tr><td>" . _PERMISSIONS . ":</td>";


    if ($chng_radminarticle == 1) {


        $sel1 = "checked";


    } else {


        $sel1 = "";


    }


    if ($chng_radmintopic == 1) {


        $sel2 = "checked";


    } else {


        $sel2 = "";


    }


    if ($chng_radminuser == 1) {


        $sel3 = "checked";


    } else {


        $sel3 = "";


    }


    if ($chng_radminsurvey == 1) {


        $sel4 = "checked";


    } else {


        $sel4 = "";


    }


    if ($chng_radminsection == 1) {


        $sel5 = "checked";


    } else {


        $sel5 = "";


    }


    if ($chng_radminlink == 1) {


        $sel6 = "checked";


    } else {


        $sel6 = "";


    }


    if ($chng_radminephem == 1) {


        $sel7 = "checked";


    } else {


        $sel7 = "";


    }


    if ($chng_radminfaq == 1) {


        $sel8 = "checked";


    } else {


        $sel8 = "";


    }


    if ($chng_radmindownload == 1) {


        $sel9 = "checked";


    } else {


        $sel9 = "";


    }


    if ($chng_radminreviews == 1) {


        $sel10 = "checked";


    } else {


        $sel10 = "";


    }


    if ($chng_radminnewsletter == 1) {


        $sel11 = "checked";


    } else {


        $sel11 = "";


    }


    if ($chng_radminforum == 1) {


        $sel12 = "checked";


    } else {


        $sel12 = "";


    }


    if ($chng_radmincontent == 1) {


        $sel13 = "checked";


    } else {


        $sel13 = "";


    }


    if ($chng_radminency == 1) {


        $sel14 = "checked";


    } else {


        $sel14 = "";


    }


    if ($chng_radminsuper == 1) {


        $sel15 = "checked";


    } else {


        $sel15 = "";


    }

Will modifyadmin() (Edit Admins) work without the additional db fields and additional $sel variables to cover the additional radminCalendarAdmin, radminblocker, radmingroup, (and whatever) ? My guess... no way.

The forms without the additional db fields are suspect too. Then apply the whole thing to the next function in authors.php. Updateadmin().

I had calendar and blocker working together just fine because I was able to fiddle with all this stuff until I got it working.... then I added groups and that's what broke my Edit Admins on 6.9 and it was easier to use phpmyadmin than visit that function again.

But is it just that function that breaks? Would there not be other script bits that need editing too?

I'd also like to add Approve Membership to this pit of snakes. And I want them to all play nice together. Am I just wishing and hoping and in denial? Has anyone ever tried it?

Raven, you posted a link to NukeCops about this issue, but that post is gone.

New Member Joined: Oct 15, 2004 Posts: 1

Raven wrote:

This is usually an indication that either your nuke_authors table has been modified (like by calendar or something) and the corresponding SQL code in the admin folder has not been updated. Is that possible?

i just put calendar on my saite and i cant add new admins. how can i fix this?

Posted: Fri Oct 15, 2004 9:33 am

My experience of this problem is that it is only a problem if one adds *two* third party applications that require edits to the authors table. One application will play nice with the core files and authors table, but the second application doesn't know about the first application and that's what breaks things.

My workaround ... Use phpmyadmin to add/edit authors.

Posted: Fri Oct 15, 2004 10:30 am

Group protector and the calendar's admin files, zip them and upload to your server, post the link to it, by admin files i mean anything that might go in the admin case, links and modules folders.