last check in future

[MarioF]

i had a problem with a linux server running zabbix was running fast. unfortuantely I made an error and forwarded there server onto October 2010. I realised my mistake and corrected it, but now my last check is still set to October 2010! Is there a way I can change this?
my db is mysql v5.

Thanks

Mario

[MarioF]

progress

okay, so it looks like there is a nextcheck field under zabbix.items. I'm not sure what the sql should be to do a global replace to change the value of nextcheck to zero.
if this the right thing to do?

[MarioF]

Solved

okay, i ran the following sql:

update zabbix.items
set nextcheck=0
where nextcheck > 0 where hostid=<blah>

once I was happy that things were working as expected, i removed the "where hostid" section.