What Database Issues?

I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.

Turns out we’ve had MariaDB installed since June 2014.

Yesterday we upgraded it to the latest version. Which went smoothly after we’d remembered to shut mysqld.exe down as a service.

Click to enlarge

In the last 15 months that we’ve been using MariaDB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden shutdown of the computer.

That was easily fixed using Heidisql to repair the tables.

“We could never say the same about another well known automation program. The database in that would crash when you least expected it and was royal pain to fix again. That’s if you were lucky enough to retrieve your database as that program never had a proper database backup tool.

 
We take a regular daily backups of our database with the RadioDJ database setup tool.

The database in RadioDJ is far more robust and tends not to go wrong unless something major happens on the PC running it.

On the whole MariaDB seems to work like a star.

We’d like to thank the development team at MariaDB for making such a wonderfully stable SQL server program.

What Database Issues? I wouldn’t have a stable reliable music stream without it!

RadioDJ of course has to take some of the credit.

“RadioDJ and MariaDB are the most reliable and stable pieces of software we’ve EVER used and we’ve used lots of other databses”

 
So next time you’re looking to install a database for use with a radio automation program such as RadioDJ

@MariaDB is the database program EVERYONE should be using.

Last updated on: October 23rd, 2016
at 13:40 PM Europe/London

Radiodj Free Radio Dj Automation Software.

What is RadioDJ?

RadioDJ is a free radio studio automation program for use by any DJ or radio station.

Click to enlarge

You can even run multiple Shoutcast/Icecast radio stations if you want using third party virtual audio cables (VACS).

It can also be used as a home entertainment system for music. (Which is what we currently use it for)

Is RadioDJ really free?

Yes! It’s 100% Free with no nasty hidden fees or catches despite what certain software/hosting companies try claim in their blog posts. No keys, activation or patches needed to work the full program.

Will RadioDJ work on Windows 10?

Yes RadioDJ works rather well on Windows 10 with very few issues. Unlike other radio automation programs that have “compatibility” issues.

Read the full article

Last updated on: March 26th, 2017
at 17:23 PM Europe/London

Help! I Can’t Install Radiodj

Installing RadioDJ the easy way…

We know it can be daunting and scary installing new software for the first time, Especially if you aren’t used to using software that requires a database, but don’t panic it’s not as difficult as you might think.

If you follow these easy steps and have a bit of patience then you should have the program up and running in no time.

1) Starting off with a FRESH clean install of your Windows operating system is a good bet.

Don’t forget to backup files before you reformat Windows.

Once you’ve reinstalled Windows and downloaded & installed all required security patches/updates/drivers for your PC then you can begin the process of installing and configuring RadioDJ.

Read the full article

Last updated on: March 26th, 2017
at 15:11 PM Europe/London

Mariadb & Radiodj

We came across MariaDB after a user posted on the RadioDJ forums that they were using it with RadioDJ.

Click to enlarge

I have to admit I was surprised by how easy it was to install. It’s a lot more straight forward than the normal MySQL installer.

If you have previously had MySQL installed you will need to see this article about removing it as a service

1) Download the Maria DB MSI installer for your version of Windows Here

2) Open the file & Install and run when Windows prompts.

3) On the licence agreement screen check the accept box. Click next.

Read the full article

Last updated on: April 23rd, 2017
at 09:04 AM Europe/London

Radiodj Database Backup

You can now automatically backup your RadioDJ database at a specified hour of the day with the database setup tool.

Click to enlarge

It’s pretty straight forward to set up.

1) Download RadioDJ
2) Unzip the RadioDJ folder to C:\ outside of the program folder.
3) Open up databasesetup.exe inside the setup folder.
4) Install RadioDJ and install your database as per these Instructions
5) In the second tab set the time and location where you want to backup your database.
6) Minimise to the tray and leave it running.

 
It should automatically backup your database at the hour you set it to backup.

Top Tip: Try making sure you backup your database to an external drive. A small 1GB USB pen drive will do. That way you don’t have to worry about losing your database data in the unlikely event of your database crashing or a power cut.

 

Last updated on: March 26th, 2017
at 15:31 PM Europe/London

Firebird Database Sam Broadcaster

Firebird Database SAM Broadcaster

SAM Broadcaster comes with four different options of database install.

Firebird – MySQL – PostgreSQL – MSSQL

 
Sam Broadcaster Database options

Of the 4 different database options that come with SAM Broadcaster, Firebird appears to be the most unstable database of the four options.

We often see someone complaining that the Firebird database in SAM Broadcaster has crashed on them.

The Firebird database only allows you to load a maximum of 20,000 songs into SAM Broadcaster. So it’s not great if you have a huge music collection.

The MySQL database in SAM Broadcaster doesn’t fare much better as that’s also prone to crashing or becoming corrupted especially if SAM crashes without warning.

The SQL database in RadioDJ is far more stable and lets you load as many songs as you need.

rdj-background-min

Plus the MySQL server & database in RadioDJ isn’t that difficult to setup.

The database in RadioDJ seems to be a lot more robust and stable. (It’s over 2 years since we last rebuilt of database from scratch)

You can find a tutorial on how to setup an SQL server here.

The Firebird database that comes with SAM Broadcaster just isn’t fit for purpose. It’s just another reason to stop buying software from Spacial Audio.

Last updated on: March 26th, 2017
at 15:12 PM Europe/London

Radiodj Track(S) From Sql Query

Recently the developer of RadioDJ introduced a feature into the program called “Track(s) from SQL Query” which can be used along side track rotations.

SQLQueryrotation

It makes programming songs from the “Top 40” “Most played” or “Two songs by the same artist” a piece of pie.

Read the full article

Last updated on: March 26th, 2017
at 19:32 PM Europe/London

Sam Broadcaster Bad Sql!

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!

Last updated on: March 26th, 2017
at 15:35 PM Europe/London

Translate ยป