[Tickets #8729] Whups Complains of missing field (not had this problem before)

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/8729
------------------------------------------------------------------------------
  Ticket             | 8729
  Created By         | hall_monty at rastar.merseine.nu
  Summary            | Whups Complains of missing field (not had this problem
                     | before)
  Queue              | Whups
  Version            | 1.0.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


hall_monty at rastar.merseine.nu (2009-11-25 16:33) wrote:

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"]