Release.rst

Release

Version 18.x.x

Date: <date>

Notes

• Existing installations: update QFQ extension config form-layout.formBsColumns/formBsLabelColumns/formBsInputColumns,formBsNoteColumns. old: 12, new: 'col-md-12 col-lg10' resp. smaller values for individual columnns.
• New config values:
  • Config/flagProduction: yes/now - differentiate between development und production system. Will be used for 'throwExceptionGeneralError' too.
  • Debug/throwExceptionGeneralError - shows/hide exception of general errors.

Features

Bug Fixes

Version 18.12.0

Date: 10.12.2018

Notes

• Config.qfq.php: the variable T3_DB_NAME is not necessary anymore.
• Following SYSTEM_STORE variables renamed. Old: '_dbNameQfq' ,'_dbNameData'. New: 'dbNameQfq' ,'dbNameData'
• New: Bootstrap 'col-lg-10' is defined on every form. On screens greater than 'md' the forms won't be expanded to 100% anymore.

Features

• #3992 / STORE_SYSTEM: dbNameQfq, dbNameData, dbNameT3
• Config.php: read 'dbNameT3' from TYPO3_CONF_VARS or from T3 config file.
• Download.php: get dbNameT3 now from STORE_SYSTEM
• #4906 / Php Session Timeout: can be specified globally in configuration and per form. Affects only logged in FE User.
• #6866 / On logout destroy STORE_USER. Session.php: check if _COOKIE['fe_typo_user'] has changed - yes: clear STORE_USER. Store.php: Rearrange functions.
• #6999 / Bootstrap/Form: define columns for desktop 'col-lg-10'
• #7138 / PDF / single source: deliver without converting
• #7293 / Implement new logging for file upload.
• #7406 / dbinit might contain multiple sql statements now.
• #7407 / MariaDB / Ubuntu 18 complains about missing values if column of type TEXT isn't explicit specified in INSERT. New default for database.init=SET sql_mode = "NO_ENGINE_SUBSTITUTION"
• #7431 / FE.type=afterSave (FE Action): SQL won't report the causing FE.name/id
• #7434 / FE.type=beforeLoad / sqlValidate: Validation message not shown to user
• FormEditor.sql: Switch off 'MySQL strict setting of default values'
• Logger.php: remove UserAgent - that one is logged in FormSubmitLog Table. Add 'cookie' to filter individual actions.
• New css classes for icons: .icon-flipped (mirrors icon), .icon-spin (icon spins once on hover), .icon-spin-reverse (mirror of icon spin).

Bug Fixes

• #7001 / Error message: if 'modeSql' fails, error message does not contain a reference to the causing FE.
• ErrorHandler.php: raise an error as an exception has been stopped in mid 2017 - reactivated now.
• Fix problem in upload elements: a) in exception FE_ID was not reported, b) fillStoreVar was not fired.
• FormAction.php: throw exception if 'fillStoreVar' selects more than one row.

Version 18.10.3

Date: 29.10.2018

Notes

• QFQ now recommends ImageMagick instead of GraphicsMagic, due to much better 'auto orient' (JPEG) capabilities.

Features

• #4901 / Implement 'delete split files' if primary file is deleted (record) or replaced against a new one.
• #4901 / Implement 'fileSplitOptions'.
• #4901 / Implement PDF split based on IM 'convert' (jpeg).
• #7012 / Memory limit for file download - replace file_get_content() by readfile().
• #7112 / fabric: configure default color.
• thumbnail: empty path filename is no ignored, instead of throwing an exception. This is the same behaviour as building links - no definition means 'no link', and not 'error'.
• Refactor chmod(), unlink(), rename(), rmdir(), copy() to use by QFQ version which throws an exception.

Bug Fixes

• #3613 - Revert due to bug in dynamic show/hide (Revision 0bb99fd, Revision 77096ca7) -

Version 18.10.2

Date: 13.10.2018

Features

• #2509 / Render encrypted mailto as single link
• #3281 / Trim form inputs
• #4649 / Add sqlBefore & sqlAfter to sendmail FE, move validate() before sqlBefore()/sqlAfter().
• #4922 / Some minor improvements to the excel import
• #5112 / Add incompatibility warning for encode specialchar and checkType allbut…
• #5450 / MySQL Exception: underline faulty area
• #6596 / uid ExcelExport / PDF
• #6944 / Add double comma SQL Hint

Bug Fixes

• #3529 / No double urldecode() of GET parameters
• #3613 / Label input note layout
• #3850 / Change set input maxlength
• #4545 / After delete: reload page with original parameters
• #4751 / Add bulleted und numbered lists back to tinyMCE Editor
• #4765 / Extend tooltip visibility for checkboxes and radio buttons
• #6911 / Only fire afterInsert on new record (also fix afterUpdate, beforeInsert,…
• #6929 / Treat single file argument like several file argument (savePdf: copy,…

Version 18.10.1

Date: 12.10.2018

Features

• #5578 / Safari only handles one filetype in upload dialog.
• #6991 / Optional process 'readonly' FE during save. New FE parameter 'processReadOnly = 0|1'.

Bug Fixes

• #6880 / Fixed Exceptions with too many details to end user.
• 'Drag and drop' failed due to fillStoreForm requests {{form:S}} which was not necessary for drag and drop.
• Upload: rename 'chmod' to 'chmodFile'. Implement 'chmodDir'. Permissions applied for all new created directories.
• Upload: replace 'rename' with 'copy/unlink'

Version 18.10.0

Date: 04.10.2018

Features

• #6894 / Upload: chmod for file creation.
• #6886 / Upload: Auto Orient - implementation.
• #6721 / Log switching {{feUser:U}} to qfq.log. Log {{feUser:U}} to sql.log.
• #5458 / Add '{{feUser:U}}' to be shown on exception.
• Manual.rst: Fix missing single tick in special column name '_=<var>'
• Report / Variables copied to STORE_USER via "... AS '_=<varname>'" are now available in STORE_RECORD by {{<varname>:R}}

Bug Fixes

• #6902 / Drag and drop in subrecords: expect 1 row got nothing.

Version 18.9.2

Date: 16.09.2018

Notes

• To use the new 'tablesorter' feature, please add 'tablesorter-bootstrap.css', 'jquery.tablesorter.combined.min.js', 'jquery.tablesorter.pager.min.js', 'widget-columnSelector.min.js' in your Typo3 template record. See https://docs.typo3.org/typo3cms/drafts/github/T3DocumentationStarter/Public-Info-053/Manual.html#setup-css-js

  • Existing QFQ installations: update your CSS/JS includes! The new tablesorter jquery plugin might break (JS errors seen on the console) your installation, if it isn't included!

  • If you use the extension 'UZH Corporate Design Template':

    • Update to the latest version 18.9.0.

    • Add constants in the Typo3 template record 'ext: main':

      cd.extra.css.file5 = typo3conf/ext/qfq/Resources/Public/Css/tablesorter-bootstrap.css
      
      cd.extra.js.file10 = typo3conf/ext/qfq/Resources/Public/JavaScript/jquery.tablesorter.combined.min.js
      cd.extra.js.file11 = typo3conf/ext/qfq/Resources/Public/JavaScript/jquery.tablesorter.pager.min.js
      cd.extra.js.file12 = typo3conf/ext/qfq/Resources/Public/JavaScript/widget-columnSelector.min.js

• STORE_USER: check the examples - great new feature to temporary save user settings.

Features

• #6721 / STORE_USER: variables per browser session
• #6690 / Tablesorter for subrecords

Version 18.9.1

Date: 15.09.2018

Notes

• Report
  • Type of nesting delimiter in 'report' now limited to '{', '[', '(', '['
  • Hide/reuse report content later: 10.content=hide and later 1000.head = {{10.content}}
• New Excel import - copy Excel files directly into a DB table.
• Forms with named primary key different than 'id' are now supported.

Features

• #1261 / Tablesorter, incl. saved sort, combined column sort, filters, pagination
• #3129 / suggestion for subrecord title design
• #4922 / Excel import
• #6300 / Disable preview button for requiredNew forms
• #6314 / HTML Mode & sendMailSubjectHtmlEntity for Forms.
• #6481 / Add custom primary key option to Forms.
• #6645 / better error message for incomplete download as link
• #6650 / Report hide content (line) - use later via a variable. First version - problem with enclosed ticks.
• #6653 / Add save button class/glyphicon/tooltip for submit button
• Thesis code correction
• Update QFQ download URL

Bug Fixes

• AbtractBuildForm.php: fix problem with subrecords in MultiDB Environment.
• #2340 / Report: Problematic Bracket - form now on, only ''{[(<'' will change the nesting token.
• #3333 / Fixed subquery recognition in reports '10.sql, 10.1.sql ...'
• #4837 / Don't display hidden pills
• #5467 / Fill Record Store when evaluating min/max parameters
• #6621 / Fix shifted subrecord head
• #6646 / Fix broken extraInfoButton for some FEs

Version 18.9.0

Date: 07.09.2018

Features

• #6357 / Save pdf on server
• #5381 / Stored procedures can be called from QFQ Reports
• #4996 / Log QFQ Update with timestamp.
• #6255 / Inline Report Editing - now with SIP and save.php api

Bug Fixes

• #6465 / Allow newlines in form action queries (e.g. sqlInsert)
• #4654 / Better FE color highlighting (UX)
• #5689 / Default BS Columns for FormElement match Form setting
• #6484 / Download Links mit css class
• #6576 / download buttons are now rendered disabled with render mode r:3
• Cookie Sitepath: wrong detected in case of API calls.

Version 18.8.2

Date: 28.8.18

Features

• #6563 / Accept 0 as required.

Bug Fixes

• DatabaseUpdateData.php: add missed 'on the fly' update for Form.title, changed in FormEditor.sql in 18.8.1
• 6562 / sendmail: redirect all mail - the sender is replaced too.
• Manual.rst: several typos fixed

Version 18.8.1

Date: 26.08.2018

Features

• #4432 / Every 'form submit' will be logged with raw data.
• #4763 / Render vertical text more stable: '... AS _vertical'
• #4996 / Log QFQ Version update
• #5403 / Tooltip on pills are now supported
• #5876 / Subrecord title of column 'Edit' & 'Delete' are now customizable.
• #6249 / Subrecords can now be reordered via drag and drop.
• #6333 / Add to qfq.log: IP Address, User Agent, QFQ Cookie, FE User

Bug Fixes

• #6401 / Handle Backticks in sendmail
• #6452 / Empty form title: no title row will be rendered anymore.

Version 18.8.0

Date: 25.08.2018

Notes

• Excel export
• Copy to clipboard

Features

• #4922 / Excel Export - create Excel sheets from scratch or based on a template.
• #3294 / Improve Typo3 QFQ backend layout. Add sparql syntax highlighting.
• #5878 / Formelement.type=note with #!report - whitespace is trimmed.
• #6314 / HTML Mails enabled by specifying flag 'mode=html'.
• Import/Merge form: A new form 'copyFormFromExt' (see file copyFormFromExt.sql) offers a one click import of external QFQ forms (incl. renumbering of id's).
• formEditor.sql: resized Form.title from 255 to 511 (requested by IK Tool)
• Drag and Drop now offers the possibility to show the renumbered values.
• Manual.rst: security hints, T3 Setup best practice, text input retype, charactercountwrap.
• Config.qfq: central defaults for DATA_MATCH, DATA_ERROR
• Bootstrap QFQ development: switched from bower to npm only.

Bug Fixes

• #5843 / File upload: limitation to file extensions are no case insensitive.
• #6247 / Replace deprecated each function
• #6281 / FormElement / column 'note': token '#!report' - STORE_RECORD does not work.
• #6331 / File Upload: Wrong error message if filesize is much too big.
• #6229 / Add QFQ icon to content element and content element wizard
• AbstractException.php: fixed problem with htmlEntities() on link to 'Edit Form' and 'Edit FormElement'.

Version 18.6.1

Date: 21.06.2018

Notes

• Configuration QFQ: form-config.formDataPatternError. New behaviour: If this field is empty, a more specific default message is shown (instead of one message for all situations). Best is to clear this field.

Features

• sqlHint / Note if a query fails and contains some not replaced variables.
• #4438 / Log attack detected: will be logged now to fileadmin/protected/log/qfq.log.
• #4041 / Subrecord: Spalte 'id' automatisch mit '<span class="text-muted">' wrappen.
• #5885 / show 'sql.log' in FE.
• #6121 / Formular: ID per Default in Titel.

Bug Fixes

• #6283 / Form: hide title frame if empty.
• #4299 / HiddenSelect' into 'master'.
• #6276 / default data-required-error moved to central Config.php.
• #5884 / sql.log by default public - protect against access.
• #6276 / Default check_type messages not shown.
• #6233 / Alert 'Form incomplete' - stays until click - auto disappear would be better.

Version 18.6.0

Date: 13.06.2018

Notes

• config.qfq.ini migrated to config.qfq.php - the old config.qfq.ini get's chmod 000.

• Most of config.qfq.ini migrated to Typo3 / Extension Manager - all but the DB /LDAP credentials.

• Keep in config.qfq.ini:

  # Rename DB credentials from DB_<key> to DB_1_<key>, with key = 'NAME|HOST|USER|PASSWORD'
  DB_1_USER = ...
  DB_1_SERVER = ...
  DB_1_PASSWORD = ...
  DB_1_NAME = ...

• NEW: Drag and drop to sort elements! Check the Manual.

• URL forwardMode

  • client renamed to auto.
  • close added.