reseting the hook_update_n status of a module

Question

I'm extending a module I've previously written and it needs some schema changes which I implement in hook_update_N.

I've updated the module's version from 7.x-1.0 to 7.x-1.1 and implemented the foo_update_7100 and it works fine.

The problem is that I've made a mistake inside foo_update_7100 and now that I've fixed it I cannot rerun the 7100 update. I need to create a 7101 one but that doesn't make sense because all my changes are not committed yet.

I've tried reseting the status of the hook_update_n via:

update system set schema_version=-1 where name='foo';

> Query OK, 1 row affected (0.01 sec)
> Rows matched: 1  Changed: 1  Warnings: 0

Then I do drush cc all but drush updatedb -y still gives me "No database updates required".

How can I solve this instead of simply incrementing the hook_update_N number?

Answer 1

Setting it to 0 should work. system_schema() says the value should be:

-1 if the module is not installed (its tables do not exist); 0 or the largest N of the module's hook_update_N() function that has either been run or existed when the module was first installed.

Answer 2

FYI, in Drupal 8, the system table has been removed, and this information is now stored in the key_value table.

UPDATE key_value SET value='i:8000;' WHERE collection = 'system.schema' AND name = 'module_name';

(As noted above, the actual value should be less than the hook_update_N() you want to repeat, but higher than or matching the last update that does not need to be repeated.)

Answer 3

I did this so much that I ended up writing a drush module to roll back the update version in the system table. Called "uroll" for update rollback.

https://github.com/danshumaker/drush-uroll

Usage: drush uroll --module=mycustommodule --version=5

It's super simple but I use it all the time. This combined with a database backup reload script allows you to rinse and repeat when writing update functions.

Hopefully helpful to you. Good luck.

Answer 4

For anyone who is still looking for an answer you can achieve this in 3 ways:

• SQL: UPDATE system SET schema_version = [N*] WHERE name = '[Name of module]';

• Drush: drush ev "drupal_set_installed_schema_version('[Name of module]', [N*])"

• Drush uroll drush uroll --module=[Name of module] --version=N*

*N being the update function you want to revert to (i.e the last successful update function)

Answer 5

To get your update hook to run again, you should set the schema_version to 1 below the sequence number of your hook.

Technically, anything below the hook you wish to rerun and above the update hook you do not need/want to rerun (but at least 0; -1 means the module is not installed) is OK; if there are no other update hooks, that means that even 0 falls between those boundaries, but in the typical case, update hooks are increased by one, so only going 1 lower is the only safe option if you do not want to run more code than the current highest update hook.

The update process simply checks that value, and sees if there are any update hooks with a higher sequence number. If so, it will run them in sequence. (This also means that the installation process sets the schema version to that corresponding to the highest available update hook; it assumes that upon installation, your module will have a state corresponding to that last update hook).