Does this apply to MariaDB as well as MySQL?
Rob
--
Я там, где ребята толковые,
Я там, где плакаты "Вперёд",
Где песни рабочие новые
Страна трудовая поёт.
On Fri, 26 Jul 2019, Patrick Linstruth wrote:
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ı <emiryap...@gmail.com> 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 a
nd S1.SC
HED_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="ST
INGS")||(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
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
