6.0.0-beta1
7/5/25

[#8729] Whups Complains of missing field (not had this problem before)
Summary Whups Complains of missing field (not had this problem before)
Queue Whups
Queue Version 1.0.1
Type Bug
State Not A Bug
Priority 1. Low
Owners mrubinsk (at) horde (dot) org
Requester hall_monty (at) rastar (dot) merseine (dot) nu
Created 11/25/2009 (5701 days ago)
Due
Updated 11/25/2009 (5701 days ago)
Assigned
Resolved 11/25/2009 (5701 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
11/25/2009 11:26:00 PM hall_monty (at) rastar (dot) merseine (dot) nu Comment #3 Reply to this comment
Read docs/UPGRADING
I extracted the docs from the dist file. know.  Problem solved. Looks 
like the freebsd port maintainer has not included the docs in the 
package list or mentioned anything in the UPDATING log..  I'll let 
them know.
11/25/2009 09:39:59 PM Michael Rubinsky Comment #2
Assigned to Michael Rubinsky
State ⇒ Not A Bug
Reply to this comment
Read docs/UPGRADING
11/25/2009 09:33:20 PM hall_monty (at) rastar (dot) merseine (dot) nu Comment #1
Priority ⇒ 1. Low
Patch ⇒ No
Milestone ⇒
Queue ⇒ Whups
Summary ⇒ Whups Complains of missing field (not had this problem before)
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
Been using whups for quite a while.  I think FreeBSD may have just 
update the whups ports.

Monty
===========
Nov 25 21:21:39 HORDE [error] [whups] DB Error: no such field: SELECT 
whups_tickets.ticket_id AS id, whups_tickets.ticket_summary AS 
summary, whups_tickets.user_id_requester, whups_tickets.state_id AS 
state, whups_tickets.type_id AS type, whups_tickets.priority_id AS 
priority, whups_tickets.queue_id AS queue, whups_tickets.date_updated, 
whups_tickets.date_assigned, whups_tickets.date_resolved, 
whups_tickets.version_id AS version, whups_tickets.ticket_timestamp AS 
timestamp, whups_tickets.ticket_due AS due, whups_types.type_name AS 
type_name, whups_states.state_name AS state_name, 
whups_states.state_category AS state_category, 
whups_priorities.priority_name AS priority_name, 
whups_versions.version_name AS version_name, 
whups_versions.version_description AS version_description, 
whups_versions.version_active AS version_active, 
whups_queues.queue_name AS queue_name FROM whups_tickets INNER JOIN 
whups_ticket_owners ON whups_tickets.ticket_id = 
whups_ticket_owners.ticket_id AND whups_ticket_owners.ticket_owner = 
'user:<<DELETE BY REPORTER>>' INNER JOIN whups_types ON 
whups_tickets.type_id = whups_types.type_id INNER JOIN whups_states ON 
whups_tickets.state_id = whups_states.state_id INNER JOIN 
whups_priorities ON whups_tickets.priority_id = 
whups_priorities.priority_id INNER JOIN whups_states state2 ON 
whups_tickets.type_id = state2.type_id LEFT JOIN whups_versions ON 
whups_tickets.version_id = whups_versions.version_id INNER JOIN 
whups_queues ON whups_tickets.queue_id = whups_queues.queue_id WHERE 
((whups_tickets.type_id = whups_states.type_id AND 
whups_tickets.state_id = whups_states.state_id AND 
whups_states.state_category <> 'resolved')) GROUP BY 
whups_tickets.ticket_id, whups_tickets.ticket_summary, 
whups_tickets.user_id_requester, whups_tickets.state_id, 
whups_tickets.type_id, whups_tickets.priority_id, 
whups_tickets.queue_id, whups_tickets.ticket_timestamp, 
whups_tickets.ticket_due, whups_tickets.date_updated, 
whups_tickets.date_assigned, whups_tickets.date_resolved, 
whups_types.type_name, whups_states.state_name, 
whups_states.state_category, whups_versions.version_name, 
whups_versions.version_description, whups_versions.version_active, 
whups_tickets.version_id, whups_queues.queue_name, 
whups_priorities.priority_name [nativecode=1054 ** Unknown column 
'whups_versions.version_active' in 'field list'] [pid 31683 on line 
1018 of "/usr/local/www/horde/whups/lib/Driver/sql.php"]

Saved Queries