===6.2===
(03.12.2025) ((commit:209ee5a9849d70ee6c680a5fa53de46f942b3cab 209ee5a)) -> **RC1** ++(((/Dev/Release/R6.2/ReleaseNotes Release Notes)) | ((!/Chronological by release)))++
As work on WackoWiki 6.2 is ((/Dev/Release/R6.2/ToDo still underway)), this is an incomplete list of changes.
{{toc numerate=1 from="h3" to="h6"}}
====Features====
* add SQLite support
====Configuration====
=====primary config=====
1. new
1. renamed
=====secondary config=====
1. new
* ##reserved_namespaces##
* ##whatsnew_page##
1. removed
* ##disable_npjlinks##
* ##session_prefix##
=====theme config=====
*
=====constants=====
1. new
* ##DATA_DIR##
1. renamed
* ##UPLOAD_BACKUP_DIR## -> ##BACKUP_DIR##
1. removed
=====conf files=====
1. changed
1. ((source:master/src/config/autoload.conf autoload.conf))
1. ((source:master/src/config/csp_custom.conf csp_custom.conf))
1. ((source:master/src/config/csp.conf csp.conf))
2. ((source:master/src/config/permissions_policy.conf permissions_policy.conf))
2. ((source:master/src/config/router.conf router.conf))
====Core====
* rewrote SQL queries to work with MySQL as well as SQLite
* register custom regexp function to use ##REGEXP## with SQLite
* fix missing route case for CSS files in ##RECOVERY_MODE##
=====Classes=====
* added
* ##DbSqlite##
=====Methods=====
This is only a random selection.
Add functions to abstract SQL syntax and function differences between MySQL and SQLite
* ##utc_dt()##
* ##date_sub(int $value, string $interval)##
* ##binary()##
* ##collate()##
* ##limit()##
These functions reside in the ##Dbal## class mainly because the ##DbPDO## class serves SQLite as well MySQL.
=====Folders=====
new folder
* ##file/data## - .htaccess protected folder for SQLite database file.
%%(info type="warning")
It is strongly recommended to place the database file **outside** the webroot for security, but if you must place it within the webroot, use a filename like ##file/data/.ht.sqlite## to help prevent direct access via the web server.
%%
====Database====
((/Dev/Release/R6.2/Database Database schema)) changes
====Installer====
* add SQLite table creation script
* add ##_t()## function for ##$lang[]## array, uses now English as fallback for missing message sets
* add system page with the ##whatsnew## action and set it as default bookmark
* add private system page with with the ##admincache## and ##admin_recovery## action and set it as bookmark for the admin
* the installer sets now bookmarks for the admin account, therefore it no longer shows the default bookmarks for the admin in the menu by default
* add mandatory installer password protection by default
* It is imperative to set the password for the installer in the ##config/lock_setup## file.
* removing the ##config/lock_setup## file disables the installer password protection (not recommended)
====Formatters====
====Actions====
* ##menu##: fix not showing 'Set a bookmark' form in menu action
* ##whatsnew##:
* add filter for pages, comments and files
* show also edited comments in list
====Handlers====
* ##show##: Displays the number of comments in the article header and provides a link to the comments section.
====Themes====
====WikiEdit====
* replace ##var## with ##const## and ##let##
====Admin panel====
* add backup & restore for SQLite
====Translations====
====Packages====
updated
* ((https://github.com/Bad-Behaviour/badbehaviour Bad Behaviour)) 2.2.26
* ((https://github.com/zenorocha/clipboard.js clipboard.js)) v2.0.11
* ((/Dev/Components/Lib/Captcha freeCap)) 1.4.6
* ((https://hashids.org/php/ Hashids)) 5.0.2 ++(((https://github.com/ivanakimov/hashids.php/blob/master/CHANGELOG.md Changelog)))++
* ((https://github.com/JBlond/php-diff php-diff)) 2.5.0 ++(((https://github.com/JBlond/php-diff/blob/master/changelog.md Changelog)))++
* ((https://github.com/PHPMailer/PHPMailer PHPMailer)) 7.0.1 ++(((https://github.com/PHPMailer/PHPMailer/blob/master/changelog.md Changelog)))++
* ((https://github.com/PHPThumb/PHPThumb PHP Thumb Library)) 2.3.3
* ((/Dev/Projects/SafeHTML SafeHTML)) 1.3.13
* ((https://simplepie.org/ SimplePie)) 1.9.0 ++(((https://github.com/simplepie/simplepie/blob/master/CHANGELOG.md Changelog)))++
* ((https://github.com/darylldoyle/svg-sanitizer svg-sanitizer)) 0.22
* ((/Dev/Projects/WikiEdit WikiEdit)) 3.25
See ((/Dev/Release/R6.2/Dependencies core dependencies))
----
Note that the changelog is usually incomplete, for a complete list of changes that went into R6.2, you can browse the Commit log, the ((https://wackowiki.org/bugs/changelog_page.php Bug Tracker Log)) and ((ToDo)) list.