sql error when uploading events/detections with a station name containing apostrophe about aatams HOT 8 CLOSED

http://xkcd.com/327/

from aatams.

@danfruehauf you tested your fix against the problematic file? Can this be closed?

from aatams.

AFAIK yes, however, link this to the new bug it introduced.

from aatams.

Closing, as @danfruehauf 's fix seems to have fixed this bug.
However, it may have introduced #29

from aatams.

This is going to be handled as a backlog item.

from aatams.

@pblain I guess from my previous comment here that I've discussed this issue with you already, but just confirming, do we have a backlog item for this already?

I think we need to have a bit of a re-think about how we upload and store detections. We can probably solve this problem, as well as remove the need to refresh materialised views nightly (which uses a lot of CPU on the DB) and probably some other performance problems too. But, it's not trivial :-)

from aatams.

Yes, there is a backlog item related to this (NET55). We'll need to flesh it out before it makes it to planning. But it's in there.

from aatams.

Noting that this is still an issue for users. Andrew has just emailed Rog about it.

from aatams.