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 <[email protected]> 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 <[email protected]>: > >> 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 <[email protected]> >> wrote: >> >>> >>> Le 21 août 2015 16:07, "Maxim Solodovnik" <[email protected]> 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 < >>> [email protected]> 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
