Overview for 'mysql'

Fixing JSON errors after database conversion from MySQL 5.6 to 5.7

If you're migrating a database from MySQL 5.6 to 5.7, you might bump into issues with the JSON encoding of certain fields. This probably happens because only in MySQL 5.7, JSON columns are properly supported. The improved support for native JSON makes it more strict, which can cause errors after bumping the database version or after exporting and subsequently importing it.


Written by Bob on Thursday January 14, 2021.

Finding all rows in the database related to a Record

Under the hood, Bolt uses the Doctrine ORM to abstract database storage. This means that a Record in, for example, the Pages ContentType will behave as a single Entity in Bolt, but in the database, its data is persisted in a few different tables.


Written by Bob on Wednesday March 31, 2021.

Renaming ContentTypes

Sometimes, you might want to change the name of an existing ContentType, after development of a site is well under way. Here's how to rename one, without losing existing content.


Written by Bob on Thursday April 22, 2021.