You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports » 7.5.3 Deleting User Groups
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (Jake, A-GATE), 29 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 12/20/03
Posts: 4424
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 13
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#226971 - 06/01/09 05:09 PM 7.5.3 Deleting User Groups
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
I get this

Script: /home/riddle6/public_html/hprpg/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 = 12 and USER_ID = (select distinct USER_ID from ubbt_USER_GROUPS where GROUP_ID <> 12 and USER_ID = uid)
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#226973 - 06/01/09 05:30 PM Re: 7.5.3 Deleting User Groups [Re: AshtarRose]
pinkmelon Offline
journeyman 		Registered: 03/19/09
Posts: 64
I want to delete a user group but can not do it because there are 6 people in that group but when you click on the link showing there are 6 people it tells me there is nobody in that group
Top
#226975 - 06/01/09 06:05 PM Re: 7.5.3 Deleting User Groups [Re: AshtarRose]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Originally Posted By: AshtarRose
I get this

Script: /home/riddle6/public_html/hprpg/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 = 12 and USER_ID = (select distinct USER_ID from ubbt_USER_GROUPS where GROUP_ID <> 12 and USER_ID = uid)


This is one of the places where we had to use a 4.1 MySQL query to prevent people from deleting groups that had users in them that did not belong to any other group.

So, since you're getting that error it sounds like you're stuck with the ancient MySQL 4 wink. For now, what I'd do is just relabel the group to DELETED or something like that. If you really, really need it deleted and you are sure that nobody belongs to the group, I can give you a query to delete it manually.
Top
#226976 - 06/01/09 06:06 PM Re: 7.5.3 Deleting User Groups [Re: pinkmelon]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Originally Posted By: pinkmelon
I want to delete a user group but can not do it because there are 6 people in that group but when you click on the link showing there are 6 people it tells me there is nobody in that group


If you know the group id, then you can verify with the following query (just change # to the actual group id):

Sql Query:
select count(*) from ubbt_USER_GROUPS where GROUP_ID='#'
Top
#226978 - 06/01/09 06:23 PM Re: 7.5.3 Deleting User Groups [Re: Rick]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Pardon me Rick.
I was just trying this with 7.5.3. I have a custom group with one member.
My control panel states I have MYSQL 5.0.67.
When I try to delete the group I get the same error.
I even manually removed the member from the group but still get a fail on group delete. This one member is also in the default user group.
_________________________
Blue Man Group
Top
#226979 - 06/01/09 06:51 PM Re: 7.5.3 Deleting User Groups [Re: Ruben]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hmm, I'd double check what version of MySQL they actually have you running on. Run the query below from within the UBB.threads control panel:

Sql Query:
show variables


Towards the bottom, you're looking for where it shows the "Version"
Top
#226980 - 06/01/09 07:17 PM Re: 7.5.3 Deleting User Groups [Re: Rick]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
Here is what it says using the show query:
version 5.0.67-community
version_comment MySQL Community Edition (GPL)
version_compile_machine i686
version_compile_os redhat-linux-gnu
_________________________
Blue Man Group
Top
#226981 - 06/01/09 07:43 PM Re: 7.5.3 Deleting User Groups [Re: Ruben]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hmm, going to have to look into this a bit more. The query works on all of the 4.1+, 5.x MySQL installs that I just tested with (about 6 wink ), but failed in the two that are running 4.0.x
Top
#226982 - 06/01/09 07:48 PM Re: 7.5.3 Deleting User Groups [Re: Rick]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
I sent you a PM with my test board info.
If you have time.
_________________________
Blue Man Group
Top
#227006 - 06/03/09 04:21 PM Re: 7.5.3 Deleting User Groups [Re: AshtarRose]
Ruben Offline

Registered: 12/20/03
Posts: 4424
Loc: Lutz,FL
There is a temporary fix for this in a prior post HERE
But there is a caveat per Rick so read the whole post.
_________________________
Blue Man Group
Top
#227106 - 06/10/09 06:31 PM Re: 7.5.3 Deleting User Groups [Re: Ruben]
pinkmelon Offline
journeyman 		Registered: 03/19/09
Posts: 64
How can I be sure if there is someone in the group or not if I am told there is at one time and that there is not at another?
I moved everyone out of the group before trying to delete the group but it tells me there are 6 people...

I do not know what version of mysql is on the server
What version should I ask for 7.5.3?
Top
#227116 - 06/11/09 02:05 PM Re: 7.5.3 Deleting User Groups [Re: pinkmelon]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
From my earlier post:

If you know the group id, then you can verify with the following query (just change # to the actual group id):

Sql Query:
select count(*) from ubbt_USER_GROUPS where GROUP_ID='#'


You'll want to at least have MySQL 4.0, but 4.1+ is preferred.
Top
#231408 - 12/01/09 07:50 PM Re: 7.5.3 Deleting User Groups [Re: Rick]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
This is still a bug in 7.5.4.2

A better and working query would be:
Php Code:
	 // How many users are in this group and another group
		$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);


the other query will always return an empty set (0 rows) and always cause the group delete to fail..
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top