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 >
