Actions
Bug #9355
closedColumn Header in MailLog zu schmal
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() ==================================================
Updated by Carsten Rose over 4 years ago
- Status changed from New to Some day maybe
Updated by Carsten Rose about 3 years ago
- Status changed from Some day maybe to Closed
- % Done changed from 0 to 100
Applied in changeset typo3-qfq|c15a5b4b686160955b4ed6fdbbd3e1b0b4401c30.
Updated by Carsten Rose about 3 years ago
- Assignee set to Carsten Rose
- Target version set to 21.2.0
Actions