As in Features issue #2511858, an error is produced updating from 7.x-2.0-alpha9 to 7.x-2.0-beta1 using Drush 5.9

WD php: PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "cache_feeds_http" does not exist: TRUNCATE [error]
{cache_feeds_http} ; Array
(
)
in cache_clear_all() (line 167 of /var/www/html/drupal7/includes/cache.inc).

Manually installing the updated module, and running db update provides an alternative.

CommentFileSizeAuthor
#1 feeds-cache-table-exists-2531706-1.patch568 bytestwistor

Comments

twistor’s picture

twistor commented
Status: Active » Needs review
StatusFileSize
new feeds-cache-table-exists-2531706-1.patch568 bytes

I suppose we can use the same fix.

  • twistor committed e21dbe1 on 7.x-2.x 
    Issue #2531706 by twistor: relation "cache_feeds_http" does not exist
twistor’s picture

twistor commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

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

memcinto’s picture

memcinto commented

Also with drush 5.7.

jaredcampbell’s picture

jaredcampbell commented

I was receiving a similar error, but it referred to cache_feeds_http as a table, not a relation. I believe my error was related to an update with the media, file_entity module and the problem discussed at https://www.drupal.org/node/2170231. The patch in #1 fixed the problem after I manually reverted the file_entity schema_version in the system table from 7101 to 7100 and ran update.php.

benjarlett’s picture

benjarlett commented

worked for me with drush version 6.2

when running update.php or clearing cache I was getting:

WD php: PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '****.cache_feeds_http' doesn't exist: TRUNCATE {cache_feeds_http} ; Array [error]
(
)
in cache_clear_all() (line 167 of /var/www/vhosts/******/httpdocs/includes/cache.inc).
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '****.cache_feeds_http' doesn't exist: TRUNCATE {cache_feeds_http} ; Array
(
)
in cache_clear_all() (line 167 of /var/www/vhosts/*****/httpdocs/includes/cache.inc).

jacov’s picture

jacov commented

@twistor++ patch #1 works for me too

was getting this on drush cc all:

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx_dev.cache_feeds_http' doesn't exist' in         [error]
efes’s picture

efes commented

Thanks! Patch #1 worked for me too.

adrian1231’s picture

adrian1231 commented

Patch works for me as well.