By default WordPress adds <p> tags at runtime, so the editor is usually set up to strip them out. But sometimes you might need to use an editor where these tags aren’t stripped out, for example writing content for a newsletter that needs to have these tags in. And you might not want to change... » read more
If you have a bunch of databases that you want to migrate into a single Azure SQL DB, and the table names are all different then that’s quite easy. If you don’t mind renaming things, then there’s a solution for same-named tables too… Add/migrate one database Head over to the Azure SQL section https://portal.azure.com/#create/Microsoft.AzureSQL Create... » read more
No one likes this one. You enabled a new theme on your WordPress multi-site site and you got the instant screen of death. If you try all the other methods first and have no luck, then try this next. If you can’t change the theme in admin, or find yourself locked out then we can... » read more
Sometimes you might be asked to run a compatibility troubleshooter, like this: You might be experiencing the problem due to compatibility issues. To fix it, run Program Compatibility Troubleshooter. Follow the steps below: Right-click on the Microsoft Visual Studio icon on your desktop and select Properties. In the Properties window, click on the Compatibility tab. Now, click on... » read more
Azure .NET web apps connecting to an AWS SQL database kept throwing up this error sporadically, seemingly without any pattern. The full message was this: An unhandled exception occurred while processing the request. Win32Exception: An existing connection was forcibly closed by the remote host. Unknown location.SqlException: A connection was successfully established with the server, but... » read more
I found this message on a site in Google reCaptcha that appeared to be working, so why the error message? We detected that your site isn’t verifying reCAPTCHA solutions. This is required for the proper use of reCAPTCHA on your site. Please see our developer site for more information. In my case I was following... » read more
Newtonsoft.Json.JsonSerializationException: ‘Error converting value {null} to type “System.Boolean”. Code like this can generate the error: This happens when the bool field in your source is null, and the model you’re converting into’s matching field does not allow nulls. If you don’t mind this field being null in your destination model item, then you can just... » read more
With this error: Error inserting data into table. (Microsoft.SqlServer.Import.Wizard)Error inserting data into table. (Microsoft.SqlServer.Prose.Import)Object reference not set to an instance of an object. (Microsoft.SqlServer.Prose.Import) In my case this was due to extra carriage returns at the end of the CSV file – SSMS doesn’t like them! Remove them in a text editor and try again.... » read more
If you come across this ancient bit of code in a Classic ASP project. CDO.Message.1 error ‘80040220’ The “SendUsing” configuration value is invalid. It might not be what you think… Go into IIS, Application Pools, find your website, Right Click and Advanced, then check this setting: Set ‘Identity’ to ‘Network Service’ and see if that fixes... » read more