This is due to latest versions of MySQL: https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
Until Rivendell is updated to support this new default, you will need to disable ONLY_FULL_GROUP_BY. Patrick > On Jul 26, 2019, at 2:40 PM, Emir Yapıcı <[email protected]> wrote: > > Hello Fred, everyone! > > Thanks for your awesome work on Rivendell v3. > > I've done a fresh RD v3.0.1 install on xubuntu 18.04 without any errors. > I have a weird database error in rdlibrary. I cannot add or show any items > even if test cart. When i run it from terminal and try to add a song, these > errors occurs: > > rduser@rdserver:~$ rdlibrary > 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 inner join CART_SCHED_CODES as S0 on > (CART.NUMBER=S0.CART_NUMBER and S0.SCHED_CODE='') inner join CART_SCHED_CODES > as S1 on (CART.NUMBER=S1.CART_NUMBER and S1.SCHED_CODE='') where > ((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 > limit 100 > 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.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 > limit 100 > ReadAtom: "/media/rduser/FIESTA_MSC/037 - Far East Movement feat Cataracs and > Dev - Like A G6.mp3": invalid atom size, extends outside parent atom - > skipping to end of "" "" 1229206275 vs 5361370 > ReadAtom: "/media/rduser/FIESTA_MSC/037 - Far East Movement feat Cataracs and > Dev - Like A G6.mp3": atom type is suspect > ReadChildAtoms: "/media/rduser/FIESTA_MSC/037 - Far East Movement feat > Cataracs and Dev - Like A G6.mp3": In atom missing child atom moov > FindIntegerProperty: no such property - moov.mvhd.modificationTime > (src/mp4file.cpp,746) > DB connection re-established > invalid SQL or failed DB connection[Expression #24 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.FORCED_LENGTH,CART.TITLE,CART.ARTIST,CART.ALBUM,CART.LABEL,CART.CLIENT,CART.AGENCY,CART.USER_DEFINED,CART.COMPOSER,CART.CONDUCTOR,CART.PUBLISHER,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.NUMBER=40001 group by CART.NUMBER > > > > I don't have any idea to handle this. > > Best Regards > Emir YAPICI > > _______________________________________________ > 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
