Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Internal TimedEvents date wrong Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
moniputer
Groupie
Groupie


Joined: October 27 2006
Location: United States
Online Status: Offline
Posts: 44
Posted: August 21 2015 at 08:51 | IP Logged Quote moniputer
PH came up with a system date of 10/20/15. I have
corrected that and re-started PH but now all timed events
are scheduled for 10/20/15.

How to I correct this?
Back to Top View moniputer's Profile Search for other posts by moniputer
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: August 21 2015 at 09:16 | IP Logged Quote dhoward
Moniputer,

You could correct this with the following SQL
statement executed in the PH Multi-Editor in SQL mode
(shift-F5):

update timedevents set starttime =
dateadd(day,-60,starttime),reftime =
dateadd(day,-60,reftime)

You would want to first stop timedevents, then execute
the sql, open the PH Explorer and check everything is
ok and then restart Timed events. This SQL would bring
everything back to today's date (10/20/2015 is 60 days
different from today).

As with anything sql, its very easy to corrupt your
database so I would probably take a backup first. You
could also correct the timed event entries by hand in
the PH Explorer if you'd rather not use SQL.

Hope this helps,

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
moniputer
Groupie
Groupie


Joined: October 27 2006
Location: United States
Online Status: Offline
Posts: 44
Posted: August 21 2015 at 09:36 | IP Logged Quote moniputer
Thanks Dave!

Joe
Back to Top View moniputer's Profile Search for other posts by moniputer
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum