Field 'views' doesn't have a default value - INSERT INTO scms_module_advertising_campaign_banner_metrics (banner_uid, period_uid, clicks) VALUES ('OGlTNqkZ', 'GSXvSGTR', 1 ) ON DUPLICATE KEY UPDATE clicks = clicks + 1