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: > > 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
