ERROR 1364 (HY000) at line 47 in file: 'mysql/init.sql': Field 'IS_DISABLED' doesn't have a default value

[fabio.d...@bciseguros.cl]

Hi,

i got the error below while creating scheudlix 2.7 on mysql.

ERROR 1364 (HY000) at line 47 in file: 'mysql/init.sql': Field 'IS_DISABLED' doesn't have a default value

looking into script i got this line:


INSERT INTO SCHEDULING_HIERARCHY (
        ID, SE_PARENT_ID, SE_CHILD_ID, ALIAS_NAME, IS_STATIC, PRIORITY, SUSPEND, MERGE_MODE, ESTP_ID,
        CREATOR_U_ID,
 CREATE_TS, CHANGER_U_ID, CHANGE_TS, VALID_FROM, VALID_TO)
VALUES (
        30, NULL,         NULL,        NULL,       0,         0,        1,       3,          NULL,
        0, 0, 0, 0, 0, 9223372036854775807);

which value i can assing to IS_DISABLED to have this running ?  1 equals true?

Thanks
Fábio

[Ronald Jeninga]

Hi Fábio,

thank you for reporting this. I'll have a look at it and fix it.

Since the default is to enable the jobs in a hierarchy, the IS_DISABLED should set to be zero (= false).

Sorry for the hassle.

Regards,

Ronald