Convert between Local Time and UTC or Zulu time

Here is some visual basic code for you!
You receive a ZULU time and want to store it in your local time?

Dim MyZulu As New Date(year,month,day,hr,min,sec,DateTimeKind.Utc)
Dim MyLocal As DateTime = MyZulu.ToLocalTime()

Or is someone or some API asking you for the next format in return, and all you have is a DateTime with your local time in it?

*UTC + offset as (YYYY-MM-DDThh:mm:ss+hh:mm)
Continue reading Convert between Local Time and UTC or Zulu time

System.NullReferenceException: ‘Object reference not set to an instance of an object.’

A happy error while coding in visual basic, vb.net
It is not the line where you get this error, but something that happened before, that made one of your variables invalid and unusable.

Read this. (@ NullReference Exception — Visual Basic)

Continue reading System.NullReferenceException: ‘Object reference not set to an instance of an object.’

WordPress 404 errors

How To Fix Broken Permalinks In WordPress.
WordPress is a powerful CMS. Sometimes a slight tweak can make your website inaccessible. Another common problem that most WordPress users face at some point is WordPress posts returning a 404 Error. In this article we will show you how to fix WordPress posts returning 404 error.

Usually in this scenario a user can access their WordPress admin area, their blog’s main page, but when accessing a single posts they get a 404 Not found error. First of all, don’t panic most of the time your posts are still there and completely safe. This usually happens if your .htaccess file got deleted or something went wrong with the rewrite rules. What you need to do is fix your permalinks settings. There are several sites describing this, below is the summary of what you actually need to do.

UPDATE JULY 2021: “Still haven’t found what I’m looking for”… so I wrote my own htaccess_keeper plugin. It runs on the normal homepage of the website to save the htaccess to a backup file (when changed), and restores it when a zero bytes file has been detected. It also shoots of an e-mail to the admin that it had to jump to the rescue again!
Interested in this plugin? It is for sale, just contact My Brain.

Continue reading WordPress 404 errors

Breakpoint will not be hit?

Visual Studio Community edition is great… except sometimes you get an error like “The breakpoint will not currently be hit. No symbols have been loaded for this document.

Whats’s going on? And how to solve? Google! and find this, except it sounds too complicated. Simply go into your menu:

- Debug
- Options
- General
AND: Remove the check-mark for "Enable Just My Code"

That’s all folks!
Have a nice day…

Data size troubles 1406

When the scripts start compaining, “[Native code: 1406] [Native message: Data too long for column …]”, check how much data you are actually trying to squeeze into a single field.
source: maximum length of data I can put in a BLOB column in MySQL?

BLOB ≈ 64KB,
MEDIUMBLOB ≈ 16MB and
LONGBLOB ≈ 4GB

Also: “The maximum size of a BLOB or TEXT object is determined by its type, but the largest value you actually can transmit between the client and server is determined by the amount of available memory and the size of the communications buffers.”
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html

Row size too large (> 8126)

Error Code: 1118
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline.

See the possible solutions here:
https://mariadb.com/kb/en/troubleshooting-row-size-too-large-errors-with-innodb/

Get your ‘create table’ sql code and add:

SET GLOBAL innodb_default_row_format='dynamic';
SET SESSION innodb_strict_mode=OFF;
Continue reading Row size too large (> 8126)