[horde] Unable to attach files in Whups
Daniel Bareiro
daniel-listas at gmx.net
Wed Jan 7 12:40:27 UTC 2015
Hi, Jan.
Thanks for your reply.
On 07/01/15 08:46, Jan Schneider wrote:
>>> This is my first message in the list. Several months ago I decided to
>>> use Horde with Whups for my own entrepreneurship.
>>>
>>> Yesterday I opened a new ticket where some of the updates had
>>> attachments (26 in total, some files of several megabytes).
>>>
>>> Since that moment, new updates including attachments were published with
>>> text but not the files. The same happened if I update the ticket with an
>>> attachment but no text.
>>>
>>> What could be causing this behavior? Does Whups handle some kind of
>>> quota for files of each ticket?
>>
>> After this problem, I opened a new ticket and found that here either I
>> can add attachments so it seems to be a more general problem which
>> affecting not only the previous ticket.
> Check log files. Could be a limitation of your PHP configuration, web
> server configuration, or VFS backend configuration.
I was reviewing the logs of the Apache server. The error log has no
records when I try to add an attachment. The access log adds entries
when I send the information on the form but no evidencing some kind of
problem. Bellow I copy this log:
------------------------------------------------------------------------
10.1.0.40 - - [07/Jan/2015:09:18:31 -0300] "POST
/whups/ticket/update.php HTTP/1.1" 302 684
"https://webmail.opcion-libre.com.ar/whups/ticket/update.php?id=36"
"Mozilla/5.0 (X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0
Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:36 -0300] "GET /whups/ticket/?id=36
HTTP/1.1" 200 6082
"https://webmail.opcion-libre.com.ar/whups/ticket/update.php?id=36"
"Mozilla/5.0 (X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0
Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/sidebar.js?v=be5cf1c9 HTTP/1.1" 304 221
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/prototype.js?v=be5cf1c9 HTTP/1.1" 200 41737
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET /js/horde.js?v=be5cf1c9
HTTP/1.1" 200 2830
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/date/es-ES.js?v=be5cf1c9 HTTP/1.1" 200 2912
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/accesskeys.js?v=be5cf1c9 HTTP/1.1" 200 1451
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/hordecore.js?v=be5cf1c9 HTTP/1.1" 200 6640
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET /js/topbar.js?v=be5cf1c9
HTTP/1.1" 200 1594
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/growler.js?v=be5cf1c9 HTTP/1.1" 200 2990
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/scriptaculous/sound.js?v=be5cf1c9 HTTP/1.1" 200 1423
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET /js/popup.js?v=be5cf1c9
HTTP/1.1" 200 1675
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/form_ghost.js?v=be5cf1c9 HTTP/1.1" 200 2017
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/date/date.js?v=be5cf1c9 HTTP/1.1" 200 18293
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/scriptaculous/effects.js?v=be5cf1c9 HTTP/1.1" 200 9206
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
10.1.0.40 - - [07/Jan/2015:09:18:37 -0300] "GET
/js/toggle_quotes.js?v=be5cf1c9 HTTP/1.1" 200 950
"https://webmail.opcion-libre.com.ar/whups/ticket/?id=36" "Mozilla/5.0
(X11; Linux x86_64; rv:34.0) Gecko/20100101 Firefox/34.0 Iceweasel/34.0"
------------------------------------------------------------------------
I also put the Horde log in debug mode making the following change in
the file config/conf.php:
$conf['log']['priority'] = 'DEBUG';
When I send the information on the form, This is the log (filter only
Whups entries) - I see some errors in PHP declarations, but not sure
that this has to do with the problem I am having:
------------------------------------------------------------------------
Jan 7 09:26:31 mail HORDE: [whups] Load config file (conf.php; app:
whups) [pid 31577 on line 109 of
"/usr/share/php/Horde/Registry/Loadconfig.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
whups_tickets.ticket_id AS id, whups_tickets.ticket_summary AS#012#011
summary, whups_tickets.user_id_requester, whups_tickets.state_id
AS#012#011 state, whups_tickets.type_id AS type,
whups_tickets.priority_id AS#012#011 priority, whups_tickets.queue_id
AS queue, whups_tickets.date_updated,#012#011
whups_tickets.date_assigned, whups_tickets.date_resolved,#012#011
whups_tickets.version_id AS version, whups_tickets.ticket_timestamp
AS#012#011 timestamp, whups_tickets.ticket_due AS due,
whups_types.type_name AS#012#011 type_name, whups_states.state_name AS
state_name,#012#011 whups_states.state_category AS
state_category,#012#011 whups_priorities.priority_name AS
priority_name,#012#011 whups_versions.version_name AS
version_name,#012#011 whups_versions.version_description AS
version_description,#012#011 whups_versions.version_active AS
version_active,#012#011 whups_queues.queue_name AS queue_name FROM
whups_tickets INNER JOIN#012#011 whups_types ON whups_tickets.type_id =
whups_types.type_id INNER JOIN#012#011 whups_states ON
whups_tickets.state_id = whups_states.state_id INNER#012#011 JOIN
whups_priorities ON whups_tickets.priority_id =#012#011
whups_priorities.priority_id INNER JOIN whups_states state2 ON#012#011
whups_tickets.type_id = state2.type_id LEFT JOIN whups_versions
ON#012#011 whups_tickets.version_id = whups_versions.version_id INNER
JOIN#012#011 whups_queues ON whups_tickets.queue_id =
whups_queues.queue_id WHERE#012#011 (whups_tickets.ticket_id = '36')
GROUP BY whups_tickets.ticket_id,#012#011 whups_tickets.ticket_summary,
whups_tickets.user_id_requester,#012#011 whups_tickets.state_id,
whups_tickets.type_id,#012#011 whups_tickets.priority_id,
whups_tickets.queue_id,#012#011 whups_tickets.ticket_timestamp,
whups_tickets.ticket_due,#012#011 whups_tickets.date_updated,
whups_tickets.date_assigned,#012#011 whups_tickets.date_resolved,
whups_types.type_name,#012#011 whups_states.state_name, whups_states.state
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
guest_email FROM whups_guests WHERE guest_id = '-36' [pid 31577 on line
208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0003s) #012#011SELECT
ticket_id AS id, ticket_owner AS owner FROM whups_ticket_owners#012#011
WHERE ticket_id IN (36) [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
ticket_id AS id, d.attribute_name, a.attribute_id,#012#011
a.attribute_value FROM whups_attributes a INNER JOIN#012#011
whups_attributes_desc d ON (d.attribute_id =
a.attribute_id)WHERE#012#011 a.ticket_id IN (36) [pid 31577 on line 208
of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
queue_id, queue_name FROM whups_queues ORDER BY queue_name [pid 31577 on
line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_pgp::init() should be compatible with
Horde_Form_Type_longtext::init($rows = 8, $cols = 80, $helper = Array)
[pid 31577 on line 863 of "/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_image::onSubmit() should be compatible with
Horde_Form_Type::onSubmit() [pid 31577 on line 1346 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_link::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 1423 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_matrix::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2147 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_enum::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2317 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_mlenum::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2393 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_mlenum::onSubmit() should be compatible with
Horde_Form_Type::onSubmit() [pid 31577 on line 2393 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_set::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2551 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_sorter::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3366 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_selectfiles::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3436 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_assign::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3566 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_assign::getValues() should be compatible with
Horde_Form_Type::getValues() [pid 31577 on line 3566 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_dblookup::init() should be compatible with
Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 31577 on line
3717 of "/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_figlet::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3770 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_invalid::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3839 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_country::init() should be compatible with
Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 31577 on line
908 of "/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Declaration of
Whups_Form_Ticket_Edit::validate() should be compatible with
Horde_Form::validate($vars = NULL, $canAutoFill = false) [pid 31577 on
line 9 of "/space/www/horde/whups/lib/Form/Ticket/Edit.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0004s) #012#011SELECT
queue_id, queue_name, queue_description, queue_versioned,#012#011
queue_slug, queue_email FROM whups_queues WHERE queue_id = 4 [pid 31577
on line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
d.attribute_id, d.attribute_name, d.attribute_description,#012#011
d.attribute_type, d.attribute_params, d.attribute_required,#012#011
a.attribute_value FROM whups_attributes_desc d LEFT JOIN
whups_tickets#012#011 t ON (t.ticket_id = '36') LEFT OUTER JOIN
whups_attributes a ON#012#011 (d.attribute_id = a.attribute_id AND
a.ticket_id = '36') WHERE#012#011 d.type_id = t.type_id ORDER BY
d.attribute_name [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
state_id, state_name FROM whups_states WHERE type_id = 25 ORDER#012#011
BY state_category, state_name [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
priority_id, priority_name FROM whups_priorities WHERE type_id#012#011
= 25 ORDER BY priority_name [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
g.group_uid AS group_uid, g.group_name AS group_name FROM#012#011
horde_groups g, horde_groups_members m WHERE m.user_uid =
'dbareiro'#012#011 AND g.group_uid = m.group_uid ORDER BY g.group_name
[pid 31577 on line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
user_uid FROM whups_queues_users WHERE queue_id = 4 ORDER BY#012#011
user_uid [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] Load config file (prefs.php; app:
whups) [pid 31577 on line 109 of
"/usr/share/php/Horde/Registry/Loadconfig.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
pref_name, pref_value FROM horde_prefs WHERE pref_uid =#012#011
'dblanco' AND pref_scope = 'whups' [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] Load config file (nls.php; app:
horde) [pid 31577 on line 109 of
"/usr/share/php/Horde/Registry/Loadconfig.php"]
Jan 7 09:26:31 mail HORDE: [whups] Load config file (prefs.php; app:
horde) [pid 31577 on line 109 of
"/usr/share/php/Horde/Registry/Loadconfig.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
pref_name, pref_value FROM horde_prefs WHERE pref_uid =#012#011
'dblanco' AND pref_scope = 'horde' [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0003s) #012#011SELECT
pref_name, pref_value FROM horde_prefs WHERE pref_uid =#012#011
'fmaggi' AND pref_scope = 'whups' [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
pref_name, pref_value FROM horde_prefs WHERE pref_uid =#012#011
'fmaggi' AND pref_scope = 'horde' [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] PHP ERROR: Only variables should be
assigned by reference [pid 31577 on line 145 of
"/space/www/horde/whups/lib/Form/Ticket/Edit.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
reply_id, reply_name, reply_text FROM whups_replies WHERE#012#011
type_id = 25 ORDER BY reply_name [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
g.group_uid AS group_uid, g.group_name AS group_name FROM#012#011
horde_groups g, horde_groups_members m WHERE m.user_uid =
'dbareiro'#012#011 AND g.group_uid = m.group_uid ORDER BY g.group_name
[pid 31577 on line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0005s) #012#011DELETE FROM
horde_tokens WHERE token_timestamp < 1420547191 [pid 31577 on line 208
of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,0004s) #012#011SELECT
token_id FROM horde_tokens WHERE token_address = 'MTAuMS4wLjQw'#012#011
AND token_id = '1C_eWl9ojWhypPN2QxJnzzDQPw4' [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] SQL (0,1919s) #012#011INSERT INTO
horde_tokens (token_address, token_id, token_timestamp)#012#011 VALUES
('MTAuMS4wLjQw', '1C_eWl9ojWhypPN2QxJnzzDQPw4', 1420633591) [pid 31577
on line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:31 mail HORDE: [whups] Max memory usage: 17825792 bytes
[pid 31577 on line 618 of "/usr/share/php/Horde/Registry.php"]
Jan 7 09:26:31 mail HORDE: [whups] Load config file (conf.php; app:
whups) [pid 31577 on line 109 of
"/usr/share/php/Horde/Registry/Loadconfig.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
whups_tickets.ticket_id AS id, whups_tickets.ticket_summary AS#012#011
summary, whups_tickets.user_id_requester, whups_tickets.state_id
AS#012#011 state, whups_tickets.type_id AS type,
whups_tickets.priority_id AS#012#011 priority, whups_tickets.queue_id
AS queue, whups_tickets.date_updated,#012#011
whups_tickets.date_assigned, whups_tickets.date_resolved,#012#011
whups_tickets.version_id AS version, whups_tickets.ticket_timestamp
AS#012#011 timestamp, whups_tickets.ticket_due AS due,
whups_types.type_name AS#012#011 type_name, whups_states.state_name AS
state_name,#012#011 whups_states.state_category AS
state_category,#012#011 whups_priorities.priority_name AS
priority_name,#012#011 whups_versions.version_name AS
version_name,#012#011 whups_versions.version_description AS
version_description,#012#011 whups_versions.version_active AS
version_active,#012#011 whups_queues.queue_name AS queue_name FROM
whups_tickets INNER JOIN#012#011 whups_types ON whups_tickets.type_id =
whups_types.type_id INNER JOIN#012#011 whups_states ON
whups_tickets.state_id = whups_states.state_id INNER#012#011 JOIN
whups_priorities ON whups_tickets.priority_id =#012#011
whups_priorities.priority_id INNER JOIN whups_states state2 ON#012#011
whups_tickets.type_id = state2.type_id LEFT JOIN whups_versions
ON#012#011 whups_tickets.version_id = whups_versions.version_id INNER
JOIN#012#011 whups_queues ON whups_tickets.queue_id =
whups_queues.queue_id WHERE#012#011 (whups_tickets.ticket_id = '36')
GROUP BY whups_tickets.ticket_id,#012#011 whups_tickets.ticket_summary,
whups_tickets.user_id_requester,#012#011 whups_tickets.state_id,
whups_tickets.type_id,#012#011 whups_tickets.priority_id,
whups_tickets.queue_id,#012#011 whups_tickets.ticket_timestamp,
whups_tickets.ticket_due,#012#011 whups_tickets.date_updated,
whups_tickets.date_assigned,#012#011 whups_tickets.date_resolved,
whups_types.type_name,#012#011 whups_states.state_name, whups_states.state
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
guest_email FROM whups_guests WHERE guest_id = '-36' [pid 31577 on line
208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
ticket_id AS id, ticket_owner AS owner FROM whups_ticket_owners#012#011
WHERE ticket_id IN (36) [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
ticket_id AS id, d.attribute_name, a.attribute_id,#012#011
a.attribute_value FROM whups_attributes a INNER JOIN#012#011
whups_attributes_desc d ON (d.attribute_id =
a.attribute_id)WHERE#012#011 a.ticket_id IN (36) [pid 31577 on line 208
of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
queue_id, queue_name FROM whups_queues ORDER BY queue_name [pid 31577 on
line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
ticket_id as id, ticket_owner as owner FROM whups_ticket_owners#012#011
WHERE ticket_id = 36 [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0008s) #012#011SELECT
alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,#012#011
alarm_params, alarm_title, alarm_text, alarm_snooze,
alarm_internal#012#011 FROM horde_alarms WHERE alarm_dismissed = 0 AND
((alarm_snooze IS NULL#012#011 AND alarm_start <= '2015-01-07
12:26:32') OR alarm_snooze <=#012#011 '2015-01-07 12:26:32') AND
(alarm_end IS NULL OR alarm_end >=#012#011 '2015-01-07 12:26:32') AND
(alarm_uid IS NULL OR alarm_uid = '' OR#012#011 alarm_uid = 'dbareiro')
ORDER BY alarm_start, alarm_end [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0003s) #012#011SELECT
whups_tickets.ticket_id AS id, whups_tickets.ticket_summary AS#012#011
summary, whups_tickets.user_id_requester, whups_tickets.state_id
AS#012#011 state, whups_tickets.type_id AS type,
whups_tickets.priority_id AS#012#011 priority, whups_tickets.queue_id
AS queue, whups_tickets.date_updated,#012#011
whups_tickets.date_assigned, whups_tickets.date_resolved,#012#011
whups_tickets.version_id AS version, whups_tickets.ticket_timestamp
AS#012#011 timestamp, whups_tickets.ticket_due AS due,
whups_types.type_name AS#012#011 type_name, whups_states.state_name AS
state_name,#012#011 whups_states.state_category AS
state_category,#012#011 whups_priorities.priority_name AS
priority_name,#012#011 whups_versions.version_name AS
version_name,#012#011 whups_versions.version_description AS
version_description,#012#011 whups_versions.version_active AS
version_active,#012#011 whups_queues.queue_name AS queue_name FROM
whups_tickets INNER JOIN#012#011 whups_types ON whups_tickets.type_id =
whups_types.type_id INNER JOIN#012#011 whups_states ON
whups_tickets.state_id = whups_states.state_id INNER#012#011 JOIN
whups_priorities ON whups_tickets.priority_id =#012#011
whups_priorities.priority_id INNER JOIN whups_states state2 ON#012#011
whups_tickets.type_id = state2.type_id LEFT JOIN whups_versions
ON#012#011 whups_tickets.version_id = whups_versions.version_id INNER
JOIN#012#011 whups_queues ON whups_tickets.queue_id =
whups_queues.queue_id WHERE#012#011 (whups_tickets.ticket_id = '36')
GROUP BY whups_tickets.ticket_id,#012#011 whups_tickets.ticket_summary,
whups_tickets.user_id_requester,#012#011 whups_tickets.state_id,
whups_tickets.type_id,#012#011 whups_tickets.priority_id,
whups_tickets.queue_id,#012#011 whups_tickets.ticket_timestamp,
whups_tickets.ticket_due,#012#011 whups_tickets.date_updated,
whups_tickets.date_assigned,#012#011 whups_tickets.date_resolved,
whups_types.type_name,#012#011 whups_states.state_name, whups_states.state
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
ticket_id AS id, ticket_owner AS owner FROM whups_ticket_owners#012#011
WHERE ticket_id IN (36) [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
ticket_id AS id, d.attribute_name, a.attribute_id,#012#011
a.attribute_value FROM whups_attributes a INNER JOIN#012#011
whups_attributes_desc d ON (d.attribute_id =
a.attribute_id)WHERE#012#011 a.ticket_id IN (36) [pid 31577 on line 208
of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_pgp::init() should be compatible with
Horde_Form_Type_longtext::init($rows = 8, $cols = 80, $helper = Array)
[pid 31577 on line 863 of "/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_image::onSubmit() should be compatible with
Horde_Form_Type::onSubmit() [pid 31577 on line 1346 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_link::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 1423 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_matrix::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2147 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_enum::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2317 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_mlenum::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2393 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_mlenum::onSubmit() should be compatible with
Horde_Form_Type::onSubmit() [pid 31577 on line 2393 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_set::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 2551 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_sorter::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3366 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_selectfiles::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3436 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_assign::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3566 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_assign::getValues() should be compatible with
Horde_Form_Type::getValues() [pid 31577 on line 3566 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_dblookup::init() should be compatible with
Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 31577 on line
3717 of "/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_figlet::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3770 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_invalid::init() should be compatible with
Horde_Form_Type::init() [pid 31577 on line 3839 of
"/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] PHP ERROR: Declaration of
Horde_Form_Type_country::init() should be compatible with
Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 31577 on line
908 of "/usr/share/php/Horde/Form/Type.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
d.attribute_id, d.attribute_name, d.attribute_description,#012#011
d.attribute_type, d.attribute_params, d.attribute_required,#012#011
a.attribute_value FROM whups_attributes_desc d LEFT JOIN
whups_tickets#012#011 t ON (t.ticket_id = '36') LEFT OUTER JOIN
whups_attributes a ON#012#011 (d.attribute_id = a.attribute_id AND
a.ticket_id = '36') WHERE#012#011 d.type_id = t.type_id ORDER BY
d.attribute_name [pid 31577 on line 208 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0003s) #012#011SELECT
whups_comments.comment_text,#012#011
whups_transactions.transaction_timestamp AS timestamp,#012#011
whups_logs.ticket_id, whups_logs.log_type, whups_logs.log_value,#012#011
whups_logs.log_value_num, whups_logs.log_id,#012#011
whups_logs.transaction_id,
whups_transactions.transaction_user_id#012#011 user_id,
whups_priorities.priority_name, whups_states.state_name,#012#011
whups_versions.version_name, whups_types.type_name,#012#011
whups_attributes_desc.attribute_name FROM whups_logs LEFT JOIN#012#011
whups_comments ON whups_logs.log_type = 'comment' AND#012#011
whups_logs.log_value_num = whups_comments.comment_id LEFT JOIN#012#011
whups_versions ON whups_logs.log_type = 'version' AND#012#011
whups_logs.log_value_num = whups_versions.version_id LEFT JOIN#012#011
whups_states ON whups_logs.log_type = 'state' AND#012#011
whups_logs.log_value_num = whups_states.state_id LEFT JOIN#012#011
whups_priorities ON whups_logs.log_type = 'priority' AND#012#011
whups_logs.log_value_num = whups_priorities.priority_id LEFT
JOIN#012#011 whups_types ON whups_logs.log_type = 'type' AND#012#011
whups_logs.log_value_num = whups_types.type_id LEFT JOIN#012#011
whups_attributes_desc ON whups_logs.log_type = 'attribute' AND#012#011
whups_logs.log_value_num = whups_attributes_desc.attribute_id
LEFT#012#011 JOIN whups_transactions ON whups_logs.transaction_id
=#012#011 whups_transactions.transaction_id WHERE whups_logs.ticket_id
= 36#012#011 ORDER BY whups_logs.transaction_id [pid 31577 on line 208
of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0003s) #012#011SELECT
queue_id, queue_name, queue_description, queue_versioned,#012#011
queue_slug, queue_email FROM whups_queues WHERE queue_id = 4 [pid 31577
on line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] SQL (0,0002s) #012#011SELECT
attribute_id, attribute_name, attribute_description,#012#011
attribute_type, attribute_params, attribute_required FROM#012#011
whups_attributes_desc WHERE type_id = 25 ORDER BY attribute_name [pid
31577 on line 208 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
Jan 7 09:26:32 mail HORDE: [whups] Max memory usage: 19398656 bytes
[pid 31577 on line 618 of "/usr/share/php/Horde/Registry.php"]
------------------------------------------------------------------------
Thanks again for your answer.
Best regards,
Daniel
More information about the horde
mailing list