You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Samuel Imbert <sa...@gmail.com> on 2015/08/21 15:00:46 UTC
Moodle Plugin and room's lifespan
Hello,
I'm using moodle plugin to create and access conference room for our
teachers and students. Everything is going great, but it seems that
rooms have a lifespan, because after sometimes i get this 1286 error :
"There is no such room available. The event in the calendar and
connected room is already deleted."
generated by WebContent/src/base/hibernate/hibRtmpConnection.lzx
when no ID is passed (DEBUG: getRoomById: null ).
As i have the same error when i access the room with om's admin, i
supposed it's link to a lifespan (default duration for calendar event
linked to the room).
May someone enlighten me about this?
Thanks,
Samuel
Re: Moodle Plugin and room's lifespan
Posted by Maxim Solodovnik <so...@gmail.com>.
I see no reason for this room not being displayed
could you send me backup of you OM server (privately) so I can investigate
it here?
On Tue, Aug 25, 2015 at 5:19 PM, Imbert Samuel <sa...@gmail.com>
wrote:
> Hello,
>
> Here is the result :
>
> [image: Textes complets]
> <https://www.pieber.fr/database/sql.php?db=admin_OM&table=room&sql_query=SELECT+%2A++FROM+%60room%60+WHERE+%60id%60+%3D+171&goto=sql.php&full_text_button=1&display_text=F&token=08761d69b55e61e4ead9459fe3c6fdd8> id
> allow_font_styles allow_recording allow_user_questions appointment auto_video_select
> chat_moderated chat_opened comment_field confno deleted demo_time externalRoomId
> externalRoomType files_opened hide_actions_menu hide_activities_and_actions
> hide_chat hide_files_explorer hide_screen_sharing hide_top_bar hide_whiteboard
> is_audio_only is_closed isdemoroom ismoderatedroom ispublic name numberOfPartizipants
> owner_id pin redirect_url show_microphone_status sip_enabled starttime updatetime
> wait_for_recording roomtypes_id tmp_id [image: Modifier] Modifier
> <https://www.pieber.fr/database/tbl_change.php?db=admin_OM&table=room&where_clause=%60room%60.%60id%60+%3D+171&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60room%60+WHERE+%60id%60+%3D+171&goto=sql.php&default_action=update&token=08761d69b55e61e4ead9459fe3c6fdd8> [image:
> Copier] Copier
> <https://www.pieber.fr/database/tbl_change.php?db=admin_OM&table=room&where_clause=%60room%60.%60id%60+%3D+171&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60room%60+WHERE+%60id%60+%3D+171&goto=sql.php&default_action=insert&token=08761d69b55e61e4ead9459fe3c6fdd8> [image:
> Effacer] Effacer
> <https://www.pieber.fr/database/sql.php?db=admin_OM&table=room&sql_query=DELETE+FROM+%60admin_OM%60.%60room%60+WHERE+%60room%60.%60id%60+%3D+171&message_to_show=La+ligne+a+%C3%A9t%C3%A9+effac%C3%A9e&goto=sql.php%3Fdb%3Dadmin_OM%26table%3Droom%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560room%2560%2BWHERE%2B%2560id%2560%2B%253D%2B171%26message_to_show%3DLa%2Bligne%2Ba%2B%25C3%25A9t%25C3%25A9%2Beffac%25C3%25A9e%26goto%3Dsql.php%26token%3D08761d69b55e61e4ead9459fe3c6fdd8&token=08761d69b55e61e4ead9459fe3c6fdd8>
> 171 1 *NULL*1 0 0 0 0 Created by SOAP-Gateway*NULL*0 0 *NULL*moodle 0 0 1
> 0 0 0 0 0 1 0 0 1 0 PIEBER 165 Salle de conférence 4 *NULL**NULL*0 0 2015-07-15
> 11:04:46 2015-08-20 14:12:14 *NULL*3
> <https://www.pieber.fr/database/sql.php?db=admin_OM&table=roomtype&pos=0&sql_query=SELECT+%2A+FROM+%60admin_OM%60.%60roomtype%60+WHERE+%60id%60+%3D+3&token=08761d69b55e61e4ead9459fe3c6fdd8>
> 1412101029
>
> 2015-08-25 7:50 GMT+02:00 Maxim Solodovnik <so...@gmail.com>:
>
>> appointment = 0, deleted = 0 and invisible in #admin/room
>> that is weird :(
>> could you select * from rooms with ID of this room so I can take a look?
>>
>> >>How are linked rooms and events in the database
>> appointment has room_id
>>
>> in case room was created for particular appointment (appointment room)
>> appointment flag will be set to 1
>>
>>
>> On Fri, Aug 21, 2015 at 10:02 PM, Imbert Samuel <sa...@gmail.com>
>> wrote:
>>
>>>
>>> Le 21 août 2015 16:07, "Maxim Solodovnik" <so...@gmail.com> a
>>> écrit :
>>> >
>>> > I'm afraid you need to investigate this a little bit
>>>
>>> > What room is being used by Moodle?
>>> Type 3 (video and whiteboard)
>>>
>>> is room with this ID exists in OM?
>>> Yes. In room table with no different settings than another one working,
>>> but not visible in #admin/room
>>>
>>> > Maybe room was appointment room?
>>> In room table: appointment = 0
>>> (deleted = 0)
>>>
>>> How are linked rooms and events in the database ?
>>>
>>> >
>>> > On Fri, Aug 21, 2015 at 7:00 PM, Samuel Imbert <
>>> samuel.imbert@gmail.com> wrote:
>>> >>
>>> >> Hello,
>>> >>
>>> >> I'm using moodle plugin to create and access conference room for our
>>> teachers and students. Everything is going great, but it seems that rooms
>>> have a lifespan, because after sometimes i get this 1286 error :
>>> >>>
>>> >>> "There is no such room available. The event in the calendar and
>>> connected room is already deleted."
>>> >>>
>>> >>> generated by WebContent/src/base/hibernate/hibRtmpConnection.lzx
>>> when no ID is passed (DEBUG: getRoomById: null ).
>>> >>
>>> >> As i have the same error when i access the room with om's admin, i
>>> supposed it's link to a lifespan (default duration for calendar event
>>> linked to the room).
>>> >>
>>> >>
>>> >> May someone enlighten me about this?
>>> >>
>>> >> Thanks,
>>> >>
>>> >> Samuel
>>> >
>>> >
>>> >
>>> >
>>> > --
>>> > WBR
>>> > Maxim aka solomax
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
--
WBR
Maxim aka solomax
Re: Moodle Plugin and room's lifespan
Posted by Imbert Samuel <sa...@gmail.com>.
Hello,
Here is the result :
[image: Textes complets]
<https://www.pieber.fr/database/sql.php?db=admin_OM&table=room&sql_query=SELECT+%2A++FROM+%60room%60+WHERE+%60id%60+%3D+171&goto=sql.php&full_text_button=1&display_text=F&token=08761d69b55e61e4ead9459fe3c6fdd8>
id
allow_font_styles allow_recording allow_user_questions appointment
auto_video_select
chat_moderated chat_opened comment_field confno deleted demo_time
externalRoomId
externalRoomType files_opened hide_actions_menu
hide_activities_and_actions hide_chat
hide_files_explorer hide_screen_sharing hide_top_bar hide_whiteboard
is_audio_only
is_closed isdemoroom ismoderatedroom ispublic name
numberOfPartizipants owner_id
pin redirect_url show_microphone_status sip_enabled starttime
updatetime wait_for_recording
roomtypes_id tmp_id [image: Modifier] Modifier
<https://www.pieber.fr/database/tbl_change.php?db=admin_OM&table=room&where_clause=%60room%60.%60id%60+%3D+171&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60room%60+WHERE+%60id%60+%3D+171&goto=sql.php&default_action=update&token=08761d69b55e61e4ead9459fe3c6fdd8>
[image:
Copier] Copier
<https://www.pieber.fr/database/tbl_change.php?db=admin_OM&table=room&where_clause=%60room%60.%60id%60+%3D+171&clause_is_unique=1&sql_query=SELECT+%2A++FROM+%60room%60+WHERE+%60id%60+%3D+171&goto=sql.php&default_action=insert&token=08761d69b55e61e4ead9459fe3c6fdd8>
[image:
Effacer] Effacer
<https://www.pieber.fr/database/sql.php?db=admin_OM&table=room&sql_query=DELETE+FROM+%60admin_OM%60.%60room%60+WHERE+%60room%60.%60id%60+%3D+171&message_to_show=La+ligne+a+%C3%A9t%C3%A9+effac%C3%A9e&goto=sql.php%3Fdb%3Dadmin_OM%26table%3Droom%26sql_query%3DSELECT%2B%252A%2B%2BFROM%2B%2560room%2560%2BWHERE%2B%2560id%2560%2B%253D%2B171%26message_to_show%3DLa%2Bligne%2Ba%2B%25C3%25A9t%25C3%25A9%2Beffac%25C3%25A9e%26goto%3Dsql.php%26token%3D08761d69b55e61e4ead9459fe3c6fdd8&token=08761d69b55e61e4ead9459fe3c6fdd8>
171 1 *NULL*1 0 0 0 0 Created by SOAP-Gateway*NULL*0 0 *NULL*moodle 0 0 1 0
0 0 0 0 1 0 0 1 0 PIEBER 165 Salle de conférence 4 *NULL**NULL*0 0 2015-07-15
11:04:46 2015-08-20 14:12:14 *NULL*3
<https://www.pieber.fr/database/sql.php?db=admin_OM&table=roomtype&pos=0&sql_query=SELECT+%2A+FROM+%60admin_OM%60.%60roomtype%60+WHERE+%60id%60+%3D+3&token=08761d69b55e61e4ead9459fe3c6fdd8>
1412101029
2015-08-25 7:50 GMT+02:00 Maxim Solodovnik <so...@gmail.com>:
> appointment = 0, deleted = 0 and invisible in #admin/room
> that is weird :(
> could you select * from rooms with ID of this room so I can take a look?
>
> >>How are linked rooms and events in the database
> appointment has room_id
>
> in case room was created for particular appointment (appointment room)
> appointment flag will be set to 1
>
>
> On Fri, Aug 21, 2015 at 10:02 PM, Imbert Samuel <sa...@gmail.com>
> wrote:
>
>>
>> Le 21 août 2015 16:07, "Maxim Solodovnik" <so...@gmail.com> a
>> écrit :
>> >
>> > I'm afraid you need to investigate this a little bit
>>
>> > What room is being used by Moodle?
>> Type 3 (video and whiteboard)
>>
>> is room with this ID exists in OM?
>> Yes. In room table with no different settings than another one working,
>> but not visible in #admin/room
>>
>> > Maybe room was appointment room?
>> In room table: appointment = 0
>> (deleted = 0)
>>
>> How are linked rooms and events in the database ?
>>
>> >
>> > On Fri, Aug 21, 2015 at 7:00 PM, Samuel Imbert <sa...@gmail.com>
>> wrote:
>> >>
>> >> Hello,
>> >>
>> >> I'm using moodle plugin to create and access conference room for our
>> teachers and students. Everything is going great, but it seems that rooms
>> have a lifespan, because after sometimes i get this 1286 error :
>> >>>
>> >>> "There is no such room available. The event in the calendar and
>> connected room is already deleted."
>> >>>
>> >>> generated by WebContent/src/base/hibernate/hibRtmpConnection.lzx when
>> no ID is passed (DEBUG: getRoomById: null ).
>> >>
>> >> As i have the same error when i access the room with om's admin, i
>> supposed it's link to a lifespan (default duration for calendar event
>> linked to the room).
>> >>
>> >>
>> >> May someone enlighten me about this?
>> >>
>> >> Thanks,
>> >>
>> >> Samuel
>> >
>> >
>> >
>> >
>> > --
>> > WBR
>> > Maxim aka solomax
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
Re: Moodle Plugin and room's lifespan
Posted by Maxim Solodovnik <so...@gmail.com>.
appointment = 0, deleted = 0 and invisible in #admin/room
that is weird :(
could you select * from rooms with ID of this room so I can take a look?
>>How are linked rooms and events in the database
appointment has room_id
in case room was created for particular appointment (appointment room)
appointment flag will be set to 1
On Fri, Aug 21, 2015 at 10:02 PM, Imbert Samuel <sa...@gmail.com>
wrote:
>
> Le 21 août 2015 16:07, "Maxim Solodovnik" <so...@gmail.com> a écrit :
> >
> > I'm afraid you need to investigate this a little bit
>
> > What room is being used by Moodle?
> Type 3 (video and whiteboard)
>
> is room with this ID exists in OM?
> Yes. In room table with no different settings than another one working,
> but not visible in #admin/room
>
> > Maybe room was appointment room?
> In room table: appointment = 0
> (deleted = 0)
>
> How are linked rooms and events in the database ?
>
> >
> > On Fri, Aug 21, 2015 at 7:00 PM, Samuel Imbert <sa...@gmail.com>
> wrote:
> >>
> >> Hello,
> >>
> >> I'm using moodle plugin to create and access conference room for our
> teachers and students. Everything is going great, but it seems that rooms
> have a lifespan, because after sometimes i get this 1286 error :
> >>>
> >>> "There is no such room available. The event in the calendar and
> connected room is already deleted."
> >>>
> >>> generated by WebContent/src/base/hibernate/hibRtmpConnection.lzx when
> no ID is passed (DEBUG: getRoomById: null ).
> >>
> >> As i have the same error when i access the room with om's admin, i
> supposed it's link to a lifespan (default duration for calendar event
> linked to the room).
> >>
> >>
> >> May someone enlighten me about this?
> >>
> >> Thanks,
> >>
> >> Samuel
> >
> >
> >
> >
> > --
> > WBR
> > Maxim aka solomax
>
--
WBR
Maxim aka solomax
Re: Moodle Plugin and room's lifespan
Posted by Imbert Samuel <sa...@gmail.com>.
Le 21 août 2015 16:07, "Maxim Solodovnik" <so...@gmail.com> a écrit :
>
> I'm afraid you need to investigate this a little bit
> What room is being used by Moodle?
Type 3 (video and whiteboard)
is room with this ID exists in OM?
Yes. In room table with no different settings than another one working, but
not visible in #admin/room
> Maybe room was appointment room?
In room table: appointment = 0
(deleted = 0)
How are linked rooms and events in the database ?
>
> On Fri, Aug 21, 2015 at 7:00 PM, Samuel Imbert <sa...@gmail.com>
wrote:
>>
>> Hello,
>>
>> I'm using moodle plugin to create and access conference room for our
teachers and students. Everything is going great, but it seems that rooms
have a lifespan, because after sometimes i get this 1286 error :
>>>
>>> "There is no such room available. The event in the calendar and
connected room is already deleted."
>>>
>>> generated by WebContent/src/base/hibernate/hibRtmpConnection.lzx when
no ID is passed (DEBUG: getRoomById: null ).
>>
>> As i have the same error when i access the room with om's admin, i
supposed it's link to a lifespan (default duration for calendar event
linked to the room).
>>
>>
>> May someone enlighten me about this?
>>
>> Thanks,
>>
>> Samuel
>
>
>
>
> --
> WBR
> Maxim aka solomax
Re: Moodle Plugin and room's lifespan
Posted by Maxim Solodovnik <so...@gmail.com>.
I'm afraid you need to investigate this a little bit
What room is being used by Moodle? is room with this ID exists in OM?
Maybe room was appointment room?
On Fri, Aug 21, 2015 at 7:00 PM, Samuel Imbert <sa...@gmail.com>
wrote:
> Hello,
>
> I'm using moodle plugin to create and access conference room for our
> teachers and students. Everything is going great, but it seems that rooms
> have a lifespan, because after sometimes i get this 1286 error :
>
> "There is no such room available. The event in the calendar and connected
> room is already deleted."
>
> generated by WebContent/src/base/hibernate/hibRtmpConnection.lzx when no
> ID is passed (DEBUG: getRoomById: null ).
>
> As i have the same error when i access the room with om's admin, i
> supposed it's link to a lifespan (default duration for calendar event
> linked to the room).
>
>
> May someone enlighten me about this?
>
> Thanks,
>
> Samuel
>
--
WBR
Maxim aka solomax