Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Robert
On Mon, 2013-01-14 at 16:37 +, Andy Brown wrote: > It is this POST-IMPORT CART that causes the error and the hour to > crash. > As soon as I removed the POST-IMPORT CART the hour generation worked > perfectly. same problem here some time ago when we tried to run a PRE-IMPORT CART and a POST-

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Wayne Merricks
Does sound like a bug, you can create a sweeper event and add a pre-import (or post I guess). Then set up your clocks to be: latest sweeper 00 sweeper etc Wayne Merricks The Voice Asia On 14/01/13 16:37, Andy Brown wrote: > Hmm! > OK, so I decided to compile from source, so I'm now running 2

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Andy Brown
Hmm! OK, so I decided to compile from source, so I'm now running 2.3.0 updated the database, everything looks pretty good. Except, same errors! As you mention here its not clear if its dropping the db connection or dropping because of the fault, I think its because of the fault, as if I check for

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Sébastien Leblanc
On 14 January 2013 10:09, Andy Brown wrote: > so I'm thinking of grabbing source and 'doing > it properly'! That's the spirit! -- Sébastien Leblanc ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/m

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Sébastien Leblanc
On 14 January 2013 09:54, Andy Brown wrote: > Yeah I'd tried that, the table that was created has ID as a primary key, > and its the primary key thats the issue, It's trying to add a duplicate > entry for ID: That is weird. Usually, in most database implementations for lists, the primary key is a

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Andy Brown
thanks for the suggestions, all good points, in this instance the table is being created by Rivendell when it generates the log so I can't intervene and remove the index temporarily to see if it fixes it. (Each time I do it re-creates the table). I am also thinking the same though, when it hits an

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Andy Brown
Hi, Yeah I'd tried that, the table that was created has ID as a primary key, and its the primary key thats the issue, It's trying to add a duplicate entry for ID: insert into `2013_01_15_LOG` set ID=47,COUNT=47,TYPE=0, SOURCE=3,START_TIME=82807000,GRACE_TIME=0, CART_NUMBER=9

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Sébastien Leblanc
I don't have an answer for your problem, but regarding MySQL indexes, that should not be a problem. Databases are supposed to work properly even when indexes are missing. The only drawback are performance issues, when trying to sort, or fetching a specific row in the table, based on that column (e.

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Wayne Merricks
Hi, Have you tried running that query in mysql directly: mysql -u root -p Type in your root password then paste in: insert into `2013_01_15_LOG` set ID=3,COUNT=3,TYPE=1, SOURCE=3,START_TIME=7000,GRACE_TIME=-1, CART_NUMBER=0,TIME_TYPE=0,POST_POINT="N", TRANS_TYPE=1,COMMENT="End\ song" MySQL will

Re: [RDD] RDLogmanager and clocks

2013-01-14 Thread Andy Brown
service name, Production is the default. > > You'll probably get QTIME errors saying something like 86:00:00 is not a > valid QTIME ignore those and pay attention to the rest of the stuff that > follows immediately after that. > > Regards, > > Wayne > > -Or

Re: [RDD] RDLogmanager and clocks

2013-01-13 Thread Wayne Merricks
Wayne -Original Message- From: rivendell-dev-boun...@lists.rivendellaudio.org on behalf of Andy Brown Sent: Sun 13/01/2013 20:56 To: rivendell-dev@lists.rivendellaudio.org Subject: [RDD] RDLogmanager and clocks Hi all, I'm new to Rivendell, look after a few community FM radio statio

[RDD] RDLogmanager and clocks

2013-01-13 Thread Andy Brown
Hi all, I'm new to Rivendell, look after a few community FM radio stations here in the UK and looking to migrate them all over to Rivendell as its looking impressive! Have done a manual install on Ubuntu, got everything all up and running. Rivendell version: 2.2.0 Everything is looking good, audi