sorry got busy in the weekend, ok I resolved one issue.
i.e. Now it started updating again, The problem was on the new mysql server, Strict mode was on.
Now the problem is there is a delay of 6hrs before it gets updated. Definitely a time issue, But not sure where, because the time all looks to be correct.
