mysql> use opensim Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed mysql> show tables; +-------------------+ | Tables_in_opensim | +-------------------+ | Avatars | | Friends | | GridUser | | UserAccounts | | assets | | auth | | estate_groups | | estate_managers | | estate_map | | estate_settings | | estate_users | | estateban | | inventoryfolders | | inventoryitems | | land | | landaccesslist | | migrations | | primitems | | prims | | primshapes | | regionban | | regions | | regionsettings | | regionwindlight | | spawn_points | | terrain | | tokens | +-------------------+ 27 rows in set (0.00 sec) 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 Maybe because this is 0.7.3 ?? Thanks Clive On Fri, Mar 2, 2012 at 3:11 PM, Fleep Tuque <[email protected]> wrote: > 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
