Yes. result below mysql> select * from om_timezone where id = 42; +----+---------------------+---------------------+-----------+--------------------------------------------+----------+ | id | ical | inserted | jname | label | order_id | +----+---------------------+---------------------+-----------+--------------------------------------------+----------+ | 42 | America/Los_Angeles | 2013-08-22 04:15:54 | Etc/GMT-8 | Vancouver, Portland, Las Vegas, California | 32 | +----+---------------------+---------------------+-----------+--------------------------------------------+----------+ 1 row in set (0.00 sec)
On Thu, Aug 22, 2013 at 10:03 PM, Maxim Solodovnik <[email protected]>wrote: > have you restarted OM? > what is the result of following SQL: select * from om_timezone where id = > 42; > > > > On Fri, Aug 23, 2013 at 12:00 PM, John Tran <[email protected]> wrote: > >> No change, it still the same. Samoa TZ still at the top or default. >> >> >> On Thu, Aug 22, 2013 at 9:50 PM, Maxim Solodovnik >> <[email protected]>wrote: >> >>> update om_timezone set order_id = 32 where id = 42; >>> >>> >>> On Fri, Aug 23, 2013 at 11:49 AM, John Tran <[email protected]>wrote: >>> >>>> Maxim >>>> >>>> From the below: >>>> | 39 | Alberta, Colorado, >>>> Phoenix | 25 | >>>> | 40 | Canada (Alberta), Mexico (Chihuahua), USA >>>> (Colorado) | 26 | >>>> | 41 | Canada (northeastern British Columbia), Mexico (Sonora), USA >>>> (Arizona) | 26 | >>>> | 42 | Vancouver, Portland, Las Vegas, >>>> California | 27 | >>>> | 43 | Anchorage, Fairbanks, >>>> Juneau | 28 | >>>> >>>> If my choice of tZ is 42, would I my command be: >>>> >>>> update om_timezone set order_id = 27 where id = 44; >>>> >>>> >>>> On Thu, Aug 22, 2013 at 9:28 PM, Maxim Solodovnik <[email protected] >>>> > wrote: >>>> >>>>> stop OM >>>>> >>>>> open connection to your database using anything you like >>>>> run following >>>>> select id, label, order_id from om_timezone; >>>>> this will give you the full list on timezones >>>>> >>>>> update om_timezone set order_id = 32 where id = 41; >>>>> >>>>> to set highest order for your timezone >>>>> >>>>> start OM >>>>> >>>>> >>>>> On Fri, Aug 23, 2013 at 11:19 AM, John Tran <[email protected]>wrote: >>>>> >>>>>> Oh. I am using MySQL. >>>>>> >>>>>> >>>>>> On Thu, Aug 22, 2013 at 9:17 PM, Maxim Solodovnik < >>>>>> [email protected]> wrote: >>>>>> >>>>>>> unfortunately it is not enough :( >>>>>>> What DB are you using? >>>>>>> >>>>>>> >>>>>>> On Fri, Aug 23, 2013 at 11:15 AM, John Tran >>>>>>> <[email protected]>wrote: >>>>>>> >>>>>>>> Not in DB, i wouldnt' know how. I make the change in >>>>>>>> usr/lib/red5/webapps/ >>>>>>>> openmeetings/languages/timezones.xml and move GMT-8 to the top of >>>>>>>> the list, above Samoa and change the orderId to 0(zero) and restart >>>>>>>> red5 >>>>>>>> >>>>>>>> >>>>>>>> On Thu, Aug 22, 2013 at 9:12 PM, Maxim Solodovnik < >>>>>>>> [email protected]> wrote: >>>>>>>> >>>>>>>>> did you moved it in timezones.xml or in the DB? >>>>>>>>> have you just change the line? or also change "orderId" value? >>>>>>>>> >>>>>>>>> >>>>>>>>> On Fri, Aug 23, 2013 at 11:04 AM, John Tran <[email protected] >>>>>>>>> > wrote: >>>>>>>>> >>>>>>>>>> I am on GMT-8. I did move it to the top of the list and changed >>>>>>>>>> it to 0(zero). It did not help. Still showed Samoa as the first >>>>>>>>>> on the >>>>>>>>>> list as default. >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Thu, Aug 22, 2013 at 9:00 PM, Maxim Solodovnik < >>>>>>>>>> [email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> First one is selected in case timezone offset was not retrieved >>>>>>>>>>> or timezone with your offset was not found. >>>>>>>>>>> Also you can check browser javascript console (to ensure there >>>>>>>>>>> were no errors) >>>>>>>>>>> >>>>>>>>>>> What Time Zone do you have? >>>>>>>>>>> To move you timezone on top you might need to edit database and >>>>>>>>>>> change orderId of your time zone to have lowest number >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> On Fri, Aug 23, 2013 at 10:50 AM, John Tran < >>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>> >>>>>>>>>>>> Maxim >>>>>>>>>>>> >>>>>>>>>>>> It does not seem to pick it up for whatever reason. When I do >>>>>>>>>>>> an invite an pick a "period" option, it default to GMT+13 (Samoa), >>>>>>>>>>>> first >>>>>>>>>>>> one on the list. >>>>>>>>>>>> >>>>>>>>>>>> -john- >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Thu, Aug 22, 2013 at 8:46 PM, Maxim Solodovnik < >>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> according to the code: >>>>>>>>>>>>> Timezone offset is taking from your browser >>>>>>>>>>>>> Timezone with your timezone offset is preselected >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> On Fri, Aug 23, 2013 at 7:52 AM, John Tran < >>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks Lee. Already tried that. >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> On Thu, Aug 22, 2013 at 4:45 PM, Lee Saunders < >>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>> >>>>>>>>>>>>>>> Go here: \webapps\openmeetings\languages\timezones.xml. You >>>>>>>>>>>>>>> can change the order in that. >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> On Fri, Aug 23, 2013 at 12:04 AM, Lee Saunders < >>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> I could find the default time zone in Administration > >>>>>>>>>>>>>>>> Configuration > Number 30 in the list. >>>>>>>>>>>>>>>> There is no selection box to change it though. >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> On Thu, Aug 22, 2013 at 9:46 PM, John Tran < >>>>>>>>>>>>>>>> [email protected]> wrote: >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> Does one know how to change or where to go to change the >>>>>>>>>>>>>>>>> default timezone shown in the invitation popup. Somewhere in >>>>>>>>>>>>>>>>> archive >>>>>>>>>>>>>>>>> someone said moving the intended timzone to the top of the >>>>>>>>>>>>>>>>> list in >>>>>>>>>>>>>>>>> /usr/lib/red5/webapps/openmeetings/languages/timezones.xml >>>>>>>>>>>>>>>>> worked for >>>>>>>>>>>>>>>>> them. It didn't work for me when I tried it, even when I >>>>>>>>>>>>>>>>> changed the >>>>>>>>>>>>>>>>> orderId to 0 >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>> -- >>>>>>>>>>>>>>>>> -john- >>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> >>>>>>>>>>>>>> -- >>>>>>>>>>>>>> jt >>>>>>>>>>>>>> ________________________________ >>>>>>>>>>>>>> John Tran >>>>>>>>>>>>>> Northern California, CA >>>>>>>>>>>>>> [email protected] >>>>>>>>>>>>>> ICQ IM: 27741710 >>>>>>>>>>>>>> AOL IM: find1ngj0hn >>>>>>>>>>>>>> Yahoo! IM: findingj0hn >>>>>>>>>>>>>> MSN IM: [email protected] >>>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> WBR >>>>>>>>>>>>> Maxim aka solomax >>>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> jt >>>>>>>>>>>> ________________________________ >>>>>>>>>>>> John Tran >>>>>>>>>>>> Northern California, CA >>>>>>>>>>>> [email protected] >>>>>>>>>>>> ICQ IM: 27741710 >>>>>>>>>>>> AOL IM: find1ngj0hn >>>>>>>>>>>> Yahoo! IM: findingj0hn >>>>>>>>>>>> MSN IM: [email protected] >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> WBR >>>>>>>>>>> Maxim aka solomax >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> jt >>>>>>>>>> ________________________________ >>>>>>>>>> John Tran >>>>>>>>>> Northern California, CA >>>>>>>>>> [email protected] >>>>>>>>>> ICQ IM: 27741710 >>>>>>>>>> AOL IM: find1ngj0hn >>>>>>>>>> Yahoo! IM: findingj0hn >>>>>>>>>> MSN IM: [email protected] >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> WBR >>>>>>>>> Maxim aka solomax >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> jt >>>>>>>> ________________________________ >>>>>>>> John Tran >>>>>>>> Northern California, CA >>>>>>>> [email protected] >>>>>>>> ICQ IM: 27741710 >>>>>>>> AOL IM: find1ngj0hn >>>>>>>> Yahoo! IM: findingj0hn >>>>>>>> MSN IM: [email protected] >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> WBR >>>>>>> Maxim aka solomax >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> jt >>>>>> ________________________________ >>>>>> John Tran >>>>>> Northern California, CA >>>>>> [email protected] >>>>>> ICQ IM: 27741710 >>>>>> AOL IM: find1ngj0hn >>>>>> Yahoo! IM: findingj0hn >>>>>> MSN IM: [email protected] >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> WBR >>>>> Maxim aka solomax >>>>> >>>> >>>> >>>> >>>> -- >>>> jt >>>> ________________________________ >>>> John Tran >>>> Northern California, CA >>>> [email protected] >>>> ICQ IM: 27741710 >>>> AOL IM: find1ngj0hn >>>> Yahoo! IM: findingj0hn >>>> MSN IM: [email protected] >>>> >>> >>> >>> >>> -- >>> WBR >>> Maxim aka solomax >>> >> >> >> >> -- >> jt >> ________________________________ >> John Tran >> Northern California, CA >> [email protected] >> ICQ IM: 27741710 >> AOL IM: find1ngj0hn >> Yahoo! IM: findingj0hn >> MSN IM: [email protected] >> > > > > -- > WBR > Maxim aka solomax > -- jt ________________________________ John Tran Northern California, CA [email protected] ICQ IM: 27741710 AOL IM: find1ngj0hn Yahoo! IM: findingj0hn MSN IM: [email protected]
