Moode Forum

Full Version: Orphaned url in Radio Station DB
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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
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%'"
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
To delete the orphan

Code:
moodeutl -q "delete from cfg_radio where id='500'"
Done! Re-created station successfully. Thanks Again.
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.