Results in the MySQL database are all 0 for all columns

Please do not duplicate post, it confuses responses. You have responses here Could not save PLC output data from mqtt node to MySQL