search

lsst-uk / lasair-lsst

Apache License 2.0
0 stars 0 forks source link

Update mma_watchmap view detail with schema changes #158

Closed gpfrancis closed 1 month ago

gpfrancis commented 1 month ago

Viewing https://lasair-lsst-dev.lsst.ac.uk/mma_watchmaps/136/ gives this error:

<h1>ProgrammingError
       at /mma_watchmaps/136/</h1>
  <pre class="exception_value">1054 (42S22): Unknown column 'o.rPSFluxMax' in 'field list'</pre>

GET
http://lasair-lsst-dev.lsst.ac.uk/mma_watchmaps/136/
5.0
ProgrammingError
1054 (42S22): Unknown column 'o.rPSFluxMax' in 'field list'
/usr/local/lib/python3.10/dist-packages/mysql/connector/connection_cext.py, line 647, in cmd_query
lasair.apps.mma_watchmap.views.mma_watchmap_detail
/usr/bin/python3
3.10.12
['/home/ubuntu/lasair-lsst/webserver',  '/home/ubuntu/lasair-lsst/webserver',  '/usr/lib/python310.zip',  '/usr/lib/python3.10',  '/usr/lib/python3.10/lib-dynload',  '/usr/local/lib/python3.10/dist-packages',  '/usr/lib/python3/dist-packages',  '../common',  '..',  '../common',  '../../../common',  '../common',  '../common',  '../common',  '../../../common',  '../common',  '..',  '../common',  '../common',  '../common',  '../../../common']
RoyWilliams commented 1 month ago

rPSFluxMax is no longer in the LSST schema and is not a Lasair feature, so changed it to rPSFlux. Same for g.

gpfrancis commented 1 month ago

For reference it looks like this is fixed by https://github.com/lsst-uk/lasair-lsst/commit/fa36f5ecc35eb5207aa5c1815138db5c4ce2a3c1