[Tickets #10420] Re: wrong column names and non-standard compliant queries

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10420
------------------------------------------------------------------------------
  Ticket             | 10420
  Updated By         | thpo+horde at dotrc.de
  Summary            | wrong column names and non-standard compliant queries
  Queue              | Ansel
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


thpo+horde at dotrc.de (2011-08-11 07:09) wrote:

> Can you provide the error that is thrown from not quoting the  
> signature? It's a bound parameter, so the quoting should be taken  
> care of by the Horde_Db library. If it's not, something is wrong in  
> that library.

ERR: HORDE [ansel] SQL QUERY FAILED: SQLSTATE[22021]: Character not in  
repertoire: 7 ERROR:  invalid byte sequence for encoding "UTF8": 0x80
TIP:  This error can also happen if the byte sequence does not match  
the encoding expected by the server, which is controlled by  
"client_encoding".
         UPDATE ansel_faces SET face_signature =  
'<80>6srh{Z^_^_Eyu1|^Bxz ^Z^T' WHERE
           face_id = 1 [pid 14759 on line 808 of  
"/usr/share/php/Horde/Db/Adapter/Base.php"]