1
-Lonestar-
Stupid Question
  • 2006/1/23 9:25

  • -Lonestar-

  • Just popping in

  • Posts: 22

  • Since: 2005/10/15


I changed the name of my Webmaster group, now I don't have access to the system module, because I did not add myself to the new group, what can I do? How can I edit the database or group to allow me to view the system module again?

2
mawi27
Re: Stupid Question
  • 2006/1/23 10:19

  • mawi27

  • Friend of XOOPS

  • Posts: 103

  • Since: 2006/1/1 1


Hi Lonestar,
connect to your MySQL database. You have to decide, if you feel more comfortable with a db backup

In the table YourPrefix_groups you find the groupid of your new webmaster group:
SELECT * FROM `xoops_groups`

In the table YourPrefix_users you find the uid of your user
SELECT * FROM `xoops_users`

In the table YourPrefix_groups_users_link you look for the highest linkid
SELECT * FROM `xoops_groups_users_link` ORDER BY `linkid`

Then add a line with the next free linkid, groupid and uid, you want to connect.
INSERT INTO `xoops_groups_users_link` VALUES (next linkid,webmaster groupid,you uid);
e.g.
[i]INSERT INTO `xoops_groups_users_link` VALUES (1, 1, 1);


(This is tested with 2.2.3 / I don't know if there are mayor changes in db structure to 2.0.x !)

Marco
--
Match Dart!
Darts Ranking, News, Videos, Forum and more

3
m0nty
Re: Stupid Question
  • 2006/1/23 10:24

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


what do you mean you didn't add yourself to the new group?

changing the name of the group shouldn't affect permissions of users in the group the webmaster uid=1 can't be removed from the webmaster group.

i can't tell what you are trying when you say you didn't add yourself to the *new* group?

how are you changing the name?

4
-Lonestar-
Re: Stupid Question
  • 2006/1/23 10:36

  • -Lonestar-

  • Just popping in

  • Posts: 22

  • Since: 2005/10/15


Um...I modified the group "Webmasters" and changed it to "Commanding Officer(s) and after I did that the system module was no longer available. I have been in myPHPadmin, and can't find where to edit it to get it back to normal. I tried navigating to /system/admin/preferences/main.php and it says access denied.

5
-Lonestar-
Re: Stupid Question
  • 2006/1/23 11:06

  • -Lonestar-

  • Just popping in

  • Posts: 22

  • Since: 2005/10/15


Well I have completely screwed up my database, I'm just going to delete the subdomain and try again, next time I'll create a new group before deleting one.

Login

Who's Online

351 user(s) are online (258 user(s) are browsing Support Forums)


Members: 0


Guests: 351


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits