PS1 Color All Sky Camera running on ps1puka — Version 1.23 --> -->
 
 
<type 'exceptions.RuntimeError'>
Python 2.7.17: /usr/bin/python
Thu Mar 28 01:14:24 2024

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 556a5a3fb120>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594134195\n ')
   2269 # query via the given MySQL DB connection.
   2270 def selectOneValue(connection, query):
=> 2271     return selectOneRow(connection, query)[0]
   2272 
   2273 
global selectOneRow = <function selectOneRow>, connection = <_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 556a5a3fb120>, query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594134195\n '
 /otis/ops/src/python/ps1util.py in selectOneRow(connection=<_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 556a5a3fb120>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594134195\n ')
   2262     if selectCursor.rowcount != 1:
   2263         raise RuntimeError("selectOneRow(%s) resulted in %d rows!" %
=> 2264                            (query, selectCursor.rowcount))
   2265     return selectCursor.fetchone()
   2266 
query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1594134195\n ', selectCursor = <MySQLdb.cursors.Cursor object>, selectCursor.rowcount = 0L

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