Ahh, must be because you have 0.7.3. Take a look at the structure of GridUser. That looks promising. I"m downloading 0.7.3 as I type...
Steve On Mar 2, 2012, at 10:20 AM, Clive Gould wrote: > 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 _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
