SAM Broadcaster Bad SQL!
We keep seeing posts on the Spacial Audio Facebook pages and forums from people saying that their queue list table within MySQL has crashed and is corrupted.
This is usually the MySQL error that people get.
Or they simply just get a message like this.
This is nothing new and has been a major issue within SAM Broadcaster SQL tables ever since SAM Broadcaster v2.7.9
It just goes to show that the SQL structure wasn’t written properly in the first place.
In Fact it’s a really badly written SQL structure which is prone to going wrong when you least want it too.
SAM Broadcaster’s badly coded SQL structure was also another reason we ditched the program and started using RadioDJ
We have yet to have a major database crash with RadioDJ.
There is a simple fix for this.
2) Flush all SAMDB Tables from your SQL server.
3) Install RadioDJ and run the database setup utility.
4) Start enjoying running a stress free radio station!
You will be a lot happier in the long run.
There is just no need for SAM Broadcaster to have badly coded SQL tables!