Reset Super User Access Rights

[oneski2006]

Hi,

I think I have messed up my Super Users access rights. All I seem to see when I login as a Super User is this shown in the attached image. (blank screen with joomla top bar + log out).

My adminisistrators are fine they still login correctly.
I have full access to both the server and database as they are running from our companies server.

I was trying to add a module to the home page that let Super Admins see certain private links by creating a 'Site Admin' viewing access group and adding super admins to it. I think this may have messed up something.

Any ideas on how to reset these details.
I do not have a backup ( i know stupid me )

Thanks,

Tim

[abernyte]

You can try making a new super user account to get you back into the Admin area.
1. Navigate to phpMyAdmin and select the database for the Joomla! site in the left-hand drop-down list box. This will show the database tables on the left side of the screen.
2. Press the "SQL" button in the toolbar to run a SQL query on the selected database. This will display a field called "Run SQL query/queries on database <your database>".
3. Delete any text in this field and paste in the following HAVING CHANGED JOS_ TO THE PREFIX FOR YOUR DATABASE:

Code: Select all

INSERT INTO `jos_users`
   (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`,
    `registerDate`, `lastvisitDate`,`activation`,`params`)
    VALUES ('40', 'Administrator2', 'admin2', '[email protected]',
    'd2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199',
    'Super Administrator', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00',"","");
INSERT INTO `jos_user_usergroup_map` (`user_id`,`group_id`) VALUES (40, 8);

4. At this point, you should be able to log into the back end of Joomla! with the username of "admin2" and password of "secret". After logging in, go to the User Manager and change the password to a secure value and the e-mail to a valid e-mail address.

This worked with J1.6 and J1.7 and I see no reason why it doesn't still work with J2.5.3, I just haven't tested it yet so backup...backup..backup.

[oneski2006]

No change im affraid, its logs me in but I am still shown that blank display as shown in my previous attached item. If i login as a Administrator I have access to everything except 'Super User' things.

[ropadepot]

I have the same exact problem. I'm thinking of re-installing everything.

[oneski2006]

i've done way too much work to reinstall everything

[abernyte]

If you want to go back into the database via phpmyAdmin you might be able to unpublish the new Admin module that you made which seems to be the source of the issue.
Look in jos_modules where jos is the prefix for you database installation. It will not be jos! When you find the module change Published to 0.
While you are in there, go into jos_users and have a look at what your login name usertype is set to. It should be Super User.

[oneski2006]

I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

[abernyte]

Well done. I am glad you are back. Now take a backup!

[ropadepot]

YOU ARE THE BEST. Thank you very much.

[ArjenM]

I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

Phew thx a bunch for posting this, today ran into the same problem but got it fixed with this

[essamy]

I have got this problem after i upgrade to 2.5.2..
I tried to solve it as before..
but i fount these settings as descried and the problem still here..

can any one help please?

[ShMaunder]

@essamy Did you just upgrade to 2.5.2 or 2.5.4? Could be module related as well, can you browse to /administrator/index.php?option=com_modules&view=modules ?


Something a little off-topic, the common problem with the special access level gives me a idea for a basic diagnostic tool external from Joomla.

[essamy]

Thank you for replay..
I upgrade to latest ver from administrator cp..

I browse to /administrator/index.php?option=com_modules&view=modules ?
and i got same screen with this message :

You are not authorised to view this resource.

Thank you

[ShMaunder]

If you have just updated to the latest then first check this
http://forum.joomla.org/viewtopic.php?f ... 4#p2782469

Check the symptoms first.

[essamy]

Thank you very much..
SOLVED!

[essamy]

May I ask about another issue pleas..
I just want to remove some fields "say Name" from the registration form..

How can i do it?

thanks

[ShMaunder]

Have a look at
http://forum.joomla.org/viewtopic.php?f=624&t=684263

[essamy]

Thank you very much..
I discovered new issue appears after upgrade also..
When I edit an article from the front-end, the html editor not appears, instead the html code for the page is appears..
Any idea to solve this please?
Thanks

[essamy]

Also this is a new problem after this "BLACK" upgrade!!
Text Filter Settings not saved..
I cant add any Custom HTML!!
Also JCE editor not working!!
I do not know how i can do..

[ShMaunder]

@essamy
I have no idea but you should create a new thread in the General Questions forum if you haven't already. This topic is for "Reset Super User Access Rights". You may get more replies there.

[essamy]

Thank you very much.

[Ksiaze]

I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

It really WORKS ! Many thanks.

[derfdesign]

I have the same problem, but how do I change these values in phpMyadmin

I found the table viewlevels, under "rules" I see
1 [1]
1 [4]
1 [6,2,8]

How can I change these values? I'm thinking of using an insert function, but could use some help/advice.

(pulling hair out)


oneski2006 wrote:
I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

[Agence Nature]

Thank you very much..; Work for me
SOLVED!

[O3car]

You're a lifesaver!

[humvee]

[Mod note: Moved from Admin Forum to ACL Forum;]
To help you, in the future, find the correct forum for your topic please read the Which forum to post your question that I have put together.

[coalaweb]

I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

This worked in my case.

Thanks

[chilie]

I too would like to say "Kudo's!" I had the same problem and this fixed it perfectly. I was thinking I was going to have to restore the site. You saved me hours of work.

[phenixat]

I managed to resolve this issue.

When I was messing about with permissions I must have changed something.
I went into my database a changed the 'jos_viewlevels' back to there default values and now everything is back where it should be.

1 Public 0 [1]
2 Registered 1 [6,2,8]
3 Special 2 [6,3,8]

This worked also in my case. THX so much !!!! I saved a re-install of the website. Fortunately I would have had a backup (THX to Akeeba!!! :-) )
Anyway, thanks again guys !

[renata_2013]

Your solutions works like a charm!! Thanks!