CHANGELOG.md



To find the state of this project's repository at the time of any of these versions, check out the tags.


.. ================================================== .. ================================================== ..
================================================== .. Header hierarchy .. == .. -- .. ^^ ..    ""
.. ;; .. ,, .. .. --------------------------------------------used to the update the records specified ------ .. Best
Practice T3 reST: https://docs.typo3.org/m/typo3/docs-how-to-document/master/en-us/WritingReST/CheatSheet.html
.. Reference: https://docs.typo3.org/m/typo3/docs-how-to-document/master/en-us/WritingReST/Index.html
.. Italic italic
.. Bold bold
.. Code text
.. External Links: Bootstrap <http://getbootstrap.com/>_
.. Internal Link: :ref:downloadButton (default url text) or :ref:download Button<downloadButton> (explicit url text)
.. Add Images:    .. image:: ../Images/a4.jpg .. .. .. Admonitions .. .. note::   .. important::     .. tip::     ..
warning::
.. Color:   (blue)       (orange)           (green)      (red)
.. .. Definition:
.. some text becomes strong (only one line)
.. description has to indented
.. -- coding: utf-8 -- with BOM.
.. include:: Includes.txt
.. _release:

Release

Version 22.x.x
Date: 
Notes ^^^^^
Features ^^^^^^^^
Bug Fixes ^^^^^^^^^

Version 22.9.2
Date: 22.09.2022
Features ^^^^^^^^


12630 / dateTimePicker refactored. Mode: 'qfq', 'browser', 'no'. Default: 'qfq'

Add release notes to update UZH CD to latest version and to remove QFQ JS/CSS includes from custom typoscript
template.


Version 22.9.1
Date: 18.09.2022
Notes ^^^^^
In 22.5.0 CodeMirror has been implemented for Report editing in the front end. QFQ delivers now the minimized Javascript
version too. Please check http://docs.qfq.io/en/master/Installation.html#setup-css-js for updated JS includes.
T3 extension 'UZH_CD' should be updated to latest version >=22.09.18!
Attention: since 22.09.07 UZH_CD includes all JS/CSS (exception: fabric). Remove all QFQ standard JS/CSS includes like
datetimepicker, codemirror, ... from your typoscript template(s).
Features ^^^^^^^^


14616 / Fabric updated to version 5. Annotation of images should now be supported again by modern browsers.


10012 / RedirectAllMailto: optionally dynamically set by current logged in FE or BE User.


14718 / Added prepared MySQL statement: QLEFT(), QRIGHT().


14635 / Add comment to update /etc/ImageMagick-6/policy.xml in case of 'convert-im6.q16: no images defined'.


9052 / Report: CodeMirror with SQL Syntax Highlight in FE - minimized JS versions.


T3 QFQ extension config: change 'enter-as-submit' from string to boolean.


Bug Fixes ^^^^^^^^^


12452 / T3 QFQ extension setup: Fixes broken string in doc for 'baseUrl'.


Version 22.9.0
Date: 04.09.2022
Features ^^^^^^^^

Report.rst: Add description details to tablesorter view saver. Fix Typo QESC_SQUOTE.

Bug Fixes ^^^^^^^^^


14660 / Tablesorter View Saver: Broken in Multi-DB Setup


14622 / Temp workaround for broken exception - Encrypt/Decrypt detection.


Version 22.8.1
Date: 28.08.2022
Features ^^^^^^^^


9221 / If FE_TYPEAHEAD_LDAP or FE_TYPEAHEAD_SQL is set, skip forcing maxlength to table column definition. Instead
use custom supplied value.
Minor update form 'FormElement'
Refactor $buildElementFunctionName: remove indirect function calls from AbtractBuildForm.php to simplify debugging.
Extend Support::getColumnSize with further MariaDB column type sizes
Extension config description baseUrl: updated.

Bug Fixes ^^^^^^^^^


14618 / string expected, null given.


14611 / MultiDB: broken 'show table definition' in FormEditor. Add pill 'Table Definition' to form FormElement.


14590 / emptyTypeAheadRequest'.


9281 / QFQ system tables: Allow STRICT_TRANS_TABLES - Default '0' is now set for all INT columns. DB-Update will
change column definition. TEXT columns still don't have a default: Before MariaDB 10.2.1, BLOB and TEXT columns could
not be assigned a DEFAULT value. This restriction was lifted in MariaDB 10.2.1.
Removed empty typeahead request at the beginning


Version 22.8.0
Date: 22.08.2022
Notes ^^^^^

Add Enis Nuredini as developer.

Features ^^^^^^^^


11262 / stored Procedure: QNBSP - replace space by ' '.


14270 / FormEditor: add pill 'Table Definition'.


14321 / Remember last used pill: on/off via QFQ config or per form.


14588 / FormEditor: Remove bell for debugging Form/Session mode.

FormEditor: Column fe.mode shows now fe.modeSql by default. If empty, fe.mode will be shown.
QFQ_Encrypt_Decrypt - pre version - not finalized.

Bug Fixes ^^^^^^^^^


4018 / Typeahead Attack Detected: Implement renamed keywords _ta_query, _ta_prefetch. Fix broken detection of typeahead mode.


13689 / Enter auf Eingabefeld mit ungültigem Wert führt zu blurry Seite.


14288 / Upload: removed upload + save > triggers general error.


14291 / Doc minor fix: Upload Doku table broken.


14292 / Upload: mode=required broken for advanced upload (non primary column) after first save.


14302 / Doc minor fix. SanitizeTest.php: minor const replacement.


14587 / Use case: Self Registration - table definiton broken in doc: Changed Table Person, to include index and
auto increment + authExpire default Null.
SYSTEM_SECURITY_GET_MAX_LENGTH: take care that minimum is 32.
Update Release.rst and Installation.rst: add missing Codemirror.css|js
RestClient undefined array element fix.


Version 22.5.0
Date: 16.5.2022
Notes ^^^^^
Please update your CSS and JS (T3 Main Template > Setup) to include the new DateTime Picker. Forms cannot save if the JS
files are missing::
page.includeCSS.file08 = typo3conf/ext/qfq/Resources/Public/Css/bootstrap-datetimepicker.min.css page.includeCSS.file09
= typo3conf/ext/qfq/Resources/Public/Css/codemirror.css page.includeJS.file14 =
typo3conf/ext/qfq/Resources/Public/JavaScript/moment.min.js page.includeJS.file15 =
typo3conf/ext/qfq/Resources/Public/JavaScript/bootstrap-datetimepicker.min.js page.includeJS.file16 =
typo3conf/ext/qfq/Resources/Public/JavaScript/codemirror.min.js page.includeJS.file17 =
typo3conf/ext/qfq/Resources/Public/JavaScript/code-mirror-mode/sql/sql.min.js
Features ^^^^^^^^


9052 / Report frontend editing: CodeMirror with syntax highlight.


10096 / Date time picker.


10782 / TinyMCE: image upload via drag'n'drop. 'fileUploadPath=fileadmin/...'.


13440 / Form: remember last used pill in localstore.


13543 / System - base url: multiple base url can be configured.


13562 / System - base url: if not set, set base url.


13572 / Form Load: better error message on try to load non existent record.


13581 / Copy to clipboard: small animation on icon.


13657 / Added two new twig report files to system: FormEditorTwig and autoCronTwig.


13679 / tablesorter/subrecord: view-saver added.


13788 / Date time picker: selectable weekdays.

Update / doc: datetimepicker requires moment.js - put it in example code before datetimepicker.
Update / QFQ config note to baseUrl.
Skip selenium to speed up.
Move Marc Egger to further contributor.

Bug Fixes ^^^^^^^^^


9520 / Button Save inside form.


10646 / typeAhead: maxLength by default 512.


11134 / Set samesite header for cookies.


11325 / SQL CALL is handled seperate. All statements will execute. If only a SELECT statement is used in PROCEDURE then the output will shown, otherwise not.


13658 / qfq.json: remove world readable.


12483 / qfq.json - Doc: update all references of config.qfq.php to qfq.json


12484 / config.render: old Both, new: Single.


13084,9724 / Dropdown list on iOS not clickable.


13527 / Form Multi: by default set r=0.


13677 / FormEditor: Preview disabled if 'new.required' is given.


13722 / Detect and fix pdfunite problems "Gen inside xref table too large (bigger than INT_MAX)" via pdf2ps, ps2pdf.


13767 / Date time picker: up down button better design if required.


13827 / Date time picker should not offer user credentials (like username / password).


13751 / Date time picker dynamic update aware.


13797 / Checkbox: dynamic update (single and multi) fixed.


13818 / typeahead: fix for key/value problem: expects parameter 1 to be string, array given.


13842 / Broken SIP: wkhtml and qfqpdf.


13933 / Broken SIP: exception handling buggy.


13860 / Safari: broken typeahead input.


Version 21.12.0
Date: 13.12.2021
Notes ^^^^^


New HTML to PDF renderer: puppeteer. Wrapped and used by qfqpdf. Solves various JS and CSS problems of wkhtml.
Install:
mkdir /opt/qfqpdf; cd /opt/qfqpdf curl -L -o qfqpdf https://www.math.uzh.ch/repo/qfqpdf/current/qfqpdf-linux
chmod a+x qfqpdf


Module php-curl not needed anymore - has been replaced by php-stream.


Features ^^^^^^^^


4812 / Subrecord - check for reserved Typo3 keywords (id, type, L) and throw exception.


10145 / Typeahead Min Length = 0 is now possible.


10715 / qfqpdf (puppeteer).


13113 / Rewrite REST Client as php stream, add contentFile option.


13242 / Apply given sanitize class to all defined stores.


13330 / Multi Form: Upload.


13333 / Option: Switch off attack detect.


13496 / TinyMCEfontselect - Fontselect and fontsize are removed from the default configuration.


12511 / Typo3 Store: new variables.


13526 / QFQ tablesorter: Rename 'private view' to 'personal view' and 'public view' to 'group view'.


12541 / Page and link without pageAlias.


Bug Fixes ^^^^^^^^^


3446 / Unknown permission mode: 'logged_in'


9268 / SELECT with outer brackets not recognized as SELECT


13030 / Max length cuts - line endings \r\n has been counted as two chars. During input they are counted as 1 and
therefore on data load the string has been cutted.


13139 / Tablesorter: some elements are in front of a sticky title row


13507 / QFQ function should work without 'sql='


13525 / makefile adjusted for multiple users


Version 21.6.0
Date: 29.6.2021
Notes ^^^^^

For full image HEIC/HEIF support, please install package libheif-examples.

Features ^^^^^^^^


8945 / Best practice self-registration_


12551 / Add QFQ bootstrap diagram


12615 / Implements silent HEIC/HEIF conversion to png.


12636 / New FormElement.encoding = 'single tick'

Form.rst: Update doc of Multi-Form

Bug Fixes ^^^^^^^^^


12701 / Bug 'spaces in mails'. Replaces '
' by '
\r\n'


9371 / MultiSQL now accepts _id too.


12674 / QFQ Function subheader: skip deleted

Remove keySemId and keySemIdUser - outdated / deprecated since 0.19.0 (pre 09.2017)
Download.php: Fix broken variable this->downloadDebugLog.


Version 21.5.1