Anemometer icon indicating copy to clipboard operation
Anemometer copied to clipboard

Problem installing in MariaDB

Open yure opened this issue 9 years ago • 1 comments

MariaDB checks if default date makes sense, and fails on default date 0000-00-00.

Here is a patch to fix the issue

index 8803f38..6f84644 100644 --- a/install.sql +++ b/install.sql @@ -23,8 +23,8 @@ CREATE TABLE global_query_review_history ( db_max varchar(64) DEFAULT NULL, checksum bigint(20) unsigned NOT NULL, sample longtext NOT NULL,

  • ts_min datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  • ts_max datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  • ts_min datetime NOT NULL DEFAULT '1990-01-01 00:00:00',
  • ts_max datetime NOT NULL DEFAULT '1990-01-01 00:00:00', ts_cnt float DEFAULT NULL, Query_time_sum float DEFAULT NULL, Query_time_min float DEFAULT NULL,

yure avatar Apr 25 '15 10:04 yure

Thank you, this solve my problem and I am using mysql

mmojica53 avatar Oct 12 '16 18:10 mmojica53