SAM Broadcaster Bad SQL!
I 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 SQL error that people get.
“Mysqli prepare error: Table ‘samdb_mysql.queuelist’ doesn’t exist”
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 version 2.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 I ditched the program and started using RadioDJ.
I have yet to have a major database crash with RadioDJ.
There is a simple fix for this.
1) Uninstall SAM Broadcaster from your computer.
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.
If in the unlikely event of database crash in RadioDJ you can use a program like HeidiSQL to repair your database tables.
There is just no need for SAM Broadcaster to have badly coded SQL tables!