I try to install backup and migrate module, but when save jump this error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'data_base_cache_vars' doesn't exist: TRUNCATE
{cache_vars} ; Array ( ) in cache_clear_all() (line 165 of /home/user/public_html/includes/cache.inc).

And i need it to finish a work.

Comments

John_B’s picture

cache_vars is used by the Variables API module. Did you install it? Maybe uninstall it?

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

thitoo’s picture

same issue with above and yes used the variables module and it is difficult to uninstall because I used shop module

John_B’s picture

I would have a look to see if the table cache_vars exists (e.g in phpmyadmin).

I do not find a module 'shop'. Considering that Variables API appears not to be receiving active support by the maintainters, I would not use it myself unless I had time to support it rather than relying on it to just work. It is a risk you may choose to take, or maybe find a way to work without it.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors

Olawunmi’s picture

Error messagePDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'olawunmi.cache_views' doesn't exist: TRUNCATE {cache_views} ; Array ( ) in cache_clear_all() (line 168 of C:\xampp\htdocs\drupal7.50\includes\cache.inc).
please i need idea on how to solve this issue.