Re: [RDD] Scrolling to current time on Load
Hi everyone, On Mon, Jul 30, 2012 at 3:17 PM, Fred Gleason wrote: > On Jul 24, 2012, at 19:49 48, Wayne Merricks wrote: > > > So I propose an alteration to the LL macro to take 4 arguments instead > of 3. > > > > LL [] [] []! > > > > Make-Next = 1 to make next or 0 to play (or don't set it to play) > > Great idea. > It doesn't seem the suggested patch has been applied to the sources, or am I missing something ? Is there a reason for this -- seemed like quite a good idea. If anyone knows of a way to load today's log without hard-cutting the playing track, I'd love to hear it! (I'm trying to get my head around CHAIN LOG issues) All the best, David ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Database connection fails when adding clocks to grid
Hello all, Sorry for the delay, I was on vacation. I can confirm that replacing ENGINE=InnoDB with ENGINE=MyISAM in the SERVICES table of the Rivendell database has solved the issue. Thank you very much, dealing with grids has now become so much easier :) Bye, David On Mon, Aug 20, 2012 at 1:15 PM, Wayne Merricks wrote: > Hi again, > > InnoDB didn't replace MyISAM it was just made the default choice if no > engine was specified (as InnoDB is more fault tolerant amongst other > things). > > However you might be able to work around it by recreating the table. > Simply copy/paste the SQL from the table tab but remember to replace > ENGINE=InnoDB with ENGINE=MyISAM. > > If I were you, I'd rename the SERVICES table to SERVICES_Inno (or > something easily understandable years from now). > > Then recreate the table with the MyISAM bit then copy back in the > records from the renamed table (theres a button on the left that says > Save result as SQL insert script if you're using emma (just above the > magnifying glass). > > This might be something to consider moving forwards in terms of the Riv > code as it will probably be a more prominent problem the more people > move onto newer versions of MySQL. > > Wayne Merricks > The Voice Asia > > On 19/08/12 21:56, David Chamla wrote: >> Myself: >> >>>> `CLOCK167` char(64) DEFAULT NULL, >>>> PRIMARY KEY (`NAME`) >>>> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 >>>> >>>> The thing to note (I hope) is that mine shows ENGINE=MyISAM >>>> which doesn't have this page size limitation (or at least not as small by >>>> default). Is your DB also showing MyISAM? >>> No, it actually shows InnoDB! >> ... explained by the fact that I user mysql-server-5.5. >> (MyISAM was apparently replaced by InnoDB from v5.5) >> >> >> David >> ___ >> Rivendell-dev mailing list >> Rivendell-dev@lists.rivendellaudio.org >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > > > ### > Scanned by MailMarshal > ### > > > > Attention: > > The information contained in this message is confidential and intended > for the addressee(s) only. If you have received this message in error > or there are any problems, please notify the originator immediately. > The unauthorised use, disclosure, copying or alteration of this message > is strictly forbidden. Christian Vision or any of its subsidiaries will > not be liable for direct, special, indirect or consequential damages > arising from alteration of the contents of this message by a third party > or as a result of any virus being passed on. Please note that we reserve > the right to monitor and read any e-mails sent or received by the > company under the Telecommunications (Lawful Business Practice) > (Interception of Communications) Regulation 2000. Christian Vision is > registered in England as a limited company 2842414 and as a charity > 1031031 > > > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Database connection fails when adding clocks to grid
Myself: >> `CLOCK167` char(64) DEFAULT NULL, >> PRIMARY KEY (`NAME`) >>) ENGINE=MyISAM DEFAULT CHARSET=latin1 >> >> The thing to note (I hope) is that mine shows ENGINE=MyISAM >> which doesn't have this page size limitation (or at least not as small by >> default). Is your DB also showing MyISAM? > > No, it actually shows InnoDB! ... explained by the fact that I user mysql-server-5.5. (MyISAM was apparently replaced by InnoDB from v5.5) David ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Database connection fails when adding clocks to grid
Wayne: > Anyway I had a look on the DB I use, if you're in Emma and you click > on Table when you've selected the SERVICES table you'll see the SQL > code for that table. Mine looked like this: > > CREATE TABLE `SERVICES` ( > `NAME` char(10) NOT NULL, > `DESCRIPTION` char(255) DEFAULT NULL, > `NAME_TEMPLATE` char(255) DEFAULT NULL, > `PROGRAM_CODE` char(255) DEFAULT NULL, > >... SNIP SNIP ... > > `CLOCK167` char(64) DEFAULT NULL, > PRIMARY KEY (`NAME`) >) ENGINE=MyISAM DEFAULT CHARSET=latin1 > > The thing to note (I hope) is that mine shows ENGINE=MyISAM > which doesn't have this page size limitation (or at least not as small by > default). Is your DB also showing MyISAM? No, it actually shows InnoDB! David ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Database connection fails when adding clocks to grid
Wayne: > If you want a quick manual work around download a MySQL editor like emma > (in the software center on Ubuntu), add the connection to localhost and > then edit the SERVICES table for each clock name. Ah, exactly what I needed, thanks. > It still seems like something odd is happening to your mysql install for > reasons I can't understand (normally local = fine unless you've done > some strange install other than apt-get install mysql-server) It seems you're right! Editing the MySQL database with Emma, I get the exact same errors as within Rivendell: "Row Size too large. The maximum row size for the used table, type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs." OK, so in the end it is a database issue. The remaining questions are: - since even standard queries are not able to change records in this particular Table, I feel a bit stuck... - I still have to understand whether it is a MySQL install issue or a Rivendell issue (somehow messing up during tables creation?) Anyway, thanks for reading. David ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
Re: [RDD] Database connection fails when adding clocks to grid
Actually it seems that all the empty clocks are unable to be filled once the problem appears. Already filled ones can be updated, though. I tried backing up the database and modifying the grid by hand (line beginning by "INSERT INTO `SERVICES`" etc...), replacing all the "NULL" values by the appropriate values (with clock names), but when importing it back into the system (Restore Database), it yells at me: "ERROR 1118 (42000) at line 4230: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs". meh. Hence my "MySQL newbie" bit in my first email :) David On Fri, Aug 17, 2012 at 6:14 PM, Wayne Merricks wrote: > I can't get Riv to fail with the same clock and production names. Does > it let you update with a different clock? > > Wayne Merricks > The Voice Asia > > On 17/08/12 16:41, David Chamla wrote: >> Thanks Wayne, >> >> >> The database is installed locally, and I made sure that no special >> characters besides spaces are used in Rivendell (except in carts and >> cuts). >> >> >> David >> >> On Fri, Aug 17, 2012 at 5:21 PM, Wayne Merricks >> wrote: >>> Odd behaviour, it seems like a strange MySQL issue more than a Rivendell >>> one. >>> >>> Are there any strange characters in your clock names or apostrophes? >>> There might be an unknown bug with incorrectly escaped characters for >>> MySQL causing problems. >>> >>> Is the database local or on another machine? >>> >>> Wayne Merricks >>> The Voice Asia >>> >>> On 17/08/12 15:08, David Chamla wrote: >>>> Hello all, >>>> >>>> >>>> First of all, a couple of words to introduce myself since it's my >>>> first message here. >>>> I'm from France, and volunteering as technical manager at a local >>>> non-profit freeform radio. >>>> I'm a basic user of Unix, and by no means familiar with MySQL. I've >>>> been subscribed to this list for about a month now. >>>> >>>> I've been searching for a replacement of our (nice) old (somewhat >>>> temperamental!) automation system, and I'm obviously more than >>>> seriously considering switching to Rivendell. >>>> To do so, I'm setting up an Ubuntu workstation with Rivendell, in an >>>> attempt to air a full week or real airtime (during student summer >>>> holidays) based on prerecorded material so as to evaluate the amount >>>> of work that will be needed to completely switch to Rivendell in a few >>>> months. >>>> >>>> I've basically imported hundreds of GB worth of music, shows, idents, >>>> etc... into my library. >>>> I've built events, clocks, and I'm now constructing my grid with >>>> RDLogManager. >>>> >>>> >>>> This is how my post is probably beginning to make sense to this >>>> mailing-list: >>>> 1/ I filled about half of the 168 clocks with 5 different clocks (I've >>>> kept it very simple for now) >>>> 2/ I closed the "Edit Grid" window >>>> 3/ after a couple of minutes, I re-opened this "Edit Grid" window, >>>> filling up the rest of the 168 clocks >>>> 4/ unfortunately, generating logs produced some errors, so I went back >>>> to the "Edit Grid" window, and saw that none of the modifications made >>>> at step 3 were written in the database >>>> 5/ I've started rdlogmanager from a terminal to be able to see any >>>> output message. I get when trying to fill a slot with a clock in the >>>> "Edit Grid" window, the output is as follows: >>>> >>>> < >>>> invalid SQL or failed DB connection: update SERVICES set >>>> CLOCK26="Music Exp Nuit" where >>>> NAME="Saison A" >>>> Database connection failed: update SERVICES set CLOCK26="Music Exp >>>> Nuit" where NAME="Saison A" >>>> Database connection restored. >>>> "Music Exp Nuit" is a Clock name. >>>> "Saison A" is a Service name. >>>> CLOCK changes according to the actual slot I'm frying to fill in. >>>> Apart from those messages, the GUI gives me absolutely no clue that >>>> something is
Re: [RDD] Database connection fails when adding clocks to grid
Thanks Wayne, The database is installed locally, and I made sure that no special characters besides spaces are used in Rivendell (except in carts and cuts). David On Fri, Aug 17, 2012 at 5:21 PM, Wayne Merricks wrote: > Odd behaviour, it seems like a strange MySQL issue more than a Rivendell > one. > > Are there any strange characters in your clock names or apostrophes? > There might be an unknown bug with incorrectly escaped characters for > MySQL causing problems. > > Is the database local or on another machine? > > Wayne Merricks > The Voice Asia > > On 17/08/12 15:08, David Chamla wrote: >> Hello all, >> >> >> First of all, a couple of words to introduce myself since it's my >> first message here. >> I'm from France, and volunteering as technical manager at a local >> non-profit freeform radio. >> I'm a basic user of Unix, and by no means familiar with MySQL. I've >> been subscribed to this list for about a month now. >> >> I've been searching for a replacement of our (nice) old (somewhat >> temperamental!) automation system, and I'm obviously more than >> seriously considering switching to Rivendell. >> To do so, I'm setting up an Ubuntu workstation with Rivendell, in an >> attempt to air a full week or real airtime (during student summer >> holidays) based on prerecorded material so as to evaluate the amount >> of work that will be needed to completely switch to Rivendell in a few >> months. >> >> I've basically imported hundreds of GB worth of music, shows, idents, >> etc... into my library. >> I've built events, clocks, and I'm now constructing my grid with >> RDLogManager. >> >> >> This is how my post is probably beginning to make sense to this mailing-list: >> 1/ I filled about half of the 168 clocks with 5 different clocks (I've >> kept it very simple for now) >> 2/ I closed the "Edit Grid" window >> 3/ after a couple of minutes, I re-opened this "Edit Grid" window, >> filling up the rest of the 168 clocks >> 4/ unfortunately, generating logs produced some errors, so I went back >> to the "Edit Grid" window, and saw that none of the modifications made >> at step 3 were written in the database >> 5/ I've started rdlogmanager from a terminal to be able to see any >> output message. I get when trying to fill a slot with a clock in the >> "Edit Grid" window, the output is as follows: >> >> < >> invalid SQL or failed DB connection: update SERVICES set >> CLOCK26="Music Exp Nuit" where >> NAME="Saison A" >> Database connection failed: update SERVICES set CLOCK26="Music Exp >> Nuit" where NAME="Saison A" >> Database connection restored. >> "Music Exp Nuit" is a Clock name. >> "Saison A" is a Service name. >> CLOCK changes according to the actual slot I'm frying to fill in. >> Apart from those messages, the GUI gives me absolutely no clue that >> something is going wrong: the slots colors do change and give the >> false impression that the grid is actually being filled. However, by >> closing the window and re-opening it again, I can see that the grid >> database remains completely frozen at stage 3. >> >> Additional info: when I try to modify an already filled clock, it is >> actually modified and no such error message is given. Does that mean >> that only the process of *adding* an entry to the DB is problematic? >> >> Any idea? Is this a bug, or did I do something wrong in the first place? >> Any workaround? (it seems that backing up the sql database and >> importing it temporarily solves the issue... till the next grid >> modification going wrong). >> I've encountered this issue a couple of times, this is completely >> repeatable on my end. >> >> >> Best regards, >> David >> ___ >> Rivendell-dev mailing list >> Rivendell-dev@lists.rivendellaudio.org >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev > > > ### > Scanned by MailMarshal > ### > > > > Attention: > > The information contained in this message is confidential and intended > for the addressee(s) only. If you have received this message in error > or there are any problems, please notify the originator immediately. > The unauthorised use, disclosure, copying or alteration of thi
[RDD] Database connection fails when adding clocks to grid
Hello all, First of all, a couple of words to introduce myself since it's my first message here. I'm from France, and volunteering as technical manager at a local non-profit freeform radio. I'm a basic user of Unix, and by no means familiar with MySQL. I've been subscribed to this list for about a month now. I've been searching for a replacement of our (nice) old (somewhat temperamental!) automation system, and I'm obviously more than seriously considering switching to Rivendell. To do so, I'm setting up an Ubuntu workstation with Rivendell, in an attempt to air a full week or real airtime (during student summer holidays) based on prerecorded material so as to evaluate the amount of work that will be needed to completely switch to Rivendell in a few months. I've basically imported hundreds of GB worth of music, shows, idents, etc... into my library. I've built events, clocks, and I'm now constructing my grid with RDLogManager. This is how my post is probably beginning to make sense to this mailing-list: 1/ I filled about half of the 168 clocks with 5 different clocks (I've kept it very simple for now) 2/ I closed the "Edit Grid" window 3/ after a couple of minutes, I re-opened this "Edit Grid" window, filling up the rest of the 168 clocks 4/ unfortunately, generating logs produced some errors, so I went back to the "Edit Grid" window, and saw that none of the modifications made at step 3 were written in the database 5/ I've started rdlogmanager from a terminal to be able to see any output message. I get when trying to fill a slot with a clock in the "Edit Grid" window, the output is as follows: < invalid SQL or failed DB connection: update SERVICES set CLOCK26="Music Exp Nuit" where NAME="Saison A" Database connection failed: update SERVICES set CLOCK26="Music Exp Nuit" where NAME="Saison A" Database connection restored. > "Music Exp Nuit" is a Clock name. "Saison A" is a Service name. CLOCK changes according to the actual slot I'm frying to fill in. Apart from those messages, the GUI gives me absolutely no clue that something is going wrong: the slots colors do change and give the false impression that the grid is actually being filled. However, by closing the window and re-opening it again, I can see that the grid database remains completely frozen at stage 3. Additional info: when I try to modify an already filled clock, it is actually modified and no such error message is given. Does that mean that only the process of *adding* an entry to the DB is problematic? Any idea? Is this a bug, or did I do something wrong in the first place? Any workaround? (it seems that backing up the sql database and importing it temporarily solves the issue... till the next grid modification going wrong). I've encountered this issue a couple of times, this is completely repeatable on my end. Best regards, David ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
