Orphaned url in Radio Station DB

[Skip Pack]

I have been using 8.1.2 on a fresh install since a few days after its release. I added three radio stations with images successfully, and they worked fine. Yesterday, I went to play them, and they had disappeared from the interface. It had been a month or so since I'd looked at the radio station interface, so I don't know when it happened. Since it's so easy, I re-entered two of them quickly and successfully. The third one, however, failed, messaging that there was already an entry in the database for that station's URL. The interface did not show that station. 

I imagine it will be easy to fix, but would like to get some hints, and I'm happy to run diagnostics.

Thanks,   Skip

[Tim Curtis]

To start troubleshooting post the results of the queries below.

Code:

moodeutl -q "select * from cfg_radio where station like'%ANY_PART_OF_THE_URL%'"

moodeutl -q "select * from cfg_radio where name like'%STATION_NAME%'"

[Skip Pack]

Response to the 'station' query is:

500|http://stream.kpft.org:8000/live_64|New station|r|local|Eclectic|||||||No||NULL

No response to the 'name' query.

Thnx,   Skip

[Tim Curtis]

To delete the orphan

Code:

moodeutl -q "delete from cfg_radio where id='500'"

[Skip Pack]

Done! Re-created station successfully. Thanks Again.

[MilaPi]

I had a similar issue after adding a radio called Radio "Russe".
The system did not like the " character.
I attempted to delete from the user interface, but the station remained, like a ghost.
In my case, radio had id =506.
So, I typed the following:
moodeutl -q "delete from cfg_radio where id='506'"
and ghost disappeared.

Thanks a lot for the information.