Previous Thread
Next Thread
Print Thread
Hop To
Joined: Sep 2006
Posts: 89
P
journeyman
journeyman
P Offline
Joined: Sep 2006
Posts: 89
Set up a new group, it is not yet active, trying now to delete it and get the following:

Control panel message
Script: /usr/www/users/packlite/forum/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 = 6 and USER_ID = (select distinct USER_ID from ubbt_USER_GROUPS where GROUP_ID <> 6 and USER_ID = uid)

Help appreciated, of course smile

packlite

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Do you happen to know what version of MySQL you are running? This was a subquery we snuck in, and your version of MySQL might not support it.

If you really need to get rid of it for now you can just remove it directly with the following SQL command.

SQL Query
delete from ubbt_GROUPS where GROUP_ID='6'

Joined: Sep 2006
Posts: 89
P
journeyman
journeyman
P Offline
Joined: Sep 2006
Posts: 89
Thanks Rick -- My version is MySQL 5.0.45.

Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
I am getting the same error with MySQL 5.0.67


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
0 members (), 396 guests, and 110 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)