6.0.0-beta1
9/7/25

[#3471] psql error when using turba
Summary psql error when using turba
Queue Turba
Queue Version HEAD
Type Bug
State Not A Bug
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester Chris (at) vandenberghe (dot) org
Created 02/14/2006 (7145 days ago)
Due
Updated 02/20/2006 (7139 days ago)
Assigned 02/14/2006 (7145 days ago)
Resolved 02/19/2006 (7140 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
02/20/2006 08:19:27 PM Chris (at) vandenberghe (dot) org Comment #7 Reply to this comment
Solved!  There was a configuration problem in the sources.php that 
made every request timeout on a non-active data source.



Thanks for you help,

Chris.
02/19/2006 09:34:01 PM Chris (at) vandenberghe (dot) org Comment #6 Reply to this comment
Hi Michael,
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.
You were very right, the database encoding was indeed incorrect.   
Thanks for fixing this and sorry for the bogus bug report.



However, Turba still doesn't work properly.  The combination 
Horde/IMP/Kronolith work just fine, enabling Turba makes the system 
performance go down to an unusable level (minutes per page request!).   
There are no error message in the Horde log, psql log or Apache log... 
so, I'm in the dark about what could cause this behavior.



The login is still enabled if you'd care to take a look.



Thanks,

Chris,
02/19/2006 07:59:22 PM Michael Rubinsky Comment #5
State ⇒ Not A Bug
Priority ⇒ 1. Low
Reply to this comment
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]"


02/16/2006 04:05:39 PM Michael Rubinsky Comment #4 Reply to this comment
I just installed turba and kronolith for testing purposes and just
clicked on the address book icon.  SInce installing turba everything
goes very very slow (where before it actually worked quite
efficiently).
If this is the first time you clicked on the address book icon, then 
turba was trying to create your default share.  The value in the SQL 
statement that is causing problems should be the name of the source 
that the share is for....if you didn't change anything in sources.php, 
this should be 'localsql'.  Why the SQL statement is broken, I have no 
idea yet...



Can you: (assuming this is not a production box)

Clear the turba share datatree by going to the SQL shell and typing:

delete from horde_datatree where group_uid='horde.shares.turba';



In lib/Driver.php, after line 1030 add:

line 1030: $params = array('sourceType' => $shareName);



newlines:

    echo '<pre>';

    var_dump($params);

    echo '</pre>';



Now try to return to Turba and please provide the output  of the 
var_dump as an attachment to this ticket...



Thanks.

[Show Quoted Text - 11 lines]
02/16/2006 09:29:40 AM Chris (at) vandenberghe (dot) org Comment #3 Reply to this comment
I just installed turba and kronolith for testing purposes and just 
clicked on the address book icon.  SInce installing turba everything 
goes very very slow (where before it actually worked quite efficiently).



I can provide you with a test login if that would help.



Cheers,

Chris.



---
Can you please post more information:  What you were doing when this
error occurs (creating a new address book?), the values you were
using etc...

Thanks.
02/15/2006 08:45:56 PM Michael Rubinsky Comment #2 Reply to this comment
Can you please post more information:  What you were doing when this 
error occurs (creating a new address book?), the values you were using 
etc...



Thanks.

[Show Quoted Text - 13 lines]
02/14/2006 08:22:14 AM Jan Schneider Assigned to Michael Rubinsky
State ⇒ Assigned
 
02/14/2006 12:13:04 AM Chris (at) vandenberghe (dot) org Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ psql error when using turba
Queue ⇒ Turba
State ⇒ Unconfirmed
Reply to this comment
turba-h3-2.1-rc2 on PSQL 7.4 gives the following error:



2006-02-14 01:04:43 [16705] LOG:  statement: INSERT INTO 
horde_datatree (datatree_id, group_uid, datatree_name, datatree_order, 
datatree_data, user_uid, datatree_serialized, datatree_parents) VALUES 
(25, 'horde.shares.turba', 'l

2006-02-14 01:04:43 [16705] ERROR:  unterminated quoted string at or 
near "'l" at character 182



I can provide more information and testing if requested.



Best regards,

Chris.

Saved Queries