Reset Super User Access Rights

Moderators: mandville, PhilD, General Support Moderators

oneski2006
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Mar 19, 2012 10:49 am

Reset Super User Access Rights

Post by oneski2006 » Mon Mar 19, 2012 10:56 am

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
You do not have the required permissions to view the files attached to this post.

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3620
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Reset Super User Access Rights

Post by abernyte » Mon Mar 19, 2012 6:48 pm

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', 'your-email@yourdomain.com',
    '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.
It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Twain

oneski2006
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Mar 19, 2012 10:49 am

Re: Reset Super User Access Rights

Post by oneski2006 » Tue Mar 20, 2012 10:45 am

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Sat Mar 17, 2012 4:15 am

Re: Reset Super User Access Rights

Post by ropadepot » Tue Mar 20, 2012 3:40 pm

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

oneski2006
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Mar 19, 2012 10:49 am

Re: Reset Super User Access Rights

Post by oneski2006 » Tue Mar 20, 2012 4:04 pm

i've done way too much work to reinstall everything

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3620
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Reset Super User Access Rights

Post by abernyte » Tue Mar 20, 2012 6:49 pm

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.
It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Twain

oneski2006
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Mon Mar 19, 2012 10:49 am

Re: Reset Super User Access Rights

Post by oneski2006 » Wed Mar 21, 2012 10:31 am

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]

User avatar
abernyte
Joomla! Virtuoso
Joomla! Virtuoso
Posts: 3620
Joined: Fri May 15, 2009 2:01 pm
Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड

Re: Reset Super User Access Rights

Post by abernyte » Wed Mar 21, 2012 7:34 pm

Well done. I am glad you are back. Now take a backup!
It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so. Twain

ropadepot
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Sat Mar 17, 2012 4:15 am

Re: Reset Super User Access Rights

Post by ropadepot » Wed Mar 21, 2012 9:33 pm

YOU ARE THE BEST. Thank you very much.

ArjenM
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Mar 22, 2012 1:13 pm

Re: Reset Super User Access Rights

Post by ArjenM » Thu Mar 22, 2012 1:53 pm

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]
Phew thx a bunch for posting this, today ran into the same problem but got it fixed with this :)

essamy
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Sat Apr 07, 2012 3:44 am

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
Joomla! Explorer
Joomla! Explorer
Posts: 486
Joined: Mon Jul 05, 2010 7:22 pm
Location: UK
Contact:

Re: Reset Super User Access Rights

Post by ShMaunder » Sat Apr 07, 2012 3:52 am

@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.
Shaun Maunder
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/

essamy
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Sat Apr 07, 2012 3:57 am

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
Joomla! Explorer
Joomla! Explorer
Posts: 486
Joined: Mon Jul 05, 2010 7:22 pm
Location: UK
Contact:

Re: Reset Super User Access Rights

Post by ShMaunder » Sat Apr 07, 2012 4:01 am

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.
Shaun Maunder
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/

essamy
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Sat Apr 07, 2012 4:12 am

Thank you very much..
SOLVED!

essamy
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Sat Apr 07, 2012 4:14 am

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
Joomla! Explorer
Joomla! Explorer
Posts: 486
Joined: Mon Jul 05, 2010 7:22 pm
Location: UK
Contact:

Re: Reset Super User Access Rights

Post by ShMaunder » Sat Apr 07, 2012 4:27 am

Shaun Maunder
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/

essamy
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Sat Apr 07, 2012 2:40 pm

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
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Sun Apr 08, 2012 10:54 pm

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
Joomla! Explorer
Joomla! Explorer
Posts: 486
Joined: Mon Jul 05, 2010 7:22 pm
Location: UK
Contact:

Re: Reset Super User Access Rights

Post by ShMaunder » Tue Apr 10, 2012 5:14 pm

@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.
Shaun Maunder
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/

essamy
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Sun Jan 09, 2011 7:20 pm
Contact:

Re: Reset Super User Access Rights

Post by essamy » Wed Apr 11, 2012 10:24 pm

Thank you very much.

Ksiaze
Joomla! Apprentice
Joomla! Apprentice
Posts: 30
Joined: Thu Jan 17, 2008 8:35 pm

Re: Reset Super User Access Rights

Post by Ksiaze » Mon Jun 25, 2012 3:32 am

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]
It really WORKS ! Many thanks.

derfdesign
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Jun 27, 2011 5:46 am

Re: Reset Super User Access Rights

Post by derfdesign » Tue Jul 31, 2012 11:53 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Thu Aug 02, 2012 9:07 am

Re: Reset Super User Access Rights

Post by Agence Nature » Thu Aug 02, 2012 9:09 am

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

O3car
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Fri Jan 26, 2007 8:05 pm

Re: Reset Super User Access Rights

Post by O3car » Thu Nov 08, 2012 5:49 pm

You're a lifesaver!

User avatar
humvee
Joomla! Master
Joomla! Master
Posts: 14713
Joined: Wed Aug 17, 2005 10:27 pm
Location: Kent, England

Re: Reset Super User Access Rights

Post by humvee » Fri Nov 09, 2012 9:35 am

[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.

User avatar
coalaweb
Joomla! Apprentice
Joomla! Apprentice
Posts: 41
Joined: Wed Jun 30, 2010 6:42 pm
Location: New York
Contact:

Re: Reset Super User Access Rights

Post by coalaweb » Thu Nov 22, 2012 9:09 am

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]
This worked in my case.

Thanks

chilie
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Sun Oct 10, 2010 1:29 am
Contact:

Re: Reset Super User Access Rights

Post by chilie » Fri Dec 14, 2012 9:45 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Tue Mar 27, 2012 6:49 am

Re: Reset Super User Access Rights

Post by phenixat » Tue Dec 18, 2012 7:25 pm

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]
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
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Jan 03, 2013 9:28 am

Re: Reset Super User Access Rights

Post by renata_2013 » Thu Jan 03, 2013 10:39 am

Your solutions works like a charm!! Thanks! :)


Post Reply

Return to “Access Control List (ACL) in Joomla! 2.5”