[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]] 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]<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
