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
