PS1 Color All Sky Camera running on ps1puka — Version 1.23 --> -->
 
 
<type 'exceptions.RuntimeError'>
Python 2.7.17: /usr/bin/python
Thu Mar 30 05:25:29 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 55e79b46e340>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1675411450\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 55e79b46e340>, query = '\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1675411450\n '
 /otis/ops/src/python/ps1util.py in selectOneRow(connection=<_mysql.connection open to 'ps1puka.ps1.ifa.hawaii.edu' at 55e79b46e340>, query='\n SELECT SUBSTR(name, 1, 10)\n ... WHERE time = 1675411450\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 = 1675411450\n ', selectCursor = <MySQLdb.cursors.Cursor object>, selectCursor.rowcount = 0L

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