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

* Your Email Address
* Spam protection	Enter the letters below: . ..__ . .. ..__ \ /[__)\|\/\|\|\/\|[__) \/ \| \| \|\| \|\| \
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"] >
Attachment
Watch this ticket

Saved Queries