[support] database schema error - what to do???

Dave Stevens geek at uniserve.com
Mon Nov 5 04:14:47 UTC 2012


Hello All,

I have a d7.15 site under development. When I run the status report I get 
this:

Database schema	Inconsistent
The Schema comparison report shows:

    * 25 modules with matching tables
    * 1 modules with mis-matching tables

The database schema comparison report provides more details.

And then the schema report shows three headers, 

Match(92)
Mismatch(3)
Extra(0)

and under mismatch is

Search with
- Search_dataset

column type - differences on: length, default
declared: array('description' => 'TODO: please describe this field!', 'type' 
=> 'varchar', 'length' => 16, 'not null' => TRUE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 
'varchar', 'length' => '64', 'not null' => TRUE, 'default' => '')

- Search_index 

column type - differences on: length, default
declared: array('description' => 'TODO: please describe this field!', 'type' 
=> 'varchar', 'length' => 16, 'not null' => TRUE)
actual: array('description' => 'TODO: please describe this field!', 'type' => 
'varchar', 'length' => '64', 'not null' => TRUE, 'default' => '')

- Search_node_links

column type - difference on: length
declared: array('description' => 'TODO: please describe this field!', 'type' 
=> 'varchar', 'length' => 16, 'not null' => TRUE, 'default' => '')
actual: array('description' => 'TODO: please describe this field!', 'type' => 
'varchar', 'length' => '64', 'not null' => TRUE, 'default' => '')

So, knowing as little as I do, it seems that there is a discrepancy between 
the length descriptors as 16 vs 64 characters, but I haven't a clue what to do 
about this or where to report it, if that's the indicated action. All of this 
is under the compare tab, there's more under the other tabs but I don't know 
what's relevant. E.g., there are 700-odd fields with no descriptions listed 
under the "describe" tab.

I'm much too attached to the parts of the site that DO work to tinker blindly. 

Advice?

Dave



-- 
Politics is the Entertainment Division of the military industrial complex.

~Frank Zappa


More information about the support mailing list