By Kornika on

I created a Drupal site (http://speak.kornika.com) and tweaked it until I got it just right after which I created another login to participate in my little community I built without having to show as the "Admin" first user.

The problem is, I also installed a module that automatically deletes users that haven't had activity on the site in over 4 weeks. My first user, and only "super" Admin, was deleted as apart of the housekeeping because the site basically manages itself without my having to log in as the super user.

What do I do now? I can not access any of the admin stuff and I have been pouring over the database files in myremoteSQL to perhaps change a value there for my new user that I created hoping that I would be able to just change a number somewhere to make the new user the super Admin again.

Help!

Thanks in advance. If more details are needed, please let me know!

⋅ Categories: Drupal 4.6.x

Comments

toma’s picture

toma commented

Just add a user with id 1 in your database and log in, you ll have admin access to your website

senpai’s picture

senpai commented

I'll add a caution to anyone developing a module for Drupal that initiates 'housekeeping' duties. Please check to see which users are being nuked, and try not to kill the UID1?

This same scenario happened to me during a deploy of Cognos Business Intelligence software onsite at a client's offices. I clicked a "cleanup old users" link while logged in as myself, and the helpful little utility deleted the 'su' login account from the database. I was standing before six people as a subcontractor who now couldn't make the changes they were requesting before the next meeting.

Sorry people, but one should check to see what one is deleting before one deletes the number one account . That last sentence was clever, eh? Either that, or I seriously need sleep......

****
Joel "Senpai" Farris | certified to rock score

snsace’s picture

snsace commented

I just deleted my Super Admin because it was not acting right. I had to reupload my site and database because of a host problem.

I figured I needed to recreate my Super Admin. I have no other users on the site.

I looked in users table and only see a UID of 0 with other zeros down the table cells. I tried to create a new user from the site/user registration and I checked the table again. This test user was UID 2 and the password data and a few other cells were scrambled.

Is there a way I can recreate my Super Admin?

snsace’s picture

snsace commented

I got it by changing the UID to 1. My purpose for deleting and recreating my Super Admin was to see if that would fix my "access denied" when administering the site modules. Here is more detail about my problem: http://drupal.org/node/105519#comment-184386