Added https://github.com/apache/openmeetings/commit/645f0b96c252370e1f7cbfcbe78b2d65ef923163
Thanks! On Sat, 30 May 2020 at 01:12, Chamberland, Martin < [email protected]> wrote: > [image: cid:banner1.jpg] > > > > Hi Maxim, > > > > I found where is the problem in the procedure of upgrading. > > I don’t know if it’s me missing thing, but here it is…. > > > > Perform DB backup using tools available for your database > > ./admin.sh -v -b -file ../backup_today.zip > > Delete/move folder with existing installation of OM > > Drop existing OM database > > Create empty Database with same name and UTF-8 support > > Unzip new version of OM into the same folder > > Copy your connector (.jar file) to make sure admin.sh script file will be > able to connect the database correctly. > > ./admin.sh -v -i -file ../backup_today.zip --drop --skip-default-objects > > > > > > *De :* Maxim Solodovnik [mailto:[email protected]] > *Envoyé :* 29 mai 2020 08:49 > *À :* Openmeetings user-list <[email protected]> > *Objet :* Re: update M4 to M5 > > > > 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 > -- Best regards, Maxim
