PS1 Color All Sky Camera running on ps1puka

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

<type 'exceptions.RuntimeError'>

Python 2.7.17: /usr/bin/python
Thu Mar 30 03:49:25 2023

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>()

602 </tr>

603 </table>

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

=> 605 getDailyImageLinks(),

=> 606 getFreshDarkLink(),

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

259 FROM %s

260 WHERE time = %d

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

=> 262 else:

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

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

2186 # query via the given MySQL DB connection.

2187 def selectOneValue(connection, query):

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

2189

2190

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

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

2179 if selectCursor.rowcount != 1:

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

=> 2181 (query, selectCursor.rowcount))

2182 return selectCursor.fetchone()

2183

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

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