Previous Thread
Next Thread
Print Thread
Hop To
[FIXED in RC1] Member search - sort by last Online
#3477 09/18/2006 10:20 PM
Joined: Jul 2006
Posts: 47
journeyman
OP Offline
journeyman
Joined: Jul 2006
Posts: 47
This is a control panel message error produced after sorting by LAST ONLINE in my control panel (Member Management).
Probably another data base field missing.


Control panel message
select COUNT(t1.USER_ID) from advp_USERS as t1, advp_USER_PROFILE as t2, advp_USER_DATA as t3, advp_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 ORDER BY t1.USER_LAST_ON ASC

Unknown column 't1.USER_LAST_ON' in 'order clause'


Last edited by Rick; 09/19/2006 2:52 PM.
Re: Member search - sort by last Online
Markus_003 #3502 09/19/2006 2:52 PM
Joined: Jun 2006
Posts: 9,243
Former Developer
Offline
Former Developer
Joined: Jun 2006
Posts: 9,243
Several of the sort options resulted in errors. Have all of these patched up for RC1.

Re: Member search - sort by last Online
Rick #3543 09/20/2006 9:14 AM
Joined: Jul 2006
Posts: 47
journeyman
OP Offline
journeyman
Joined: Jul 2006
Posts: 47
Thank you.


Link Copied to Clipboard
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
allow photos to a PM?
by Morgan - 04/03/2020 4:24 PM
SFS Login Detection Issue [NotABug]
by Ruben - 03/29/2020 1:16 PM
possible bug?
by Morgan - 03/29/2020 5:18 AM
Who's Online Now
1 members (1 invisible), 69 guests, and 39 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4