Open GoogleCodeExporter opened 9 years ago
I also see this error.
running on a Raspberry Pie with Raspberian wheezy
Original comment by coli...@gmail.com
on 3 Nov 2012 at 1:18
Had same error on raspberry pi resulting in data not being sent to PVOutput.
Something to do with different schema. Table LiveData is not being created.
(see c code in smamysql.c). I was able to fix this in my set up on raspberry pi
by just running the create table sql query from the command prompt - once the
table was created smatool started uploading to pvoutput.
In MySQL:
> use smatool;
> 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;
Then run smatool again if it is not alreay running and table LiveData is
populated and pvoutput is uploaded (Note pvoutput live upload limits)
Original comment by marissan...@gmail.com
on 24 Nov 2012 at 9:52
Yes! Thank you. This missing "LiveData" table was the last thing that was
needed to get smatool working on my Raspberry PI and SMA 3000 TL. Well, the
*second* last thing. Once the missing table was created all I had to do was
leave smatool alone and running for long enough to catch up with all the data
it had downloaded from the 3000TL. You see, every time I ran it I kept aborting
the thing after a few minutes as I thought it was hanging. Eventually I wised
up and ran smatool with the debug and verbose flags and saw that it was just
trying to upload 2 months of data to PVOutput 30 lines at a time with a delay
between each set...and I had been crashing it out in the middle of it. Doh! I
ran it and left it running overnight happily uploading data and the next
morning found it had returned to the command prompt. I then setup the cronjob
to run smatool automatically every 15 minutes and it has now been running
without issue for 3 days so far. Happy as an extremely happy thing!
Original comment by slowboil...@gmail.com
on 11 Dec 2012 at 9:38
I also had the livedata error, and I resolved it in teh following way
-in the table settings: change the schema value from 3 to 2
-run ./smatool --UPDATE
=> the Livedate table is created
Original comment by lcb...@gmail.com
on 26 Jan 2013 at 7:54
I have exactly the same problem, and Im also using a 3000TL.
Copy pasted the TABLE_CREATE line into terminal, but I get
ERROR 1064 (42000) You have an error in your SQL syntax ... syntax near CREATE
TABLE LiveData (id BIGINT NULL AUTO_INCREMENT, DateTim at line 1
Im a beginner at linux/sql so dont know how to fix it.
Original comment by andy...@googlemail.com
on 6 Jul 2013 at 9:04
Original issue reported on code.google.com by
zoeper...@gmail.com
on 22 Oct 2012 at 5:45