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