Benutzergruppen kaputt
Verfasst: 06.02.2007 13:07
joa hi,
ich hab ein problem und zwar kommt wenn man unter benutzergruppen auf information anzeigen geht folgende fehlermeldung:
--------------------------------------------------------------------------------
Could not get moderator information
DEBUG MODE
SQL Error : -1 ERROR: column reference "group_id" is ambiguous
SELECT g.group_moderator, g.group_type, auth_mod FROM milesnoctis_groups g, milesnoctis_auth_access WHERE g.group_id = 35 AND group_id = g.group_id UNION ( SELECT g.group_moderator, g.group_type, NULL FROM milesnoctis_groups g WHERE g.group_id = 35 AND NOT EXISTS ( SELECT group_id FROM milesnoctis_auth_access aa WHERE group_id = g.group_id ) ) ORDER BY auth_mod DESC
Line : 444
File : groupcp.php
--------------------------------------------------------------------------------
weis einer woran das liegt / wie ich das beheben kann?
EDIT: hab die groupcp.php ma gelöscht und neu hochgeladen. jez kommt das hier:
--------------------------------------------------------------------------------
Could not get moderator information
DEBUG MODE
SQL Error : -1 ERROR: relation "aa" does not exist
SELECT g.group_moderator, g.group_type, aa.auth_mod FROM milesnoctis_groups g, milesnoctis_auth_access aa WHERE g.group_id = 35 AND aa.group_id = g.group_id UNION ( SELECT g.group_moderator, g.group_type, NULL FROM milesnoctis_groups g WHERE g.group_id = 35 AND NOT EXISTS ( SELECT aa.group_id FROM milesnoctis_auth_access aa WHERE aa.group_id = g.group_id ) ) ORDER BY aa.auth_mod DESC
Line : 444
File : groupcp.php
--------------------------------------------------------------------------------
EDIT²: habs so geschafft:
http://www.phpbb.de/viewtopic.php?t=141 ... does+exist
mfG
MSN
ich hab ein problem und zwar kommt wenn man unter benutzergruppen auf information anzeigen geht folgende fehlermeldung:
--------------------------------------------------------------------------------
Could not get moderator information
DEBUG MODE
SQL Error : -1 ERROR: column reference "group_id" is ambiguous
SELECT g.group_moderator, g.group_type, auth_mod FROM milesnoctis_groups g, milesnoctis_auth_access WHERE g.group_id = 35 AND group_id = g.group_id UNION ( SELECT g.group_moderator, g.group_type, NULL FROM milesnoctis_groups g WHERE g.group_id = 35 AND NOT EXISTS ( SELECT group_id FROM milesnoctis_auth_access aa WHERE group_id = g.group_id ) ) ORDER BY auth_mod DESC
Line : 444
File : groupcp.php
--------------------------------------------------------------------------------
weis einer woran das liegt / wie ich das beheben kann?
EDIT: hab die groupcp.php ma gelöscht und neu hochgeladen. jez kommt das hier:
--------------------------------------------------------------------------------
Could not get moderator information
DEBUG MODE
SQL Error : -1 ERROR: relation "aa" does not exist
SELECT g.group_moderator, g.group_type, aa.auth_mod FROM milesnoctis_groups g, milesnoctis_auth_access aa WHERE g.group_id = 35 AND aa.group_id = g.group_id UNION ( SELECT g.group_moderator, g.group_type, NULL FROM milesnoctis_groups g WHERE g.group_id = 35 AND NOT EXISTS ( SELECT aa.group_id FROM milesnoctis_auth_access aa WHERE aa.group_id = g.group_id ) ) ORDER BY aa.auth_mod DESC
Line : 444
File : groupcp.php
--------------------------------------------------------------------------------
EDIT²: habs so geschafft:
http://www.phpbb.de/viewtopic.php?t=141 ... does+exist
mfG
MSN