database schema error - what to do???
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
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@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
On Monday, November 05, 2012 05:11:04 AM Earnie Boyd wrote:
Have you tried to execute the update.php script?
I've just done so and it says there are no updates.
If you do that again, do you see errors?
yes, there seems to have been no change. D
Earnie
On Sun, Nov 4, 2012 at 11:14 PM, Dave Stevens <geek@uniserve.com> wrote:
Hello All,
-- Politics is the Entertainment Division of the military industrial complex. ~Frank Zappa
Looking at my install of D7 .16 I see these fields as having a size of 16 (like the schema says), which means that some other module has altered the table schema directly, and then not implemented a hook_schema_alter function to indicate that it has done this. The "proper" procedure would be to search through all your installed (or previously installed) modules, to find the one that changed the field and file an issue on that module. If it changes the schema of a module it is supposed to implement hook_schema_alter to indicate this. You may be able to figure out which module did it by looking at the tables with something like phpMyAdmin and looking for entries longer than 16 characters, the module these are from it the likely culprit. The other option would be to grep your drupal sources for modules that alter these tables. Of course, another option is to just ignore the error, as it won't really cause a problem. A third option would be to make a little module that defines hook_schema_alter and fixes these schema entries just to silence the error. On Nov 4, 2012, at 11:14 PM, Dave Stevens <geek@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/ ]
Was this an upgraded site from 6.x? If so, the 6.x schema may have been different than the 7.x schema. Nancy Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________ From: Richard Damon
Looking at my install of D7 .16 I see these fields as having a size of 16 (like the schema says), which means that some other module has altered the table schema directly, and then not implemented a hook_schema_alter function to indicate that it has done this.
On Monday, November 05, 2012 02:30:52 PM Ms. Nancy Wichmann wrote:
Was this an upgraded site from 6.x? If so, the 6.x schema may have been different than the 7.x schema.
Nancy
No, it was installed as a version 7 site. If the error messages are only informative and don't cause problems I am not as concerned. From time to time as I add stuf in I run the update script. I have entered several hundred quotes and it seems as if every time I run update I get new blank quotes that I subsequently have to delete by hand. I don't know where these come from and that's the real source of my concern here. I've not done that for about a week and I just now deleted about 150 anonymous and empty quotes. I really like to not have them appear in the first place. D
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
________________________________
From: Richard Damon
Looking at my install of D7 .16 I see these fields as having a size of 16 (like the schema says), which means that some other module has altered the table schema directly, and then not implemented a hook_schema_alter function to indicate that it has done this.
-- Politics is the Entertainment Division of the military industrial complex. ~Frank Zappa
On Mon, Nov 5, 2012 at 6:39 PM, Dave Stevens <geek@uniserve.com> wrote:
On Monday, November 05, 2012 02:30:52 PM Ms. Nancy Wichmann wrote:
Was this an upgraded site from 6.x? If so, the 6.x schema may have been different than the 7.x schema.
Nancy
No, it was installed as a version 7 site. If the error messages are only informative and don't cause problems I am not as concerned. From time to time as I add stuf in I run the update script. I have entered several hundred quotes and it seems as if every time I run update I get new blank quotes that I subsequently have to delete by hand. I don't know where these come from and that's the real source of my concern here. I've not done that for about a week and I just now deleted about 150 anonymous and empty quotes. I really like to not have them appear in the first place.
Have you looked to find which modules touch the table as Richard Damon suggested? If a contrib module is causing you grief you need to open an issue with that module. -- Earnie -- https://sites.google.com/site/earnieboyd
On 11/6/12 7:51 AM, Earnie Boyd wrote:
On Mon, Nov 5, 2012 at 6:39 PM, Dave Stevens <geek@uniserve.com> wrote:
On Monday, November 05, 2012 02:30:52 PM Ms. Nancy Wichmann wrote:
Was this an upgraded site from 6.x? If so, the 6.x schema may have been different than the 7.x schema.
Nancy No, it was installed as a version 7 site. If the error messages are only informative and don't cause problems I am not as concerned. From time to time as I add stuf in I run the update script. I have entered several hundred quotes and it seems as if every time I run update I get new blank quotes that I subsequently have to delete by hand. I don't know where these come from and that's the real source of my concern here. I've not done that for about a week and I just now deleted about 150 anonymous and empty quotes. I really like to not have them appear in the first place. Have you looked to find which modules touch the table as Richard Damon suggested? If a contrib module is causing you grief you need to open an issue with that module.
And to cut down how much you need to search, it is almost certain to be a contrib module, not core so under likely under sites/all/modules (unless you are using multi-site) and is very likely to be in the modules *.info file (if it made the changes on install/upgrade). If you have shell access, the needed grep should be fairly quick, even if you don't limit to just *.info -- Richard Damon
participants (5)
-
Dave Stevens -
Earnie Boyd -
Ms. Nancy Wichmann -
Richard Damon -
Richard Damon