Table 'smatool.LiveData' doesn't exist

[mmcd89]

Hi, 

Total noob here, I have just setup a Raspberry Pi as per these instructions http://ictoblog.nl/raspberry-pi/raspb.... 
When I first run the ./smatool everything seems to be fine. The next step is to input my API-key and system id into the smatool.conf file, which then gives me the error(s) 

Table 'smatool.LiveData' doesn't exist 
Segmentation fault. 

Can someone help as I am totally lost? 
I'm using Raspbian “wheezy”, connecting via ssh on a Mac.

Thanks in advance, 
Michael.

[Ralph McKnight]

thats a new(ish) table, make sure its created (run the . with --update option).

--
You received this message because you are subscribed to the Google Groups "sma-bluetooth" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sma-bluetoot...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[furriephillips]

Hi,

I had the same issue, but as my install was a brand new, I was simply running "./smatool --INSTALL" and never thought to use "--UPDATE" - why would you - shouldn't the table be created with "--INSTALL"?

Anyway, after running "./smatool -v -d" I could see messages about missing table, then grepped the code for that table name.  I ended up creating the table manually in MySQL with what I found: -

CREATE TABLE `LiveData` (
     `id` BIGINT NOT NULL AUTO_INCREMENT,
      `DateTime` datetime NOT NULL,
      `Inverter` varchar(10) NOT NULL,
      `Serial` varchar(40) NOT NULL,
      `Description` char(20) NOT NULL,
     `Value` INT NOT NULL,
     `Units` char(20) NOT NULL,
     `CHANGETIME` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
     UNIQUE KEY (`DateTime`,`Inverter`,`Serial`,`Description`),
      PRIMARY KEY (`id`)
) ENGINE = MYISAM;

I'm still seeing other issues, so I may yet muck about and see if "--UPDATE" helps.

Cheers