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 <findingj...@gmail.com> 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 <solomax...@gmail.com>wrote:
>
>> update om_timezone set order_id = 32 where id = 42;
>>
>>
>> On Fri, Aug 23, 2013 at 11:49 AM, John Tran <findingj...@gmail.com>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 
>>> <solomax...@gmail.com>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 <findingj...@gmail.com>wrote:
>>>>
>>>>> Oh.  I am using MySQL.
>>>>>
>>>>>
>>>>> On Thu, Aug 22, 2013 at 9:17 PM, Maxim Solodovnik <
>>>>> solomax...@gmail.com> wrote:
>>>>>
>>>>>> unfortunately it is not enough :(
>>>>>> What DB are you using?
>>>>>>
>>>>>>
>>>>>> On Fri, Aug 23, 2013 at 11:15 AM, John Tran <findingj...@gmail.com>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 <
>>>>>>> solomax...@gmail.com> 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 
>>>>>>>> <findingj...@gmail.com>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 <
>>>>>>>>> solomax...@gmail.com> 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 <
>>>>>>>>>> findingj...@gmail.com> 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 <
>>>>>>>>>>> solomax...@gmail.com> 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 <
>>>>>>>>>>>> findingj...@gmail.com> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Thanks Lee.  Already tried that.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Thu, Aug 22, 2013 at 4:45 PM, Lee Saunders <
>>>>>>>>>>>>> leesenglishless...@gmail.com> 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 <
>>>>>>>>>>>>>> leesenglishless...@gmail.com> 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 <
>>>>>>>>>>>>>>> findingj...@gmail.com> 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
>>>>>>>>>>>>> findingj...@gmail.com
>>>>>>>>>>>>>      ICQ IM: 27741710
>>>>>>>>>>>>>     AOL IM: find1ngj0hn
>>>>>>>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>>> WBR
>>>>>>>>>>>> Maxim aka solomax
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> jt
>>>>>>>>>>> ________________________________
>>>>>>>>>>> John Tran
>>>>>>>>>>> Northern California, CA
>>>>>>>>>>> findingj...@gmail.com
>>>>>>>>>>>      ICQ IM: 27741710
>>>>>>>>>>>     AOL IM: find1ngj0hn
>>>>>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> WBR
>>>>>>>>>> Maxim aka solomax
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> jt
>>>>>>>>> ________________________________
>>>>>>>>> John Tran
>>>>>>>>> Northern California, CA
>>>>>>>>> findingj...@gmail.com
>>>>>>>>>      ICQ IM: 27741710
>>>>>>>>>     AOL IM: find1ngj0hn
>>>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> WBR
>>>>>>>> Maxim aka solomax
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> jt
>>>>>>> ________________________________
>>>>>>> John Tran
>>>>>>> Northern California, CA
>>>>>>> findingj...@gmail.com
>>>>>>>      ICQ IM: 27741710
>>>>>>>     AOL IM: find1ngj0hn
>>>>>>> Yahoo! IM: findingj0hn
>>>>>>>    MSN IM: findingj...@hotmail.com
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> WBR
>>>>>> Maxim aka solomax
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> jt
>>>>> ________________________________
>>>>> John Tran
>>>>> Northern California, CA
>>>>> findingj...@gmail.com
>>>>>      ICQ IM: 27741710
>>>>>     AOL IM: find1ngj0hn
>>>>> Yahoo! IM: findingj0hn
>>>>>    MSN IM: findingj...@hotmail.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>
>>>
>>>
>>> --
>>> jt
>>> ________________________________
>>> John Tran
>>> Northern California, CA
>>> findingj...@gmail.com
>>>      ICQ IM: 27741710
>>>     AOL IM: find1ngj0hn
>>> Yahoo! IM: findingj0hn
>>>    MSN IM: findingj...@hotmail.com
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
>
> --
> jt
> ________________________________
> John Tran
> Northern California, CA
> findingj...@gmail.com
>      ICQ IM: 27741710
>     AOL IM: find1ngj0hn
> Yahoo! IM: findingj0hn
>    MSN IM: findingj...@hotmail.com
>



-- 
WBR
Maxim aka solomax

Reply via email to