Fatal MySQL error 1364: Field 'id' doesn't have a default value when attempting to run prune database

Do you see any errors in your logs about Scheduler jobs or cron? Check both

suitecrm.log
php_errors.log

Also give this command

php -i | grep "'_'"

Use copy-paste to put that in, otherwise it’s hard not to mess up. That should be double-quote, single-quote, underscore, single_quote, double_quote.