I have an SQL for Spot collector: <NeedFilter> and ((ODX<500) and (ODX>0)) and (mode='cw') 
It appears to have stopped working on September 28. Is there a way to restart it?

Please explain what you mean by "appears to have stopped working".

Scroll your Spot Database Display to the right until the ODX column
is visible. Does that column contain data or is it blank?

73,

... Joe, W4TV

The ODX column is populated.

Actually, the SQL query is:
<NeedFilter> and ((SPProb>50) or (LPProb>50)) and (mode='cw')  -  I copied the wrong one. Neither the SPProb nor the LPProb has any information in it. I didn't change anything, it just stopped making that calculation. I suspect all I need to do is turn it back on, but I don't know how. The last (most recent) station that came up in response to this query is dated 9/28/2022. 

+ AA6YQ comments below

Actually, the SQL query is:
<NeedFilter> and ((SPProb>50) or (LPProb>50)) and (mode='cw') - I copied the wrong one. Neither the SPProb nor the LPProb has any information in it. I didn't change anything, it just stopped making that calculation. I suspect all I need to do is turn it back on, but I don't know how. The last (most recent) station that came up in response to this query is dated 9/28/2022.

+ The "Propagation Prediction" panel on the General tab of SpotCollector's Configuration window governs the automatic generation of propagation forecasts for some or all Spot Database Entries. See

https://www.dxlabsuite.com/dxlabwiki/SpotDatabasePropagationPrediction

73,

Dave, AA6YQ

Somehow the box for "look up missing location information" on the general tab of the SC configuration became unchecked. I rechecked it and recomputed. It seems to be working again. Not sure how it got unchecked.