[whups] Trying to use whups for Horde problem reports

Lars Stavholm stava at telcotec.se
Wed Dec 27 00:34:41 PST 2006


Chuck Hagenbuch wrote:
> Quoting Lars Stavholm <stava at telcotec.se>:
> 
>> Well, not sure what to share, but I'll give it a try:
>>
>> Using horde and whups from CVS 2006-12-19.
>>
>> Database shows:
>>
>> select ticket_id, ticket_summary, user_id_requester, queue_id, type_id
>> from whups_tickets;
>> ticket_id   ticket_summary    user_id_requester  queue_id    type_id
>> ----------  ----------------  -----------------  ----------  ----------
>> 1           The addons sucks  root               1           1
>> 2           help me           root               1           1
>>
>> When I do a simple Ticket Search, it comes back with nothing,
>> no matter what search criteria I use. I'm a bit lost now.
> 
> Turn horde logging up to debug level and log the query that whups is
> running when searching, to see what's going on.

Thanks, Chuck, that proved to be fruitful.

The only anomaly I found was the follwing:

rde/whups/lib/Driver/sql.php"]
SQL Query by Whups_Driver_sql::saveSearch(): INSERT INTO
whups_users_searches (user_uid, search_name, search_getvars) VALUES (?,
?, ?) [on line 1593 of "/opt/horde/whups/lib/Driver/sql.php"]
DB Error: DB backend not capable: INSERT INTO whups_users_searches
(user_uid, search_name, search_getvars) VALUES ('root', 'Queue: addons,
Category: Unconfirmed, New, Assigned, Type: Any, Summary: ',
'category%5B%5D=assigned&amp;category[]=new&amp;category[]=unconfirmed&amp;queue=1')
[DB Error: DB backend not capable] [on line 1604 of
"/opt/horde/whups/lib/Driver/sql.php"]

So, I guess that means that the search query fails,
and that's why I don't find my tickets.

Question:
What's the normal procedure in the horde world
in these cases? I'm running off of CVS (2006-12-19).
Should I just upgrade to latest and hope for the best?
Should I report this somewhere?

Thanks
/Lars


More information about the whups mailing list