MariaDB & RadioDJ (Setting Up MySQL)

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

I have to admit I was surprised by how easy MariaDB was to install. It’s a lot more straight forward than the normal MySQL installer. Its not as fiddly as setting up MySQL server edition.

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: 25th September 2018
at 10:55 AM Europe/London

Firebird Database Sam Broadcaster

Firebird Database SAM Broadcaster

SAM Broadcaster comes with four different options of database install.

Firebird – MySQL – PostgreSQL – MSSQL

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

Read the full article

Last updated on: 5th September 2018
at 12:46 PM Europe/London

RadioDJ Tracks From SQL Query

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: 5th September 2018
at 12:46 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”

Read the full article

Last updated on: 19th July 2018
at 14:13 PM Europe/London

Changing The Default MySQL Port

Changing the Default SQL port:

When it comes to a SQL server running along side RadioDJ some users have found that their web hosts won’t allow connections to the default SQL port 3306.

If you need a specific port open for this to work it’s probably a wise idea to email your website host support department asking if it’s OK to use a non standard port for use with SQL. Otherwise you may get into trouble with them.

Read the full article

Last updated on: 7th September 2018
at 15:39 PM Europe/London

  Translate