On 26/09/13 16:48, Andy Brown wrote: > On 26/09/13 16:43, Alan Peterson wrote: >> Andy, any of those exploding carts have "non-QWERTY" characters, such as >> accent marks or German phonetic symbols? >> As I understand it, Rivendell gets indigestion when it encounters those. >> >> AP > > Hi Alan, > I did previously spot this one and have advised them to keep an eye on > carts for this. Whilst I've not found any recently, I'll not rule it > out! (But in these cases I don't believe this was the crash) > > I might look at a mysql query that looks for non-qwerty (if thats > possible) that I can run on a schedule to watch for things like that. > > Thanks for the hint, >
Just to add to this, the following queries should do the trick: mysql -u rduser Rivendell --execute="select NUMBER,TITLE,ARTIST,ALBUM from CART where not ARTIST REGEXP \"[A-Za-z0-9,']\" and ARTIST <> '';" mysql -u rduser Rivendell --execute="select NUMBER,TITLE,ARTIST,ALBUM from CART where not TITLE REGEXP \"[A-Za-z0-9,']\";" -- Andy e: andy @ thebmwz3.co.uk w: http://www.thebmwz3.co.uk g: https://github.com/andyb2000/ _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
