There is a slight error in the schema for scheduler. The default values for 'publish_on', 'unpublish_on' and 'timezone' is set to the string '0' when it should be the integer 0

This is a small thing, I know, but I get an error whenever I use the schema module:

scheduler.publish_on is type int but its default 0 is PHP type string
scheduler.unpublish_on is type int but its default 0 is PHP type string
scheduler.timezone is type int but its default 0 is PHP type string

I've corrected it in the snippet below.

function scheduler_schema() {
  return array(
    'scheduler' => array(
      'description' => t('The main table to hold the scheduler data.'),
      'fields' => array(
        'nid' => array(
          'description' => t('The foreign key to node.nid'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
        ),
        'publish_on' => array(
          'description' => t('The UNIX UTC timestamp when to publish'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
          'default' => 0,
        ),
        'unpublish_on' => array(
          'description' => t('The UNIX UTC timestamp when to unpublish'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
          'default' => 0,
        ),
        'timezone' => array(
          'description' => t('The offset in seconds due to the timezone'),
          'type' => 'int',
          'unsigned' => TRUE,
          'not null' => TRUE,
          'default' => 0,
        ),
      ),
      'indexes' => array(
        'scheduler_publish_on' => array('publish_on'),
        'scheduler_unpublish_on' => array('unpublish_on'),
      ),
      'primary key' => array('nid'),
    ),
  );
}

Comments

eric-alexander schaefer’s picture

Status: Active » Fixed
eric-alexander schaefer’s picture

Fixed in 6.x-1.3

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.