Just have updated instructions https://openmeetings.apache.org/Upgrade.html
with missing steps https://github.com/apache/openmeetings/commit/3cde45faff4bfa279af4b129b9b6ae87cb94d505 On Fri, 29 May 2020 at 19:44, Chamberland, Martin < [email protected]> wrote: > [image: cid:banner1.jpg] > > > > Let me try it again ! > > > > Damn, I can’t wait to have a bulletproof step by step to go from MX to > MY J > > > > bye > > > > *De :* Maxim Solodovnik [mailto:[email protected]] > *Envoyé :* 29 mai 2020 08:42 > *À :* Openmeetings user-list <[email protected]> > *Objet :* Re: update M4 to M5 > > > > Hello Martin, > > > > this error can't happened if you were using "normal tutorial." :))) > > > > You should drop DB, and create new one before staring import :))) > > > > On Thu, 28 May 2020 at 19:37, Chamberland, Martin < > [email protected]> wrote: > > [image: cid:[email protected]] > > > > Hi there, > > > > We just did a upgrade from M4 to M5. > > Using the normal tutorial. > > > > Now trying to create a new local user. > > > > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Field > 'forceTimeZoneCheck' doesn't have a default value {prepstmnt 403446639 > INSERT INTO om_user (deleted, inserted, updated, activatehash, age, > displayName, domain_id, external_id, firstname, language_id, lastlogin, > lastname, login, owner_id, password, pictureuri, regdate, resetdate, > resethash, salutation, show_contact_data, show_contact_data_to_contacts, > time_zone_id, type, user_offers, user_searchs, address_id, sip_user_id) > VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, > ?, ?, ?, ?, ?, ?)} [code=1364, state=HY000] > > > > Is that error related to the TimeZone (Canadian) fix in M5 ? > > > > Bye > > > > Martin C. > > > > > > > -- > > Best regards, > Maxim > -- Best regards, Maxim
