box / box/Anemometer

Problem installing in MariaDB

Open
#126 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
1.4k
Forks
306
PR merge metrics
No merged PRs in 30d

Description

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,

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.