Author Topic: Error in SQL Syntax  (Read 1248 times)

gnomeradio

  • Guest
Error in SQL Syntax
« on: June 29, 2014, 03:37:21 AM »
Hi, I'm trying to install RadioDJ, I've followed the getting started tutorial and have gotten stuck configuring the database. I've install MySQL and when I try and run the Database Setup Utility and install my database I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Radio;CREATE DATABSE IF NOT EXISTS Gnome Radio' at line 1 (DROP DATABASE IF EXISTS Gnome Radio; CREATE DATABASE IF NOT EXISTS Gnome Radio;)

I've tried googling and have seen people with a similar error using other applications but could not find anything that actually helped me solve this issue.

Can anybody help? Thanks.

Marius

  • Administrator
  • Hero Member

  • Offline
  • *****
  • 5718
    • Radio DJ
Re: Error in SQL Syntax
« Reply #1 on: June 29, 2014, 07:18:48 AM »
You cannot put spaces in database name.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

gnomeradio

  • Guest
Re: Error in SQL Syntax
« Reply #2 on: June 29, 2014, 11:33:08 AM »
Jeez, what a simple fix. Thank you so much.