The same query worked for me, did you name your database something other than opensim?
- Chris/Fleep Chris M. Collins (SL/OS: Fleep Tuque) Center for Simulations & Virtual Environments Research (UCSIM) UCIT Instructional & Research Computing University of Cincinnati 406A Zimmer Hall 315 College Drive PO BOX 210088 Cincinnati, OH 45221-0088 [email protected] (513) 556-3018 http://ucsim.uc.edu On Fri, Mar 2, 2012 at 10:08 AM, Clive Gould <[email protected]> wrote: > Sorry didn't work for me - am I being dense? > > useraccounts was UserAccounts but... > > mysql> select a.firstname, a.lastname from UserAccounts a, presence b > where a.principalid = b.userid; > ERROR 1146 (42S02): Table 'opensim.presence' doesn't exist > > > On Fri, Mar 2, 2012 at 2:05 PM, Steven Salter <[email protected]> wrote: > > This seemed to work for me: > > > > select a.firstname, a.lastname from useraccounts a, presence b where > a.principalid = b.userid > > > > > > Steve > > > > On Mar 2, 2012, at 8:40 AM, Clive Gould wrote: > > > >> Hi > >> > >> Any idea what SQL query I need to use to find out how many users are > logged in? > >> > >> I've tried the query on the page > >> http://opensimulator.org/wiki/Useful_Queries and the table > >> opensim.agents no longer exists in the database schema > >> > >> i.e. Count the number of users presently logged in (same issues as > >> listing online users, above): > >> SELECT count(UUID) AS 'Users Online' FROM opensim.agents WHERE > >> agentonline = '1'; > >> > >> I've looked at the Online=TRUE in the opensim.GridUser table and this > >> returns 21, whereas the console reports 9 agents online > >> > >> Any suggestions most welcome > >> > >> Thanks > >> > >> Clive > >> > >> P.S I've just freed up some memory on our server and upgraded to 0.7.3 > >> and so far nothing has gone wrong > >> _______________________________________________ > >> Opensim-users mailing list > >> [email protected] > >> https://lists.berlios.de/mailman/listinfo/opensim-users > > > _______________________________________________ > Opensim-users mailing list > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users >
_______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
