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

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

Installing sqlyog on Mac OS X Yosemite

-
I like to use sqlyog for my work with mysql, but only windows binaries are supplied on the google code site. Another option is to use sqlyog in wine, so to install wine a simpler option is to use Homebrew (http://brew.sh/). Installation for homebrew is quite straightforward, however you need to have installed the command line tools with xcode, if not please install that first. The installation instructions are already on the first page of the homebrew website, so i will not reproduce this, once brew is installed, install wine. brew install wine when i tried installing wine, brew asked me to install a dependency and nicely told me to do the following wine: XQuartz is required to install this formula. You can install with Homebrew Cask:   brew install Caskroom/cask/xquartz so i just did that, once this was completed i could complete installing wine. Now head over to https://code.google.com/p/sqlyog/wiki/Downloads and install the latest sqlyog, at the time of wr
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 upon a
Read more