[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:23) wrote:

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

And I am sure you are right about that...the question now becomes why  
is the /etc/horde/trean/prefs.php not apparently having any effect?

I removed my temporary code fix and the SQL error is back.  That, and  
the fact that there are no prefs available for Bookmarks/trean in the  
Admin Config or Preferences web page, even though they are NOT locked  
in prefs.php, seems to indicate that trean's prefs.php is not being  
read.

I checked the horde logs and PHP and do not see any indication in the  
logs of a problem with reading trean/prefs.php.  I also checked the  
admin config screen and it indicates Bookmarks (Trean) 1.0.3 is  
installed, but there are no prefs to be configured for it.  I looked a  
the PostgreSQL db and I see two trean tables, trean_schema_info and  
trean_bookmarks, but NO "trean" prefs in horde_prefs (ie, "SELECT *  
FROM horde_prefs WHERE pref_scope = 'trean' " returns an empty list.)

So at this point I am at a loss for what to check next.  Horde seems  
to be quietly ignoring /etc/horde/trean/prefs.php which in turn is  
causing the empty "sortby" value to be passed.