I ran into this recently in a non-Rivendell MySQL situation. The issue is in the server's MySQL configuration. This error message is the clue: "this is incompatible with sql_mode=only_full_group_by"
Here's a page from Stack Exchange that explains how to fix it: https://craftcms.stackexchange.com/questions/12084/getting-this-sql-error-group-by-incompatible-with-sql-mode-only-full-group-by ᐧ On Thu, Aug 22, 2019 at 7:04 PM jstinson <[email protected]> wrote: > 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 >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
