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" <[email protected]> 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 > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
