[horde] Fatal error with whups

[Hanns Mattes]

Hi,

Am 27.02.2015 um 23:24 schrieb erling at eph.dk:
> 
> Citat af Hanns Mattes <hanns at hannsmattes.de>:
> 
>> Any other ideas, what could cause this error? Though there is no need
>> for a ticket system in my use case - I don't like it, if things aren't
>> working the way they should.
> Let us se your config.
> I have it installed on my test server.
> With sql backend.
> Perhaps we can find out what is wrong if we get some more info.
> I don't get that error.

Here we go:

horde/whups is installed under /usr/share/php5/PEAR/www/horde/*

Basically it is an rpm-installation with opensuse 13.2 using the RPMs,
Ralf (I think) provided and since then upgrade via pear.

Preference system ist sql with horde defaults.

whups/config/conf.php

<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Id: 56c6fd76ea2179142484c6e1ae4147df8b7ab6bf $
$conf['tickets']['params']['driverconfig'] = 'horde';
$conf['tickets']['driver'] = 'Sql';
$conf['guests']['figlet_font'] = '/usr/share/figlet/big.flf';
$conf['guests']['captcha'] = true;
$conf['mail']['return_path'] = 'admin at bruecko.de';
$conf['mail']['always_copy'] = 'hannsldap at hannsmattes.de';
$conf['mail']['reply'] = false;
$conf['mail']['include_headers'] = true;
$conf['mail']['attach_message'] = false;
$conf['mail']['commenthistory'] = 'new';
$conf['mail']['link_attach'] = true;
$conf['mail']['incl_resp'] = true;
$conf['mail']['server_name'] = 'horde.bruecko.de';
$conf['mail']['server_port'] = 80;
$conf['mail']['username'] = 'admin at bruecko.de';
$conf['prefs']['autolink_terms'] = 'bug|ticket|issue';
$conf['prefs']['assign_all_groups'] = false;
$conf['states']['1']['name'] = 'Unconfirmed';
$conf['states']['1']['desc'] = 'A ticket has been reported but not yet
analyzed';
$conf['states']['1']['category'] = 'unconfirmed';
$conf['states']['1']['active'] = 'active';
$conf['states']['2']['name'] = 'Accepted';
$conf['states']['2']['desc'] = 'The ticket has been analyzed and
accepted as valid.';
$conf['states']['2']['category'] = 'new';
$conf['states']['2']['active'] = 'active';
$conf['states']['3']['name'] = 'Assigned';
$conf['states']['3']['desc'] = 'Someone has accepted responsibility for
the ticket.';
$conf['states']['3']['category'] = 'assigned';
$conf['states']['3']['active'] = 'active';
$conf['states']['4']['name'] = 'Resolved';
$conf['states']['4']['desc'] = 'The ticket has been resolved.';
$conf['states']['4']['category'] = 'resolved';
$conf['states']['4']['active'] = 'active';
$conf['states']['5']['name'] = 'Canceled';
$conf['states']['5']['desc'] = 'The ticket is no longer valid for one
reason or another.';
$conf['states']['5']['category'] = 'resolved';
$conf['states']['5']['active'] = 'active';
$conf['states']['6']['active'] = 'inactive';
$conf['states']['7']['active'] = 'inactive';
$conf['states']['8']['active'] = 'inactive';
$conf['priorities']['1']['name'] = '1. Low';
$conf['priorities']['1']['desc'] = 'This is a very low priority ticket';
$conf['priorities']['1']['active'] = 'active';
$conf['priorities']['2']['name'] = '2. Medium';
$conf['priorities']['2']['desc'] = 'This is an important task, but not
urgent.';
$conf['priorities']['2']['active'] = 'active';
$conf['priorities']['3']['name'] = '3. High';
$conf['priorities']['3']['desc'] = 'This ticket is very urgent';
$conf['priorities']['3']['active'] = 'active';
$conf['priorities']['4']['active'] = 'inactive';
$conf['priorities']['5']['active'] = 'inactive';
$conf['priorities']['6']['active'] = 'inactive';
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */

prefs.php (No changes, so no prefs.local.php):

<?php
/**
 * See horde/config/prefs.php for documentation on the structure of this
file.
 *
 * IMPORTANT: DO NOT EDIT THIS FILE! DO NOT COPY prefs.php TO
prefs.local.php!
 * Local overrides ONLY MUST be placed in prefs.local.php or prefs.d/.
 * If the 'vhosts' setting has been enabled in Horde's configuration,
you can
 * use prefs-servername.php.
 */

$prefGroups['display'] = array(
    'column' => _("General Preferences"),
    'label' => _("Display Preferences"),
    'desc' => _("Change display preferences such as how search results
are sorted."),
    'members' => array(
        'sortby', 'sortdir', 'comment_sort_dir', 'whups_default_view',
        'summary_show_requested', 'summary_show_ticket_numbers',
        'report_time_format', 'autolink_tickets'
    )
);

$prefGroups['notification'] = array(
    'column' => _("General Preferences"),
    'label' => _("Notification Preferences"),
    'desc' => _("Change preferences for email notifications of ticket
activity."),
    'members' => array('email_others_only', 'email_comments_only'));

$prefGroups['addressbooks'] = array(
    'column' => _("General Preferences"),
    'label' => _("Address Books"),
    'desc' => _("Select address book sources for adding and searching
for addresses."),
    'members' => array('sourceselect'),
    'suppress' => function() {
        return !$GLOBALS['registry']->hasMethod('contacts/sources');
    }
);


// the layout of the bugs portal.
$_prefs['mybugs_layout'] = array(
    'value' => 'a:0:{}'
);

// user preferred sorting column
$_prefs['sortby'] = array(
    'value' => 'id',
    'type' => 'enum',
    'enum' => array(
        'id' => _("Id"),
        'summary' => _("Summary"),
        'state_name' => _("State"),
        'type_name'     => _("Type"),
        'priority_name' => _("Priority"),
        'queue_name' => _("Queue"),
        'version_name' => _("Version"),
        'timestamp' => _("Created"),
        'date_assigned' => _("Assigned"),
        'date_resolved' => _("Resolved")
    ),
    'desc' => _("Default sorting criteria:")
);

// user preferred sorting direction
$_prefs['sortdir'] = array(
    'value' => 0,
    'type' => 'enum',
    'enum' => array(
        0 => _("Ascending"),
        1 => _("Descending")
    ),
    'desc' => _("Default sorting direction:")
);

// default view
$_prefs['whups_default_view'] = array(
    'value' => 'mybugs',
    'type' => 'enum',
    'enum' => array(
        'mybugs' => _("My Tickets"),
        'search' => _("Search Tickets"),
        'ticket/create' => _("Create Ticket")
    ),
    'desc' => _("Select the view to display after login:")
);

// show requested tickets in the horde summary?
$_prefs['summary_show_requested'] = array(
    'value' => 1,
    'type' => 'checkbox',
    'desc' => _("Show tickets you have requested in the summary view?"),
);

// show ticket ids in the horde summary?
$_prefs['summary_show_ticket_numbers'] = array(
    'value' => 1,
    'type' => 'checkbox',
    'desc' => _("Show ticket IDs in the summary view?"),
);

// Allow custom time/date formats in reports
$_prefs['report_time_format'] = array(
    'value' => '%m/%d/%y',
    'type' => 'enum',
    'enum' => array(
        '%a %d %B' => _("Weekday Day Month"),
        '%c' => _("Weekday Day Month HH:MM:SS TZ"),
        '%m/%d/%y' => _("MM/DD/YY"),
        '%m/%d/%y %H:%M:%S' => _("MM/DD/YY HH:MM:SS"),
        '%d/%m/%y' => _("DD/MM/YY"),
        '%d/%m/%y %H:%M:%S' => _("DD/MM/YY HH:MM:SS"),
        '%y/%m/%d' => _("YY/MM/DD"),
        '%y/%m/%d %H:%M:%S' => _("YY/MM/DD HH:MM:SS"),
    ),
    'desc' => _("Date/Time format for search results"),
);

// Skip notification of changes you added?
$_prefs['email_others_only'] = array(
    'value' => 1,
    'type' => 'checkbox',
    'desc' => _("Only notify me of ticket changes from other users?"),
);

// Skip notification without comments?
$_prefs['email_comments_only'] = array(
    'value' => 0,
    'type' => 'checkbox',
    'desc' => _("Only notify me of ticket changes with comments?")
);

// AutoLink to tickets references in comments
$_prefs['autolink_tickets'] = array(
    'value' => 1,
    'type' => 'checkbox',
    'desc' => _("Autolink to other tickets in comments?")
);

// Show ticket comments in ascending or descending order?
$_prefs['comment_sort_dir'] = array(
    'value' => 1,
    'type' => 'enum',
    'enum' => array(
        0 => _("Chronological (oldest first)"),
        1 => _("Most recent first")
    ),
    'desc' => _("Show comments in chronological order, or most recent
first?")
);

// address book selection widget
$_prefs['sourceselect'] = array(
    'type' => 'special',
    'requires_nolock' => array('search_sources'),
    'handler' => 'Whups_Prefs_Special_Sourceselect'
);

// Address book(s) to use when expanding addresses
// Refer to turba/config/sources.php for possible source values
//
// You can provide default values this way:
//   'value' => json_encode(array('source_one', 'source_two'))

$_prefs['search_sources'] = array(
    'value' => ''
);

// Field(s) to use when expanding addresses
// Refer to turba/config/sources.php for possible source and field values
//
// If you want to provide a default value, this field depends on the
// search_sources preference. For example:
//   'value' => json_encode(array(
//       'source_one' => array('field_one', 'field_two'),
//       'source_two' => array('field_three')
//   ))
// will search the fields 'field_one' and 'field_two' in source_one and
// 'field_three' in source_two.
$_prefs['search_fields'] = array(
    'value' => ''
);

Regards Hanns