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
