[RDD] RDAirPlay DB errors

Karl Koscher supersat at uwave.fm
Fri May 15 07:03:49 EDT 2015


Yep, the query works just fine. I also see the row added to the
Production_SRT table so it seems to be executing.
On May 15, 2015 2:27 AM, "Wayne Merricks" <waynemerricks at thevoiceasia.com>
wrote:

> Hi,
>
> Have you tried running that query in a mysql client directly?
>
> I had an issue with an old version of Riv where an operator had added a
> clock called "HR3 " <-- notice the space, this was trimmed when Riv used it
> but not when the table was created so I kept getting errors reported like
> that "database lost, restored."
>
> It was obvious when I ran the SQL directly and got a "HR3 table does not
> exist".
>
> Regards,
>
> Wayne Merricks
> The Voice Asia
>
> On 15/05/15 07:09, Karl Koscher wrote:
>
>> insert into `Production_SRT` set
>> LENGTH=308026,LOG_NAME="2015_05_11",LOG_ID=16,CART_NUMBER=10122,STATION_NAME="hill",EVENT_DATETIME="2015-05-11
>> 00:35:41",EVENT_TYPE=3,EVENT_SOURCE=2,EXT_START_TIME="00:33:00",EXT_LENGTH=0,EXT_DATA="",EXT_EVENT_ID="",EXT_ANNC_TYPE="",PLAY_SOURCE=1,CUT_NUMBER=1,EXT_CART_NAME="",TITLE="Master\
>> Blaster\ \(Jammin\'\)",ARTIST="Stevie\
>> Wonder",SCHEDULED_TIME="00:33:00",ISRC="",PUBLISHER="",COMPOSER="",USAGE_CODE=0,START_SOURCE=3,ONAIR_FLAG="N",ALBUM="Hotter\
>> Than\ July",LABEL="",USER_DEFINED="CD",CONDUCTOR="",SONG_ID="",ISCI=""
>>
>
> _______________________________________________
> Rivendell-dev mailing list
> Rivendell-dev at lists.rivendellaudio.org
> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20150515/f98a6178/attachment.html>


More information about the Rivendell-dev mailing list