Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Can’t Create Timed Event Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: December 10 2006 at 22:59 | IP Logged Quote UpstateMike
Been trying to create a timed Insteon event but I get a database error every time. All fields are filled in... what am I missing?

Timing= Exact
Frequency= One Shot
Type= Device Control
ID= INSTEON+OFFICE SIDE LAMPS+OFF

All set with mouse clicks so no typos.
Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: December 14 2006 at 12:50 | IP Logged Quote UpstateMike
Specifically the error is that column "action" cannot be null in table "timed events". Of course there is no "action" column in the timed events window so how do I resolve this?

Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
cmhardwick
Senior Member
Senior Member
Avatar

Joined: July 08 2006
Location: United States
Online Status: Offline
Posts: 290
Posted: December 14 2006 at 15:21 | IP Logged Quote cmhardwick
have you scrolled over to the right to make sure there's not action column? ID would be Insteon, Device would be Office Side Lamps and Action would be Off. not in one entry, if I remember. Most of my timed events are insteonrawgroup commands

__________________
Cicero, Enjoying automation!
Back to Top View cmhardwick's Profile Search for other posts by cmhardwick Visit cmhardwick's Homepage
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: December 14 2006 at 19:48 | IP Logged Quote TonyNo
I just created a timed event like yours and there was no error.

The Action column in the table is where the commands go.

Edited by TonyNo - December 14 2006 at 19:58
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: December 15 2006 at 00:09 | IP Logged Quote UpstateMike
cmhardwick wrote:
have you scrolled over to the right to make sure there's not action column? ID would be Insteon, Device would be Office Side Lamps and Action would be Off. not in one entry, if I remember. Most of my timed events are insteonrawgroup commands


Yes it is one entry in the form of:

Insteon+Lamps+OFF in the column labeled ID/Keys/Formula

Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: December 17 2006 at 11:25 | IP Logged Quote UpstateMike
TonyNo wrote:
I just created a timed event like yours and there was no error.

The Action column in the table is where the commands go.


Don't know what I am doing wrong. I shut down and restarted PH and then tried again. I always get the same error. Does this mean my database is corrupted?
Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
TonyNo
Moderator Group
Moderator Group
Avatar

Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
Posted: December 17 2006 at 11:33 | IP Logged Quote TonyNo
Could be. Try a rebuild (run phupg.exe).
Back to Top View TonyNo's Profile Search for other posts by TonyNo Visit TonyNo's Homepage
 
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: December 17 2006 at 13:00 | IP Logged Quote UpstateMike
Nope... same error after a rebuild. It has to be something simple I am overlooking here!
Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: December 18 2006 at 16:22 | IP Logged Quote dhoward
Mike,

Ive tried to duplicate this and have been unsuccessful so far. The "action" column is the "ID/Keys/Formula" field. There was an earlier bug reported where the "Device Control" window was not saving the data properly in the Control Center Details screen and this may be related (I'll have to do some checking and post back).

Can you try just typing in the Device Control String and seeing if that will take? If it doesnt, you may want to email me a copy of your database as it may be something peculiar that I'll have to investigate.

Thanks,

Dave.
Back to Top View dhoward's Profile Search for other posts by dhoward Visit dhoward's Homepage
 
UpstateMike
Senior Member
Senior Member


Joined: February 18 2006
Location: United States
Online Status: Offline
Posts: 142
Posted: December 18 2006 at 21:09 | IP Logged Quote UpstateMike
Typing in the string didn't help so I sent you the database.
Back to Top View UpstateMike's Profile Search for other posts by UpstateMike
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: December 26 2006 at 12:26 | IP Logged Quote dhoward
To keep everyone posted, we solved the problem. Mike had a completely blank timed events (as would be on a new database) and when navigating with the Explorer, PowerHome would automatically create an initial blank timed event (If a section is blank, PowerHome automatically creates the first blank record on all screens). Mike was inadvertantly inserting a new blank Timed Event, editing, and saving whilst leaving the default created blank timed event untouched. This was what was ultimately causing the error saying that the "Action" column was blank.

To work around this, you must either use the default created blank record or delete it before saving to not have these errors.

Hope this helps,

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

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