What OM version are you using? What DB?
On 25 August 2014 15:38, Murat Tamer Ataol <[email protected]> wrote: > Hello, > > I checked the log files. There is one error in openmeetings.log. > > ---------------------------------------------------------------------------------------- > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Table > 'openmeetings.appointments' doesn't exist {prepstmnt 641714439 SELECT > t0.id, t1.id, t1.comment_field, t1.deleted, t1.name, t1.starttime, > t1.updatetime, t2.id, t2.activatehash, t3.id, t3.additionalname, > t3.comment_field, t3.deleted, t3.email, t3.fax, t3.phone, t3.starttime, > t4.id, t4.code, t4.deleted, t4.name, t4.shortName, t4.starttime, > t4.updatetime, t3.street, t3.town, t3.updatetime, t3.zip, t2.age, > t2.availible, t2.deleted, t2.externalUserId, t2.externalUserType, > t2.firstname, t2.forceTimeZoneCheck, t2.language_id, t2.lastlogin, > t2.lastname, t2.lasttrans, t2.level_id, t2.login, t2.owner_id, > t2.pictureuri, t2.regdate, t2.resethash, t2.salutations_id, t2.sendSMS, > t2.show_contact_data, t2.show_contact_data_to_contacts, t5.id, t5.allow, > t5.callbackextension, t5.context, t5.defaultuser, t5.fullcontact, t5.host, > t5.ipaddr, t5.lastms, t5.md5secret, t5.name, t5.nat, t5.port, > t5.regseconds, t5.regserver, t5.secret, t5.type, t5.useragent, > t2.starttime, t2.status, t2.time_zone_id, t2.type, t2.updatetime, > t2.user_offers, t2.user_searchs, t0.is_connected_event, t0.deleted, > t0.description, t0.appointment_endtime, t0.icalId, t0.starttime, > t0.isdaily, t0.ismonthly, t0.isweekly, t0.isyearly, t0.language_id, > t0.location, t6.id, t6.activatehash, t6.adresses_id, t6.age, > t6.availible, t6.deleted, t6.externalUserId, t6.externalUserType, > t6.firstname, t6.forceTimeZoneCheck, t6.language_id, t6.lastlogin, > t6.lastname, t6.lasttrans, t6.level_id, t6.login, t6.owner_id, > t6.pictureuri, t6.regdate, t6.resethash, t6.salutations_id, t6.sendSMS, > t6.show_contact_data, t6.show_contact_data_to_contacts, t6.sip_user_id, > t6.starttime, t6.status, t6.time_zone_id, t6.type, t6.updatetime, > t6.user_offers, t6.user_searchs, t0.password, t0.is_password_protected, > t7.id, t7.deleted, t7.fieldvalues_id, t7.name, t7.starttime, > t7.updatetime, t8.id, t8.activatehash, t8.adresses_id, t8.age, > t8.availible, t8.deleted, t8.externalUserId, t8.externalUserType, > t8.firstname, t8.forceTimeZoneCheck, t8.language_id, t8.lastlogin, > t8.lastname, t8.lasttrans, t8.level_id, t8.login, t8.owner_id, > t8.pictureuri, t8.regdate, t8.resethash, t8.salutations_id, t8.sendSMS, > t8.show_contact_data, t8.show_contact_data_to_contacts, t8.sip_user_id, > t8.starttime, t8.status, t8.time_zone_id, t8.type, t8.updatetime, > t8.user_offers, t8.user_searchs, t0.is_reminder_email_send, t9.id, > t9.allow_font_styles, t9.allow_recording, t9.allow_user_questions, > t9.appointment, t9.auto_video_select, t9.chat_moderated, t9.chat_opened, > t9.comment_field, t9.confno, t9.deleted, t9.demo_time, t9.externalRoomId, > t9.externalRoomType, t9.files_opened, t9.hide_actions_menu, > t9.hide_activities_and_actions, t9.hide_chat, t9.hide_files_explorer, > t9.hide_screen_sharing, t9.hide_top_bar, t9.hide_whiteboard, > t9.is_audio_only, t9.is_closed, t9.isdemoroom, t9.ismoderatedroom, > t9.ispublic, t9.name, t9.numberOfPartizipants, t9.owner_id, t9.pin, > t9.redirect_url, t9.roomtypes_id, t9.show_microphone_status, > t9.sip_enabled, t9.starttime, t9.updatetime, t9.wait_for_recording, > t0.appointment_starttime, t0.appointmentname, t0.updatetime FROM > appointments t0 LEFT OUTER JOIN appointmentcategory t1 ON t0.category_id = > t1.id LEFT OUTER JOIN om_user t6 ON t0.user_id = t6.id LEFT OUTER JOIN > appointmentremindertyps t7 ON t0.remind_id = t7.id LEFT OUTER JOIN room > t9 ON t0.room_id = t9.id LEFT OUTER JOIN om_user t2 ON t1.user_id = t2.id > LEFT OUTER JOIN om_user t8 ON t7.user_id = t8.id LEFT OUTER JOIN address > t3 ON t2.adresses_id = t3.id LEFT OUTER JOIN sipusers t5 ON > t2.sip_user_id = t5.id LEFT OUTER JOIN state t4 ON t3.state_id = t4.id > WHERE (t0.deleted = ? AND t0.is_reminder_email_send = ? AND (t0.remind_id = > ? OR t0.remind_id = ?) AND (t0.appointment_starttime >= ? AND > t0.appointment_starttime <= ? OR t0.appointment_endtime >= ? AND > t0.appointment_endtime <= ? OR t0.appointment_starttime < ? AND > t0.appointment_endtime > ?))} [code=1146, state=42S02] > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) > ~[openjpa-bundle-2.2.2.jar:2.2.2] > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) > ~[openjpa-bundle-2.2.2.jar:2.2.2] > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59) > ~[openjpa-bundle-2.2.2.jar:2.2.2] > at > org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118) > ~[openjpa-bundle-2.2.2.jar:2.2.2] > at > org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268) > ~[openjpa-bundle-2.2.2.jar:2.2.2] > > ----------------------------------------------------------------------------------- > > I dont exacly know why this table is not there. Installation didnt give > any problem. How can I fix this one? > > Kind regards, > Tamer Ataol > > > > Murat Tamer Ataol > Sistem Yönetimi Daire Başkanlığı > > Sağlık Bakanlığı > Sağlık Bilgi sistemleri Genel Müdürlüğü > Mithatpaşa Cad. No:3 Çankaya / Ankara > > Yasal Uyarı : > Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve > Şartlar dokümanına tabidir : > http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html > > ------------------------------ > *Kimden:* Vasiliy Degtyarev [[email protected]] > *Gönderildi:* 25 Ağustos 2014 Pazartesi 11:26 > *Kime:* [email protected] > *Konu:* Re: Openmeetings problem > > Hello Tamer Ataol, > > Please check log files in the log directory. > > Thanks, > Vasiliy > > > On 25.08.2014 15:22, Murat Tamer Ataol wrote: > > Hello, > > I have a problem after installation. Installation completes ok. After that > when I hit the "Enter the Application" link notinited page comes. I tried > writing localhost:5080/openmeetings on the address bar. It didnt work. I > couldnt find how to come to login page. Login page never comes. > > Can you be of any help? > > Kind regards, > Tamer Ataol > > > > Murat Tamer Ataol > Sistem Yönetimi Daire Başkanlığı > > Sağlık Bakanlığı > Sağlık Bilgi sistemleri Genel Müdürlüğü > Mithatpaşa Cad. No:3 Çankaya / Ankara > > Yasal Uyarı : > Bu elektronik posta işbu linki kullanarak ulaşabileceğiniz Koşul ve > Şartlar dokümanına tabidir : > http://www.saglik.gov.tr/sbsgm/belge/1-17902/yasal-uyari.html > > > > > ------------------------------ > > YASAL UYARI: > Bu e-posta'nın içerdiği bilgiler (ekleri de dahil olmak üzere) gizlidir. > T.C. Sağlık Bakanlığı onayı olmaksızın içeriği kopyalanamaz, üçüncü > kişilere açıklanamaz veya iletilemez . Bu mesajın gönderilmek istendiği > kişi değilseniz (ya da bu e-posta'yı yanlışlıkla aldıysanız), lütfen > yollayan kişiyi haberdar ediniz ve mesajı sisteminizden derhal siliniz. > T.C. Sağlık Bakanlığı bu mesajın içerdiği bilgilerin doğruluğu veya > eksiksiz olduğu konusunda bir garanti vermemektedir. Bu nedenle, bilgilerin > ne şekilde olursa olsun içeriğinden, iletilmesinden, alınmasından, > saklanmasından T.C. sağlık Bakanlığı sorumlu değildir. Bu mesajın içeriği > yazarına ait olup, T.C. Sağlık Bakanlığı görüşlerini içermeyebilir. > > Bu e-posta bizce bilinen tüm bilgisayar virüslerine karşı taranmıştır. > > DISCLAIMER: > This e-mail (including any attachments) may contain confidential and/or > privileged information. Copying, disclosure or distribution of the material > in this e-mail without The Ministry of Health of Turkey's authority is > strictly forbidden. If you are not the intended recipient (or have received > this e-mail in error), please notify the sender and delete it from your > system immediately. The Ministry of Health of Turkey makes no warranty as > to the accuracy or completeness of any information contained in this > message and hereby excludes any liability of any kind for the information > contained therein or for the information transmission, reception, storage > or use of such in any way whatsoever. Any opinions expressed in this > message are those of the author and may not necessarily reflect the > opinions of The Ministry of Health of Turkey. > > This e-mail has been scanned for all computer viruses known to us. > ------------------------------ > > > > > > > > -- WBR Maxim aka solomax
