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

Earnie Boyd earnie at users.sourceforge.net
Mon Nov 5 13:11:04 UTC 2012


Have you tried to execute the update.php script?  If you do that
again, do you see errors?

Earnie

On Sun, Nov 4, 2012 at 11:14 PM, Dave Stevens <geek at uniserve.com> wrote:
> 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
> --
> [ Drupal support list | http://lists.drupal.org/ ]



-- 
Earnie
-- https://sites.google.com/site/earnieboyd


More information about the support mailing list