Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (capnbob, JetStar, GregK), 39 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/08/06
Posts: 1465
Top Posters (30 Days)
Ruben 50
DennyP 24
Gizmo 24
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
SD 9
drkknght00 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#165447 - 10/09/06 01:05 PM [FIXED] Group management
MMG Offline
journeyman
Registered: 06/07/06
Posts: 55
I imported my forum from classic 7.2. When I go into the group editor I see the correct number of people in the group. But when I click on the number I receive the following message:

Control panel message
select COUNT(t1.USER_ID) from ubbt_USERS as t1, ubbt_USER_PROFILE as t2, ubbt_USER_DATA as t3, ubbt_USER_GROUPS as t4 WHERE t1.USER_ID <> '1' and t1.USER_ID = t2.USER_ID and t1.USER_ID = t3.USER_ID and t1.USER_ID = t4.USER_ID and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5) and t4.GROUP_ID IN (5)GROUP BY t1.USER_ID ORDER BY t2.USER_DISPLAY_NAME ASC

Unknown column 't2.USER_DISPLAY_NAME' in 'order clause'


Edited by Rick (10/12/06 01:21 PM)
Top
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."
#165449 - 10/09/06 01:15 PM Re: Group management [Re: MMG]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hmm, I think this may have been something leftover from the beta version. Can you check like 146 of admin/membersearch.php, it should read:

$orderby = "t1.USER_DISPLAY_NAME";
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
Yesterday at 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33840 Topics
181693 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image