Adding Admins

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

I added an admin on my site for the first time. How do they log in? Do they just log on as a normal user using the login block or do they use the sitename/admin.php ?

GanjaUK · Posted: Mon Jul 12, 2004 8:12 am

admin.php

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

I tried that. I try to log on with the admins name and assigned password and when I hit "login" it flashes back to the same screen.

GanjaUK · Posted: Mon Jul 12, 2004 9:52 am

Does your new admin get the same problem then?
Login using the NICKNAME of the new admin, and not the NAME

Raven · Posted: Mon Jul 12, 2004 9:59 am

Try deleting your cookies and flushing your cache.

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

MY new admin tried that and it keeps reloading the log in screen. Anything else I should try?

GanjaUK · Posted: Tue Jul 13, 2004 7:45 am

Did you try using the nickname as the username you gave for the new admin?

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

yes i did. Also, the admin has been a regular member for some time. I gave them the same name for their admin name as their registered name. Would that have caused a problem?

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

when I add him as an admin and then click, "add author" it goes to a blank screen at the admin.php address

CodyG · Posted: Tue Jul 13, 2004 11:01 am

oops, seen that one before.
Have the same problem due to some mods not playing nice together in the authors scripts. My work around is adding another entry to the authors table using phpmyadmin.

Raven · Posted: Tue Jul 13, 2004 11:09 am

My guess is that you (or an application you installed) have altered the authors table schema and the script has not been properly altered.

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

hmm ok. What should I do?

Raven · Posted: Tue Jul 13, 2004 12:09 pm

If it were me I would either backtrace what I've added recently or restire the authors table and/or the admin/modules/authors.php file to get back to the default installation.

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

Raven,

I re-uploaded the authors.php file and I still have the same problem. Can you assist me with the authors table. I don't have any experience working with tables.

Raven · Posted: Tue Jul 13, 2004 2:06 pm

The default author's table should look like this (22 columns). Does yours?

Code:

`aid` varchar(25) NOT NULL default '',
`name` varchar(50) default NULL,
`url` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`pwd` varchar(40) default NULL,
`counter` int(11) NOT NULL default '0',
`radminarticle` tinyint(2) NOT NULL default '0',
`radmintopic` tinyint(2) NOT NULL default '0',
`radminuser` tinyint(2) NOT NULL default '0',
`radminsurvey` tinyint(2) NOT NULL default '0',
`radminsection` tinyint(2) NOT NULL default '0',
`radminlink` tinyint(2) NOT NULL default '0',
`radminephem` tinyint(2) NOT NULL default '0',
`radminfaq` tinyint(2) NOT NULL default '0',
`radmindownload` tinyint(2) NOT NULL default '0',
`radminreviews` tinyint(2) NOT NULL default '0',
`radminnewsletter` tinyint(2) NOT NULL default '0',
`radminforum` tinyint(2) NOT NULL default '0',
`radmincontent` tinyint(2) NOT NULL default '0',
`radminency` tinyint(2) NOT NULL default '0',
`radminsuper` tinyint(2) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default ''

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

Here's what I have:

Quote:

aid varchar(25) No
name varchar(50) Yes NULL
url varchar(255) No
email varchar(255) No
pwd varchar(40) Yes NULL
counter int(11) No 0
radminarticle tinyint(2) No 0
radmintopic tinyint(2) No 0
radminuser tinyint(2) No 0
radminsurvey tinyint(2) No 0
radminsection tinyint(2) No 0
radminlink tinyint(2) No 0
radminephem tinyint(2) No 0
radminfaq tinyint(2) No 0
radmindownload tinyint(2) No 0
radminreviews tinyint(2) No 0
radminnewsletter tinyint(2) No 0
radminforum tinyint(2) No 0
radmincontent tinyint(2) No 0
radminency tinyint(2) No 0
radminNewsflashAdmin tinyint(2) No 0
radminCalendarAdmin tinyint(2) No 0
radminsuper tinyint(2) No 1
admlanguage varchar(30) No

Raven · Posted: Tue Jul 13, 2004 2:23 pm

radminNewsflashAdmin tinyint(2) No 0
radminCalendarAdmin tinyint(2) No 0

2 too many. So, this means that something went wrong when you installed the applications that added these 2 fields. Since you have restored the original authors.php file, you need to drop those 2 columns from the table. Use phpMyAdmin to do that. This has renedered those applications non-workable. You will need to reinstall them.

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

I dropped the tables and I was able to add him. He said he still can't get on but I think that's a cache issue. I'll post back when he gets on. Thanks for your help

Raven · Posted: Tue Jul 13, 2004 2:42 pm

Well, you didn't need to drop the table. You only needed to drop the 2 columns Wink

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

ok, I dropped the two you told me to. I guess my terminology is off. I now have 22 what I call "rows" To much use of MS Excel i guess..

Raven · Posted: Tue Jul 13, 2004 2:54 pm

Rows, of course, would mean that you have 22 admins Smile

which I doubt. The columns in an sql table refer to the column tabs across the top of an Excel Spreadsheet. Rows would refer to the numbered entries down the left hand side. Tables would refer to individual spreadsheets Wink

sqzdog · Involved Joined: Sep 22, 2003 Posts: 252

But the bottom line is, I did it right?

Raven · Posted: Tue Jul 13, 2004 4:42 pm

As long as the table ended up with the original 22 columns -- Groovy