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
