webTareas / News: Recent posts

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: PHP Warning: Undefined array key "" in /var/www/html/forms/exportforms.php on line 764
• BUG FIXED: PHP Warning: pg_query_params(): Query failed: ERROR: invalid input syntax for type integer in /var/www/html/includes/request.class-dbspec.pg.php on line 164
• BUG FIXED: PHP Warning: pg_query_params(): Query failed: ERROR: operator does not exist: integer = character varying in /var/www/html/includes/request.class-dbspec.pg.php on line 164
• CHANGED: wrap section report query text in a CDATA section when exporting report definitions
• CHANGED: wrap section user query to launch approval procedure in a CDATA when exporting approval templates
• CHAGNED: report output to show the form ID as a hyperlink rather than plain text
• CHAGNED: view form to show form description first field rather than full form descript in the breadcrumbs... read more

Docker image luiswangtaiwan/webtareas has ARM(linux/arm64) support now.

https://hub.docker.com/r/luiswangtaiwan/webtareas

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: sql error: Unknown column 'cae.reminder_timer1' in 'WHERE'(1054)
• BUG FIXED: stderr is missing in log files for all cronjobs
• BUG FIXED: valid value for date format/time format 'system default' missing in add/edit user webpage
• BUG FIXED: hour_code.min.js:2 Uncaught TypeError: Cannot read properties of undefined (reading 'action')
• BUG FIXED: unable to delete equipment usage
• BUG FIXED: Query failed: ERROR: syntax error in processdocument.php
• BUG FIXED: unable to use a currency field as condition in createreport.php
• BUG FIXED: forms exporting incompletely if the form conatians list field with linked table
• BUG FIXED: vulnerability scanner flagging a missing HttpOnly/Secure/SameSite cookie
• BUG FIXED: SQL syntax error for the right syntax to use near 'UDPATE yT1ui_settings SET uisettings = ? WHERE member = ? AND uitype = ? AND ...' in /includes/upload.php
• CHANGED: use <input type="number"> HTML element defines for entering numerical values
• CHAGNED: use HTML required attribute to forces users to fill out an input field before submitting a form
• CHAGNED: use a secure php stream script to play video/audio or display image/photo/logo
• CHANGED: use autofocus attribute that completely replaces the need for JavaScript onLoad body commands
• CHANGED: use hash_equals to prevent login from timing attack
• CHANGED: use parameterized queries to prevent all public(without a login) pages from timing attack/sql injection
• CHANGED: move temporary files garbage collection to cron job
• CHANGED: email/export forms need Edit Permission of the form template and form status is approved or no approvals needed
• CHANGED: upgrade jQuery to 3.7.1 from 1.11.1
• CHANGED: wrap report description in a CDATA section when exporting report definitions
• CHANGED: wrap section approval stage description and approval template description in a CDATA when exporting approval templates
• CHANGED: wrap extension description in a CDATA section when exporting extensions
• ADDED: Content-Security-Policy, Referrer-Policy, Strict-Transport-Security
• ADDED: wipes the browser cache, cookies, and local storage immediately upon logging out
• ADDED: script to reset admin password (run on console only)... read more

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: javascript error: Pattern attribute value [a-zA-Z0-9._-] is not a valid regular expression: Uncaught SyntaxError: Invalid regular expression: /[a-zA-Z0-9._-]/v: Invalid character in character class
• CHANGED: remove all html tags from all memo field values when exporting custom reports

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/3.0p4/

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: new custom field in history-table not created when import form template xml into an existed form template
• BUG FIXED: PHP message: PHP Warning: Undefined array key "24H" in /var/www/html/users/viewuser.php on line 141
• BUG FIXED: PHP message: PHP Warning: Undefined array key "..." in /var/www/html/includes/library.php on line 4006
• BUG FIXED: field type Alpha-numeric-hyphen input pattern incorrect... read more

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: PHP Warning: Undefined array key "..." in /var/www/html/includes/library.php on line 2509
• BUG FIXED: PHP Warning: Undefined array key ... in /var/www/html/approvals/viewapprovaltemplate.php on line 281
• BUG FIXED: PHP Warning: Undefined variable $expfmt in /var/www/html/users/edituser.php on line 472
• BUG FIXED: PHP Warning: unserialize(): Error at offset 0 of 5 bytes in /var/www/html/general/login.php on line 93
• BUG FIXED: PHP message: Duplicate entry '1-UploadFiles-10000' for key 'PRIMARY' ... , request: "POST /includes/upload.php
• BUG FIXED: view task error if task dependencies defined or equipment management enabled
• BUG FIXED: export project error if equipment management enabled
• BUG FIXED: unable to maintain contact birthdate
• CHANGED: send the system notification emails with the administrator as the sender, except functions user send email and user announcement... read more

This is a maintenance release. The following items were fixed and/or changed:

• CHANGED: suspend all scheduled jobs if site off
• CHANGED: disable import deny hosts script by default
• BUG FIXED: PHP Warning: Undefined variable $action in /var/www/html/forms/viewform.php
• BUG FIXED: PHP Fatal error: Uncaught ValueError: ZipArchive::addFile(): Argument #1 ($filepath) must not be empty in /var/www/html/forms/exportforms.php... read more

2 new docker compose files have been published to webTareas on SourceForge.

Docker Compose:
https://sourceforge.net/projects/webtareas/files/docker-compose/compose-3.0-php8.4-fpm-mysql-vsftpd.zip/download
https://sourceforge.net/projects/webtareas/files/docker-compose/compose-3.0-php8.4-fpm-postgres-vsftpd.zip/download

Run your webTareas v3.0 on kubernetes:
3 new sample YAML files have been published to webTareas on SourceForge.

https://sourceforge.net/projects/webtareas/files/kubernetes/webtareas-3.0-php8.4-fpm-mysql-vsftpd.yml/download
https://sourceforge.net/projects/webtareas/files/kubernetes/webtareas-3.0-php8.4-fpm-postgres-vsftpd.yml/download
https://sourceforge.net/projects/webtareas/files/kubernetes/webtareas-2.8to3.0-php8.4-fpm-postgres-vsftpd.yml/download

The following items were fixed and/or changed:

• ADDED: PHP8.x compatible
• ADDED: approval actions - specify the custom fields to be updated, publish document or trigger subsequent procedures(only when procedure approved) when the approval procedure is submitted, approved, or rejected.
• ADDED: show document id in approval notifications
• ADDED: including pending approval from which user(s) in the document informations
• ADDED: able to show only owned data in the form list
• ADDED: custom field type - currency
• ADDED: able to execute extensions cronjobs (minutely, hourly, daily, weekly and monthly) not support on windows
• CHAGNED: show The approval request has been withdrawn instead of permission denied when an approval request canceled
• BUG FIXED: sql error when adding/editing custom field with datasource from custom report
• BUG FIXED: excluding specific user profile, department or team from an approval procedure not working
• BUG FIXED: upload file failed with empty file extensions setting
• BUG FIXED: characters &, > and < will be converted to html entities in memo type fields when exporting form data... read more

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: able to show form list either card-view mode or list mode
• ADDED: able to lock form after approval
• BUG FIXED: unable to skip a required image/video/audio/file non-empty field when editing form record
• BUG FIXED: field valid-values duplicated after field definition updated
• BUG FIXED: inconsistency between the report and the exported data... read more

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: PHP Warning: ftp_put(): Illegal PORT command (due to php ftp active mode)

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.8p5/

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: unable to redirect to the previous page after login

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.8p4/

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: unable to add new forms due to the incorrect serial field numbering
• BUG FIXED: unable to use custom fields if database type is postgres

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.8p3/

This is a maintenance release. The following items were fixed and/or changed:

• BUG FIXED: unable to delete field with linked-table
• BUG FIXED: child forms always empty in view mode

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.8p1/

The following items were fixed and/or changed:

• ADDED: custom field editable on creation only (no change)
• ADDED: able to hide rarely used items in main menu
• ADDED: no. of rejections required for approval stage
• CHANGED: back to form list after form creation
• CHANGED: show approval document in new window on clicking the view link in view document page
• CHANGED: single textbox for list type field as report's parameter
• BUG FIXED: confused content of list type field with linked-table as report's output
• BUG FIXED: no textbox available for serial type field as report's parameter
• BUG FIXED: unable to leave optional field with valid values unchoose
• BUG FIXED: unable to access files uploaded with upload multiple files interface
• BUG FIXED: user forced logout after submit approval/reject document from internal notification... read more

The following items were fixed and/or changed:

• ADDED: including approval template information in the approval notifications
• ADDED: use custom report output as linked-table field's choose-list data source
• ADDED: file management - upload multiple files at once
• ADDED: select option show up to xxx items in bottom of list/card-view block
• ADDED: new column remark in to-do list (project name for milestones/tasks/meetings/support requests, approval template name for approval documents)
• ADDED: shift select multiple checkboxes for card-view items
• ADDED: custom field hide in view mode
• ADDED: change custom fields display order by drag & drop
• ADDED: new custom field type - priority, would be passed to approval document
• CHANGED: file management - open default folder directly there is only one folder
• CHANGED: show deleted foms link only if form template history enabled
• BUG FIXED: boolean field condition in the custom report creation failed
• BUG FIXED: confused file list content after files deletion
• BUG FIXED: incorrect page links in bottom of list/card-view block
• BUG FIXED: show raw data of list type field with valid values in form list
• BUG FIXED: card-view actions not show up with multiple selected forms in form list
• BUG FIXED: incorrect originator name of approval document in to-do list
• BUG FIXED: no percent sign for percentage type custom field... read more

The following items were fixed and/or changed:

• ADDED: upgrade webTareas from CLI
• ADDED: trigger approval procedure on field changing
• ADDED: icon for file type mp4

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.6/

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: new custom field types - locked, reference
• CHANGED: function copy to only for forms with 3 (or more) identical custom fields
• CHANGED: always display to-do list on mainmenu

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.5p8/

This is a maintenance release. The following items were fixed and/or changed:

• CHANGED: choose list data filter (exclude 'draft', 'need approval', 'not approved', 'canceled', 'deleted', 'inactive', 'locked', 'folder')
• BUG FIXED: missing files in new copied form if there is no file attached in the original form

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.5p7/

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: new custom field type - list

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.5p6/

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: copy one form data to another form (different form templates)
• ADDED: able to copy image/audio/video/file fields in the form
• BUG FIXED: unable to show new copied form template on the mainmenu

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.5p5/

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: new page - Deleted Fomrs, able to show the changelogs & differences of deleted forms
• BUG FIXED: EXCEPTION CAUGHT! upload multiple attachments and assign image/audio/video/file fields at the same time in the form adding procedure

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.5p4/

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: enable form list group options if the form approval enabled
• ADDED: prefix string for serial field
• CHANGED: re-design choose list (data filters & sorters)
• BUG FIXED: no data permissions checking applied on the choose list
• BUG FIXED: unable to extract form exported zip file if form description too long
• REMOVED: fields link to meetings, notes, support_requests, tasks & topics... read more

This is a maintenance release. The following items were fixed and/or changed:

• ADDED: form change logs
• ADDED: export forms

webTareas Web Site > http://webtareas.sf.net/
Download > http://sourceforge.net/projects/webtareas/files/2.5p2/