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”
This has been a major issue within SAM Broadcaster & its SQL tables ever since they wrote the database for SAM Broadcaster v2.x.x
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.
“I keep getting an error MySQL table Songlist corrupted & I can no longer query the Songlist table in the MySQL database used by SAM”
SAM Broadcaster’s badly coded MySQL structure was also another reason we ditched the program and started using RadioDJ
It was a pain to do any coding with.
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!
Its a nightmare coding a website from the basic website templates that come with SAM, Coding a website shouldn’t be difficult but sadly the code is a nightmare with SAM Broadcaster
I’m still hearing reports of crashing and stability issues with SAM mainly from users using the Firebird database…
Did You Know: You cannot backup the SAM Broadcaster MySQL database without knowledge of using external database tools.
“The built-in backup tool in SAM isn’t made for this and usually has problems with the default MySQL security settings which prevent the MySQL daemon from writing backup files to the hard disk itself”
The built in backup for SAM Broadcaster only backs up the program settings, Even when you get a tool to backup the SAM Broadcaster database it doesn’t backup any of your events which RadioDJ does.
You can backup the database in RadioDJ complete with events & its over 5 years now since I last installed my RadioDJ database from scratch.
The joys of having a daily backup with the database setup tool.
Last updated on: 24th April 2020
at 11:33 AM Europe/London