Admin Functions Return Blank Page

Posted: Wed Jul 02, 2003 2:41 am

i use nsn groups , i still get the same problem a blank page

i turned debug on

not sure if this helps tho

SQL query: select radminsuper from nuke_authors where aid='jeff'
SQL query: insert into nuke_authors values ('adminwrrw', 'admin', '', 'here@here.com', '03c37aa99aa4f6b766f802451e06c6c7', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '')

i also tried doing a direct input into the databse using the above

get this error

INSERT INTO nuke_authors
VALUES (

'adminwrrw', 'admin', '', 'here@here.com', '03c37aa99aa4f6b766f802451e06c6c7', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', ''
)

MySQL said:

Column count doesn't match value count at row 1

so if i counted right 23 in the sql quert , but 24 columns in the data base

the answers there somewhere Shocked

Posted: Wed Jul 02, 2003 4:49 am

fixed it

Quote:

$result = sql_query("insert into ".$prefix."_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_pwd',
'0', '$add_radminarticle','$add_radmintopic','$add_radminuser',
'$add_radminsurvey','$add_radminsection','$add_radminlink',
'$add_radminephem','$add_radminfaq','$add_radmindownload',
'$add_radminreviews','$add_radminnewsletter','$add_radmingroup','$add_radminforum',
'$add_radmincontent','$add_radminency','$radminCalendarAdmin',
'$add_radminsuper','$add_admlanguage')", $dbi); if (!$result) {
return;
}

it seemed to be missing the groups bit

Nuke Cadet Joined: Jul 02, 2003 Posts: 9

Anybody will not help me???

Nuke Cadet Joined: Jun 10, 2003 Posts: 8

Hey Raven and Holbrookau, I found this article. I have a similar issue on both my production and test site. I did install both Nucalendar. The issue I first noticed is that I try to add an admin and when I click "Add Author" I would just stare at a blank screen. Well, I didn't know what to do so I tried making the author in phpmyadmin, it worked but if I didn't give them superuser rights, they "did not have access to this page". If I give 1 to superuser it worked.

This was not acceptable. I then made that chage in your suggested fix earlier in this thread and I AM now able to successfully create an admin in the Administration panel. However the rights issue still remains. If I don't give this newly created admin "superuser" rights, then they can't do anything. "what happens is they login as the new admin I created and they can login successfully, but the Administration panel shows them the permission icons I allowed but every single one of them says YOu do not have access to this page"

Any suggestions?

Posted: Mon Jul 07, 2003 9:22 am

gybanez

we have the same problem at nukemods.com
Unless the Admin you are adding has SuperUser rights, then it doesn't work.

mikem

Posted: Mon Jul 07, 2003 9:47 am

Ok I am making progress here.
More than liekly this whole issue is caused by ANY field being added to the authors table. There are other mods that do this as well and unless they supply a modified authors.php file to allow for the added field in the aithors table, then adding admins bombs out in one way or the other.

Check your authors table. these are the DEFAULT fields that SHOULD be there. Anything additional needs to be looked at as the possible culprit. More than likely your authors.php is not recognizing any additional table(s) if they are there.

Quote:

aid
name
url
email
pwd
counter
radminarticle
radmintopic
radminuser
radminsurvey
radminsection
radminlink
radminephem
radminfaq
radmindownload
radminreviews
radminnewsletter
radminforum
radmincontent
radminency
radminsuper
admlanguage

Posted: Mon Jul 07, 2003 10:58 am

Ok ANYONE having this problem.
Check your authors table against the list of fields I gave above.
IF you have additional fields, you need to add them to this line in your authors.php

Code:

$result = sql_query("insert into ".$prefix."_authors values ('$add_aid', '$add_name', '$add_url', '$add_email',
'$add_pwd', '0', '$add_radminarticle','$add_radmintopic','$add_radminuser','$add_radminsurvey','$add_radminsection',
'$add_radminlink','$add_radminephem','$add_radminfaq','$add_radmindownload','$add_radminreviews','$add_radminnewsletter',
'$add_radminforum','$add_radmincontent','$add_radminency',
'$add_radminsuper','$add_admlanguage')", $dbi);

we have the additional field of
radminblocker
If you too have additional fields, you need to add them to the line.

All I had to do was add this part

Code:

,'$add_radminblocker'

to that line at the end to get authors.php to recognize that field.

so I add to that line like this

Code:

$result = sql_query("insert into ".$prefix."_authors values ('$add_aid', '$add_name', '$add_url', '$add_email',
'$add_pwd', '0', '$add_radminarticle','$add_radmintopic','$add_radminuser','$add_radminsurvey','$add_radminsection',
'$add_radminlink','$add_radminephem','$add_radminfaq','$add_radmindownload','$add_radminreviews','$add_radminnewsletter',
'$add_radminforum','$add_radmincontent','$add_radminency',
'$add_radminsuper','$add_admlanguage','$add_radminblocker')", $dbi);

it is at least worth a try. Wink

Nuke Cadet Joined: Jun 10, 2003 Posts: 8

Hi MikeM. I tried your solution and I did check my authors table and the only added field was "radminNewsflashAdmin"

so I went to my authors.php file and adde this

$result = sql_query("insert into ".$prefix."_authors values ('$add_aid', '$add_name', '$add_url', '$add_email', '$add_pwd', '0', '$add_radminarticle','$add_radmintopic','$add_radminuser','$add_radminsurvey','$add_radminsection','$add_radminlink','$add_radminephem','$add_radminfaq','$add_radmindownload','$add_radminreviews','$add_radminnewsletter','$add_radminforum','$add_radmincontent','$add_radminency','$add_radminsuper','$add_admlanguage','$add_radminNewsflashAdmin')", $dbi);

Unfortunately, it still doesn't give me access to the page when I successfully create a new admin. Still the same..it only works if I give Superuser. Do you know if there are other changes required on the authors.php file that I may have not done yet?

Posted: Sun Jul 13, 2003 4:19 pm

Ok..gybanez
One mroe thing we can try.

open your admin.php file
Find this part.

Code:

$sql = "SELECT radminarticle,radmintopic,radminuser,radminsurvey,radminsection,radminlink,radminephem,radminfaq,radmindownload,radminreviews,radminnewsletter,radminforum,radmincontent,radminency,radminsuper FROM ".$prefix."_authors WHERE aid='$aid'";

add your variable to that like this

Code:

$sql = "SELECT radminarticle,radmintopic,radminuser,radminsurvey,radminsection,radminlink,radminephem,radminfaq,radmindownload,radminreviews,radminnewsletter,radminforum,radmincontent,radminency,radminsuper,radminNewsflashAdmin FROM ".$prefix."_authors WHERE aid='$aid'";

then find this line

Code:

$radminsuper = $row[radminsuper];

and add this line just below it.

Code:

$radminNewsflashAdmin = $row[radminNewsflashAdmin];

MAKE SURE you backup that file before uploading the changed one.
Let's see if that works. Leave the change you made to the authors.php file earlier.

mikem

Sergeant Joined: Jun 14, 2003 Posts: 92

Hey mikem,

All of my tables are the same as your list and I still get the blank page. Only difference is that the page goes blank when I try to add a message to the main page. Any suggestions?

Nuke Cadet Joined: Jun 10, 2003 Posts: 8

mikem, it didnt work. It still does the same thing. I was wondering if I remove Newsflash if it will function back to normal. I like Newsflash but I also need the ability to delegate authors.

I'm gonna try to research Newsflash and see if they know the fix or even heard of this issue. Thank you for all your help and I will keep researching.

Corporal Joined: Jun 08, 2003 Posts: 64

Hi,

Do es anyone know if a definitive solution has been found to the Calendar mod causing EDIT ADMIN to return a blanke page yet? I have tried all the solution in this post but nothing is working...I am using Calendar 1.12 in another site and it works just fine (Nuke6.5) but in this site OSC2NUKE 6.9 ..no luck at all..

Lieutenant Joined: Jul 14, 2003 Posts: 153

I've been having the same problem with adding new authors/supers/admins, etc...

ZX has me report it as a bug.

Just checked my authors, admin.php and my database nuke_authors.

All fields are set properly and the appropriate entries are correct in the admin and authors.php

Posted: Wed Dec 03, 2003 10:29 pm

What happens if I don't have event calendar and I still get that blank page? I recently upgraded my site and basically the site loads and looks like Rainbow Brite. most of the modules give me an error and I get that stupid blank admin page.

what y'all suggest?

Nuke Cadet Joined: Nov 19, 2003 Posts: 8

I also have the Blank page problem when i try to add an admin, and i DON'T have the calendar installed... Any suggestions?