[Tickets #12733] Re: SQL Error in listBookmarks () When $sortby empty

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/12733
------------------------------------------------------------------------------
  Ticket             | 12733
  Updated By         | adorman at ironicdesign.com
  Summary            | SQL Error in listBookmarks () When $sortby empty
  Queue              | Trean
  Version            | 1.0.3
  Type               | Bug
  State              | Not A Bug
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


adorman at ironicdesign.com (2013-10-14 16:44) wrote:

> You have a broken (read empty) 'sortby' preference stored.

I discovered the logging config setting and set it to be DEBUG.  Then  
I watched the logs for anything mentioning "prefs" and saw this logged  
when I logged out and back in.

2013-10-14T11:34:15.170087-05:00 yorick HORDE: [trean] SQL  (0.0003s)   
#012#011SELECT pref_name, pref_value FROM horde_prefs WHERE pref_uid  
=#012#011  'andydorman at comehome.net' AND pref_scope = 'trean' [pid  
19288 on line 558 of "/usr/share/php/Horde/Db/Adapter/Base.php"]

So Horde is definitely looking in the db for trean preferences, but  
since I can not find anywhere to edit trean prefs in neither the Admin  
config nor my individual config screens, these prefs are empty.

So it looks like it comes back to the problem reading  
/etc/horde/trean/prefs.php.  I did not see anything in the logs that  
hinted at what is causing that problem.

Any thoughts about what to look for would be welcome.

Andy Dorman