Previous Thread
Next Thread
Print Thread
Hop To
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
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
R
Former Developer
Former Developer
R Offline
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.

SQL Query
delete from ubbt_GROUPS
where GROUP_ID = '#'

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
admin/dogroupmanage.php

find
PHP Code
	 // How many users are in this group and another group
		$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:

PHP Code
	 // SD:Mod fix the query to do what it is supposed to versus die ;)
		// 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); 

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 frown

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Originally Posted by Sirdude
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 frown

Wasn't for lack of trying on your part. You just needed to smack me upside the head a bit harder wink

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
no probs Rick.. you are beezie with v8 too laugh

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Have the SD fix in for 7.5.6 smile

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
yay!

1 less thing on 'my list' laugh

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 smile

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 smile


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)