NOTE the md5sum on the release page did not match the uploaded file. This has been corrected below.
(MD5SUM b0d00cb74d81f56b572ac0dbf10b85e9) ../ampache-4.2.2_all.zip
Ampache 4.2.2-release
DATABASE CHANGES You can now force a default collation and charset on your database.
If you choose to use utf8mb4; Ampache will convert your table engine to InnoDB to handle the extra bytes.
Added
- Numeric 'Played/Skipped ratio' added to search. (Set using (stream/skip)*100.)
> 0 & < 100
: Skipped more than played100
: Equal plays and skips> 100
: Played more than skipped
- Add 'Original Year', 'Release Type' to Album searches
- Allow setting custom database collation and charset without overwriting your changes
- Video search added to random.php
- 'samesite=strict' on JS cookies
- Translation updates (August 2020)
- Put 'Labels' into search, browse headers and sidebar when enabled
- NEW config options (config_version 45)
- database_charset: Set a default charset for your database
- database_collation: Set a default collation for your database
- simple_user_mode: Don't allow users to edit their account values (used for demo sites that allow login)
- NEW files
- bin/update_file.inc: Update your catalog when individual files are changed using inotifywait.sh
- bin/update_db.inc: Update your database collation, charset and table engine from the cli
- docs/examples/inotifywait.sh: script to use inotifywait and update_file.inc to update as file changes happen
- docs/examples/inotifywait.service: systemd example service for inotifywait.sh
Changed
- stats.php: Show total 'Item Count' on Statistics page instead of trying to shoehorn songs/videos/etc into different columns
- ampache.sql updated after about 4 years... no more updates on install!
- Searching by "Rating (average)" now ignores private/public and always returns the average.
- Hide searches for '# Skipped' and 'Played/Skipped ratio' when 'Show # skipped' is Off
- Search items rearranged to try to match each other
- Sort 'Playlist' and 'Smart Playlist' browse pages by name
- Display the blankuser avatar in now playing if missing
- Swap 'Random' and 'Playlists' in the sidebar (CSS order numbers)
- Don't hide artist art when you disable lastfm_api_key in the config
- Hide 'Metadata' search when 'enable_custom_metadata' is disabled
Deprecated
- Drop version number from the release string in develop. ('4.3.0-develop' => 'develop')
- This should stop a bit of confusion when removing / adding requirements
- The '-release' suffix in version number will be dropped for Ampache 5.0.0
Removed
- Remove stat recording from channels
- Don't reset the database charset and collation after each db update
Fixed
- Fixed a few issues on the Statistics page
- Report 'Catalog Size' correctly for podcasts
- Report 'Item Count' correctly for podcasts and video catalogs
- Searching albums for artist name
- Mashup 'Newest' would incorrectly apply an offset missing the newest items
- Search by 'Smart Playlist' rules fixed when added with other rules
- Use LEFT JOIN instead of HAVING for search rules to allow more complicated lists
- Logic searching 'My Rating' includes unrated (0 Stars) in a better way
- Captcha was not generated for registration
- Enforce lowercase codec for live streams
- Parsing integer search rules was overwriting index values
- Handle empty XML on similar artist requests to last.fm
Security
Fix CVE-2020-15153 - Unauthenticated SQL injection in Ampache
API 4.2.2
Minor bugfixes
Added
- Api::advanced_search added parameter 'random' (0|1) to shuffle your searches
Changed
- Remove spaces from advanced_search rule names. (Backwards compatible with old names)
- 'has image' => 'has_image'
- 'image height' => 'image_height'
- 'image width' => 'image_width'
- 'filename' => 'file' (Video search)
Deprecated
- Search rules 'has image','image height', 'image width', 'filename'. (Removed in Ampache 5.0.0)
Fixed
- Api::stream, Api::download Api::playlist_generate 'format' parameter was overwritten with 'xml' or 'json'
- Produce valid XML for playlist_generate using the 'id' format in XML