Dear Jacopo, Sorry for coming back to you late on the issue. I've done changing from DATETIME(6) to DATETIME(3). Everything works perfectly without error so far. However, in order to avoid potential duplicate entry when creating new record, my suggestion is to set it as DATETIME(6). As the calculating capacity & efficiency increases these days, odds still remain for duplicate data entries when the CPU & RAM are powerful enough.
This is only my personal view for your reference. HIH. B.R. Schumann -----邮件原件----- 发件人: Jacopo Cappellato <jacopo.cappell...@hotwaxsystems.com> 发送时间: 2018年4月2日 13:59 收件人: email@example.com ML <firstname.lastname@example.org> 主题: Re: 答复: 答复: 答复: A major bug in OFBiz Manufacturing MRP function On Sun, Apr 1, 2018 at 10:30 AM, Schumann Ye <schumanny...@hotmail.com> wrote: > Hi Jacopo, > > Thanks for your hints. > Actually I am not using SVN now, I've done quite some customizations > so I would like to do it directly in the database mysql by using alter table. > Is it ok if I do it this way? > Yes, you can directly alter the MRP_EVENT table. Regards, Jacopo