Now I tried to fix a cart from MYSQL only.
First I checked the length of cart 5652 (really the cut in that cart but
it is only cut, and all carts so far only have one cut)
mysql> SELECT * FROM CUTS WHERE CART_NUMBER = '5652' ;
+------------+-------------+-----------+-----------------------+--------+------+------+--------+---------------------+---------------------+---------------------+------+------+------+------+------+------+------+---------------+-------------+-------------+--------+---------------------+-----------------+--------------+---------------+----------+---------------+-------------+----------+----------+-----------+-------------+-----------+--------------+----------------+-------------------+-----------------+------------+------------------+----------------+------------------+----------------+
| CUT_NAME | CART_NUMBER | EVERGREEN | DESCRIPTION | OUTCUE
| ISRC | ISCI | LENGTH | ORIGIN_DATETIME | START_DATETIME |
END_DATETIME | SUN | MON | TUE | WED | THU | FRI | SAT |
START_DAYPART | END_DAYPART | ORIGIN_NAME | WEIGHT | LAST_PLAY_DATETIME
| UPLOAD_DATETIME | PLAY_COUNTER | LOCAL_COUNTER | VALIDITY |
CODING_FORMAT | SAMPLE_RATE | BIT_RATE | CHANNELS | PLAY_GAIN |
START_POINT | END_POINT | FADEUP_POINT | FADEDOWN_POINT |
SEGUE_START_POINT | SEGUE_END_POINT | SEGUE_GAIN | HOOK_START_POINT |
HOOK_END_POINT | TALK_START_POINT | TALK_END_POINT |
+------------+-------------+-----------+-----------------------+--------+------+------+--------+---------------------+---------------------+---------------------+------+------+------+------+------+------+------+---------------+-------------+-------------+--------+---------------------+-----------------+--------------+---------------+----------+---------------+-------------+----------+----------+-----------+-------------+-----------+--------------+----------------+-------------------+-----------------+------------+------------------+----------------+------------------+----------------+
| 005652_001 | 5652 | N | I Know Enough To Know | NULL
| NULL | | 219834 | 2014-05-18 12:27:26 | 2014-06-01 00:00:00 |
2075-06-06 00:00:00 | Y | Y | Y | Y | Y | Y | Y |
NULL | NULL | rdhost | 1 | 2014-06-23 11:18:45
| NULL | 3 | 3 | 2
| 0 | 44100 | 0 | 2 | 0 | 0
| 219834 | -1 | -1 | -1
| -1 | -3000 | -1 | -1
| 0 | 17000 |
+------------+-------------+-----------+-----------------------+--------+------+------+--------+---------------------+---------------------+---------------------+------+------+------+------+------+------+------+---------------+-------------+-------------+--------+---------------------+-----------------+--------------+---------------+----------+---------------+-------------+----------+----------+-----------+-------------+-----------+--------------+----------------+-------------------+-----------------+------------+------------------+----------------+------------------+----------------+
1 row in set (0.00 sec)
Length is 219834. Checking the Cart:
mysql> SELECT * FROM CART WHERE NUMBER = '5652' ;
+--------+------+------------+-----------------------+-------------+-------+------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM |
YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER | COMPOSER
| USER_DEFINED | SONG_ID | BPM | USAGE_CODE | FORCED_LENGTH |
AVERAGE_LENGTH | LENGTH_DEVIATION | AVERAGE_SEGUE_LENGTH |
AVERAGE_HOOK_LENGTH | CUT_QUANTITY | LAST_CUT_PLAYED | PLAY_ORDER |
VALIDITY | START_DATETIME | END_DATETIME | ENFORCE_LENGTH |
PRESERVE_PITCH | ASYNCRONOUS | OWNER | MACROS | SCHED_CODES | NOTES |
METADATA_DATETIME | USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID |
PENDING_DATETIME |
+--------+------+------------+-----------------------+-------------+-------+------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| 5652 | 1 | 101 | I Know Enough To Know | Wine Family |
NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
NULL | 101_SP6633.wav | NULL | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 1 | NULL | NULL
| 2 | 2014-06-01 00:00:00 | 2075-06-01 00:00:00 | N
| N | N | NULL | NULL | NULL | NULL |
2014-05-18 12:27:26 | N | NULL | NULL |
NULL |
+--------+------+------------+-----------------------+-------------+-------+------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
1 row in set (0.00 sec)
And Changing the Entry:
mysql> UPDATE CART SET FORCED_LENGTH = '219834', AVERAGE_LENGTH =
'219834' WHERE NUMBER = '5652' ;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql>
And then go to Airplay, reload the log, and now that cart is white not
red and has the length listed.
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 6/23/2014 5:38 PM, Nathan Steele wrote:
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 6/23/2014 5:29 PM, Nathan Steele wrote:
OK, It looks like when I touch the files, the FORCED_LENGTH and
AVERAGE_LENGTH entries in the CART table go from 0, to whatever is
appropriate. here is a snippet from my terminal. CART 101101 was one
that was working properly, it was a new legal ID imported this
morning. CART 002364 is one that didn't work, and the second instance
is after I opened the cut in RDLibrary and clicked OK, not actually
changing any fields. So....How do I update the Carts entries with the
correct values without having to open each cut and click OK? and
better yet, why Did this happen in the first place?
mysql> SELECT * FROM CART WHERE CART_NUMBER = '101101' ;
ERROR 1054 (42S22): Unknown column 'CART_NUMBER' in 'where clause'
mysql> SELECT * FROM CART WHERE NUMBER = '101101' ;
+--------+------+------------+------------+--------+-------+------------+------+-------+-----------+--------+--------+-----------+----------+--------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+----------------+--------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM |
YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER |
COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE | FORCED_LENGTH
| AVERAGE_LENGTH | LENGTH_DEVIATION | AVERAGE_SEGUE_LENGTH |
AVERAGE_HOOK_LENGTH | CUT_QUANTITY | LAST_CUT_PLAYED | PLAY_ORDER |
VALIDITY | START_DATETIME | END_DATETIME | ENFORCE_LENGTH |
PRESERVE_PITCH | ASYNCRONOUS | OWNER | MACROS | SCHED_CODES | NOTES |
METADATA_DATETIME | USE_EVENT_LENGTH | PENDING_STATION |
PENDING_PID | PENDING_DATETIME |
+--------+------+------------+------------+--------+-------+------------+------+-------+-----------+--------+--------+-----------+----------+--------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+----------------+--------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| 101101 | 1 | LEGAL | Network ID | | |
0000-00-00 | NULL | | | | | | |
| | 0 | 0 | 7900 | 7900 | 0
| 7998 | 0 | 1
| NULL | NULL | 2 | NULL | NULL |
N | N | N | NULL | NULL
| | NULL | 2014-06-23 09:19:15 | N | NULL
| NULL | NULL |
+--------+------+------------+------------+--------+-------+------------+------+-------+-----------+--------+--------+-----------+----------+--------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+----------------+--------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM CART WHERE NUMBER = '002364' ;
+--------+------+------------+------------------+-------------+-------+------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM
| YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER |
COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE |
FORCED_LENGTH | AVERAGE_LENGTH | LENGTH_DEVIATION |
AVERAGE_SEGUE_LENGTH | AVERAGE_HOOK_LENGTH | CUT_QUANTITY |
LAST_CUT_PLAYED | PLAY_ORDER | VALIDITY | START_DATETIME |
END_DATETIME | ENFORCE_LENGTH | PRESERVE_PITCH | ASYNCRONOUS |
OWNER | MACROS | SCHED_CODES | NOTES | METADATA_DATETIME |
USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID | PENDING_DATETIME |
+--------+------+------------+------------------+-------------+-------+------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| 2364 | 1 | 101 | I Choose To Live | Autum Nelon | NULL
| NULL | NULL | NULL | NULL | NULL | NULL | NULL |
NULL | 101_SP2369.wav | NULL | 0 | 0 | 0
| 0 | 0 | 0
| 0 | 1 | NULL | NULL
| 2 | 2014-06-01 00:00:00 | 2075-06-01 00:00:00 |
N | N | N | NULL | NULL |
. | NULL | 2014-05-18 07:30:54 | N |
NULL | NULL | NULL |
+--------+------+------------+------------------+-------------+-------+------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM CART WHERE NUMBER = '002364' ;
+--------+------+------------+------------------+-------------+-------+------------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| NUMBER | TYPE | GROUP_NAME | TITLE | ARTIST | ALBUM
| YEAR | ISRC | LABEL | CONDUCTOR | CLIENT | AGENCY | PUBLISHER
| COMPOSER | USER_DEFINED | SONG_ID | BPM | USAGE_CODE |
FORCED_LENGTH | AVERAGE_LENGTH | LENGTH_DEVIATION |
AVERAGE_SEGUE_LENGTH | AVERAGE_HOOK_LENGTH | CUT_QUANTITY |
LAST_CUT_PLAYED | PLAY_ORDER | VALIDITY | START_DATETIME |
END_DATETIME | ENFORCE_LENGTH | PRESERVE_PITCH | ASYNCRONOUS |
OWNER | MACROS | SCHED_CODES | NOTES | METADATA_DATETIME |
USE_EVENT_LENGTH | PENDING_STATION | PENDING_PID | PENDING_DATETIME |
+--------+------+------------+------------------+-------------+-------+------------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
| 2364 | 1 | 101 | I Choose To Live | Autum Nelon |
| 0000-00-00 | NULL | | | | |
| | 101_SP2369.wav | | 0 | 0 |
237900 | 237900 | 0 | 237986
| 0 | 1 | NULL | NULL
| 1 | 2014-06-01 00:00:00 | 2075-06-06 00:00:00 |
N | N | N | NULL | NULL |
. | NULL | 2014-06-23 13:26:03 | N |
NULL | NULL | NULL |
+--------+------+------------+------------------+-------------+-------+------------+------+-------+-----------+--------+--------+-----------+----------+----------------+---------+------+------------+---------------+----------------+------------------+----------------------+---------------------+--------------+-----------------+------------+----------+---------------------+---------------------+----------------+----------------+-------------+-------+--------+-------------+-------+---------------------+------------------+-----------------+-------------+------------------+
1 row in set (0.00 sec)
mysql>
Nathaniel C. Steele
Chief Engineer/Technical Director
WTCF-Southernlight
and
TheCross Online
On 6/23/2014 3:36 PM, Thomas Churchill wrote:
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: rivendell-dev-boun...@lists.rivendellaudio.org
[mailto:rivendell-dev-boun...@lists.rivendellaudio.org] 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
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
_______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev