From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '973931_d217.cache_update' doesn't exist: SELECT cache_update.cid AS cid, cache_update.data AS data, cache_update.created AS created, cache_update.expire AS expire, cache_update.serialized AS serialized FROM {cache_update} cache_update WHERE (cache_update.cid LIKE :db_condition_placeholder_0 ESCAPE '\\') ; Array ( [:db_condition_placeholder_0] => available_releases::% ) in _update_get_cache_multiple() (line 823 of /srv/disk4/973931/www/1.mosswebs .com/modules/update/update.modul e). It seems a table is missing. How do I create that? Via PHPMyAdmin? Thanks, John
Something failed to install. You don't want to use PHPMyAdmin but instead, go to admin/modules, disable the update module, then go to the Uninstall tab and uninstall the update module. It doesn't delete the module but resets it so that the system now thinks it isn't installed. Once that is complete go back to admin/modules and enable the module. It will install the tables it needs. Earnie On Fri, Nov 9, 2012 at 1:27 PM, John S Moss <mossj5@comcast.net> wrote:
From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]:
Base table or view not found:
1146 Table
'973931_d217.cache_update'
doesn't exist: SELECT
cache_update.cid AS cid,
cache_update.data AS data,
cache_update.created AS created,
cache_update.expire AS expire,
cache_update.serialized AS
serialized FROM {cache_update}
cache_update WHERE
(cache_update.cid LIKE
:db_condition_placeholder_0
ESCAPE '\\') ; Array (
[:db_condition_placeholder_0] =>
available_releases::% ) in
_update_get_cache_multiple()
(line 823 of
/srv/disk4/973931/www/1.mosswebs
.com/modules/update/update.modul
e).
It seems a table is missing. How do I create that? Via PHPMyAdmin?
Thanks,
John
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd
Thanks Earnie. How do I get to admin/modules? Any link across the top results in the error, except for the "Hello Admin" link. -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Friday, November 09, 2012 11:36 AM To: support@drupal.org Subject: Re: [support] Drupal 7 Error Something failed to install. You don't want to use PHPMyAdmin but instead, go to admin/modules, disable the update module, then go to the Uninstall tab and uninstall the update module. It doesn't delete the module but resets it so that the system now thinks it isn't installed. Once that is complete go back to admin/modules and enable the module. It will install the tables it needs. Earnie On Fri, Nov 9, 2012 at 1:27 PM, John S Moss <mossj5@comcast.net> wrote:
From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]:
Base table or view not found:
1146 Table
'973931_d217.cache_update'
doesn't exist: SELECT
cache_update.cid AS cid,
cache_update.data AS data,
cache_update.created AS created,
cache_update.expire AS expire,
cache_update.serialized AS
serialized FROM {cache_update}
cache_update WHERE
(cache_update.cid LIKE
:db_condition_placeholder_0
ESCAPE '\\') ; Array (
[:db_condition_placeholder_0] =>
available_releases::% ) in
_update_get_cache_multiple()
(line 823 of
/srv/disk4/973931/www/1.mosswebs
.com/modules/update/update.modul
e).
It seems a table is missing. How do I create that? Via PHPMyAdmin?
Thanks,
John
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
If you're comfortable using phpmyadmin you can set that module's status and boot status's to 0. Then you should be able to go in and uninstall it and reinstall. are you sure there's no update.php cycles you forgot to run? -Don- On 11/9/2012 2:34 PM, John S Moss wrote:
Thanks Earnie. How do I get to admin/modules? Any link across the top results in the error, except for the "Hello Admin" link.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Friday, November 09, 2012 11:36 AM To: support@drupal.org Subject: Re: [support] Drupal 7 Error
Something failed to install. You don't want to use PHPMyAdmin but instead, go to admin/modules, disable the update module, then go to the Uninstall tab and uninstall the update module. It doesn't delete the module but resets it so that the system now thinks it isn't installed. Once that is complete go back to admin/modules and enable the module. It will install the tables it needs.
Earnie
On Fri, Nov 9, 2012 at 1:27 PM, John S Moss <mossj5@comcast.net> wrote:
From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]:
Base table or view not found:
1146 Table
'973931_d217.cache_update'
doesn't exist: SELECT
cache_update.cid AS cid,
cache_update.data AS data,
cache_update.created AS created,
cache_update.expire AS expire,
cache_update.serialized AS
serialized FROM {cache_update}
cache_update WHERE
(cache_update.cid LIKE
:db_condition_placeholder_0
ESCAPE '\\') ; Array (
[:db_condition_placeholder_0] =>
available_releases::% ) in
_update_get_cache_multiple()
(line 823 of
/srv/disk4/973931/www/1.mosswebs
.com/modules/update/update.modul
e).
It seems a table is missing. How do I create that? Via PHPMyAdmin?
Thanks,
John
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
If you have just done your initial install. 1. Use phpMyAdmin to drop all the tables in the database. 2. Go into sites/default and delete settings.php 3. Goto www.YourSiteURL.com and run the install again If there has been nothing done or added to your site, you will not loose anything and save a lot of frustration. When you start activating modules, the first one should be backup and migrate. After you activate it, do a backup of the database. You will be able to get there by going to: admin/config/system/backup_migrate Then activate your other modules two or three at a time with a backup in between. This way you can figure out which one caused this problem. The backups are so you can go back to before the problem module messed up the DB and you wont have to go through this all over again. Hope this helps, Cory
I get the error when I run update.php -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Don Sent: Friday, November 09, 2012 12:46 PM To: support@drupal.org Cc: John S Moss Subject: Re: [support] Drupal 7 Error If you're comfortable using phpmyadmin you can set that module's status and boot status's to 0. Then you should be able to go in and uninstall it and reinstall. are you sure there's no update.php cycles you forgot to run? -Don- On 11/9/2012 2:34 PM, John S Moss wrote:
Thanks Earnie. How do I get to admin/modules? Any link across the top results in the error, except for the "Hello Admin" link.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Friday, November 09, 2012 11:36 AM To: support@drupal.org Subject: Re: [support] Drupal 7 Error
Something failed to install. You don't want to use PHPMyAdmin but instead, go to admin/modules, disable the update module, then go to the Uninstall tab and uninstall the update module. It doesn't delete the module but resets it so that the system now thinks it isn't installed. Once that is complete go back to admin/modules and enable the module. It will install the tables it needs.
Earnie
On Fri, Nov 9, 2012 at 1:27 PM, John S Moss <mossj5@comcast.net> wrote:
From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]:
Base table or view not found:
1146 Table
'973931_d217.cache_update'
doesn't exist: SELECT
cache_update.cid AS cid,
cache_update.data AS data,
cache_update.created AS created,
cache_update.expire AS expire,
cache_update.serialized AS
serialized FROM {cache_update}
cache_update WHERE
(cache_update.cid LIKE
:db_condition_placeholder_0
ESCAPE '\\') ; Array (
[:db_condition_placeholder_0] =>
available_releases::% ) in
_update_get_cache_multiple()
(line 823 of
/srv/disk4/973931/www/1.mosswebs
.com/modules/update/update.modul
e).
It seems a table is missing. How do I create that? Via PHPMyAdmin?
Thanks,
John
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
-- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
I suggest you start over but first explain how you installed it. Earnie On Fri, Nov 9, 2012 at 4:23 PM, John S Moss <mossj5@comcast.net> wrote:
I get the error when I run update.php
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Don Sent: Friday, November 09, 2012 12:46 PM To: support@drupal.org Cc: John S Moss Subject: Re: [support] Drupal 7 Error
If you're comfortable using phpmyadmin you can set that module's status and boot status's to 0. Then you should be able to go in and uninstall it and reinstall. are you sure there's no update.php cycles you forgot to run?
-Don-
On 11/9/2012 2:34 PM, John S Moss wrote:
Thanks Earnie. How do I get to admin/modules? Any link across the top results in the error, except for the "Hello Admin" link.
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Friday, November 09, 2012 11:36 AM To: support@drupal.org Subject: Re: [support] Drupal 7 Error
Something failed to install. You don't want to use PHPMyAdmin but instead, go to admin/modules, disable the update module, then go to the Uninstall tab and uninstall the update module. It doesn't delete the module but resets it so that the system now thinks it isn't installed. Once that is complete go back to admin/modules and enable the module. It will install the tables it needs.
Earnie
On Fri, Nov 9, 2012 at 1:27 PM, John S Moss <mossj5@comcast.net> wrote:
From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]:
Base table or view not found:
1146 Table
'973931_d217.cache_update'
doesn't exist: SELECT
cache_update.cid AS cid,
cache_update.data AS data,
cache_update.created AS created,
cache_update.expire AS expire,
cache_update.serialized AS
serialized FROM {cache_update}
cache_update WHERE
(cache_update.cid LIKE
:db_condition_placeholder_0
ESCAPE '\\') ; Array (
[:db_condition_placeholder_0] =>
available_releases::% ) in
_update_get_cache_multiple()
(line 823 of
/srv/disk4/973931/www/1.mosswebs
.com/modules/update/update.modul
e).
It seems a table is missing. How do I create that? Via PHPMyAdmin?
Thanks,
John
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
-- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd
Thanks Earnie. How do I get to admin/modules? Any link across the top results in the error, except for the "Hello Admin" link. -----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Earnie Boyd Sent: Friday, November 09, 2012 11:36 AM To: support@drupal.org Subject: Re: [support] Drupal 7 Error Something failed to install. You don't want to use PHPMyAdmin but instead, go to admin/modules, disable the update module, then go to the Uninstall tab and uninstall the update module. It doesn't delete the module but resets it so that the system now thinks it isn't installed. Once that is complete go back to admin/modules and enable the module. It will install the tables it needs. Earnie On Fri, Nov 9, 2012 at 1:27 PM, John S Moss <mossj5@comcast.net> wrote:
From a rank beginner, I just installed D7, uploaded some new modules, and am now getting this error, no matter what I try to do, from running update.php, to clicking the Configuration link. I get logged in OK.
PDOException: SQLSTATE[42S02]:
Base table or view not found:
1146 Table
'973931_d217.cache_update'
doesn't exist: SELECT
cache_update.cid AS cid,
cache_update.data AS data,
cache_update.created AS created,
cache_update.expire AS expire,
cache_update.serialized AS
serialized FROM {cache_update}
cache_update WHERE
(cache_update.cid LIKE
:db_condition_placeholder_0
ESCAPE '\\') ; Array (
[:db_condition_placeholder_0] =>
available_releases::% ) in
_update_get_cache_multiple()
(line 823 of
/srv/disk4/973931/www/1.mosswebs
.com/modules/update/update.modul
e).
It seems a table is missing. How do I create that? Via PHPMyAdmin?
Thanks,
John
-- [ Drupal support list | http://lists.drupal.org/ ]
-- Earnie -- https://sites.google.com/site/earnieboyd -- [ Drupal support list | http://lists.drupal.org/ ] ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2624/5884 - Release Date: 11/09/12
participants (5)
-
Cory Gilliam -
Don -
Earnie Boyd -
John S Moss -
John S Moss