Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
1 registered members (Gizmo), 57 guests, and 407 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
JAISP
JAISP
Pennsylvania
Posts: 1,318
Joined: February 2007
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 18
M4TT 12
FREAK 11
Ruben 8
isaac 4
mmkk 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
7.5 - Can't delete groups #223524
03/03/09 06:31 PM
03/03/09 06:31 PM
Joined: Aug 2006
Posts: 727
New Mexico
Basil Offline OP
old hand
Basil  Offline OP
old hand
Joined: Aug 2006
Posts: 727
New Mexico
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)

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."
Re: 7.5 - Can't delete groups [Re: Basil] #223528
03/03/09 06:52 PM
03/03/09 06:52 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
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/09 07:32 PM.

Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: 7.5 - Can't delete groups [Re: Ruben] #223535
03/03/09 08:21 PM
03/03/09 08:21 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
also that's not a valid query for the older version of mysql that we still 'support'

double whammy wink

Re: 7.5 - Can't delete groups [Re: SD] #223537
03/03/09 09:45 PM
03/03/09 09:45 PM
Joined: Aug 2006
Posts: 727
New Mexico
Basil Offline OP
old hand
Basil  Offline OP
old hand
Joined: Aug 2006
Posts: 727
New Mexico
This one needs a fix me thinks.

Re: 7.5 - Can't delete groups [Re: Basil] #223542
03/03/09 11:58 PM
03/03/09 11:58 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline
enthusiast
DLWebmaestro  Offline
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
Fix...

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


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

Re: 7.5 - Can't delete groups [Re: DLWebmaestro] #223543
03/04/09 01:41 AM
03/04/09 01:41 AM
Joined: Aug 2006
Posts: 727
New Mexico
Basil Offline OP
old hand
Basil  Offline OP
old hand
Joined: Aug 2006
Posts: 727
New Mexico
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!

Re: 7.5 - Can't delete groups [Re: Basil] #223564
03/04/09 11:24 AM
03/04/09 11:24 AM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline
enthusiast
DLWebmaestro  Offline
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
*takes a bow*

Re: 7.5 - Can't delete groups [Re: DLWebmaestro] #223566
03/04/09 01:50 PM
03/04/09 01:50 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
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.

Re: 7.5 - Can't delete groups [Re: Rick] #223594
03/04/09 05:03 PM
03/04/09 05:03 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
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!
Re: 7.5 - Can't delete groups [Re: Gizmo] #223595
03/04/09 05:20 PM
03/04/09 05:20 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
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/09 05:22 PM. Reason: corrected version number

Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: 7.5 - Can't delete groups [Re: Ruben] #223596
03/04/09 05:59 PM
03/04/09 05:59 PM
Joined: Jun 2006
Posts: 472
So. California
Mors Offline
addict
Mors  Offline
addict
Joined: Jun 2006
Posts: 472
So. California
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 !!!
Re: 7.5 - Can't delete groups [Re: Mors] #223598
03/04/09 06:07 PM
03/04/09 06:07 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
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
Re: 7.5 - Can't delete groups [Re: Ruben] #223608
03/04/09 07:31 PM
03/04/09 07:31 PM
Joined: Feb 2007
Posts: 1,318
Pennsylvania
JAISP Offline
veteran
JAISP  Offline
veteran
Joined: Feb 2007
Posts: 1,318
Pennsylvania
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.

Re: 7.5 - Can't delete groups [Re: JAISP] #223631
03/05/09 01:16 PM
03/05/09 01:16 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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..

Re: 7.5 - Can't delete groups [Re: SD] #223633
03/05/09 01:25 PM
03/05/09 01:25 PM
Joined: Dec 2003
Posts: 5,827
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,827
Lutz,FL
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
Re: 7.5 - Can't delete groups [Re: Ruben] #223635
03/05/09 01:29 PM
03/05/09 01:29 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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

Re: 7.5 - Can't delete groups [Re: SD] #227070
06/06/09 01:36 PM
06/06/09 01:36 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline
journeyman
TGCsanderson  Offline
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
I have: MySQL client version: 4.1.22

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

Re: 7.5 - Can't delete groups [Re: TGCsanderson] #227072
06/06/09 01:55 PM
06/06/09 01:55 PM
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
Gizmo Online tapedshut
UBB.threads Developer
Gizmo  Online Tapedshut
UBB.threads Developer
Joined: Jun 2006
Posts: 16,788
Portland, OR; USA
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.
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!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)