Field 'rule' doesn't have a default value query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('xmlsitemap_taxonomy', 28, '') in C:\Inetpub\wwwroot\ccc.com\sites\all\modules\contrib\supercron\supercron.inc on Line 281.

Field rule does not have a default query (NOT NULL).

Fix should go in supercron.install

change:

'rule' => array('type' => 'varchar', 'length' => '256', 'not null' => TRUE),

to

'rule' => array('type' => 'varchar', 'length' => '256'),

Comments

thekevinday’s picture

thekevinday commented

I get this or similar with postgres.

warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('date_timezone', 0, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('dblog', 1, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('filter', 2, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('killfile', 3, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('ldapauth', 4, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('node', 5, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('path_redirect', 6, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('rules', 7, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('rules_scheduler', 8, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('search', 9, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('statistics', 10, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('system', 11, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: pg_query(): Query failed: ERROR: null value in column "rule" violates not-null constraint in includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO supercron_enabled_mods (module_name, weight, output) VALUES ('update', 12, '') in sites/all/modules/supercron/supercron.inc on line 281.
warning: Parameter 1 to theme_supercron_settings() expected to be a reference, value given in includes/theme.inc on line 656.
cor3huis’s picture

cor3huis commented
Status: Active » Needs review

Review the fix mentioned above, and plz implement if possible.

rightchoice2c_me’s picture

rightchoice2c_me commented

and also it is getting wrong directory as I have drupal installed in d:/htdocs/drupal6/ but its keep on showing d:/htdocs/drupal6/drupal6.

cor3huis’s picture

cor3huis commented

@rightchoice2c_me, thanks for trying to help. However this is issue tracker and not a forum. Plz file another issue for another bug found. It must be your luckyday, since there is already an issue and solution filed #749606: Path to supercron.php incorrectly determined by the module code. There is for your issue also a patch to be tested. Plz. Let us know how it solved your issue by commenting on #749606: Path to supercron.php incorrectly determined by the module code, and please not in this issue.