| Author |
|
jimspobox
Newbie
Joined: June 28 2006
Location: United States
Online Status: Offline
Posts: 27
|
| Posted: August 16 2007 at 19:31 | IP Logged
|
|
|
I am setting up a new Insteon home and when I go to load Powerhome, I get an error that says I have the wrong database version, 1.03.9.4 and I need an update to 1.03.9.5. It says to run an upgrade utility but I haven't found one.
Actually there should be nothing in the database since I have not set up any switches yet.
Any idea how to get pass this point? Powehome stops with this message and does not open.
__________________
Jim
|
| Back to Top |
|
| |
cmhardwick
Senior Member
Joined: July 08 2006
Location: United States
Online Status: Offline
Posts: 290
|
| Posted: August 16 2007 at 19:48 | IP Logged
|
|
|
Database formats change. The program, in the ph directory, is I believe phupg.exe. Run this and you should be good to go.
__________________
Cicero, Enjoying automation!
|
| Back to Top |
|
| |
jimspobox
Newbie
Joined: June 28 2006
Location: United States
Online Status: Offline
Posts: 27
|
| Posted: August 16 2007 at 20:16 | IP Logged
|
|
|
When I run that file, it starts to update the database, but then it displays an error saying "transaction not connected",then the update stops. What connection is it referring to? I didn't have Powerhome open, just ran the file from Windows Explorer.
__________________
Jim
|
| Back to Top |
|
| |
jimspobox
Newbie
Joined: June 28 2006
Location: United States
Online Status: Offline
Posts: 27
|
| Posted: August 16 2007 at 20:25 | IP Logged
|
|
|
All fixed, thanks for the help. Re-booting got rid of that last error. Must have been something running in the background.
__________________
Jim
|
| Back to Top |
|
| |
cmhardwick
Senior Member
Joined: July 08 2006
Location: United States
Online Status: Offline
Posts: 290
|
| Posted: August 17 2007 at 09:42 | IP Logged
|
|
|
Cool, glad it's updated. This needs to be done everytime you get a new version of PH. There has always been some small change in the database layout between versions. This is also a maintenance utility. You can run it on your existing database if you've made lots of changes and want to compact it (clean up any empty space left after add/delete/change, etc). I probably need to do this on mine since I've been making lots of changes lately (note to self)
__________________
Cicero, Enjoying automation!
|
| Back to Top |
|
| |
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: November 18 2012 at 07:26 | IP Logged
|
|
|
My db has grown almost 6-fold in the last year, but when I
tried to compress it with phupg.exe I get a "Cannot locate
the ph212.db" file"
I am running the most current version of PH. Is it OK to
just rename my current db file to what phupg.exe is looking
for.
Seems Dave, that it would be better to open a "Finder"
window allowing a user to pick the desired db file, than to
have it hard coded.
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: November 18 2012 at 07:57 | IP Logged
|
|
|
Ken, maybe the real question is why has it grown so much. I presume you are running trimlog. I was not aware that phupg compressed the db.
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
grif091
Super User
Joined: March 26 2008
Location: United States
Online Status: Offline
Posts: 1357
|
| Posted: November 18 2012 at 08:58 | IP Logged
|
|
|
I thought trimlog reduced the data in the log file but did not reduce the physical size of the PH database. I just ran phupg which reduced my PH database from 12 meg to 3 meg, compressing out the space taken by a log file that had been trimmed.
The first prompt from phupg listed the database as pwrhome.db with the backup being pwrhome.212.db. Executed phupg from the c:\powerhome directory
I'm running 2.1.4 with I2CS zip applied
__________________
Lee G
|
| Back to Top |
|
| |
BeachBum
Super User
Joined: April 11 2007
Location: United States
Online Status: Offline
Posts: 1880
|
| Posted: November 18 2012 at 09:24 | IP Logged
|
|
|
Thanks Lee... I was under the assumption trimming would keep it down but you're never too old to learn new tricks. Just reduced mine by 13M.
__________________
Pete - X10 Oldie
|
| Back to Top |
|
| |
GadgetGuy
Super User
Joined: June 01 2008
Location: United States
Online Status: Offline
Posts: 942
|
| Posted: November 18 2012 at 17:50 | IP Logged
|
|
|
Pete/Lee -
Thanks for jumping in.
I agree Lee, the only way I know of to compact the db is
to run phupg.exe, but when I try to do so on a copy of my
powerhome.db default file I get an error comment stating
. . .
"Cannot locate the ph212.db file"
Unless I name my db to that name-string I cannot progress
past the error comment.
BUT, if I name my db file that and try again, then I get
an error comment stating that "ph212 is a powerhome
system file and cannot be modified"
I am running the most current version of PH (whatever
that is, which is not easy to determine since the startup
splash screen still shows the version number from over a
year ago :-( DAVE!)
If I duplicate my db file and name it 'ph212.db' and then
start the updater, I can get past the error comment and
pick the powerhome.db file to compress, but when I do I
get a series of "error updating datastore DS_2!" comments
(which I cannot upload to this post as every attempt
results in a "Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/forum/functions/functions_upload.asp, line 234 error.)
Looking at the 'updated' file after all of this reveals
that it is exactly the same size as before which is 72MB
versus the initial 12MB it was a year ago (withour many
significant real changes/additions to the db!).
I'm stumped (and licked) for the moment! :-(
__________________
Ken B - Live every day like it's your last. Eventually, you'll get it right!
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: November 18 2012 at 18:47 | IP Logged
|
|
|
Ken,
The ph212.db file is the blank database
file that is required by the phupg.exe
utility. This is how the actual
shrinking is done. Your database is
basically copied into this blank file so
it automatically compresses it. This
file should be located in the same
directory as your database file which
should default be c:\powerhome\database.
If this file is missing you'll need to
install PowerHome version 2.1.2 in a
different directory so you can copy the
file off.
Hope this helps,
Dave.
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: How do I update the database
