Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
ghostgeek
Regular
Regular


Joined: Jan 14, 2005
Posts: 93

PostPosted: Wed Oct 19, 2005 7:36 pm Reply with quote

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!
 
View user's profile Send private message
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17077

PostPosted: Wed Oct 19, 2005 8:20 pm Reply with quote

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?
 
View user's profile Send private message
ghostgeek
PostPosted: Wed Oct 19, 2005 10:06 pm Reply with quote

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
 
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6792
Location: Ha Noi, Viet Nam

PostPosted: Thu Oct 20, 2005 3:40 am Reply with quote

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.
 
View user's profile Send private message Send e-mail
ghostgeek
PostPosted: Thu Oct 20, 2005 10:16 am Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©