Poblem importing DB full backup

[cfreire]

Hi, I have follow the instructions here https://docs.sentora.org/?node=107 to update my Sentora 1.0.3 in Cneot 7.2009  to Sentora 2 in Ubuntu 20.04. The error that i have is when I try to import the full backup dbs to my actual Sentora server. The error is:
ERROR 1067 (42000) at line 705: Invalid default value for 'event_time'

May you ti help me to solve it, please?

Thanks by your attention.

[cfreire]

I have solved thus:
This is the correct:
"CREATE TABLE t1 (
ts TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6)
);"
This is not permitted:

CREATE TABLE t1 (
ts TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(3)
);

Thank you very much.

[TGates]

Are you using Sentora v2.0.0? I noticed a lot of changes with DB entries compared to pre-v2
Glad you sorted it out!

[TGates]

For anybody interested, the newer mysql database requires changes to the time stamps. This was the issue.
For updating to Sentora v2+ from previous versions, you may need to alter your database backups to accommodate the changes for the newer database server.

[Jettaman]

I have solved thus:
This is the correct:
"CREATE TABLE t1 (
  ts TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6)
);"
This is not permitted:

CREATE TABLE t1 (
  ts TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(3)
);

Thank you very much.

Hello @[cfreire], 
The t1 table you are talking about is not apart of sentoras default installation. This table may be in your database because you installed an old third party module or had this module installed for many years with no updates or support. We are trying to get a record or old modules that need to be updated before upgrade as soon as we can. Thank you for finding this and reporting it to us.