Null value when logging to database

argis · Joined: 06 May 2019 Posts: 31

I'm having some problems with the common log. I'm logging to MariaDB using ODBC, but occasionally a record will have a field with a null value.
I'm using a custom string variable called 'Site' which is set per device, and is included in the SQL query to export to the database. Sometimes, quite randomly, it will be null.
I'm running MariaDB v10.3 and HM v11.97 on the same server, which is Server 2016, using the 32-bit MySQL ODBC connector.

Does anyone have any clues as to what might cause this?

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

Sorry, I do not understand how you could setup "Site" variable.
If you set folder-level variable, it will be named like %fvar_site%.
If you set global variable, it will be named like %udv_site%.
if you use test comment, then you should use variable like %CommentLine1%

Regards
Alex

argis · Joined: 06 May 2019 Posts: 31

My mistake, I was looking at the field names in the database and not paying attention...
The variable is indeed called %fvar_site%.

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

I assume you did not specify this variable for some folders?

Regards
Alex

argis · Joined: 06 May 2019 Posts: 31

Yes it was specified for all folders, but it was randomly missing sometimes but not most of the time.
However I've just been talking to our developer and he thinks that it might be a problem with the database itself, so please ignore this and I'll see if we can sort it out at our end.