Ampache :: For the Love of Music - Installation -
Version: 7.9.3 Build: 001
Warning
Please consider using the CLI for this update (`php bin/cli admin:updateDatabase -e`) Ampache Wiki,- Fix Licenses on uploaded Songs and delete bad data
-
Version: 7.9.4 Build: 001
Warning
Please consider using the CLI for this update (`php bin/cli admin:updateDatabase -e`) Ampache Wiki,- Add weight columns to song, album, artist, podcast, podcast_episode and video tables
-
Version: 7.9.4 Build: 002
Warning
Please consider using the CLI for this update (`php bin/cli admin:updateDatabase -e`) Ampache Wiki,- Add weight columns to album_disk table
-
Version: 7.9.4 Build: 004
Warning
Please consider using the CLI for this update (`php bin/cli admin:updateDatabase -e`) Ampache Wiki,- Fix up Orphan Album Disk objects to be unique and update from tags
-
Version: 8.0.0 Build: 000
- Add ui option 'api_enable_8' to enable/disable API8
-
Version: 8.0.0 Build: 001
- Enable Opensubsonic for all users with `subsonic_legacy` enabled.
-
Version: 8.0.0 Build: 004
- Add 'folder' to `object_type` enum for `cache_object_count` table` table
- Add 'folder' to `object_type` enum for `cache_object_count_run` table
- Add 'folder' to `object_type` enum for `image` table
- Add 'folder' to `object_type` enum for `object_count` table
- Add 'folder' to `object_type` enum for `rating` table
- Add 'folder' to `object_type` enum for `tag_map` table
- Add 'folder' to `object_type` enum for `user_activity` table
- Add 'folder' to `object_type` enum for `user_flag` table
-
Version: 8.0.0 Build: 005
- Add a default limit of 500 to `direct_play_limit` to stop playing items with thousands of tracks
-
Version: 8.0.0 Build: 006
- Add `show_folder` preference to show/hide Sidebar the Browse menu link
-
Version: 8.0.0 Build: 007
- Add `folder` table for mapping folder's to library items
-
Version: 8.0.0 Build: 009
Warning
Please consider using the CLI for this update (`php bin/cli admin:updateDatabase -e`) Ampache Wiki,- Add weight columns to folder table
-
Version: 8.0.0 Build: 010
- Create `folder_map` table for browsing Folder's and items together
-
Version: 8.0.0 Build: 011
- Remove obsolete `webplayer_flash`, `webplayer_aurora` and `use_play2` preferences
-
Version: 8.0.0 Build: 012
- Allow the system user (-1) in `object_count`, `user_activity`, `user_data` and `now_playing` on databases where `user` was UNSIGNED
- Attribute existing `share.php` plays to the system user (-1) instead of user 0
-
Version: 8.0.0 Build: 013
- Add `object_count_summary` table to allow consolidating old play history
-
Version: 8.0.0 Build: 014
- Drop redundant `object_count` indexes covered by existing keys
-
Version: 8.0.0 Build: 015
- Add `object_count_archive` table to retain consolidated play history detail
-
Version: 8.0.0 Build: 016
- Add per-user `encode_target`, `encode_video_target`, `encode_player_webplayer_target` and `encode_player_api_target` transcoding preferences
-
Version: 8.0.0 Build: 017
- Add per-user `max_bit_rate`/`min_bit_rate` dynamic-downsampling preferences (stored in bps)
-
Version: 8.0.0 Build: 018
- Store `transcode_bitrate` in bits per second (bps) and migrate existing kilobit values
-
Version: 8.0.0 Build: 020
- Remove the obsolete `webplayer_html5` preference
-
Version: 8.0.0 Build: 021
- Add the `mini_player` preference to lock a user into the mini player interface
-
Version: 8.0.0 Build: 022
- Remove the obsolete `ajax_load` preference
-
Version: 8.0.0 Build: 023
- Correct stored art mime types written from a filename extension (`image/jpg` -> `image/jpeg`)
-
Version: 8.0.0 Build: 024
- Add the `cron_cache_live_count` preference for accurate played counts when the cache is enabled
-
Version: 8.0.0 Build: 025
- Add `subsonic_secret` to the `user` table to allow Subsonic token authentication without the api key
-
Version: 8.0.0 Build: 026
- Correct the misleading `disabled_custom_metadata_fields_input` preference label
-
Version: 8.0.0 Build: 027
- Add the per-player `transcode_bitrate_webplayer` and `transcode_bitrate_api` bitrate overrides
-
Version: 8.0.0 Build: 028
- Create `collection` and `collection_map` tables for curating lists of any object type
-
Version: 8.0.0 Build: 029
- Add a maintained `last_played` column to the tables carrying a play counter
-
Version: 8.0.0 Build: 030
- Add `show_collection` preference to show/hide the Collections sidebar link
-
Version: 8.0.0 Build: 031
- Allow a `collection` to be rated and flagged
-
Version: 8.0.0 Build: 032
- Add `position_ms`, `playback_rate` and `state` to `now_playing` for OpenSubsonic playback reports
-
Version: 8.0.0 Build: 033
- Add `artist`.`lastfm_url` to keep the last.fm page url with the cached artist info
-
Version: 8.0.0 Build: 034
- Allow `label_asso` to associate a label with an album as well as an artist
-
Version: 8.0.0 Build: 035
- Drop the unique key on `collection_map` so `unique_playlist` decides whether a collection allows duplicates
-
Version: 8.0.0 Build: 036
- Restore `album`.`subtitle`, `folder`.`playable`, `folder`.`weight` and the `folder_map` name/catalog/path columns on databases installed from a stale ampache.sql
-
Version: 8.0.0 Build: 037
- Add an index on `album`.`addition_time` and `artist`.`addition_time` so the newest lists can stop at the rows they show
-
Version: 8.0.0 Build: 038
- Add the missing `podcast` rows to `object_count` for episode plays that predate podcast play counting
- Remove the `update_counts` row from `update_info`, which timed a sweep that no longer exists
-
Version: 8.0.0 Build: 039
- Remove `folder` rows whose `path_name` is a bare directory name; the next catalog scan recreates them with their real path
-
Version: 8.0.0 Build: 040
- Remove the `7digital_api_key` and `7digital_secret_api_key` preferences; the plugin they configured has been deleted
-
Version: 8.0.0 Build: 041
- Add the `broadcast_private` preference; a new broadcast requires a session to listen unless its owner turns this off
-
Version: 8.0.0 Build: 042
- Widen `song_preview`.`file` to varchar(4096) so signed preview urls are not truncated
-
Version: 8.0.0 Build: 043
- Add `wanted` to the `image`.`object_type` enum so a wanted album keeps the art it gathered
-
Version: 8.0.0 Build: 044
- Add an index on `object_count`.`geo_latitude`, `geo_longitude` so a cached place name is a lookup
- Add an index on `user_flag`.`object_type`, `date` so the newest flagged lists stop at the rows they show
-
Version: 8.0.0 Build: 045
- Create `playlist_folder` and `playlist_folder_map` tables for organising lists into a per-user tree
-
Version: 8.0.0 Build: 046
- Add `bpm` to `song_data` table
-
Version: 8.0.0 Build: 047
- Add `mood` table
- Add `mood_map` table
- Add `show_mood` preference to show/hide the Moods sidebar link
-
Version: 8.0.0 Build: 048
- Add ui option ('hide_moods') Hide the Mood column in browse table rows
-
Version: 8.0.0 Build: 049
- Allow `tag_map` to hold a broadcast, and widen `tag_map` and `user_activity` `object_type` on installs seeded from the dump
-
Version: 8.0.0 Build: 050
- Drop redundant `user_preference` indexes covered by existing keys
-
Version: 8.0.1 Build: 001
- Drop redundant indexes that repeat the leading columns of a wider key on the same table
-
Version: 8.0.1 Build: 002
- Convert `stream_beautiful_url` into a system preference
-
Version: 8.0.1 Build: 003
- Restrict `headphones_api_url`/`headphones_api_key` to Manager level, since any regular user could point the server at an arbitrary address
Ampache Update
This page handles all database updates to Ampache starting with 3.3.3.5. Your current version is 8.0.1 with database version 7.9.0 Build: 001
The following updates need to be performed: