MariaDB & RadioDJ (Setting Up MySQL)

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

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: 5th September 2019
at 11:05 AM Europe/London

Firebird Database Sam Broadcaster

SAM Broadcaster Pro comes with four different options of database to install.

Firebird – MySQL – PostgreSQL – MSSQL

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

Read the full article

Last updated on: 12th September 2019
at 15:15 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: 6th September 2019
at 12:22 PM Europe/London

Changing The Default MySQL Port

Changing the Default SQL port:

When it comes to a MySQL 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: 16th August 2019
at 07:10 AM Europe/London

What Database Issues? (MariaDB)

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

We’ve had MariaDB installed on all of our machines since June 2014. Including any website servers its rare we have to do any maintenance.

Since we started using MariadB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden/improper shutdown of the computer.

Read the full article

Last updated on: 8th September 2019
at 11:16 AM Europe/London

Remote Database Issues? (RadioDJ)

Every now and then we see users having database issues with RadioDJ.

Then in the next sentence they then mention they are attempting to use a remote MySQL database instance.

STOP IT! seriously you will have nothing but headaches if you do try to run RadioDJ on a remote database.

Read the full article

Last updated on: 15th July 2019
at 13:07 PM Europe/London

  Translate