I have a working Drupal 7.14 system

I decided to install 'advanced_forum' module

	drush @DEV dl advanced_forum-7.x-2.x-dev
		Project advanced_forum (7.x-2.x-dev) downloaded to /srv/www/dev/sites/all/modules/contrib/advanced_forum.                                                                                       [success]
		Project advanced_forum contains 9 modules: silver_bells_stacked, naked_stacked, blue_lagoon, cloudless_day_stacked, silver_bells, naked, blue_lagoon_stacked, cloudless_day, advanced_forum.

Looks ok so far.

But when I enable the module(s)

	drush @DEV en advanced_forum forum statistics
		The following extensions will be enabled: advanced_forum, forum, statistics, comment, taxonomy
		Do you really want to continue? (y/n): y
		WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array                                  [error]
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Cannot modify header information - headers already sent by (output started at /srv/www/drush/includes/output.inc:37) bootstrap.inc:1239                                                                                  [warning]
		PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Drush command terminated abnormally due to an unrecoverable error.                                                                                                                                                                [error]

Now I can't recover from it -- or do anything it seems.

	drush @DEV en taxonomy
		WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array                                  [error]
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Drush command terminated abnormally due to an unrecoverable error.                                                                                                                                                                [error]
		PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).

	drush @DEV pm-info
		WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array                                  [error]
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Drush command terminated abnormally due to an unrecoverable error.                                                                                                                                                                [error]
		PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).

	drush @DEV pm-disable advanced_forum forum statistics
		WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array                                  [error]
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Drush command terminated abnormally due to an unrecoverable error.                                                                                                                                                                [error]
		PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).

	drush @DEV cc all
		WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array                                  [error]
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Drush command terminated abnormally due to an unrecoverable error.                                                                                                                                                                [error]
		PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).

	drush @DEV pm-info
		WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array                                  [error]
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).
		Drush command terminated abnormally due to an unrecoverable error.                                                                                                                                                                [error]
		PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'D7_db.taxonomy_vocabulary' doesn't exist: SELECT name, machine_name, vid FROM {taxonomy_vocabulary}; Array
		(
		)
		 in taxonomy_vocabulary_get_names() (line 884 of /srv/www/dev/modules/taxonomy/taxonomy.module).

How do I undo this damage and recover?

Comments

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Category: bug » support
Priority: Major » Normal
Status: Active » Fixed

(Changing to a support request until we have reproducable bug).

Try to manually disable those modules directly in the database in the system table, set status to 0 for each row where the name column matches one of the modules that you enabled. Then empty the cache and cache_bootstrap tables.

That should get your site back up, try to uninstall the taxonomy module then and only afterwards try to re-enable it.

RandyK’s picture

RandyK commented

following your instructions, and also reading

Disabling modules manually in the database

then

	mysql D7_db
		> SELECT status FROM system where name = 'taxonomy';
		+--------+
		| status |
		+--------+
		|      1 |
		+--------+
		1 row in set (0.00 sec)

		> UPDATE system SET status='0' WHERE name='taxonomy';
		> DELETE FROM cache_bootstrap WHERE cid='system_list';

		> SELECT status FROM system where name = 'taxonomy';
		+--------+
		| status |
		+--------+
		|      0 |
		+--------+
		1 row in set (0.00 sec)
		> quit

	drush @DEV pm-uninstall taxonomy
	drush @DEV pm-enable    taxonomy
	drush @DEV pm-enable    statistics forum advanced_forum

and I'm back in business !

THANK YOU !!

Status: Fixed » Closed (fixed)

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