user groups

[Blisk]

I have not added a new group a long time, but today I did add in ACP a testgroup and In ACP is all OK, but when I go to link to manage members of this group, I get
"That user group does not exist"

What can be wrong?
Can someone help me'
¢¦

[AmigaLink]

There you probably become an error in your groupcp.php
Check the hacks which you installed there.

[Blisk]

i did checked that, last mod I installed was a move users between a groups, from Oxpus, and I uninstall that MOD, but it is the same.
i checked a mysql tables and grooup is in mysql base, id of grizup when i click to add members is right but still, the same message.
"That user group does not exist"
And I can open and edit all old groups normally!

[oxpus]

Use the DB Maintenance MOD to check the group tables and retry...

[Blisk]

I tested some more and made a new group, but it is the same.

Checking tables:

* phpbb_auth_access: OK
* phpbb_banlist: OK
* phpbb_categories: OK
* phpbb_config: OK
* phpbb_confirm: OK
* phpbb_disallow: OK
* phpbb_forum_prune: OK
* phpbb_forums: OK
* phpbb_groups: OK
* phpbb_posts: OK
* phpbb_posts_text: OK
* phpbb_privmsgs: OK
* phpbb_privmsgs_text: OK
* phpbb_ranks: OK
* phpbb_search_results: OK
* phpbb_search_wordlist: OK
* phpbb_search_wordmatch: OK
* phpbb_sessions: OK
* phpbb_smilies: OK
* phpbb_themes: OK
* phpbb_themes_name: OK
* phpbb_topics: OK
* phpbb_topics_watch: OK
* phpbb_user_group: OK
* phpbb_users: OK
* phpbb_vote_desc: OK
* phpbb_vote_results: OK
* phpbb_vote_voters: OK
* phpbb_words: OK

[oxpus]

Not the optimation or reparing!
Run the User- and Group Check!

[Blisk]

No it is the same!
"That user group does not exist"
_____________

Disabling board

Delaying three seconds to allow database actions to finish...

Checking for missing anonymous account

Nothing to do :-)

Checking for incorrect pending information

Nothing to do :-)

Checking for users with multiple or no single user group

Found users with multiple single user groups:

* Resolving users to group: 2,8
* Removing groups: 2,9
* Removing user to group connection: 2,9

Recreating single user groups for user: 2,8

Checking for invalid group moderator settings

Nothing to do :-)

Checking group membership of moderators

Nothing to do :-)

Removing invalid user data in user-group-table

Nothing to do :-)

Removing empty groups

Nothing to do :-)

Removing invalid group data in user-group-table

3 affected datasets

Checking for invalid ranks

Nothing to do :-)

Checking for invalid themes settings

Nothing to do :-)

Checking for invalid theme name data

Nothing to do :-)

Checking for invalid language settings

Nothing to do :-)

Removing invalid ban data

Nothing to do :-)

Enabling board

Done

[oxpus]

Hm, the groups are simple be missing.
The groupcp.php haves no error...

...

Please run this sql with phpmyadmin to test for a result:

Code: Alles auswählen

SELECT group_moderator, group_type
		FROM phpbb_groups 
		WHERE g.group_id = 1204;

This must display the group moderator and a number (the group type) from the test group "testiram".
If this works, the auth table may be not written correctly so the admin/admin_groups.php produces the error...

[Blisk]

Here is the result

Error

SQL query: Documentation

SELECT group_moderator, group_type
FROM phpbb_groups
WHERE g.group_id =1204
LIMIT 0 , 30;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near '; ' at line 2

[oxpus]

Oh sorry, little bug. Try this one:

Code: Alles auswählen

SELECT group_moderator, group_type
FROM phpbb_groups
WHERE group_id =1204;

[Blisk]

np.
i tryed this again and here is result!

Code: Alles auswählen

Error

SQL query: Documentation

SELECT group_moderator, group_type
FROM phpbb_groups
WHERE group_id =1204
LIMIT 0 , 30;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near '; ' at line 2

But when I removed ; from the line I get

Code: Alles auswählen

Showing rows 0 - 0 (1 total, Query took 0.0007 sec)
SQL query: SELECT group_moderator, group_type
FROM phpbb_groups
WHERE group_id =1204
LIMIT 0 , 30

[oxpus]

Okay, the Query works.
So please attach the admin_groups.php and admin_up_auth.php to take a look for the group permission handling...

[Blisk]

ok here it is.

[oxpus]

These files seams to be okay...
Hm...
What have you installed after you had created the last "working" group?

[Blisk]

I found a problem, I did a search in database a differencies and found this
in table
group_single_user
all groups have num 0 or 1
but all groups I made recently have 5
if i change this 5 to 0 than it works ok.
So something make this value 5, can we finnd what it is and repair?

[oxpus]

Oh yes, I found:
You have installed a MOD with "group_allow_weblog" and insert a peace of code in the INSERT INTO SQL Statement for creating a new group at the wrong place.
So here the fixed file in the attachment.

Little explain:
The value "group_single_user" defines a group like it is or just for an entry for for user permissions for one user.
If this is set to another value like 0 or 1 the group will malfunction on several points. And this is the reason, that these wrong groups will not work on groucp for you...

[Blisk]

>thank you, now works ok.
i hope I wan't bother you anymore for some time.

thanks again.