i'm having problems accessing the webmaster group.. everytime i click the group to modify i get a server 500 error.. this is the same when i try to edit users..

I'm wondering if it's cos i updated a few tables from my old site..

ie. i have 198 members so far!!

in Table xoops_group_permission

i have 364 rows in this table, some as follows..

`xoops_group_permission` VALUES (3786, 1, 68, 1, 'module_read')

`xoops_group_permission` VALUES (4192, 5, 25, 1, 'block_read')

`xoops_group_permission` VALUES (3785, 1, 68, 1, 'module_admin')

`xoops_group_permission` VALUES (3704, 1, 11, 1, 'system_admin')

in the next Table xoops_groups_users_link I have 593 rows!!

some as follows >

`xoops_groups_users_link` VALUES (1, 1, 1);
`xoops_groups_users_link` VALUES (2, 2, 1);
`xoops_groups_users_link` VALUES (3, 2, 3);
`xoops_groups_users_link` VALUES (4, 2, 4);
`xoops_groups_users_link` VALUES (8, 2, 6);
`xoops_groups_users_link` VALUES (6, 2, 5);
`xoops_groups_users_link` VALUES (7, 4, 3);
`xoops_groups_users_link` VALUES (9, 2, 7);
`xoops_groups_users_link` VALUES (10, 2, 8);
`xoops_groups_users_link` VALUES (593, 4, 1);

--------------------------------------------------

Could somebody explain exactly what these values are for in both tables and if they are set wrong, would this account for the errors i'm getting when trying to edit users and modify the web master group?

Nothing in XOOPS should set off a server error. At most it will display a blank screen, which will show an error if PHP debug is turned on.

Group permissions table has the following fields:
Permission ID (auto_increment)
Group ID (ID of group to set permission for)
Item ID (Not sure, what this is - possibly block or something)
Module ID (ID of module to set permission for)
Permission name (Permission type)

User_link holds the relation between users and groups - that is, who is in which groups.

thanks m8,

i got it workin earlier after i posted with the user_links table.. i can now access the web master group edit.. except now i can't edit the registered users section..

cud anybody tell me the MySQL tables to update and with what.. gotta be in groups_users_links..

and the groups_permissions.. but i haven't edited that table to clear the useless rows..

i was wondering if i empty the groups_permissions table completely, would that reset all the group permissions to zero access? then if i manually edit each group and re tick the boxes would that work?

also.. I'm still unable to click the edit user in admin.. would clearing the permissions table and reticking the boxes cure that problem?

Beware so that you don't remove the rights to yourself to give back the permissions - so don't even think about touching the permissions for group id '1'

ok, well that's all done.. now i have a clean groups_permissions table..

but that didn't cure the problem :(

I still can't access the edit user function.. (i can if i find the user and then click edit) but not from the floating menu etc.. which means i can't manually add a user myself to save from having to register..

the 2nd problem is i can't modify the registered users group.. i click on it and i get an error 500: internal server error, altho this is a page not found.. i don't get white pages on this server it just gives me that message..