|
|
Joined: Sep 2007
Posts: 73 Likes: 1
Journeyman
|
|
Journeyman
Joined: Sep 2007
Posts: 73 Likes: 1 |
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)
|
|
|
|
|
Joined: Mar 2009
Posts: 64
journeyman
|
|
journeyman
Joined: Mar 2009
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
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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  . 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.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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):
select count(*) from ubbt_USER_GROUPS where GROUP_ID='#'
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
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
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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: Towards the bottom, you're looking for where it shows the "Version"
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
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
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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 ), but failed in the two that are running 4.0.x
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
I sent you a PM with my test board info.
If you have time.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,633 Likes: 85 |
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
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Mar 2009
Posts: 64
journeyman
|
|
journeyman
Joined: Mar 2009
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?
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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):
select count(*) from ubbt_USER_GROUPS where GROUP_ID='#'
You'll want to at least have MySQL 4.0, but 4.1+ is preferred.
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
This is still a bug in 7.5.4.2 A better and working query would be: $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..
|
|
|
|
0 members (),
80
guests, and
88
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
