PS1 Color All Sky Camera running on ps1puka

PS1 Color All Sky Camera running on ps1puka — Version 1.21 --> -->

<type 'exceptions.RuntimeError'>

Python 2.7.17: /usr/bin/python
Mon Jan 18 19:46:12 2021

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

/var/www/cgi-bin/colorAllSkyCam in <module>()

591 </tr>

592 </table>

=> 593 """ % (getDailyImageTitle(),

=> 594 getDailyImageLinks(),

=> 595 getFreshDarkLink(),

/var/www/cgi-bin/colorAllSkyCam in getDailyImageTitle()

248 FROM %s

249 WHERE time = %d

=> 250 """ % (table, int(fs['time'].value)))

=> 251 else:

=> 252 targetDate = ps1util.selectOneValue(connection, """

/otis/ops/src/python/ps1util.py in selectOneValue(connection=<_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 558bf4dedea0>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n ')

1964 # query via the given MySQL DB connection.

1965 def selectOneValue(connection, query):

=> 1966 return selectOneRow(connection, query)[0]

1967

1968

global selectOneRow = <function selectOneRow>, connection = <_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 558bf4dedea0>, query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n '

/otis/ops/src/python/ps1util.py in selectOneRow(connection=<_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 558bf4dedea0>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n ')

1957 if selectCursor.rowcount != 1:

1958 raise RuntimeError("selectOneRow(%s) resulted in %d rows!" %

=> 1959 (query, selectCursor.rowcount))

1960 return selectCursor.fetchone()

1961

query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594305988\n ', selectCursor = <MySQLdb.cursors.Cursor object>, selectCursor.rowcount = 0L

<type 'exceptions.RuntimeError'>: selectOneRow( SELECT SUBSTR(name, 1, 10) FROM colorAllSkyCameraImages WHERE time = 1594305988 ) resulted in 0 rows!
args = ('selectOneRow(\n SELECT SUBSTR(name, 1...me = 1594305988\n ) resulted in 0 rows!',)
message = 'selectOneRow(\n SELECT SUBSTR(name, 1...me = 1594305988\n ) resulted in 0 rows!'