Not around the test system to check, but you might try checking the DB entry for one for the cuts that is not working, export it save it etc. Then do the "touch" and go back and look at the same entry and see what if anything changed - perhaps that might give a clue as to what you need to do to edit using MySQL. Of course the changed data might be in another table you're not monitoring I suppose. I haven't gotten to looking at the structure in detail yet. But just a thought.
TC -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Nathan Steele Sent: Monday, June 23, 2014 1:24 PM To: Wayne Merricks; Rivendell Mailing List Subject: Re: [RDD] Expired cuts help, imported from wide orbit. By the way the dates are all set valid now but I still have to touch the cuts in RDLibrary before RDAirplay recognizes the changes...... Nathaniel C. Steele Chief Engineer/Technical Director WTCF-Southernlight and TheCross Online On 6/23/2014 1:20 PM, Nathan Steele wrote: > It did blank the record, unfortunately the cut was still showing 00:00 > in length until I went into the cut and saved it again, which put in > the default dates for today....... > > Perhaps setting the enforce date time to disabled would be better than > nulling the field....... > > but, no matter what, RDAirplay still reports no audio data and length > 00:00 until i go into RDlibrary and the cut and save it. I don't > actually have to change anything just go into the cart, open the cut, > and hit ok. > > I really don't want to have to do that for all 20,000 > cuts........anythoughts? > > Nathaniel C. Steele > Chief Engineer/Technical Director > > WTCF-Southernlight > > and > > TheCross Online > > On 6/23/2014 12:09 PM, Wayne Merricks wrote: >> Hi, >> >> NULL should have blanked the record, its a special case. If you want >> to try a date the format is a bit weird as its a DATETIME field: >> >> 'YYYY-MM-DD HH:MM:SS' >> >> e.g. >> >> '2014-06-23 17:07:30' >> >> So I guess: >> >> UPDATE CUTS SET START_DATETIME = '2014-06-22 00:00:00', END_DATETIME >> = '2050-12-31 23:59:59'; >> >> That would set the start to yesterday at midnight and the end to the >> end of 2050. >> >> >> Wayne Merricks >> The Voice Asia >> >> On 23/06/14 16:49, Nathan Steele wrote: >>> OK, Maybe I need to put a date in because I get the same problem >>> until I go into library and select a cart and edit the cut it adds a >>> start and end date of today then it shows like it should.... >>> >>> What is the correct syntax for the date in mysql. I tried putting >>> '06-01-2199' instead of null but that didn't do the trick..... >>> >>> Nathaniel C. Steele >>> Chief Engineer/Technical Director >>> >>> WTCF-Southernlight >>> >>> and >>> >>> TheCross Online >>> >>> On 6/23/2014 10:38 AM, Wayne Merricks wrote: >>>> Hi, >>>> >>>> The cuts have a start and end date as well as the carts. If its >>>> the cuts: >>>> >>>> UPDATE CUTS SET START_DATETIME = NULL, END_DATETIME = NULL >>>> >>>> and carts: >>>> >>>> UPDATE CART SET START_DATETIME = NULL, END_DATETIME = NULL >>>> >>>> Wayne Merricks >>>> The Voice Asia >>>> >>>> On 23/06/14 15:31, Nathan Steele wrote: >>>>> OK, sorry, this didn't work as fantastic as I thought. I have >>>>> determined that having the expired dates is causing my problems in >>>>> RDAirplay that cause the carts to show in red and say no audio >>>>> available and length 00:00, even though they will actually >>>>> play....I think this could be interfering with my music merge with >>>>> MusicMaster as well, since the system seems to think there is no >>>>> audio data...... >>>>> >>>>> Can you maybe give me MYsql commands to set the end date in all >>>>> the cuts? or maybe better, remove the start and end dates, as they >>>>> aren't strictly necessary right? >>>>> >>>>> Nathaniel C. Steele >>>>> Chief Engineer/Technical Director >>>>> >>>>> WTCF-Southernlight >>>>> >>>>> and >>>>> >>>>> TheCross Online >>>>> >>>>> On 5/20/2014 10:18 AM, Nathan Steele wrote: >>>>>> Worked just fantastic. >>>>>> >>>>>> Nathaniel C. Steele >>>>>> Chief Engineer/Technical Director >>>>>> >>>>>> WTCF-Southernlight >>>>>> >>>>>> and >>>>>> >>>>>> TheCross Online >>>>>> >>>>>> On 5/19/2014 11:00 AM, Wayne Merricks wrote: >>>>>>> UPDATE CUTS SET EVERGREEN = 'Y'; >>>>>>> >>>>>>> This will set every cut to evergreen so make sure this is what >>>>>>> you want to do. >>>>>>> >>>>>>> Wayne Merricks >>>>>>> The Voice Asia >>>>>>> >>>>>>> On 19/05/14 15:57, Nathan Steele wrote: >>>>>>>> I"m going to guess this is a windows date versus linux date >>>>>>>> thing, but almost all of the 20,000 or so carts I imported from >>>>>>>> Wide orbit have expired cuts with dates like 1933......I think >>>>>>>> wide orbit required start and end times, but for RD I"m fine >>>>>>>> without using them. I tried to select all carts and edit in >>>>>>>> rdlibrary, but since this a per cut setting, no dice. >>>>>>>> >>>>>>>> Can someone tell me the SQL command to set all cuts in the >>>>>>>> database to evergreen? >>>>>>>> >>>>>>>> Thanks! >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Rivendell-dev mailing list >>>>>>> [email protected] >>>>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Rivendell-dev mailing list >>>>>> [email protected] >>>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>>>> >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Rivendell-dev mailing list >>>>> [email protected] >>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>> >>>> _______________________________________________ >>>> Rivendell-dev mailing list >>>> [email protected] >>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >>>> >>>> >>>> >>> >> >> >> >> > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > > _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
