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,
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.
