diff -r ed4f22cfb135 -r 31caffee8c9c bmsd/mysql.c --- a/bmsd/mysql.c Mon Jan 06 16:06:28 2020 +0100 +++ b/bmsd/mysql.c Tue Jan 07 15:47:00 2020 +0100 @@ -729,7 +729,7 @@ snprintf(query, 2559, "INSERT INTO mon_ispindels SET uuid='%s', alias='%s', node='%s', online='%d', mode='%s', alarm='%d', " \ - "angle='%.6f', temperature='%.4f', battery='%.4f', gravity='%.6f', up_interval='%d'", + "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d'", ispindel->uuid, ispindel->alias, ispindel->node, ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval); @@ -747,7 +747,7 @@ snprintf(query, 2559, "UPDATE mon_ispindels SET online='%d', mode='%s', alarm='%d', " \ - "angle='%.3f', temperature='%.3f', battery='%.3f', gravity='%.3f', up_interval='%d' WHERE uuid='%s'", + "angle='%.5f', temperature='%.4f', battery='%.6f', gravity='%.5f', up_interval='%d' WHERE uuid='%s'", ispindel->online ? 1:0, ispindel->mode, ispindel->alarm, ispindel->angle, ispindel->temperature, ispindel->battery, ispindel->gravity, ispindel->interval, ispindel->uuid);