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.

“MySQLi prepare error: Table ‘samdb_mysql.queuelist’ doesn’t exist”

Or they simply just get a message like this.

Click to enlarge

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.

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.

There is just no need for SAM Broadcaster to have badly coded SQL tables!

Update: July 2017

Spacial Audio’s code monkeys appear to have done some work to the MySQL Tables

v2017.6 (3 July 2017)
* Updated database structure for FireBird and MySQL to be more consistent across databases.

We will wait to see what we see from users of the software as to whether this makes SAM Broadcaster more stable (Only time will tell) so far I’m still hearing reports of crashing and stability issues with SAM.

However the database structure in RadioDJ is still performing like a star and its over 3 years now since I last installed my RadioDJ database from scratch.

Last updated on: 22nd March 2018
at 15:55 PM Europe/London