sciserver / SkyServerWS

SkyServer Web Services
1 stars 3 forks source link

radial search fails when including u or g-band limits #8

Closed mtaghiza closed 9 years ago

mtaghiza commented 9 years ago

Test s_radial_4: after clicking on the url

http://scitest02.pha.jhu.edu/SkyserverWS/dr12/SearchTools/RadialSearch?ra=258.2&dec=64&radius=4.1&whichway=equitorial&limit=10&format=json&fp=none&uband=0,17&gband=0,15&whichquery=imaging

, I get the following error: {"Error Code":500,"Error Type":"InternalServerError","Error Message":"Failed to execute a query: Invalid column name 'u'.\r\nInvalid column name 'u'.\r\nInvalid column name 'g'.\r\nInvalid column name 'g'.","LogMessageID":"ccae9884-29c4-45d6-90f3-221aa8bc27f7"}

mtaghiza commented 9 years ago

Problem solved: u,g,r,i and z-band constraints where being enforced on apogee tables, where those columns don't exists. Had to delete that.