Im trying to add a new admin and when I click submit(of course filling out the req fields) the page just goes blank and it doesn't get added. Granted, Im not the God user(Im super) and Gods on Vacation but wouldnt I at least get an error message if I cant do it- but I think I should- right?
Hopefully this is the right place to post this erro!
Help!
MrFluffy Captain
Joined: Aug 06, 2003
Posts: 411
Location: Berlin
Posted:
Tue Dec 23, 2003 1:04 am
Do you have direct access to the database?
If so, could you count the number of fields inside the _authors table?
If you have more than 22 fields inside, that's most probably the cause.
Sorry- I don't have direct access-
But if I did- would it prevent me from adding new admins or in general- because he did add me after all.
MrFluffy Captain
Joined: Aug 06, 2003
Posts: 411
Location: Berlin
Posted:
Tue Dec 23, 2003 4:50 am
I just know about this problem, 'blank page when trying to add an admin', in relation with some modules adding fields to the authors table (calendars). In this case the sql-strings in the related admin-file need to be adjusted.
Well I did add a calendar the other day but didnt know if the admin add worked before that- I assume it did since I was created.
So what would I need to change to fix this?
MrFluffy Captain
Joined: Aug 06, 2003
Posts: 411
Location: Berlin
Posted:
Wed Dec 24, 2003 8:22 am
The short way would be to remove the module, the long way to try and update the insert string. Either way you need to find the field that was added to the table (nuke)_authors.
You will find that information in the sql-file that came with the calendar or by comparing your _authors table with this list of default fields:
Simply removing the new field should enable you to add admins again (if this was the problem's cause).
If you want to fix the command that writes to this table, you will find it in admin/modules/authors.php, around line 400:
Looks like some idiot missed adding an admin file in the corefiles folder-
And I can now add users
smacks self
Thanks for your help!
bihweb Private
Joined: May 26, 2003
Posts: 37
Posted:
Sat Jan 10, 2004 6:59 pm
All honor to Mister for great work but I just uninstall Protector. First of all all updates are for members only... Since this module came along with NUKE i expect it to be free of membership... Second it messed up my add admin thing and only way wat to remove it. And last one... It is way to many things to do in order to get it work. I use simple ban made for my site by Humpa. All I need is username or IP to ban someone... Ip gets worst on this AOL conections that keep changing them every second... And last reason... Table with stored IP's got REALLY REALLY BIG... I did deleted it from time to time but system is just keep adding IP's . The site is much faster now...
sting Site Admin
Joined: Jul 24, 2003
Posts: 1985
Location: Apparently ALWAYS Online. . .
Posted:
Thu Apr 01, 2004 7:54 pm
Thanks Mr Fluffy - that one was annoying me recently.. turns out in some versions of 6.9 the field radminblocker throws off the query, as its not included as '$add_radminblocker' and needs to be added to the modules/authors code as listed above.
-sting
_________________ Is it paranoia if they are really out to get you?
-------------------------------------------------------
sting usually hangs out at nukehaven.net
harm Nuke Soldier
Joined: Sep 20, 2003
Posts: 19
Location: Netherlands
Posted:
Sun Apr 25, 2004 12:17 pm
Hi MrFluffy,
Your are Super!!
I fixed my terrible problem!!
Great work!!
Greetings,
Harm
PrimalFear Sergeant
Joined: Mar 13, 2003
Posts: 129
Posted:
Sun Jun 27, 2004 12:14 pm
yip nice fix Fluffy.
oops Sorry ...
Mr.Fluffy
oradii Nuke Cadet
Joined: Jul 29, 2004
Posts: 1
Posted:
Thu Jul 29, 2004 3:05 am
Ok, I found the extra items in that table. But what happens if i remove them, is there not another table that is using them?
here is the name of the two extras.
radminblocker
radmingroup
I do not want to just remove them and have something else work. But I do want to be able to add admins and stuff.
Thanks for any help.
Bret
MrFluffy Captain
Joined: Aug 06, 2003
Posts: 411
Location: Berlin
Posted:
Thu Jul 29, 2004 3:25 am
If you are using the two modules that added these fields, Protector that added radminblocker and NSN Groups that added radmingroup, you should use this instead of deleting the fields:
Quote:
If you want to fix the command that writes to this table, you will find it in admin/modules/authors.php, around line 400:
At least in Protector you will find information on how to add the field to the query, in NSN Groups I'm not absolutely sure, but I think it only includes a premodded authors.php.
You have to keep exactly to the order of fields in the table, because the query only fills them from top to bottom, so each variable needs to fit in it's field exactly.
Out of the blue (this should be the default positions), I'd try:
I got the same Problem with nuke 7.4 i was running it a while and today i tried to add a new author and nothing was there only a blank page. i got the god account.i saw this article here but i am also new to this php nuke stuff.Can't i just add another author in phpmyadmin ? Please Help
SubZero Nuke Soldier
Joined: Oct 27, 2004
Posts: 22
Posted:
Wed Nov 03, 2004 6:21 am
Ops i just tried this i installed Admin Secure and Protector a few days ago now when i try to edit the author data from phpmyadmin than this appears -
* If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...
If you ever need to put a backslash ("\") or a single quote ("'") amongst those values, backslashes it (for example '\\xyz' or 'a\'b').
** For default values, please enter just a single value, without backslash escaping or quotes, using this format: a
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
