I don't know, could be something else.<br><br>this is what i get in the debug lines of what goes haywire.<br><br>update v-sensor values<br>create the data hit<br>UPDATE volt_sensors SET last_report=%s, last_value=%s, last_raw=%s WHERE volt_sensors.id = %s (
datetime.datetime(2007, 8, 7, 9, 32, 48, 125063), 13.17934, 899.0, 3116)<br>INSERT INTO volt_sensors (date_time, raw, value, volt_sensor_id) VALUES (%s, %s, %s, %s) (datetime.datetime(2007, 8, 7, 9, 32, 48, 125426), 899.0
, 13.17934, 3116)<br>Exception in thread Thread-5:<br>Traceback (most recent call last):<br> File "threading.py", line 442, in __bootstrap<br> self.run()<br> File "/home/piv/forge/main/orbcomm_input_email.py", line 570, in run
<br> self.process_flow_meter(monitor, raw)<br> File "/home/piv/forge/main/orbcomm_input_email.py", line 166, in process_flow_meter<br> FlowSensor.monitor == unicode(monitor)).one()<br> File "/usr/lib/python2.4/site-packages/storm-
0.9-py2.4.egg/storm/store.py", line 133, in find<br> File "/usr/lib/python2.4/site-packages/storm-0.9-py2.4.egg/storm/store.py", line 274, in flush<br> File "/usr/lib/python2.4/site-packages/storm-0.9-py2.4.egg
/storm/store.py", line 313, in _flush_one<br> File "/usr/lib/python2.4/site-packages/storm-0.9-py2.4.egg/storm/database.py", line 136, in execute<br> File "/usr/lib/python2.4/site-packages/storm-0.9-py2.4.egg
/storm/database.py", line 125, in _raw_execute<br> File "/usr/lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute<br> self.errorhandler(self, exc, value)<br> File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler
<br> raise errorclass, errorvalue<br>OperationalError: (1054, "Unknown column 'date_time' in 'field list'")<br><br># update volt sensor<br>print 'update v-sensor values'<br>volt_sensor.last_raw = raw
<br>volt_sensor.last_value = value
<br>volt_sensor.last_report = datetime.datetime.now()<br>print 'create the data hit'<br>hit = VoltageHit(volt_sensor.id, raw, value)<br>self.store.add(hit)<br><br>and here are the two classes<br><br>class VoltSensor(Storm):
<br> __storm_table__ = "volt_sensors"<br> id = Int(primary=True, default = AutoReload)<br> adder, multiplier = Float(), Float()<br> last_value, last_raw, highest_value = Float(), Float(), Float()<br>
monitor = Unicode()<br> last_report = DateTime()<br><br> #voltage_hits = ReferenceSet(id, "VoltageHit.volt_sensor_id")<br><br>class VoltageHit(Storm):<br> __storm_table__ = "volt_sensors"
<br>
id = Int(primary = True)<br> volt_sensor_id = Int()<br> raw, value = Float(), Float()<br> date_time = DateTime()<br><br> def __init__(self, volt_sensor_id, raw, value):<br> self.volt_sensor_id = volt_sensor_id
<br> self.raw = raw<br> self.value = value<br> self.date_time = datetime.datetime.now()<br><br>it looks like this actually happens in a different function. <br>I think that it fails when it reaches the commit / insert / update point
<br><br><br>thanks for any tips<br><br>shawn<br><br><br>