Hello,

when I re-enable 'update manager' module, it throws:

DatabaseSchemaObjectExistsException: Table cache_update already exists. in DatabaseSchema->createTable() (line 630 of /opt/pjkaixin-stage/pjkaixin/includes/database/schema.inc).

Comments

bfroehle’s picture

Component: update.module » base system

Moving this over to the base system, since I assume that is who is responsible for installing and uninstalling schemas.

rogical’s picture

Status: Active » Closed (won't fix)

problem can't be reproduced.

rickmanelius’s picture

Same problem.

astrojim’s picture

Version: 7.0 » 7.2

I get the same after migrating from 7.0 to 7.2.

DatabaseSchemaObjectExistsException: Table cache_update already exists. in DatabaseSchema->createTable() (line 629 of /var/www/awacs/includes/database/schema.inc).

astrojim’s picture

Also I get:

"One or more problems were detected with your Drupal installation. Check the status report for more information."

But the status report is green across the board. When I disable the update module the message goes away. Also note the update module report is not visible at any time (enabled or not, even if cron has been run).

Damien Tournoud’s picture

Priority: Major » Normal
Status: Closed (won't fix) » Postponed (maintainer needs more info)

Cannot reproduce on MySQL. Which database engine are you using?

astrojim’s picture

MySQL - I managed to get the issue resolved by truncating the cache_update table by hand, not a real fix but good enough for me.

EpF’s picture

Version: 7.2 » 7.9
Priority: Normal » Major

I just got this error updgrading from 6.22 to 7.9 when I tried to activate the update manager.

There is no data in the table for me to truncate before or after the attempt. Dropping the table before the attempt doesn't work either.

Regarding the engine: My database contains tables of both the MyISAM and InnoDB engines. The cache_update table is InnoDB.

Please let me know if there is any more information I can provide.

sylv3st3r’s picture

I also got this error message, so this is what I did after reading the update.install and inspecting my database

1. Go to "system" table, search for filename "modules/update/update.module"
2. Change the 'schema_version' into 7000
3. Then run update.php

On schema update 7001, it will drop your entire cache_update table and recreate it. It solves my problem

HypervisedEd’s picture

Post #9 resolved the same exact issue for me me!

knalstaaf’s picture

#9 didn't work right away after setting it to 7000 and running update.php. But it did after changing it manually to 7001 (and then run update.php again).

Edit: it did run right away, but I had to apply the changes I made in the db with Navicat ofcourse. The module should be enabled too, despite its error (depending on your update settings for enabled/disabled modules, really).

vegansupreme’s picture

Version: 7.9 » 7.26
Issue summary: View changes

#9 works for me too. Also, even easier workaround is the following drush command:
drush sql-query "UPDATE system SET schema_version='7000' WHERE filename='modules/update/update.module'"
I'm experiencing this error because my production site has update module disabled and uninstalled. However, when I pull the database to local dev and enable the module there, I get the aforementioned error.
I don't know if the problem is on the uninstall side, or the install side.

RAWDESK’s picture

Upgrading from 7.43 to 7.50 also gave me this error when enabling update_manager.
It was not necessary to apply #9.
Simply ran update.php and enabling was successful.

stefan.r’s picture

Makdomen’s picture

I have this problen 4 year.
Post #9 resolved the same exact issue and for me me!
In Drupal core 7.59
Tkanks sylv3st3r

markabur’s picture

Version: 7.26 » 7.65

Thanks, #12 worked for me. Drupal 7.65

Version: 7.65 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.