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
