Admin.php wont open

Worker Joined: Mar 31, 2004 Posts: 111

Hi have you ever had a problem if you wanted to add an ADMIN it wouldnt work? when I try to create a new admin and fill the required fields and type in the password and than hit add admin a blank page would show up with nothing on it

ofcourse the new admin is not added to the list

any solutions for this problem?

thank you

Posted: Wed Oct 05, 2005 1:14 am

Please provide some basic information when posting support requests.

To begin:
What version of PHP-Nuke?
What level of "Patched"?

If you have not updated your level of patched, I would suggest that you do that to resolve this issue.

Posted: Wed Oct 05, 2005 11:54 am

I got phpnuke 7.6 along with pach 3.1 nukesenitel and protector all fresh installed no new updateds found

Posted: Wed Oct 05, 2005 11:59 am

The problem is most likely caused by your installation of Protector in installing the radminblocker extra field.

Go back through the installation procedures for protector and be sure add the appropriate changes to the admin.php file as well as all other files as indicated.

Posted: Wed Oct 05, 2005 3:56 pm

ok i will try again Smile

thank you

Posted: Wed Oct 05, 2005 4:04 pm

well im trying to edit admin.php and this is what it says

(open admin.php)
Find on line 157 (it's under the function GraphicAdmin())

Code:




$sql = "SELECT radminarticle,radmintopic,radminuser,radminsurvey,radminsection,radminlink,radminephem,radminfaq,radmindownload,


radminreviews,radminnewsletter,radminforum,radmincontent,radminency,radminsuper FROM ".$prefix."_authors WHERE aid='$aid'";

-------------------
Replace with:

Code:




$sql = "SELECT radminarticle,radmintopic,radminuser,radminsurvey,radminsection,radminlink,radminephem,radminfaq,radmindownload,


radminreviews,radminnewsletter,radminforum,radmincontent,radminency,radminsuper,radminblocker FROM ".$prefix."_authors WHERE aid='$aid'";

-------------------

I'm not able to find that code anywhere in admin.php

this is what i have on line 157

global $gfx_chk, $admin_file;

that is my line on 157 on admin.php

I also tryed programs wich can find hiden textures but it's not working the code is nowhere to be found

NOTE: Edited by 64bitguy to encapsulate code in proper "code" function.

Posted: Wed Oct 05, 2005 10:07 pm

Well, you've got to keep in mind, Protector is a dead solution in that it is no longer maintained (in fact its home domain hasn't existed in many months) and thus the installation information is no longer valid.

If you want to keep using it, here's what you do.

Open admin.php and find (in the function graphicadmin section:

Code:

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


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


   if ($radminsuper == 1) {

And REPLACE that code with:

Code:

    $row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper,radminblocker FROM ".$prefix."_authors WHERE aid='$aid'"));


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


    $radminblocker = intval($row['radminblocker']);


    if ($radminsuper == 1 or $radminblocker == 1) {

That should fix your problem for that section.

Steph

Posted: Wed Oct 05, 2005 10:51 pm

ok now i got this problem when I klick on add author this comes up and a blan page

Column count doesn't match value count at row 1

Posted: Wed Oct 05, 2005 11:27 pm

Right, that is a missing $radminblocker variable. I'm assuming you didn't fix another section OR you are missing that field from your authors table.

Again, you need to follow ALL of the Protector installation instructions.

Posted: Wed Oct 05, 2005 11:28 pm

how can i fiux that now?

Posted: Wed Oct 05, 2005 11:34 pm

Have you tried following the rest of the file modification instructions?

Posted: Wed Oct 05, 2005 11:36 pm

yes the rest of the instructions tells me to upload authors.php into admin/modules

and edit it and when i edit it it shows me that messege if i undo the edit a blank page will apear like before

Posted: Wed Oct 05, 2005 11:42 pm

Well, at this point, I can only assume that you made a mistake in the editing of the files or they are corrupt. Use the "Patched" authors.php (and the admin.php that you've already been working on, that I also assume is from patched) and if you haven't already done it, in your admin.php file find:

Code:

$db->sql_query("INSERT INTO ".$prefix."_authors VALUES ('$name', '$the_adm', '$url', '$email', '$pwd', '0', '1', '')");

Replace with:

Code:

$db->sql_query("INSERT INTO ".$prefix."_authors (aid, name, url, email, pwd, counter, radminsuper, admlanguage, radminblocker) VALUES ('$name', '$the_adm', '$url', '$email', '$pwd', '0', '1', '', '')");

In your /admin/modules/authors.php (from patched 3.1) near the bottom of the file just before the "case "deladmin":" call, find::

Code:

$result = $db->sql_query("insert into " . $prefix . "_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_pwd', '0', '$add_radminsuper', '$add_admlanguage')");

Replace with:

Code:

$result = $db->sql_query("insert into " . $prefix . "_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_pwd', '0', '$add_radminsuper', '$add_admlanguage','')");

That should start you down the road. Keep in mind, if you haven't made the other file changes, you are simply consuming resources and not actually protecting your site. You need to make ALL of the modifications in order for Protector to do anything.

Posted: Wed Oct 05, 2005 11:48 pm

it works now thank you very much for helping me resolve this issue.

I appriciate your help and if there is something i can do for you just let me know