This is more of an annoyance than anything if you display schema on status report, mismatches cause it to display non-green status.

scheduler

    column nid - difference on: default
    declared: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE)
    actual: array('description' => 'TODO: please describe this field!', 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)

Comments

eric-alexander schaefer’s picture

eric-alexander schaefer commented
Status: Active » Postponed (maintainer needs more info)

I cannot reproduce this. The schema definition for D6 and D7 versions of scheduler are identical. The should be no mismatch. Can you try to repoduce the behavior and post the steps?

Starminder’s picture

Starminder commented

This was on a fairly large 6.2 site upgraded to 7.0. This may have been a pre-existing condition from who knows when. Am using schema module "compare" function. It gets reported there as a mismatch.

On a new D7 site the mismatch does not occur, but I am getting:
Notice: Undefined offset: 0 in scheduler_list() (line 444 of /home/hoslot5/public_html/sites/all/modules/scheduler/scheduler.module) when trying to view scheduled nodes.

Unfortunately I don't have another upgrade site to compare to (yet) but will see if it is isolated to just this site.

jonathan1055’s picture

jonathan1055 commented

Hi,
The problem with scheduler_list() is unrelated, and discussed in #1124276: Undefined offset: 0 in scheduler_list_access_callback().
Jonathan

jaydub’s picture

jaydub commented

Cannot reproduce either. I took a d6 install and upgraded to d7 and schema shows up as consistent.

jonathan1055’s picture

jonathan1055 commented

Hi jaydub,
Couple of questions:
1. What D6 version did you start with? (not sure that makes a difference though)
2. When you had consistent schemas, does it show which of the two in the original post yours matches with, ie with or without 'default => 0'

Jonathan

jonathan1055’s picture

jonathan1055 commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Just checked scheduler.install for D6 and D7. Neither of them have default 0 for nid in the scheduler table, and there are no updates which alter this. Hence I suspect that the 'actual' default value 0 in the table above was due to a manual change, or some other external db work.

Two years after the initial posting, and one year eight months since last update, marking this as 'closed cannot reproduce'.

Jonathan