Unable to add new admin

Client Joined: Apr 15, 2003 Posts: 466 Location: FL

I am unable to add a new person to my author list. I have not needed to do this for some time, in fact I think before I updated from 6.5 to 7.6.
I enter all the info, hit the add author button and the page hangs at a white page.
I don't even know where to begin trying to correct this.
Help me????

registered · Posted: Wed Jan 31, 2007 12:47 am

A blank page usually indicates an error. Enable error reporting and check your error logs

Posted: Wed Jan 31, 2007 1:02 am

Well, how hard are ya gonna laff when I tell ya I have forgotten how to enable error reporting? Let me go look at it, and I'll come back with what I find out.

registered · Posted: Wed Jan 31, 2007 6:47 am

Check your config.php file. Does it have something in there about "display_errors"?

Posted: Wed Jan 31, 2007 7:41 am

Yes it does. I haven't had to mess with that in a long time thank goodness. However, having it on gives no error. Just the blank white screen. I seen a post similar to this where they were getting an error of 'illegal operation'. My symptoms are pretty much the same, but I get no error reports.
Guess I could add from phpmyadmin? Alot of trouble for something that should be easy to do tho....

Posted: Wed Jan 31, 2007 7:59 am

I was just looking at the author's table over in phpmyadmin. I thought maybe running a repair on it would help, but that did not work. I did notice tho, that I have these comments in the structure

Quote:

PRIMARY and INDEX keys should not both be set for column `aid`

Quote:

UNIQUE and INDEX keys should not both be set for column `pwd`

Could this be causing my problem. I have double checked to make sure my God account had not been changed somehow. I am listed as a God account, have access to everything....But this just isn't working. I understood from reading in other posts that just a super user would not be able to edit or add admins, and the action I am getting seems to be indicative of that....at least to the best of my understanding.
I knew things were going too smooth....

Posted: Wed Jan 31, 2007 9:34 am

No, doubtful that is it. Try accessing the following directly from your browser. You will either get a sytax error or something to the effect of "Access Denied" or "You cannot access this file directly":

admin/modules/authors.php

I think there is a syntax error in there somewhere introduced maybe by some edits?

Posted: Wed Jan 31, 2007 1:15 pm

Here's what I get

Quote:

Forbidden
You don't have permission to access /admin/modules/authors.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request

Posted: Fri Feb 02, 2007 6:24 am

Sounds like you have a .htaccess file in this directory or above it that has this in it:

deny from all

Change it temporarily to:

allow from all

and then re-do this test. We need to find out where the parse error is and what it is.

Do NOT forget to change the .htaccess file back!

Posted: Fri Feb 02, 2007 6:44 am

Ok, tried that, but still the same thing is happening.

Posted: Fri Feb 02, 2007 7:13 am

Do you have an .htaccess file in the admin/modules/ directory? If not, add one with the "allow from all" in it. We have to find that parse error...

Posted: Fri Feb 02, 2007 7:47 am

Same as before....just a white page

Posted: Fri Feb 02, 2007 8:17 am

Ok, that's better. Laughing

Put the following into that same .htaccess file:

php_flag display_errors On

and try again...

Posted: Fri Feb 02, 2007 8:25 am

I gotta laff, coz the rule of thumb for me is "If it's freaky and can happen, it will happen to me!"
Still nothing but a white page.
Is it possible that my God account is corrupted and I just been doing everything as a super user?

Posted: Fri Feb 02, 2007 8:35 am

Well, that is odd indeed. I could have sworn that this would also show db call issues, but maybe not. At least we can rule out PHP parse errors. So, let us starting digging into the DB. Take a look at your nuke_authors table in phpMyAdmin... does it show any errors on it? Try doing a repair on that table.

Posted: Fri Feb 02, 2007 8:54 am

I had tried this before, but just went back into phpmyadmin and analyzed the table, repaired it, then optimized it. I see no errors that I can spot.
Went back and tried to add a new admin.....I took the lazy way out and did not add the email and it loaded the page with the message that ya gotta add all fields, so went back added the email and got a white page after hitting 'add author'

Posted: Fri Feb 02, 2007 9:29 am

Ah, getting closer. Please post just the structure (NO DATA) from your nuke_authors table. I am pretty sure that when you migrated from 6.5 to 7.6, there are extra columns in that table.

Posted: Fri Feb 02, 2007 9:40 am

OK, hopefully I will give ya all that you need here....Here is what is listed on the structure page

aid varchar(25) latin1_swedish_ci No
name varchar(50) latin1_swedish_ci No
url varchar(255) latin1_swedish_ci No
email varchar(255) latin1_swedish_ci No
pwd varchar(40) latin1_swedish_ci No
counter int(11) No 0
radminsection tinyint(2) No 0
radminephem tinyint(2) No 0
radminsuper tinyint(1) No 1
admlanguage varchar(30) latin1_swedish_ci

Indexes:
PRIMARY PRIMARY 7 aid
pwd UNIQUE 7 pwd
aid INDEX 7 aid
pwd_2 INDEX 7 pwd

Row Statistics:
Statements Value
Format dynamic
Collation latin1_swedish_ci
Rows 7
Row length ø 96
Row size ø 827 B
Creation Feb 10, 2006 at 05:59 AM
Last update Feb 02, 2007 at 08:55 AM
Last check Feb 02, 2007 at 08:55 AM

Posted: Fri Feb 02, 2007 9:48 am

The following two fields are NOT in 7.6 of nuke. If you are certain that you upgraded to 7.6 script files, the removal of these two extra fields might solve your problem (take a backup of your table BEFORE you do this!).

Posted: Fri Feb 02, 2007 11:40 am

Which 2 fields? I did not do the update myself, but had it done by someone else because of all the patches and mods. It is 7.6 but I forget where it's patched to. I'm sure there are more that I need now, but that's another issue.
Tell me which fields and I'll back up the table and remove them to try it. If all else fails I guess I can go in and add authors from phpmyadmin.
Thanks for all the effort you are putting into helping me Montego!

Posted: Fri Feb 02, 2007 11:42 am

sorry about that! I always forget email attachments too!

radminsection
radminephem

Posted: Mon Feb 05, 2007 7:22 am

Sorry I stepped away for a day or so...I had people from out of town and got distracted. BUT! I am very happy to tell you that this repaired my problem!!!! I just went thru the entire process of adding a new author and it took. So far there seems to be no issue from dropping the 2 fields. Thank you Montego!

Posted: Tue Feb 06, 2007 5:49 pm

u r most welcome! Glad to help.

RavensScripts