Just installed Mint 19.1 with xfce on a Averatec laptop and compiled
Rivendell using http://wiki.rivendellaudio.org/index.php/Debian9.
Having problems with RDLibrary and RDCatch. After installing and
running create with rddbconfig, RDLibrary is empty but the test tone is
accessible in RDLogEdit, RDSlots and RDAirPlay. On opening RDLibrary
in a terminal, I get this error in the terminal:
DB connection re-established
invalid SQL or failed DB connection[Expression #25 of SELECT list is not
in GROUP BY clause and contains nonaggregated column
'Rivendell.CUTS.TALK_START_POINT' which is not functionally dependent on
columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by QMYSQL: Unable to execute query]: select
CART.NUMBER,CART.FORCED_LENGTH,CART.TITLE,CART.ARTIST,CART.ALBUM,CART.LABEL,CART.CLIENT,CART.AGENCY,CART.USER_DEFINED,CART.COMPOSER,CART.PUBLISHER,CART.CONDUCTOR,CART.GROUP_NAME,CART.START_DATETIME,CART.END_DATETIME,CART.TYPE,CART.CUT_QUANTITY,CART.LAST_CUT_PLAYED,CART.ENFORCE_LENGTH,CART.PRESERVE_PITCH,CART.LENGTH_DEVIATION,CART.OWNER,CART.VALIDITY,GROUPS.COLOR,CUTS.TALK_START_POINT,CUTS.TALK_END_POINT
from CART left join GROUPS on CART.GROUP_NAME=GROUPS.NAME left join CUTS
on CART.NUMBER=CUTS.CART_NUMBER where
((CART.GROUP_NAME="TEMP")||(CART.GROUP_NAME="TEST")||(CART.GROUP_NAME="TRAFFIC")||(CART.GROUP_NAME="MUSIC")||(CART.GROUP_NAME="BEDS")||(CART.GROUP_NAME="STINGS")||(CART.GROUP_NAME="MACROS")||(CART.GROUP_NAME="LEGAL")||(CART.GROUP_NAME="IDENTS")||(CART.GROUP_NAME="Work"))&&
((CART.TITLE like "%%")||(CART.ARTIST like "%%")||(CART.CLIENT like
"%%")||(CART.AGENCY like "%%")||(CART.ALBUM like "%%")||(CART.LABEL like
"%%")||(CART.NUMBER like "%%")||(CART.PUBLISHER like
"%%")||(CART.COMPOSER like "%%")||(CART.CONDUCTOR like
"%%")||(CART.SONG_ID like "%%")||(CART.USER_DEFINED like
"%%")||(CUTS.ISCI like "%%")||(CUTS.ISRC like "%%")||(CUTS.DESCRIPTION
like "%%")||(CUTS.OUTCUE like "%%")) && ((TYPE=1)||(TYPE=2)||(TYPE=3))
group by CART.NUMBER order by CART.NUMBER
I can create a download in RDCatch but when it starts I get this error
in a terminal:
DB connection re-established
invalid SQL or failed DB connection[Field 'CHANNEL' doesn't have a
default value QMYSQL: Unable to execute query]: insert into RECORDINGS
set ID=1,STATION_NAME="Chiquita4"
Mysql is far from my understanding and any scripts I use are borrowed
from somebody on this site who knows what they are doing. Any help on
this will be greatly appreciated.
Thanks,
Jimmy
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
