This is the error:
invalid SQL or failed DB connection[You have an error in your SQL
syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near '/dev/cdrom,PARANOIA_LEVEL
int default 0,RIPPER_LEVEL int default -1300,CDDB_SERV' at line 1
QMYSQL3: Unable to execute query]: create table if not exists
RDLIBRARY (ID int unsigned primary key AUTO_INCREMENT,STATION char(40)
not null,INSTANCE int unsigned not null,INPUT_CARD int default
0,INPUT_STREAM int default 0,INPUT_PORT int default 0,INPUT_TYPE
enum('A','D') default 'A',OUTPUT_CARD int default 0,OUTPUT_STREAM int
default 0,OUTPUT_PORT int default 0,VOX_THRESHOLD int default
-5000,TRIM_THRESHOLD int default 0,RECORD_GPI int default -1,PLAY_GPI
int default -1,STOP_GPI int default -1,DEFAULT_FORMAT int unsigned
default 0,DEFAULT_CHANNELS int unsigned default 2,DEFAULT_SAMPRATE int
unsigned default 44100,DEFAULT_LAYER int unsigned default
0,DEFAULT_BITRATE int unsigned default 0,DEFAULT_RECORD_MODE int
unsigned default 0,DEFAULT_TRIM_STATE enum('N','Y') default
'N',MAXLENGTH int,TAIL_PREROLL int unsigned default 1500,RIPPER_DEVICE
char(64) default /dev/cdrom,PARANOIA_LEVEL int default 0,RIPPER_LEVEL
int default -1300,CDDB_SERVER char(64) default
"freedb.freedb.org",READ_ISRC enum('N','Y') default 'Y',ENABLE_EDITOR
enum('N','Y') default 'N',SRC_CONVERTER int default 1,LIMIT_SEARCH int
default 1,SEARCH_LIMITED enum('N','Y') default 'Y',index STATION_IDX
(STATION,INSTANCE)) engine MyISAM character set latin1 collate
latin1_swedish_ci
SQL: create table if not exists RDLIBRARY (ID int unsigned primary key
AUTO_INCREMENT,STATION char(40) not null,INSTANCE int unsigned not
null,INPUT_CARD int default 0,INPUT_STREAM int default 0,INPUT_PORT
int default 0,INPUT_TYPE enum('A','D') default 'A',OUTPUT_CARD int
default 0,OUTPUT_STREAM int default 0,OUTPUT_PORT int default
0,VOX_THRESHOLD int default -5000,TRIM_THRESHOLD int default
0,RECORD_GPI int default -1,PLAY_GPI int default -1,STOP_GPI int
default -1,DEFAULT_FORMAT int unsigned default 0,DEFAULT_CHANNELS int
unsigned default 2,DEFAULT_SAMPRATE int unsigned default
44100,DEFAULT_LAYER int unsigned default 0,DEFAULT_BITRATE int
unsigned default 0,DEFAULT_RECORD_MODE int unsigned default
0,DEFAULT_TRIM_STATE enum('N','Y') default 'N',MAXLENGTH
int,TAIL_PREROLL int unsigned default 1500,RIPPER_DEVICE char(64)
default /dev/cdrom,PARANOIA_LEVEL int default 0,RIPPER_LEVEL int
default -1300,CDDB_SERVER char(64) default
"freedb.freedb.org",READ_ISRC enum('N','Y') default 'Y',ENABLE_EDITOR
enum('N','Y') default 'N',SRC_CONVERTER int default 1,LIMIT_SEARCH int
default 1,SEARCH_LIMITED enum('N','Y') default 'Y',index STATION_IDX
(STATION,INSTANCE)) engine MyISAM character set latin1 collate
latin1_swedish_ci
SQL Error: You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use
near '/dev/cdrom,PARANOIA_LEVEL int default 0,RIPPER_LEVEL int default
-1300,CDDB_SERV' at line 1
Marius
On 12/21/2017 07:31 PM, Rob Landry wrote:
On Thu, 21 Dec 2017, Marius Wikstøl wrote:
I've done a fresh install of Debian 9 and Rivendell v2.18.0 and done
all of
the steps mentioned, but I still get an error when running rdadmin
for the
first time. What I get is a SQL-syntax error.
What's the SQL statement that generates the error?
Rob
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
