I have a streetmap and the position of hundred sensorlocations. I am currently trying to calculate the nearest line for each point. I have already done it with the nnjoin plugin. But now I want to do this with a virtual layer. For this, I followed the tutorial: https://pigrecoinfinito.wordpress.com/2017/04/28/qgis-minima-distanza-tra-punti-e-linee/
Any suggestions on how to fix this?
I have know tried it with renamed tables, but I am still getting the same error message.
Maybe something more is wrong?