Maxim - No Worries, I swap the order_id of Samoa and Los Angeles and it worked.
On Thu, Aug 22, 2013 at 10:07 PM, John Tran <[email protected]> wrote: > 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] > -- jt ________________________________ John Tran Northern California, CA [email protected] ICQ IM: 27741710 AOL IM: find1ngj0hn Yahoo! IM: findingj0hn MSN IM: [email protected]
