I suddenly encounter the above error when trying to create a new content of my Content Type "Event":
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_event_image_width' at row 1
This is the first time I see this error after updating from Drupal7. It was ok a week ago and before. In this week I updated a block and another event node text content. I also did some trials to run cron job for Civicrm module, via cPanel Cron Jobs command setup. Civicrm is using a separate database. The cron job setup wasn't successful for some reasons which I'm still trying, but it's a separate issue.
I've tried to restore database using Backup and Migrate to a week before, and replaced those config files in 'active' folder. But the problem was not resolved.
Also noticed that if I save the content as draft, the error didn't happen, the node will render and display.
Am not sure what I should further attempt to rectify this problem. Have downloaded sql backup files from cPanel JetBackup feature, but thought I should hear from the experts here before I explore further. I also wonder what would have caused this, since nothing that I did last one week should have affected the codes...