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