After installation of the module Variable the following error message is thrown attempting to search for updated modules:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.igs_intra_cache_variable' doesn't exist: DELETE FROM {cache_variable} WHERE (expire <> :db_condition_placeholder_0) AND (expire < :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => 1298743139 ) in cache_clear_all() (Zeile 170 von /var/www/html/cm7/includes/cache.inc).

The URL was: http://www.xxx.yyy/cm7/de/batch?id=245&op=do
Referrer: http://www.xxx.yyy/cm7/de/batch?op=start&id=245

Is the name of this table wrong? Or how can I add the table?

Comments

GStegemann’s picture

GStegemann commented

And this message is also displayed at the end of Modules page:

    * Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/cm7/includes/common.inc:2561) in backtrace_error_handler() (Zeile 588 von /var/www/html/cm7/sites/all/modules/devel/devel.module).

    * PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.igs_intra_cache_variable' doesn't exist: DELETE FROM {cache_variable} WHERE (expire <> :db_condition_placeholder_0) AND (expire < :db_condition_placeholder_1) ; Array ( [:db_condition_placeholder_0] => 0 [:db_condition_placeholder_1] => 1298750139 ) in cache_clear_all() (Zeile 170 von /var/www/html/cm7/includes/cache.inc).
jose reyero’s picture

jose reyero commented
Status: Active » Postponed (maintainer needs more info)

The 'cache_variable' table should be created when installing the variable module, as it's defined on the module's install file.

It may be missing if you are updating from a previous (dev or alpha) version. Try reinstalling the module.

GStegemann’s picture

GStegemann commented

Thanks, re-installation fixed it.

But in fact, it was a first time fresh installation of this module. Strange though.

Maybe the Updater failed somehow because yesterday there were many updated modules found on drupal.org. Or because several other modules now have a dependency to Variable, which was not there before and caused some side effects, like the missing columns in module Internationalization.

jose reyero’s picture

jose reyero commented
Status: Postponed (maintainer needs more info) » Fixed

Status: Fixed » Closed (fixed)

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