[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]<mailto:[email protected]>> wrote: [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 ☺ bye De : Maxim Solodovnik [mailto:[email protected]<mailto:[email protected]>] Envoyé : 29 mai 2020 08:42 À : Openmeetings user-list <[email protected]<mailto:[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]<mailto:[email protected]>> wrote: [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
