This question has been answered by d_u_n.. See the first response.
Make sure your date.timezone setting in PHP matches that used by your MySQL
Server configuration. If it does not, you are going to have trouble. If you
cannot change your php.ini, you can set the date_timezone setting inside
MODX to the proper PHP timezone string that matches the timezone being used
by MySQL. See http://php.net/manual/en/timezones.php for valid timezones for
PHP.
Ok got the solution, opengeek this might be a post from you but I can't find it now:
Make sure your date.timezone setting in PHP matches that used by your MySQL
Server configuration. If it does not, you are going to have trouble. If you
cannot change your php.ini, you can set the date_timezone setting inside
MODX to the proper PHP timezone string that matches the timezone being used
by MySQL. See http://php.net/manual/en/timezones.php for valid timezones for
PHP.
So I set the MODx date_timezone to match the server, and that did the trick. Luckily MySQL and PHP were both matching the server already.