Previous Thread
Next Thread
Print Thread
Hop To
#223524 03/03/2009 7:31 PM
Joined: Aug 2006
Posts: 583
old hand
old hand
Joined: Aug 2006
Posts: 583
I have two groups that I want to delete, but when I try to delete either one I get this error (note I modified the path name):

SQL Query
Script: .../xxx/public_html/xxx/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 = 7 and USER_ID = (select distinct USER_ID from ubbt_USER_GROUPS where GROUP_ID <> 7 and USER_ID = uid)

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
confirmed. Just made a bogus group and tried to delete with no members in group.
Same error.
Looks to me like the query is way off base.

Last edited by Ruben; 03/03/2009 8:32 PM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
also that's not a valid query for the older version of mysql that we still 'support'

double whammy wink

Joined: Aug 2006
Posts: 583
old hand
old hand
Joined: Aug 2006
Posts: 583
This one needs a fix me thinks.

Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
Fix...

In admin/dogroupmanage.php find:
PHP Code
and USER_ID = uid) 

Change to:
PHP Code
and USER_ID = 'uid') 

Joined: Aug 2006
Posts: 583
old hand
old hand
Joined: Aug 2006
Posts: 583
Originally Posted by DLWebmaestro
Fix...

In admin/dogroupmanage.php find:
PHP Code
and USER_ID = uid) 

Change to:
PHP Code
and USER_ID = 'uid') 

Yep! That did it! Thanks!

Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
*takes a bow*

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
I think for 8.0 we're going to have to require MySQL 4.1. The change to the query to make it work actually defeats the purpose of the query wink

Basically we check to make sure no users belong to that group that do not belong to any other group (otherwise they end up orphaned). There's no simple way to do this without a subselect other than grabbing every user in that group and checking each individual one to see if they are not in another group. That would be very bad if the group had many users.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Only 4.1? :sad panda:... I wonder when we start requiring modern webhosts lol...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
I guess I don't understand the response from Rick.
For me using MYSQL 4.1.22
I get the same error as Basil without DL's Mod.

Last edited by Ruben; 03/04/2009 6:22 PM. Reason: corrected version number

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 464
Likes: 1
M
Addict
Addict
M Offline
Joined: Jun 2006
Posts: 464
Likes: 1
I am using MySQL 5.0.67 and php 5.2.8 you should get out of the 4's of anything smile


Happy Customer !!!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by Mors
I am using MySQL 5.0.67 and php 5.2.8 you should get out of the 4's of anything smile
So just take all existing customers and throw them under the bus?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
Yeah, everyone should run out and update every time a new release of something comes out regardless of if you can, have time, or just have nothing better to do.

Most everything, including UBB, always has lots of bugs in it and most people do not feel like upgrading many things as they just do not wish to have the hassle of fixing bugs or spending tons of time waiting for fixes.

Why "upgrade" if it works? Yes I know I will be opening a can of worms here on this one.

Oh yeah, lets all upgrade from XP to vista. Good luck on finding drivers for most everything you have if your going to 64 bit.

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
lmao, when php.net says:

Quote
Support for PHP 4 has been discontinued since 2007-12-31. Please consider upgrading to PHP 5.2. The release below is the last PHP 4 release.
i see no reason to not be in the 5s for php..

and mysql 5x has been official since 2003 ?

and apache 2x is also mature, it would be a one time thing to using better versions of each.. so 'every time' is really a one shot dealio, imo..

now, it might be debateable as to 'time' or 'if you can' -- i'll give you that.. but 'every time' is a stretch..

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
I agree SD.
My comment is based on existing ubb customers like myself on a hosting plan that does not give you much control over what versions you can use. At lunar I am using php 5 and MySQL 5 but not Apache 2. I can elect to change to Apache2 if needed.

My old windows host is still on version 4 as of today.



Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
yes, i can understand that peeps are limited by their hosting plans as to upgrades..

but if there is any control over it that you can exert, it would be to get (one time shot) into php5, mysql5, apache2

imho

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
I have: MySQL client version: 4.1.22

Trying to get imotionhosting.com to upgrade is like pulling teeth sometimes.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
At least they're 4.1... I see a lot that are still running 4.0...

PHP5/MySQL5 would be a requirement for me if I was looking for a host...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

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 (Havenofsobriety), 522 guests, and 99 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)