Hi all, just setup a new system on Fedora 25 that plays imports edit markers etc all work. When it comes to creating a log I get
$ rdlogmanager invalid SQL or failed DB connection[Table 'Rivendell._LOG' doesn't exist QMYSQL3: Unable to execute query]: select ID from `_LOG` where TYPE=6 Database connection failed: select ID from `_LOG` where TYPE=6 Database connection restored. invalid SQL or failed DB connection[Table 'Rivendell._LOG' doesn't exist QMYSQL3: Unable to execute query]: select `_LOG`.ID,`_LOG`.CART_NUMBER,`_LOG`.START_TIME,`_LOG`.TIME_TYPE,`_LOG`. TRANS_TYPE,`_LOG`.START_POINT,`_LOG`.END_POINT,`_LOG`.SEGUE_START_POINT ,`_LOG`.SEGUE_END_POINT,CART.TYPE,CART.GROUP_NAME,CART.TITLE,CART.ARTIS T,CART.ALBUM,CART.YEAR,CART.LABEL,CART.CLIENT,CART.AGENCY,CART.USER_DEF INED,CART.CONDUCTOR,CART.SONG_ID,CART.FORCED_LENGTH,CART.CUT_QUANTITY,C ART.LAST_CUT_PLAYED,CART.PLAY_ORDER,CART.ENFORCE_LENGTH,CART.PRESERVE_P ITCH ,`_LOG`.TYPE,`_LOG`.COMMENT,`_LOG`.LABEL,`_LOG`.GRACE_TIME,`_LOG`.POST_ POINT,`_LOG`.SOURCE,`_LOG`.EXT_START_TIME,`_LOG`.EXT_LENGTH,`_LOG`.EXT_ DATA,`_LOG`.EXT_EVENT_ID,`_LOG`.EXT_ANNC_TYPE,`_LOG`.EXT_CART_NAME,CART .ASYNCRONOUS,`_LOG`.FADEUP_POINT,`_LOG`.FADEUP_GAIN,`_LOG`.FADEDOWN_POI NT,`_LOG`.FADEDOWN_GAIN,`_LOG`.SEGUE_GAIN,CART.PUBLISHER,CART.COMPOSER, CART.USAGE_CODE,CART.AVERAGE_SEGUE_LENGTH,`_LOG`.LINK_EVENT_NAME,`_LOG` .LINK_START_TIME,`_LOG`.LINK_LENGTH,`_LOG`.LINK_ID, `_LOG`.LINK_EMBEDDED,`_LOG`.ORIGIN_USER,`_LOG`.ORIGIN_DATETIME,CART.VAL IDITY, `_LOG`.LINK_START_SLOP,`_LOG`.LINK_END_SLOP, `_LOG`.DUCK_UP_GAIN,`_LOG`.DUCK_DOWN_GAIN,CART.START_DATETIME,CART.END_ DATETIME,`_LOG`.EVENT_LENGTH,CART.USE_EVENT_LENGTH,CART.NOTES from `_LOG` left join CART on `_LOG`.CART_NUMBER=CART.NUMBER order by COUNT Database connection failed: select `_LOG`.ID,`_LOG`.CART_NUMBER,`_LOG`.START_TIME,`_LOG`.TIME_TYPE,`_LOG`. TRANS_TYPE,`_LOG`.START_POINT,`_LOG`.END_POINT,`_LOG`.SEGUE_START_POINT ,`_LOG`.SEGUE_END_POINT,CART.TYPE,CART.GROUP_NAME,CART.TITLE,CART.ARTIS T,CART.ALBUM,CART.YEAR,CART.LABEL,CART.CLIENT,CART.AGENCY,CART.USER_DEF INED,CART.CONDUCTOR,CART.SONG_ID,CART.FORCED_LENGTH,CART.CUT_QUANTITY,C ART.LAST_CUT_PLAYED,CART.PLAY_ORDER,CART.ENFORCE_LENGTH,CART.PRESERVE_P ITCH ,`_LOG`.TYPE,`_LOG`.COMMENT,`_LOG`.LABEL,`_LOG`.GRACE_TIME,`_LOG`.POST_ POINT,`_LOG`.SOURCE,`_LOG`.EXT_START_TIME,`_LOG`.EXT_LENGTH,`_LOG`.EXT_ DATA,`_LOG`.EXT_EVENT_ID,`_LOG`.EXT_ANNC_TYPE,`_LOG`.EXT_CART_NAME,CART .ASYNCRONOUS,`_LOG`.FADEUP_POINT,`_LOG`.FADEUP_GAIN,`_LOG`.FADEDOWN_POI NT,`_LOG`.FADEDOWN_GAIN,`_LOG`.SEGUE_GAIN,CART.PUBLISHER,CART.COMPOSER, CART.USAGE_CODE,CART.AVERAGE_SEGUE_LENGTH,`_LOG`.LINK_EVENT_NAME,`_LOG` .LINK_START_TIME,`_LOG`.LINK_LENGTH,`_LOG`.LINK_ID, `_LOG`.LINK_EMBEDDED,`_LOG`.ORIGIN_USER,`_LOG`.ORIGIN_DATETIME,CART.VAL IDITY, `_LOG`.LINK_START_SLOP,`_LOG`.LINK_END_SLOP, `_LOG`.DUCK_UP_GAIN,`_LOG`.DUCK_DOWN_GAIN,CART.START_DATETIME,CART.END_ DATETIME,`_LOG`.EVENT_LENGTH,CART.USE_EVENT_LENGTH,CART.NOTES from `_LOG` left join CART on `_LOG`.CART_NUMBER=CART.NUMBER order by COUNT Database connection restored. $ This database is dated june 2012, can it be easily fixed or would be it easier to start from scratch? Thanks Gary. _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
