I made a mistake. When we changed the domain from events.energywhiz to energywhiz, some of the links didn’t get changed, so that’s what was causing the issue.
Steven is correct, do not modify the core WordPress tables.
FYI, the error you encountered was due to the default value for ‘user_registered’ being zero. So to fix this, you could change the default value to any non-zero date. It has to do with PHP versions changing their rules.
Read more about it here:
https://medium.com/@infinitesimal_/fixing-invalid-default-value-for-timestamp-field-mysql-a4dd22bdad85