I am seeing the following show up in the logs when using rdlogedit to add a file. There is no error reported however the entry never gets saved. However in the logs, there is an SQL error reported. For whatever reason, rdlogedit is passing 0 for ID of the new record rather than using NULL which would trigger autoincrement:
Apr 9 20:55:18 westcoast rdlogedit: invalid SQL or failed DB connection[Duplicate entry '0' for key 'PRIMARY' QMYSQL3: Unable to execute query]: insert into `WEST18_04_10_LOG` (ID,COUNT,CART_NUMBER,START_TIME,TIME_TYPE, TRANS_TYPE,START_POINT,END_POINT,SEGUE_START_POINT,SEGUE_END_POINT,TYPE, COMMENT,LABEL,GRACE_TIME,SOURCE,EXT_START_TIME, EXT_LENGTH,EXT_DATA,EXT_EVENT_ID,EXT_ANNC_TYPE,EXT_CART_NAME, FADEUP_POINT,FADEUP_GAIN,FADEDOWN_POINT,FADEDOWN_GAIN,SEGUE_GAIN, LINK_EVENT_NAME,LINK_START_TIME,LINK_LENGTH,LINK_ID,LINK_EMBEDDED, ORIGIN_USER,ORIGIN_DATETIME,LINK_START_SLOP,LINK_END_SLOP, DUCK_UP_GAIN,DUCK_DOWN_GAIN,EVENT_LENGTH) values (0,0,999101,0,0,0,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2017-10-26 13:57:58",0,0,0,0,9000),(1,1,100029,10000,0,0,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2018-04-08 23:42:13",0,0,0,0,1310000),(2,2,999100,1376500,0,0,-1,-1,-1,-1,0,"","",-1,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2018-03-30 12:56:34",0,0,0,0,1310000),(3,3,30006,1355000,0,1,-1,-1,-1,-1,0,"","",0,2,"00:22:35",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2016-11-17 19:11:47",0,0,0,0,145000),(4,4,30279,1500000,0,1,-1,-1,-1,-1,0,"","",0,2,"00:25:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2016-06-05 18:25:56",0,0,0,0,180000),(5,5,800702,1800000,1,0,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2017-11-10 21:53:02",0,0,0,0,5000),(6,6,80008,1805000,0,1,-1,-1,-1,-1,0,"","",0,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2016-01-13 17:44:08",0,0,0,0,1555000),(7,7,100019,1808700,0,1,-1,-1,-1,-1,0,"","",-1,3,"00:00:00",0,"","","","",-1,-3000,-1,-3000,-3000,"",0,0,-1,"N","westcoast","2018-04-08 23:32:13",0,0,0,0,1555000),(8,8,80008,3378400,0,1,-1,-1,-1,-1,0,"","",-1,3,"00:00:00",0,"","","" Short of looking into the code, I have no idea why this is happening. Any help on resolving this would be greatly appreciated. I am running version 2.15.1. Mike _______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev