Reset Super User Access Rights
Moderators: mandville, General Support Moderators
-
- Joomla! Fledgling
- Posts: 4
- Joined: Mon Mar 19, 2012 10:49 am
Reset Super User Access Rights
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
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.
- abernyte
- Joomla! Virtuoso
- Posts: 4189
- Joined: Fri May 15, 2009 2:01 pm
- Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड
Re: Reset Super User Access Rights
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:
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.
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.
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine
-
- Joomla! Fledgling
- Posts: 4
- Joined: Mon Mar 19, 2012 10:49 am
Re: Reset Super User Access Rights
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.
-
- Joomla! Apprentice
- Posts: 6
- Joined: Sat Mar 17, 2012 4:15 am
Re: Reset Super User Access Rights
I have the same exact problem. I'm thinking of re-installing everything.
-
- Joomla! Fledgling
- Posts: 4
- Joined: Mon Mar 19, 2012 10:49 am
Re: Reset Super User Access Rights
i've done way too much work to reinstall everything
- abernyte
- Joomla! Virtuoso
- Posts: 4189
- Joined: Fri May 15, 2009 2:01 pm
- Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड
Re: Reset Super User Access Rights
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.
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.
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine
-
- Joomla! Fledgling
- Posts: 4
- Joined: Mon Mar 19, 2012 10:49 am
Re: Reset Super User Access Rights
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]
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
- Joomla! Virtuoso
- Posts: 4189
- Joined: Fri May 15, 2009 2:01 pm
- Location: Écosse - Scozia - Escocia - Škotija -स्कॉटलैंड
Re: Reset Super User Access Rights
Well done. I am glad you are back. Now take a backup!
"Those who expect to reap the blessings of freedom must, like men, undergo the fatigue of supporting it." Thomas Paine
-
- Joomla! Apprentice
- Posts: 6
- Joined: Sat Mar 17, 2012 4:15 am
Re: Reset Super User Access Rights
YOU ARE THE BEST. Thank you very much.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Mar 22, 2012 1:13 pm
Re: Reset Super User Access Rights
Phew thx a bunch for posting this, today ran into the same problem but got it fixed with thisoneski2006 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]
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
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?
I tried to solve it as before..
but i fount these settings as descried and the problem still here..
can any one help please?
-
- Joomla! Explorer
- Posts: 486
- Joined: Mon Jul 05, 2010 7:22 pm
- Location: UK
- Contact:
Re: Reset Super User Access Rights
@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.
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/
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
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
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
-
- Joomla! Explorer
- Posts: 486
- Joined: Mon Jul 05, 2010 7:22 pm
- Location: UK
- Contact:
Re: Reset Super User Access Rights
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.
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/
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
Thank you very much..
SOLVED!
SOLVED!
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
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
I just want to remove some fields "say Name" from the registration form..
How can i do it?
thanks
-
- Joomla! Explorer
- Posts: 486
- Joined: Mon Jul 05, 2010 7:22 pm
- Location: UK
- Contact:
Re: Reset Super User Access Rights
Have a look at
http://forum.joomla.org/viewtopic.php?f=624&t=684263
http://forum.joomla.org/viewtopic.php?f=624&t=684263
Shaun Maunder
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
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
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
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
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..
Text Filter Settings not saved..
I cant add any Custom HTML!!
Also JCE editor not working!!
I do not know how i can do..
-
- Joomla! Explorer
- Posts: 486
- Joined: Mon Jul 05, 2010 7:22 pm
- Location: UK
- Contact:
Re: Reset Super User Access Rights
@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.
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/
JMapMyLDAP extensions - Joomla! 2.5/3.1/3.2 LDAP Integration & SSO
http://shmanic.com/tools/jmapmyldap/
-
- Joomla! Intern
- Posts: 59
- Joined: Sun Jan 09, 2011 7:20 pm
- Contact:
Re: Reset Super User Access Rights
Thank you very much.
-
- Joomla! Apprentice
- Posts: 30
- Joined: Thu Jan 17, 2008 8:35 pm
Re: Reset Super User Access Rights
It really WORKS ! Many thanks.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]
-
- Joomla! Fledgling
- Posts: 2
- Joined: Mon Jun 27, 2011 5:46 am
Re: Reset Super User Access Rights
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]
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]
-
- Joomla! Fledgling
- Posts: 1
- Joined: Thu Aug 02, 2012 9:07 am
Re: Reset Super User Access Rights
Thank you very much..; Work for me
SOLVED!
SOLVED!
-
- Joomla! Apprentice
- Posts: 6
- Joined: Fri Jan 26, 2007 8:05 pm
Re: Reset Super User Access Rights
You're a lifesaver!
- humvee
- Joomla! Master
- Posts: 14704
- Joined: Wed Aug 17, 2005 10:27 pm
- Location: Kent, England
Re: Reset Super User Access Rights
[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.
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
- Joomla! Apprentice
- Posts: 41
- Joined: Wed Jun 30, 2010 6:42 pm
- Location: New York
- Contact:
Re: Reset Super User Access Rights
This worked in my case.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]
Thanks
-
- Joomla! Apprentice
- Posts: 12
- Joined: Sun Oct 10, 2010 1:29 am
- Contact:
Re: Reset Super User Access Rights
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.
-
- Joomla! Fledgling
- Posts: 1
- Joined: Tue Mar 27, 2012 6:49 am
Re: Reset Super User Access Rights
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!!! :-) )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]
Anyway, thanks again guys !
-
- Joomla! Fledgling
- Posts: 3
- Joined: Thu Jan 03, 2013 9:28 am
Re: Reset Super User Access Rights
Your solutions works like a charm!! Thanks!