Ok I think you're on to something now... the correct values in the right fields:
So I followed your suggestion to run it with the db and...
MariaDB [raspberrypints]> UPDATE kegs SET label = NULLIF('Keg 3',''), kegTypeId = NULLIF('1',''), make = NULLIF('Kegland',''), model = null, serial =...