Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
PowerHome General
 PowerHome Messageboard : PowerHome General
Subject Topic: Data Base Error on Startup Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
GadgetGuy
Super User
Super User
Avatar

Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
Posted: December 05 2018 at 14:39 | IP Logged Quote GadgetGuy

Dave-
For a year I have been getting an error on PH Startup that says the IR Table is bad.

I finally got feed up with this nagging and attempted to remedy it today however ...

If I look at the IR Table using the PH SQL Editor the IR Table is empty. BUT if I examine the IR Table, outside of PH, using Access the table has four entries in it. I can delete those entries but when I try to save the fix the table it is saved as an "pwrhome.odb" which PH will not accept.

If I change the Extension to "db" instead of "odb" the file is still non-useable.

Can you suggest how I can get this all resolved?



Edited by GadgetGuy - December 05 2018 at 14:40


__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
Back to Top View GadgetGuy's Profile Search for other posts by GadgetGuy
 
dhoward
Admin Group
Admin Group
Avatar

Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
Posted: December 05 2018 at 20:06 | IP Logged Quote dhoward

Ken,

If you've got an error with your IR table on PowerHome startup, it could be an issue with the relationship between your EQUIP and IR tables. The
EQUIP table is the parent and the IR table is the child. If you've got IR entries with no corresponding EQUIP entries, then it would cause an
error.

If you're not currently using IR in PowerHome, the easiest way to clean these tables would be to open the PH Multi-Editor, change to SQL mode and
then run the following SQL statements:

delete from ir
delete from equip

With both tables empty, then the error should go away and you should be safe to start working with the IR screens from the PH Explorer.

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