[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&category[]=new&category[]=unconfirmed&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