mysqldump 8 enabled a new flag called columm-statistics by default. When you have MySQL client above 8 and try to run mysqldump on older MySQL versions, you will get the error below. mysqldump: Couldn’t execute ‘SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM ‘$”number-of-buckets-specified”‘) FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = ‘myschema’ AND TABLE_NAME = ‘craue_config_setting’;’: Unknown …

When I was running AWS CDK, I got this error and couldn’t really find the answer when I googled it. This error might happen for different reasons, but I worked out what was wrong with my CDK code after a few hours of googling and trying out different things. I’m …

I had an interesting problem with Promise Polyfill to make promise and finally work on IE11. The page has multiple JS bundles. The existing JS bundles all had Promise polyfill from older version of core-js (babel-core@7.0.0-bridge.0). import ‘core-js/es6/promise’; Then, I added another JS bundle with the latest Promise polyfill. The …

When you try to run a Maven project Java Servlet app first time, you might get this No Compiler is Provided error Eclipse/Maven error: “No compiler is provided in this environment” The solution is simple. You need to add tools.jar to installed JRE. (1) Eclipse –> Window –> Preference (2) …

I created a website that uses SVG files imported in img tags. It looked fine. When I tested the mobile version with iPhone, the SVG was bloated. It worked fine with Android with Chrome, Windows with Chrome and Mac with both Safari and Chrome. For some reason, the sizing attributes, …

I got a new laptop. I installed the latest Node.js and cloned a repo to keep continuing with my React project. I ran npm i to install all dependencies. The app started fine and built fine. However, when I ran npm test, the test was not running. My test script …

A NuGet package, Sitecore.FakeDb helps us to test functions that use Sitecore API. It is a mock memory database where you can remove the dependencies and isolate the code. When you create a brand-new test project, setting up FakeDb can be tricky. Installing FakeDb and adding the usual two Sitecore …

Sitecore PowerShell Extensions is a powerful Sitecore development tool to manage Sitecore contents, create automation jobs and do a tons of cool stuff. It brings the PowerShell scripting capabilities to deliver Sitecore solutions faster. It also has a lot of out of box tools that doesn’t require PowerShell scripting skills. …

When your controller rendering is failing with Could not create controller along with the inner exception,Constructor on type (your constructor name, e.g Sitecore.Feature.Controllers.MediaController)  not found, there is something wrong with the actual controller code. Could not create controller error has a few different reasons. Another common reason is the inner …

When you set up a visual studio project for Sitecore, you need to set Output type to Class Library. If it is set to Windows Application or Console Application, you need to change it to Class Library. Otherwise you get a build error below. error CS5001: Program does not contain …