more G-Labs products

Author Topic: Unable to Migrate installation between HG installs  (Read 902 times)

May 25, 2015, 05:32:42 PM
Read 902 times

mikeH

  • **
  • Information
  • Jr. Member
  • Posts: 27
I'm trying to move off an RPi onto an Ubuntu 14.04.2 LTS VM that I am running.  I figured that a backup and restore of the configuration running the same version of HomeGenie would be all that I'd need to do.  Unfortunately while I am able to backup and restore the installation on the RPi, when I try and restore that installation onto the VM running the same version (1.00 r488) I get no "User Programs" listed to install and it throws a MIG error when I try and force the load.  All I see in the log file that looks suspect is a reference to SQLite, which makes sense,

Code: [Select]
2015-05-25T11:24:55.9524360-04:00 HomeAutomation.HomeGenie Service.StatisticsLogger SQLite error
table ValuesHist has 6 columns but 7 values were supplied Exception.StackTrace   at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0
2015-05-25T11:24:55.9522980-04:00 HomeAutomation.HomeGenie Service.StatisticsLogger SQLite error
table ValuesHist has 6 columns but 7 values were supplied Exception.StackTrace   at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0
2015-05-25T11:24:55.9521430-04:00 HomeAutomation.HomeGenie Service.StatisticsLogger SQLite error
table ValuesHist has 6 columns but 7 values were supplied Exception.StackTrace   at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0
  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0


Any pointers of help would be appreciated.  While I'm waiting for a reply I will be poking around in the SQLite DB to see if there is anything version wise between what was in Raspbian and the 14.04LTS install that I'm using.

As a side note, I've run into a few "computer headaches" while using HomeGenie (I'm a 35 year programmer) that I'll try and capture and drop into the forums.  Some simple usage documentation would be REALLY helpful.  I feel like Gene really has a great product here, but getting some things to work beyond simple events is currently non-trivial and would be way past your average computer user.

* A Computer Headache as defined by me is when a program, like a compiler isn't working as expected and the output isn't sufficient to debug the issue.  Thus leading to wasted time and a real throbber of a headache.

May 25, 2015, 05:35:15 PM
Reply #1

mikeH

  • **
  • Information
  • Jr. Member
  • Posts: 27
Go figure, I tried to restore one last time to catch that MIG error alert and this time it worked.  I have no idea why it wasn't working before and I confirmed that I backed up against r484 and r488 to try a restore on a corresponding r484 and r488 system.  I guess we can mark this one as unable to reproduce......

May 25, 2015, 05:47:26 PM
Reply #2

Gene

  • *****
  • Information
  • Administrator
  • Posts: 1472
  • Tangible is the future!
    • Yet Another Programmer
Hi mikeH, feel free to provide any suggestion about making hg computer headache proof. :)
I am trying to setup HG wiki, it's public, so everyone can contribute with it:

https://github.com/genielabs/HomeGenie/wiki

Cheers,
g.