| Author |  | 
      
        | NorthernAl Groupie
 
  
 
 Joined: March 19 2006
 Online Status: Offline
 Posts: 48
 | 
          I've been using PH for a while so it seems crazy to ask these simple questions but not knowing the answers bugs me!
           | Posted: March 17 2007 at 12:40 | IP Logged |   |  
           | 
 |  
 - where is the log stored? in DB or disk file? If disk can it be deleted off disk?
 - I ask because due to a clock problem on my pc I ended up with events in the future in my log. Hard to get rid of them (even with log trim command)
 - is the only way to refresh the log window to close and reopen it?  A refresh button would be nice.
 
 | 
       
        | Back to Top |     | 
       
       
        |  | 
        | TonyNo Moderator Group
 
  
  
 Joined: December 05 2001
 Location: United States
 Online Status: Offline
 Posts: 2889
 | 
          The log is in the DB.
           | Posted: March 17 2007 at 14:41 | IP Logged |   |  
           | 
 |  
 I view the log via the web. Seems quicker and has a refresh button.
   | 
       
        | Back to Top |       | 
       
       
        |  | 
        | dhoward Admin Group
 
  
  
 Joined: June 29 2001
 Location: United States
 Online Status: Offline
 Posts: 4447
 | 
          The log is in the database in two tables...eventlog and weblog.  You can get rid of events in the future with this SQL statement:
           | Posted: March 19 2007 at 17:14 | IP Logged |   |  
           | 
 |  
 delete from eventlog where time_stamp > today()
 
 When the eventlog report is open (and active), F5 will refresh the data.
 
 Also, the PowerHome Status screen has a realtime eventlog window.  You can size this window to be the predominant window if you like and change a setting in the pwrhome.ini file ([PowerHome Status] eventlogrows) to go from the default last 10 rows displayed to more if you like.
 
 Dave.
 
 | 
       
        | Back to Top |       | 
       
       
        |  |