[Tickets #3471] RESOLVED: psql error when using turba

[bugs@bugs.horde.org]

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

Ticket URL: https://dev.horde.org/horde/whups/ticket/?id=3471
-----------------------------------------------------------------------
 Ticket             | 3471
 Updated By         | Michael Rubinsky <mrubinsk at horde.org>
 Summary            | psql error when using turba
 Queue              | Turba
 Version            | HEAD
-State              | Assigned
+State              | Bogus
-Priority           | 2. Medium
+Priority           | 1. Low
 Type               | Bug
 Owners             | Michael Rubinsky
-----------------------------------------------------------------------


Michael Rubinsky <mrubinsk at horde.org> (2006-02-19 11:59) wrote:

This is a configuration error: Based on your personal email to me (relevent
snippits below for reference) your datatree, indeed everything that uses a
database is broken due to an incorrect charset setting for your database.  I
corrected in your config using the test login you provided. 

Please re-enable Turba to verify this is working for you now.

---Snippits of email---

I looked at the datatree table in the db and this table was already
completely empty! 
So, I guess the problem is probably not Turba specific (although I only get
Turba errors,
nothing from IMP or Horde).  Executing the delete query you proposed through
the sql
shell (although it was empty already) gave the extensive error log attached
to this
message (contains the db password of the test setup hence the private
email).

---Relevent portion of error message, sensitive data removed---
delete from horde_datatree where group_uid='horde.shares.turba';
Results

object(DB_Error)#14 (8) {
  ["error_message_prefix"]=>
  string(0) ""
  ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  int(-2)
  ["message"]=>
  string(22) "DB Error: syntax error"
  ["userinfo"]=>
  string(196) "d e l e t e   f r o m   h o r d e _ d a t a t r e e   w h e r
e   g r o u p _ u i d = ' h o r d e . s h a r e s . t u r b a ' ; 
[nativecode=ERROR:  syntax error at or near "d" at character 1]"