You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
For instance, when there is a missing device or a project, the entire endpoint crashes because it tries to make a DB call that looks like
2018-04-17 20:12:36,381 - api - ERROR - Couldn't execute query - b'SELECT * FROM project WHERE projectId IN ()'
Traceback (most recent call last):
File "/nfs/unixspace/linux/accounts/courtesy/e/energyhill/public_html/Flower/backend/db.py", line 61, in exec_query
cursor.execute(formatted_sql_string, param_tuple)
File "/usr/remote/anaconda-3.6/lib/python3.6/site-packages/MySQLdb/cursors.py", line 250, in execute
self.errorhandler(self, exc, value)
File "/usr/remote/anaconda-3.6/lib/python3.6/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
raise errorvalue
File "/usr/remote/anaconda-3.6/lib/python3.6/site-packages/MySQLdb/cursors.py", line 247, in execute
res = self._query(query)
File "/usr/remote/anaconda-3.6/lib/python3.6/site-packages/MySQLdb/cursors.py", line 411, in _query
rowcount = self._do_query(q)
File "/usr/remote/anaconda-3.6/lib/python3.6/site-packages/MySQLdb/cursors.py", line 374, in _do_query
db.query(q)
File "/usr/remote/anaconda-3.6/lib/python3.6/site-packages/MySQLdb/connections.py", line 292, in query
_mysql.connection.query(self, query)
_mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1")
The text was updated successfully, but these errors were encountered:
For instance, when there is a missing device or a project, the entire endpoint crashes because it tries to make a DB call that looks like
The text was updated successfully, but these errors were encountered: