FreeTDS Development Group

["Rakesh Desai" <rdesai AT asite.com>]

Hi,

 

We have been using Kronolith Calendar Application deployed as part of
Horde Groupware Webmail Edition 1.2 with MS SQL 2005 as Database server
& PHP talks to it via FreeTDS.

Many times clients complain getting following message on the UI:

"The preferences backend is currently unavailable and your preferences
have not been loaded. You may continue to use the system with default
settings"

And create event icon will not be available to client.

 

At this time we can see error in the horde logs as below:

Jan 30 09:41:40 HORDE [error] [kronolith] MDB2 Error: unknown error:
_doQuery: [Error message: Could not select the database: horde]

[Last executed query: SELECT DISTINCT s.*  FROM kronolith_shares s  LEFT
JOIN kronolith_shares_users AS u ON u.share_id = s.share_id WHERE
s.share_owner = '431' OR (s.perm_creator & 2) != 0 OR (s.perm_default &
2) != 0 OR ( u.user_uid = '431' AND (u.perm & 2) != 0) ORDER BY
s.attribute_name ASC]

[Native message: Changed database context to 'horde'.]

 [pid 11420 on line 1343 of "E:\horde\kronolith\lib\Kronolith.php"]

Jan 30 09:41:40 HORDE [error] [kronolith] Failed checking prefs for 431:
DB Error: unknown error [pid 11420 on line 214 of
"E:\horde\lib\Horde\Prefs\sql.php"]

 

Is there any issue using FreeTDS with PHP in Horde?

I had posted this on Horde mailing list but was suggested to go for
FreeTDS post instead, has anyone idea about what could be the reason for
above behavior?

 

Thanks

Rakesh