|
Joined: Jan 2007
Posts: 72
journeyman
|
journeyman
Joined: Jan 2007
Posts: 72 |
Control panel message Script: /var/www/vhosts/softrak.com/httpdocs/ubbthreads/admin/dogroupmanage.php Line#: 81 SQL Error: Unknown column 'uid' in 'where clause' SQL Error #: 1054 Query: select USER_ID as uid from ubbt_USER_GROUPS where GROUP_ID = 11 and USER_ID = (select distinct USER_ID from ubbt_USER_GROUPS where GROUP_ID <> 11 and USER_ID = uid)
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
What version are you using? There was a issue on the old old version that would not delete groups. I myself am using v7.5 but I have not deleted a group in a while.
But I would search for any members that might be in the group in question first. Remove them from the group.
Then attempt to delete the group.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jan 2005
Posts: 186
member
|
member
Joined: Jan 2005
Posts: 186 |
I have 7.5.5 and removed all the users from a group and still encountered the same error as Softrak.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
That query still needs to be fixed. For now, you can manually delete if you'd like, just make sure you use the proper group id in place of the # sign.
delete from ubbt_GROUPS
where GROUP_ID = '#'
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
admin/dogroupmanage.php find $query = "
select USER_ID as uid
from {$config['TABLE_PREFIX']}USER_GROUPS
where GROUP_ID = ?
and USER_ID =
(select distinct USER_ID
from {$config['TABLE_PREFIX']}USER_GROUPS
where GROUP_ID <> ?
and USER_ID = uid)
";
$sth = $dbh->do_placeholder_query($query,array($k,$k),__LINE__,__FILE__);
$in_other = $dbh->total_rows($sth);
replace with: $query = "
select COUNT(USER_ID)
from {$config['TABLE_PREFIX']}USER_GROUPS
where GROUP_ID = ?
and USER_ID IN
(select distinct USER_ID
from {$config['TABLE_PREFIX']}USER_GROUPS
where GROUP_ID <> ?)
";
$sth = $dbh->do_placeholder_query($query,array($k,$k),__LINE__,__FILE__);
list($in_other) = $dbh->fetch_array($sth);
note: you can leave out "SD:Mod", but that is for my notes when i've changed stuff.. i've posted this fix elsewhere on this board, but it hasn't made it into 7.5.5 yet
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
note: you can leave out "SD:Mod", but that is for my notes when i've changed stuff.. i've posted this fix elsewhere on this board, but it hasn't made it into 7.5.5 yet Wasn't for lack of trying on your part. You just needed to smack me upside the head a bit harder
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
no probs Rick.. you are beezie with v8 too
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Have the SD fix in for 7.5.6
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
yay! 1 less thing on 'my list'
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
The Delete works But. . . 7.5.6 You can see you have your static Groups upto Number 5 If you create five more giving you 10 Groups then delete say number 7 it goes Qwerk ! If i add a new group it goes in at number 7 and not number 11. I was making new user groups and wanted them to show ascending. User - Month Subscription User - 6 Month Subscription User - 12 Month Subscription. I had to make a bogus group so that filled space 7 and then i had the true 11, 12, 13 Just a Heads up
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
|
Joined: Dec 2003
Posts: 6,566 Likes: 78
|
Joined: Dec 2003
Posts: 6,566 Likes: 78 |
So I guess we are back to square one? Don't delete groups, Just edit and add?
Sounds like classic issues to me.
Blue Man Group There is no such thing as stupid questions. Just stupid answers
|
|
|
|
Joined: Jul 2006
Posts: 4,057
|
Joined: Jul 2006
Posts: 4,057 |
group 7 came back with the old group icon too lol
Its a head up.
BOOM !! Version v7.6.1.1 People who inspire me Isaac ME Gizmo
|
|
|
1 members (Ruben),
1,277
guests, and
207
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|