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

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

Use ProxySQL to obfuscate data for development.

-
Before I begin let me put this out as a protection against the pitch fork guys 🙂 I do not in anyway recommend using live data (albeit sanitised) into dev, we should really have test data and keep updating the test data as application grows and is changed. But in case when your developers are supporting a really fast moving, highly configurable system there may be a need to use live backups to be regularly sanitised and applied to dev systems. The usual way of doing this is take a backup from production servers, transfer to dev/stage servers, restore to Dev DB and then run some sanitisation scripts. This seemed to be a bit of a problem as we did not want to have a situation that the mysqldump of live database sits on pre prod servers or may be left there my mistake. Privacy is a big thing today and due to introduction of GDPR we now have a need to eliminate any chances of collecting and storing personal data where we do not need it.  Enter ProxySQL: I stumbled up...
Read more

Install the right version of php_mongo.dll in windows

-
I use a macbook pro for my freelance work, a ubuntu netbook while travelling and forced to use a windows box at work. I have been recently working a lot with Mongo DB and Drupal, I installed Mongo and php drivers for mongodb without any problems on Mac and Linux, I struggled to get the correct version of php_mongo.dll on my windows box. Installing php_mongo.dll becomes very simple if you find the right version of the dll file. To find the right version, you need to ensure you look at your current configuration, note these steps these will be helpful. use phpinfo() to find out the following information: PHP Version Compiler Architecture Server Software For instance my local machine was a x64 machine running windows 7 pro, however the version of PHP installed was a 32bit. By phpinfo() shows me following: PHP Version: 5.4.x Compiler: MSVC9 (Visual C++ 2008) Architecture: x86 SERVER_SOFTWARE: Apache/2.4.3 (Win32) OpenSSL/1.0.1c PHP/5.4.7 Notice fr...
Read more