Update Drupal 8 DB to allow Updates to be run again for testing and dev purposes

-

When working with Drupal 7 and indeed Drupal 8 we may sometimes need to run updates (hook_update) again. In Drupal 7 updating system table should have been sufficient. In D8 things are a little bit different.


Run a database update as follows:
  • SELECT collection, name, substring(value, 1, 2500) FROM key_value WHERE collection="system.schema" and name="modulenameinquestion"
    • The above will give us the last update hook that was run on this database.
  • UPDATE key_value SET value = 'i:9999' where collection="system.schema" and name="modulenameinquestion"

Hope this helps.

Comments

Post a Comment

Popular posts from this blog

Use feeds module to import XML data in Drupal 7

-
Recently i had to setup a xml import process to import data from an external supplier on a regular basis, the filename and format was not changing and i could choose where to store the file. Following is how i set it up. First we need to download the following modules feeds feeds admin ui feeds_xpathparser ctools job_scheduler enable the above modules. We will need a sample XML so this will be the one we will use for this demonstration: <?xml version="1.0" encoding="utf-8" ?> <!-- Sample for demonstration of processing XML feeds with feeds module --> <Orders> <Order> <CustomerID>10</CustomerID> <Order_Number>1</Order_Number> <Order_Total>100</Order_Total> <Currency>£</Currency> </Order> <Order> <CustomerID>11</CustomerID> <Order_Number>2</Order_Number> <Order_Total>40</Order_Total> <Currency>$</Currency> ...
Read more

Using Wodby (drupal4docker) to create our local development environment.

-
Image
Using Wodby https://wodby.com  to create a Drupal local development environment using docker. I have used the official Drupal docker image to create a local dev environment, it certainly does work but does not really tie in with how we currently use and develop on Drupal. I have checked Wodby drupal4docker and it seems to do what I expect and want the local dev environment. How to set this up Obviously there is a documentation on how to set this up https://wodby.com/docs/stacks/drupal/local/ even though the documentation is quite thorough I still struggled a bit so wanted to create a documentation for myself and anyone who happens to stumble on this link. My setup will consist of a local Drupal 8 code base with custom modules and themes, I save my code base in git including the Drupal code, this may not be really needed in the future as we are moving to using composer but for now I am sticking to keeping the Drupal codebase in my repository. I als...
Read more

How do you expose your legacy database tables to views in drupal 6 Part 1

-
This is a 2 part post, that shows how I exposed a legacy table to views in drupal and used the incredible power of views to create many combinations static and conditional views. This was very helpful for my client. I had a requirement that warranted exposing existing database table to views, so that views can contain data from this table.  To enable this to happen, the following steps need to be taken. In a custom module you need to first define the views_api hook as following: function candidate_views_api(){     $view = array ();     $view = array ( 'api' => 2 ,                   'path' => drupal_get_path( 'module' , 'candidate' ). '/views' );     return $view ; } candidate module was a custom module which I already had, so it made sense to add this hook here.  The important bit here is telling the drupal sub-system where the views file will reside.  ...
Read more