Post by pkelly517 on Feb 8, 2021 14:18:11 GMT -8
Hi all,
Up front, I did not buy the SDL SDcard. During the Kickstarter, I did not see it as necessary. I had at least half a dozen unused cards of 16GB of greater.
I've muddled through a good portion of the installation issues, but I'm stuck on the MySQL portion. What is required in the database? Currently, I'm getting these errors when starting the dash_app
and a new error in SkyWeather2.py
I'm not a database guy at all. Should I try to get any further from random websites, I would expect to screw things up more than I'd fix.
And, as a suggestion, wouldn't it be worthwhile to put the SDL SDcard image on GitHub so that we all could start from a known point? Half of the questions in this forum wouldn't be necessary.
Thanks
Peter
Up front, I did not buy the SDL SDcard. During the Kickstarter, I did not see it as necessary. I had at least half a dozen unused cards of 16GB of greater.
I've muddled through a good portion of the installation issues, but I'm stuck on the MySQL portion. What is required in the database? Currently, I'm getting these errors when starting the dash_app
Traceback (most recent call last):
File "/home/pi/SDL_Pi_SkyWeather2/dash_app/weather_page.py", line 156, in generateCurrentWeatherJSON
cur.execute(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'SkyWeather2.WeatherData' doesn't exist")
Traceback (most recent call last):
File "index.py", line 22, in <module>
import weather_page
File "/home/pi/SDL_Pi_SkyWeather2/dash_app/weather_page.py", line 1031, in <module>
CWJSON = generateCurrentWeatherJSON()
File "/home/pi/SDL_Pi_SkyWeather2/dash_app/weather_page.py", line 348, in generateCurrentWeatherJSON
print("done generating CWJSON=", CWJSON)
UnboundLocalError: local variable 'CWJSON' referenced before assignment
and a new error in SkyWeather2.py
File "/home/pi/SDL_Pi_SkyWeather2/pclogging.py", line 52, in systemlog
cur.execute(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'SkyWeather2.SystemLog' doesn't exist")
Indoor Weather Sensors Found
Traceback (most recent call last):
File "/home/pi/SDL_Pi_SkyWeather2/pclogging.py", line 52, in systemlog
cur.execute(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'SkyWeather2.SystemLog' doesn't exist")
Main Weather Sensors Found
Traceback (most recent call last):
File "/home/pi/SDL_Pi_SkyWeather2/pclogging.py", line 52, in systemlog
cur.execute(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/usr/local/lib/python3.7/dist-packages/MySQLdb/connections.py", line 259, in query_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'SkyWeather2.SystemLog' doesn't exist")
I'm not a database guy at all. Should I try to get any further from random websites, I would expect to screw things up more than I'd fix.
And, as a suggestion, wouldn't it be worthwhile to put the SDL SDcard image on GitHub so that we all could start from a known point? Half of the questions in this forum wouldn't be necessary.
Thanks
Peter