UBB.threads PHP Forum Software Community Forums UBB.threads Bug Reports 7.5 - Can't delete groups

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):

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.

also that's not a valid query for the older version of mysql that we still 'support'

double whammy

This one needs a fix me thinks.

Fix...

In admin/dogroupmanage.php find:
Change to:

Yep! That did it! Thanks!

*takes a bow*

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

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.

Only 4.1? :sad panda:... I wonder when we start requiring modern webhosts lol...

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.

I am using MySQL 5.0.67 and php 5.2.8 you should get out of the 4's of anything

So just take all existing customers and throw them under the bus?

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.

lmao, when php.net says:

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..

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.

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

I have: MySQL client version: 4.1.22

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

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...