Heidisql: Bug "Broken NetType value (255)"

[bagoesz21]

Steps to reproduce this issue

1. I update the latest version (11.0.*).
2. And then, i'm open the app, i got error.
3. "Broken NetType value (255) found in settings for session mysql"
4. Then, the app is force close.

Current behavior

Expected behavior

Possible solution

Environment

• *HeidiSQL version: 11.0.0 *
  
• *Operating system: Windows 10 x64 *
  

[gustaflindqvist]

I'm getting this as well with the latest version 11.0.0.5919. I added a new connection in the settings just when I clicked update. So I guess I have a corrupt settings with NetType larger then 255 within settings.

[ansgarbecker]

Build 11.0.0.6097 is the latest version, while 5919 is the latest stable release. Be sure you were not downgrading to that one.

[bagoesz21]

how to fix it ?

[ansgarbecker]

Update HeidiSQL to the latest build 6097. Not the latest release. Then report back if that fixed the issue.

[gustaflindqvist]

ase. Then report back if that fixed the issue.

I have updated to latest build 6097. Still getting error with the corrupt setting:

Broken "NetType" value (255) found in settings for session "DB consent log". Please report that on https://github.com/HeidiSQL/HeidiSQLuery”

[ansgarbecker]

Ok, then we need to go deeper here. Please

• start regedit.exe
• navigate to HKEY_CURRENT_USER\Software\HeidiSQL\Servers\DB consent log\
• watch out for the value named NetType, which is probably really "255", but please post the value here
• do not post any more values or your sensitive data here

[gustaflindqvist]

Doh! That solved it for me. But I removed the DB consent log from Servers and didn't catch the NetType value. 🤦

Before the updated I pasted in r2dbc:postgresql://url-to-server/consent to cut out all pieces in the hostname and renamed the setting configuration to DB consent log. After that NetType value got wrong after the updater prompted to restart the application and the application started again.

[ansgarbecker]

Where exactly did you paste that "r2dbc" url? Did you perhaps create that session in the regisztry, outside HeidiSQL?

[gustaflindqvist]

Where exactly did you paste that "r2dbc" url? Did you perhaps create that session in the regisztry, outside HeidiSQL?

No I didn't. It all went into the hostname field in the settings before I clicked ok to update HeidiSQL.

[ansgarbecker]

I don't know how to reproduce this, so I'll close it. Just shout if you get the error and know how to reproduce.