Project

General

Profile

Actions

Bug #9355

closed

Column Header in MailLog zu schmal

Added by Nicola Chiapolini over 4 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Carsten Rose
Target version:
Start date:
14.10.2019
Due date:
% Done:

100%

Estimated time:
Discuss:
Prio Planung:
Vote:

Description

Bei einem Mail mit zwei Anhängen sind wir eben an die Zeichengrenze der "Header" Column gestossen (vgl. Unten). Wir haben die Spaltenbreite nun einfach auf 900 erhöht. Damit klappt das Mail. Allerdings wäre es schön, wenn der Logging-Code dieses Problem abfangen und korrekt lösen könnte.

==================================================

UniqId:: 5da449a5027f8
------------------------------------------------
toUser:: SQL error
os:: [ mysqli: 1406 ] Data too long for column 'header' at row 1
Timestamp:: 2019.10.14 12:10:45 +0200
Code:: 2001
Message:: SQL error
Report level key:: 10.12
Type:: Db Exception
SQL final:: INSERT INTO MailLog (`receiver`, `cc`, `bcc`, `sender`, `subject`, `body`, `header`, `attach`, `grId`, `xId`, `xId2`, `xId3`, `src`, `modified`, `created`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW() )
SQL Params:: array (
  0 => 'it-dekanat@mnf.uzh.ch',
  1 => '',
  2 => '',
  3 => 'it-dekanat@mnf.uzh.ch',
  4 => 'Graduation Master',
  5 => 'All QFQ outgoing mails are caught and redirected to you.
Original receiver(s) are ...
TO: baum@example.org
CC: 
BCC: 
SENDER: nicola.chiapolini@mnf.uzh.ch
WEBSITE: https://mnf-32.uzh.ch

==========================================

 Dear Peter Baum

 We have received all required documents from you. Your degree will be validated on 2019-12-13. You will receive a confirmation of your degree by mail within the next few days. 
  Please reserve Friday, 2020-10-05  from 5.00 pm for the graduation ceremony. We look forward to welcoming you and your companions to this event. Two weeks before the ceremony you will receive an invitation email from us. 
 If the final documents are ready for dispatch before the ceremony, we will send them to you by registered mail so that you can apply with the complete documents or present them to your employer as soon as possible. 
 Please do not hesitate to contact us if you have any questions (044 635 40 07) or come and see us during our opening hours (Tuesdays + Thursdays, 09.45 - 12.30 + 13.45 - 16.15  and Wednesdays, 09.45 - 12.00; closed in the afternoons during the lecture-free period). 
 best wishes
 Office of Students Affairs ',
  6 => 'OoO:on
Attachment: 0=0=F:studentadmin/msc/confirmations/msc_uww_confirmation_bama_en_7a2c1ff9e6fce809ab437967c23d9188.pdf&1=d:msc_uww_confirmation_en.pdf&1=0=F:studentadmin/msc/confirmations/msc_uww_confirmation_bama_de_7a2c1ff9e6fce809ab437967c23d9188.pdf&1=d:msc_uww_confirmation_de.pdf',
  7 => '-a /tmp/qfq.temp.T3WJjN/msc_uww_confirmation_en.pdf -a /tmp/qfq.temp.TFzybf/msc_uww_confirmation_de.pdf',
  8 => 0,
  9 => 0,
  10 => 0,
  11 => 0,
  12 => 'Report: T3 pageId=125, T3 ttcontentId=279, Level=10.12',
)
current sip:: array (
  'r' => '0',
  'student' => 'msc_uww',
  's' => '5da423e88ddbf',
  'urlparam' => 'r=0&student=msc_uww',
)
Page Id:: 125
Content Id:: 279
FE User:: hewebe
File:: /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Database/Database.php
Line:: 397
IP Address:: 130.60.23.163
Stacktrace:: 
#0 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Database/Database.php(208): IMATHUZH\Qfq\Core\Database\Database->prepareExecute('INSERT INTO Mai...', Array, '', Array, '')
#1 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/SendMail.php(315): IMATHUZH\Qfq\Core\Database\Database->sql('INSERT INTO Mai...', 'regular', Array)
#2 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/SendMail.php(100): IMATHUZH\Qfq\Core\Report\SendMail->mailLog(Array, '-a /tmp/qfq.tem...')
#3 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/Report.php(1083): IMATHUZH\Qfq\Core\Report\SendMail->process(Array)
#4 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/Report.php(799): IMATHUZH\Qfq\Core\Report\Report->renderColumn(0, 'sendmail', 'to:baum@example...', '10.12', 1, true)
#5 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/Report.php(566): IMATHUZH\Qfq\Core\Report\Report->collectRow(Array, Array, '10.12', 1, Array)
#6 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/Report.php(572): IMATHUZH\Qfq\Core\Report\Report->triggerReport(2, Array, 2)
#7 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/Report/Report.php(243): IMATHUZH\Qfq\Core\Report\Report->triggerReport()
#8 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/QuickFormQuery.php(1624): IMATHUZH\Qfq\Core\Report\Report->process('5.sql =   SELEC...')
#9 /var/www/htdocs/typo3conf/ext/qfq/Classes/Core/QuickFormQuery.php(248): IMATHUZH\Qfq\Core\QuickFormQuery->doReport()
#10 /var/www/htdocs/typo3conf/ext/qfq/Classes/Controller/QfqController.php(43): IMATHUZH\Qfq\Core\QuickFormQuery->process()
==================================================
Actions #1

Updated by Carsten Rose over 4 years ago

  • Status changed from New to Some day maybe
Actions #2

Updated by Carsten Rose about 3 years ago

  • Status changed from Some day maybe to Closed
  • % Done changed from 0 to 100
Actions #3

Updated by Carsten Rose about 3 years ago

  • Assignee set to Carsten Rose
  • Target version set to 21.2.0
Actions

Also available in: Atom PDF