This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Poblem importing DB full backup
#1
[Not Solved] Poblem importing DB full backup
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.
Reply
Thanks given by:
#2
[Not Solved] RE: Poblem importing DB full backup
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.
Reply
Thanks given by: TGates
#3
[Not Solved] RE: Poblem importing DB full backup
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 - Project Council

SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
Thanks given by:
#4
[Not Solved] RE: Poblem importing DB full backup
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.
-TGates - Project Council

SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply
Thanks given by:
#5
[Not Solved] RE: Poblem importing DB full backup
(11-19-2023, 01:00 PM)cfreire Wrote: 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.
-Jettaman-

NEW: Sentora v.2.0.1 has been released!!!

Sentora's quick recovery depends on community support and donations. We need to stand as one and help Sentora into the future.

Donate HERE and do your part. We thank you for your support.
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Restore backup from 1.x BobOki 2 2 ,273 03-27-2023, 05:31 AM
Last Post: TGates
Importing a database from Cpanel papathimiu 2 3 ,018 02-20-2023, 10:56 AM
Last Post: papathimiu

Forum Jump:


Users browsing this thread: 1 Guest(s)