cant recreate super user

Regular Joined: Jan 14, 2005 Posts: 93

I'm running PHPNuke 7.5.

Tonight I tried to change my admin password. When I attempted to relog in, it would not allow me - as if the new password was wrong.

I searched the web, and found a hint on another site telling me to go to the nuke_authors table and make the password

dc647eb65e6711e155375218212b3964

Which was supposed to reset it to "Password" This did not work.

So I followed advice in another thread, and simply deleated the entries in nuke_authors I browsed to the admin section of my nuke site where I was prompted to (re)create the super user account - which I did.

However I am still not able to log in, and the entries have NOT been recreated in nuke_authors fields.

Any advice is greatly appreciated. Thanks!

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

That implies that you have probably added a third party application that has modified the nuke_authors table. Have you recently added a module that altered that table? Here is what the schema for the nuke_authors table should look like

Code:

CREATE TABLE nuke_authors (


  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',


  radminsuper tinyint(1) NOT NULL default '1',


  admlanguage varchar(30) NOT NULL default '',


  PRIMARY KEY  (aid),


  KEY aid (aid)


) TYPE=MyISAM;

8 columns. How does that compare to yours?

Posted: Wed Oct 19, 2005 10:06 pm

Here is mine...

CREATE TABLE `nuke_authors` (
`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',
`radminsuper` tinyint(1) NOT NULL default '1',
`admlanguage` varchar(30) NOT NULL default '',
`radminapprove` tinyint(2) NOT NULL default '0',
`radminpreapprove` tinyint(2) NOT NULL default '0',
`radminblocker` tinyint(2) NOT NULL default '0',
PRIMARY KEY (`aid`),
KEY `aid` (`aid`)
) TYPE=MyISAM;

looks like 3 extra fields. Not sure what mod they went to, but I dropped 'em, and it let me recreate the superuser.

Thanks AGAIN Raven! Smile

Posted: Thu Oct 20, 2005 3:40 am

Those extra fields reminds me of an add-on for the 'Your Account' module - some sort of approve membership tweak?
You may want to check that as you might need to reinstate those fields now or remove the files that used them to prevent issues in the future.

Posted: Thu Oct 20, 2005 10:16 am

Wow - you are right. I think I installed that, but it was well over a year ago (and many upgrades since then). Never used it, so I won't miss it.

Thanks though - I was curious as to what these went to. Looks like I don't need them.