icefields / Power-Ampache-2

second version of my popular ampache Android app
GNU General Public License v3.0
47 stars 2 forks source link

Music does not play #55

Closed BlueNalgene closed 4 months ago

BlueNalgene commented 4 months ago

Power Ampache 2 version: v0.19-beta

Device: OnePlus 7T Processor: Qualcomm Snapdragon 855Plus Octa-core Model: HD1905 Android version: 12 (security update Dec. 5, 2022) Build version: HD1905_11_F.22 Baseband version: Q_V1:P14,Q_V1_P14 Kernel: 4.14.180-perf+

==============================

I can open the app, login, and see my music. When I click something, it pulls up the correct files and album art. However, when I click play....

============================== Ampache debug:

$ grep '^[^#;]' /var/www/html/ampache/config/ampache.cfg.php
config_version = 61
web_path = "/ampache/public"
local_web_path = "http://localhost/ampache"
database_hostname = localhost
database_name = ampache
database_username = [redacted]
database_password = [redacted]
secret_key = [redacted]
session_length = 3600
stream_length = 7200
remember_length = 604800
session_name = ampache
session_cookielife = 0
session_cookiesecure = 0
auth_methods = "mysql"
access_control = "true"
require_session = "true"
require_localnet_session = "true"
getid3_tag_order = "vorbiscomment,id3v2,id3v1,quicktime,matroska,ape,asf,avi,mpeg,riff"
metadata_order = "getID3,MusicBrainz,TheAudioDb,filename"
metadata_order_video = "filename,getID3"
deferred_ext_metadata = "true"
additional_genre_delimiters = "[/]{2}|[/\\\\|,;]"
catalog_file_pattern = "mp3|mpc|m4p|m4a|aac|ogg|oga|wav|aif|aiff|rm|wma|asf|flac|opus|spx|ra|ape|shn|wv"
catalog_video_pattern = "avi|mpg|mpeg|flv|m4v|mp4|webm|mkv|wmv|ogv|mov|divx|m2ts"
catalog_playlist_pattern = "m3u|m3u8|pls|asx|xspf"
catalog_prefix_pattern = "The|An|A|Die|Das|Ein|Eine|Les|Le|La"
use_auth = "true"
default_auth_level = "guest"
: It also allows users to flag objects as a favorite
ratings = "true"
directplay = "true"
sociable = "true"
playlist_art = "true"
art_order = "db,spotify,TheAudioDb,musicbrainz,lastfm,tags,folder"
lastfm_api_key = [redacted]
lastfm_api_secret = ""
wanted_types = "album,official"
live_stream = "true"
podcast = "true"
refresh_limit = "60"
show_footer_statistics = "true"
debug = "true"
debug_level = 5
log_path = "/media/storage1/ampache/"
log_filename = "%name.%Y%m%d.log"
site_charset = UTF-8
registration_display_fields = "fullname,website"
registration_mandatory_fields = "fullname"
transcode_mp3 = "allowed"
transcode_player_customize = "true"
transcode_input = "-i %FILE%"
encode_args_mp3 = "-vn -b:a %BITRATE%K -c:a libmp3lame -f mp3 pipe:1"
encode_args_ogg = "-vn -b:a %BITRATE%K -c:a libvorbis -f ogg pipe:1"
encode_args_opus = "-vn -b:a %BITRATE%K -c:a libopus -compression_level 10 -vsync 2 -f ogg pipe:1"
encode_args_m4a = "-vn -b:a %BITRATE%K -c:a libfdk_aac -f adts pipe:1"
encode_args_wav = "-vn -b:a %BITRATE%K -c:a pcm_s16le -f wav pipe:1"
encode_args_flv = "-b:a %BITRATE%K -ar 44100 -ac 2 -v 0 -f flv -c:v libx264 -preset superfast -threads 0 pipe:1"
encode_args_webm = "-b:a %BITRATE%K -f webm -c:v libvpx -preset superfast -threads 0 pipe:1"
encode_args_ts = "-q %QUALITY% -s %RESOLUTION% -f mpegts -c:v libx264 -c:a libmp3lame -maxrate %MAXBITRATE%k -preset superfast -threads 0 pipe:1"
encode_args_ogv = "-codec:v libtheora -qscale:v 7 -codec:a libvorbis -qscale:a 5 -f ogg pipe:1"
encode_get_image = "-ss %TIME% -f image2 -vframes 1 pipe:1"
encode_srt = "-vf \"subtitles='%SRTFILE%'\""
encode_ss_frame = "-ss %TIME%"
encode_ss_duration = "-t %DURATION%"
send_full_stream = "webplayer"
common_abbr = "divx,xvid,dvdrip,hdtv,lol,axxo,repack,xor,pdtv,real,vtv,caph,2hd,proper,fqm,uncut,topaz,tvt,notv,fpn,fov,orenji,0tv,omicron,dsr,ws,sys,crimson,wat,hiqt,internal,brrip,boheme,vost,vostfr,fastsub,addiction,x264,LOL,720p,1080p,YIFY,evolve,fihtv,first,bokutox,bluray,tvboom,info"
icefields commented 4 months ago

thanks, music not playing is major issue. are you trying to play a flac file by any chance? those are not supported yet

BlueNalgene commented 4 months ago

Nope. Everything I have (mostly) is 320 MP3.

Edit: specific info:

$ file /media/storage2/Sounds/B/Belzebubs/Belzebubs\ -\ 2019\ -\ Pantheon\ Of\ The\ Nightside\ Gods/01\ Cathedrals\ of\ Mourning.mp3 
/media/storage2/Sounds/B/Belzebubs/Belzebubs - 2019 - Pantheon Of The Nightside Gods/01 Cathedrals of Mourning.mp3: Audio file with ID3 version 2.3.0, contains: MPEG ADTS, layer III, v1, 320 kbps, 44.1 kHz, Stereo
icefields commented 4 months ago

@BlueNalgene

ok, thanks so much for your help, I don't have any playback issue on my devices so I cannot reproduce the issue, but the bug NEEDS to be fixed, music playback is pretty major. Can you try the following things please? whenever you have a minute, it would be very helpful.

Thanks again for helping

BlueNalgene commented 4 months ago

This is almost certainly a server or PEBKAC issue.

* Is this something that happens only on some particular songs or everywhere?

All songs. I was clicking from "Recent", but I also tried searching for specific artists.

* Can you try to kill and restart the app and try again?

Done.

* Can you go on Settings, debug logs, and copy what's in there if there's anything?

No logs appear.

* What version of the Ampache server are you using?

5.4.0-release. It looks like I'm a few versions old. I will try updating first.

* I want to rule out that the issue is on the server. Can you try to log out and on the login to "Dogmazic demo Server", there's a button on the loging page for that, and then try to play any song from that server.

The demo server works. There must be something in my config not playing nice. In addition to the version update, do I need to have specific settings in my .htaccess or redirects for this API?

icefields commented 4 months ago

I see, on that version the data is structured a bit differently, I just checked, and I'm adding the fix to the release I'll be making in a few minutes (along with other fixes and enhancements).

Anyway, I think in general you should update to the latest server, the guys at Ampache are always working on improvements and new features.

For now, please wait that I push this new release (in about 15 mins, just the time to prepare the release log) and let's try this fix I just made.

BlueNalgene commented 4 months ago

I'm currently updating my server to 6.2.1, and I am finishing the catalog update.

Edit: updated server to 6.2.1 and the playback problem persists.

icefields commented 4 months ago

Ok got it, the fix I just made might still work. Let me know. https://github.com/icefields/Power-Ampache-2/releases/tag/v0.20-beta

BlueNalgene commented 4 months ago

With v0.20-beta Power Ampache 2 and v6.2.1 Ampache, the problem still occurs. No music.

I also tried a device reset and a shutting down ad blocking apps. No effect.

BlueNalgene commented 4 months ago

By pressing play on the same song after it fails to play, the app crashes. This is not new, it occurred each time the song failed to play. However, this was the first time I had Gmail open to receive the crash report. I sent it via email since it contains real info. It may be related to this issue. Let me know if I should open a new one for that separately.

icefields commented 4 months ago

I got the bug report, what I see from the stack trace is a UI bug, most likely caused by the previous issue. I could get the stack trace of the errors directly if you enable bug reporting in the settings screen, here's a sample of the data I'll be receiving:

--------------------------------------------
2024-02-08  20:11:48  
"retrofit2.HttpException: HTTP 404 { \"exception\" : \"Failed to connect to /106.380.10.105:8320\" }\n\tat retrofit2.KotlinExtensions$await$2$2.onResponse(KotlinExtensions.kt:53)\n\tat retrofit2.OkHttpCall$1.onResponse(OkHttpCall.java:161)\n\tat okhttp3.internal.connection.RealCall$AsyncCall.run(RealCall.kt:535)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:644)\n\tat java.lang.Thread.run(Thread.java:1012)\n"

--------------------------------------------
2024-02-08  20:11:50  
"getPlaylists() - cannot load data HttpException retrofit2.HttpException: HTTP 404 { \"exception\" : \"Failed to connect to /106.380.10.105:8320\" }"

--------------------------------------------

Basically just the stack trace of the error that I'm capturing in a try catch .

Anyway, you could try one more thing with the new version if you haven't yet. Since the issue was with the user object, maybe try to log out and back in.

Thanks for sending the report btw. I decided to use email to report bugs because I wanted the app to be 100% private and free of trackers. A "silent" bug reporting tool might register too much info, while with emails the data you're sending is 100% transparent.

BlueNalgene commented 4 months ago

No luck with the logout. The demo server works fine. Can you share the config for it? Can you share the apache config?

I'm happy to send reports and break other people's code.

icefields commented 4 months ago

This is the config, but I'm not sure you'll find the solution in it. I asked the developers of Ampache about your issue, since that's their expertise. Ideally if someone has a similar issue I'd like to handle the error graciously (instead of the app just crashing on you) and show a dialog with instructions on how to enable music playback, or whatever the solution is. In the meantime it would be very useful to see the stack trace of the error. If you go to Settings in Power Ampache 2, enable "remote debug logging", and crash the app, I'll get the error on my end and can start examine it. Thanks.

config_version = 69
web_path = ""
session_length = 3600
stream_length = 7200
remember_length = 604800
session_cookielife = 0
session_cookiesecure = 0
auth_methods = "mysql"
access_control = "true"
require_session = "true"
require_localnet_session = "true"
getid3_tag_order = "vorbiscomment,id3v2,id3v1,quicktime,matroska,ape,asf,avi,mpeg,riff"
metadata_order = "getID3,MusicBrainz,TheAudioDb,filename"
metadata_order_video = "filename,getID3"
deferred_ext_metadata = "true"
additional_genre_delimiters = "[/]{2}|[_/\\|,;]"
catalog_file_pattern = "mp3|mpc|m4p|m4a|aac|ogg|oga|wav|aif|aiff|rm|wma|asf|flac|opus|spx|ra|ape|shn|wv"
catalog_video_pattern = "avi|mpg|mpeg|flv|m4v|mp4|webm|mkv|wmv|ogv|mov|divx|m2ts"
catalog_playlist_pattern = "m3u|m3u8|pls|asx|xspf"
catalog_prefix_pattern = "The|An|A|Die|Das|Ein|Eine|Les|Le|La"
waveform = "true"
use_auth = "true"
default_auth_level = "guest"
ratings = "true"
directplay = "true"
sociable = "true"
licensing = "false"
album_art_min_width = 30
album_art_min_height = 30
playlist_art = "true"
art_order = "db,tags,folder,spotify,musicbrainz"
wanted = "false"
wanted_types = "album,official"
live_stream = "true"
podcast = "true"
refresh_limit = "60"
show_footer_statistics = "true"
debug_level = 5
site_charset = "UTF-8"
cookie_disclaimer = "false"
registration_display_fields = "fullname,website"
registration_mandatory_fields = "fullname"
transcode_m4a = "required"
transcode_flac = "required"
transcode_mpc = "required"
transcode_ogg = "allowed"
transcode_wav = "required"
transcode_mp3 = "allowed"
transcode_avi = "allowed"
transcode_mkv = "allowed"
transcode_mpg = "allowed"
encode_target = "mp3"
encode_video_target = "webm"
transcode_player_customize = "true"
transcode_cmd = "ffmpeg"
transcode_input = "-i %FILE%"
encode_args_mp3 = "-vn -b:a %BITRATE%K -c:a libmp3lame -f mp3 pipe:1"
encode_args_ogg = "-vn -b:a %BITRATE%K -c:a libvorbis -f ogg pipe:1"
encode_args_opus = "-vn -b:a %BITRATE%K -c:a libopus -compression_level 10 -f ogg pipe:1"
encode_args_m4a = "-vn -b:a %BITRATE%K -c:a libfdk_aac -f adts pipe:1"
encode_args_wav = "-vn -b:a %BITRATE%K -c:a pcm_s16le -f wav pipe:1"
encode_args_flv = "-b:a %BITRATE%K -ar 44100 -ac 2 -v 0 -f flv -c:v libx264 -preset superfast -threads 0 pipe:1"
encode_args_webm = "-b:a %BITRATE%K -f webm -c:v libvpx -preset superfast -threads 0 pipe:1"
encode_args_ts = "-q %QUALITY% -s %RESOLUTION% -f mpegts -c:v libx264 -c:a libmp3lame -maxrate %MAXBITRATE%k -preset superfast -threads 0 pipe:1"
encode_args_ogv = "-codec:v libtheora -qscale:v 7 -codec:a libvorbis -qscale:a 5 -f ogg pipe:1"
encode_get_image = "-ss %TIME% -f image2 -vframes 1 pipe:1"
encode_srt = "-vf \"subtitles='%SRTFILE%'\""
encode_ss_frame = "-ss %TIME%"
encode_ss_duration = "-t %DURATION%"
send_full_stream = "webplayer"
common_abbr = "divx,xvid,dvdrip,hdtv,lol,axxo,repack,xor,pdtv,real,vtv,caph,2hd,proper,fqm,uncut,topaz,tvt,notv,fpn,fov,orenji,0tv,omicron,dsr,ws,sys,crimson,wat,hiqt,internal,brrip,boheme,vost,vostfr,fastsub,addiction,x264,LOL,720p,1080p,YIFY,evolve,fihtv,first,bokutox,bluray,tvboom,info"
icefields commented 4 months ago

I have 2 updates from the Ampache developers, I'll copy their suggestions here:

BlueNalgene commented 4 months ago
Log example with PCUSER-ADMIN and PHONEUSER In this log, PCUSER-ADMIN connects to the database, starts a song, and stops it. Then, PHONEUSER logs into the server and waits for a few minutes. Then, PHONEUSER attempts to play a song. SQL errors abound. ``` $ cat /media/storage1/ampache/ampache.20240223.log 2024-02-23T17:05:20+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:20+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:20+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:20 +0000 extension length 3600 2024-02-23T17:05:20+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Index\ShowAction" for action "show" 2024-02-23T17:05:21+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Session created: 350c767e906fd9ea344dfe07f01d9592 2024-02-23T17:05:21+00:00 [PCUSER-ADMIN] (Ampache\Module\System\AutoUpdate) -> GitHub API request https://api.github.com/repos/ampache/ampache/tags 2024-02-23T17:05:22+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711522 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:22 +0000 extension length 3600 2024-02-23T17:05:22+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:05:22+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:22 +0000 extension length 3600 2024-02-23T17:05:22+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:05:22+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711522 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:22+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711523 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:23+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:39+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:39+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:39+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Index\ShowAction" for action "show" 2024-02-23T17:05:39+00:00 [ampache] (Ampache\Module\System\Session) -> Session created: 9b265e2d3dc22129f001c1c257e8eb78 2024-02-23T17:05:39+00:00 [ampache] (Ampache\Module\System\Session) -> Unable to read value from key qf1lc61os8ai12oadqqs4c1a2d no data found 2024-02-23T17:05:39+00:00 [ampache] (Ampache\Module\System\Session) -> Writing to qf1lc61os8ai12oadqqs4c1a2d with expiration 1708711539 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Index\ShowAction" for action "show" 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Session) -> Session created: 3f9313a53c9d5cce060fe45891da29e7 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Session) -> Unable to read value from key gbt3rfg8cjv1e8jk5jbpo25bs3 no data found 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Session) -> Writing to gbt3rfg8cjv1e8jk5jbpo25bs3 with expiration 1708711545 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:45+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Index\ShowAction" for action "show" 2024-02-23T17:05:46+00:00 [ampache] (Ampache\Module\System\Session) -> Session created: 9baf73e7f664b3ab1d7a153b91c1dcd1 2024-02-23T17:05:46+00:00 [ampache] (Ampache\Module\System\Session) -> Unable to read value from key ldrnsu93d79ln5ute2jhsdcjrh no data found 2024-02-23T17:05:46+00:00 [ampache] (Ampache\Module\System\Session) -> Writing to ldrnsu93d79ln5ute2jhsdcjrh with expiration 1708711546 2024-02-23T17:05:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:55 +0000 extension length 3600 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {stream} 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (stream.ajax) -> Called for album_disk: {950} 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711555 2024-02-23T17:05:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:55 +0000 extension length 3600 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Utility\ShowAction" for action "show" 2024-02-23T17:05:55+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711555 2024-02-23T17:05:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:56 +0000 extension length 3600 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Stream\PlayItemAction" for action "play_item" 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Stream\AbstractStreamAction) -> Stream Type: web_player Media IDs: [{"object_type":"song","object_id":91550},{"object_type":"song","object_id":91549},{"object_type":"song","object_id":91553},{"object_type":"song","object_id":91555},{"object_type":"song","object_id":91554},{"object_type":"song","object_id":91552},{"object_type":"song","object_id":91551}] 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Session created: f77cb4de0905325633d3d922237d8ff2 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Stream\AbstractStreamAction) -> Stream Type: web_player Media Count: 7 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\Playback\Stream_Playlist) -> Adding urls to {f77cb4de0905325633d3d922237d8ff2}... 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\Playback\Stream_Playlist) -> Generating a {web_player} object... 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711556 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:56 +0000 extension length 3600 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\WebPlayer\ShowEmbeddedAction" for action "show" 2024-02-23T17:05:56+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711556 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Playback\PlayAction" for action "play" 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\Application\Playback\PlayAction) -> Asked for type {song} 2024-02-23T17:05:56+00:00 [ampache] (Ampache\Module\System\Session) -> f77cb4de0905325633d3d922237d8ff2 has been extended to Fri, 23 Feb 2024 19:05:56 +0000 extension length 7200 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> stream file (/media/storage2/Sounds/K/Kraftwerk/Computer World/01 computer world.mp3}... 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> Media type {mp3} 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> Registering stream @1708707956 for 2: Kraftwerk - Computer World {91550} 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Playback\PlayAction" for action "play" 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\Application\Playback\PlayAction) -> Asked for type {song} 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:05:57+00:00 [ampache] (Ampache\Module\System\Session) -> f77cb4de0905325633d3d922237d8ff2 has been extended to Fri, 23 Feb 2024 19:05:57 +0000 extension length 7200 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:57 +0000 extension length 3600 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {song} 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711557 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:05:57 +0000 extension length 3600 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711557 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> stream file (/media/storage2/Sounds/K/Kraftwerk/Computer World/01 computer world.mp3}... 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> Media type {mp3} 2024-02-23T17:05:57+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> Registering stream @1708707957 for 2: Kraftwerk - Computer World {91550} 2024-02-23T17:05:58+00:00 [PCUSER-ADMIN] (Ampache\Module\User\Activity\UserActivityPoster) -> post_activity: play song by user: 2: {91550} 2024-02-23T17:05:58+00:00 [PCUSER-ADMIN] (Ampache\Module\User\Activity\UserActivityPoster) -> post_activity: play song by user: 2: {91550} 2024-02-23T17:05:59+00:00 [PCUSER-ADMIN] (lastfm.plugin) -> No session key, not scrobbling (need to grant Ampache to last.fm) 2024-02-23T17:05:59+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> Stream ended at 106496 (106496) bytes out of 6166528 2024-02-23T17:05:59+00:00 [PCUSER-ADMIN] (lastfm.plugin) -> No session key, not scrobbling (need to grant Ampache to last.fm) 2024-02-23T17:06:00+00:00 [PCUSER-ADMIN] (Ampache\Module\Application\Playback\PlayAction) -> Stream ended at 6166528 (6166528) bytes out of 6166528 2024-02-23T17:06:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:06:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:06:22+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:06:22 +0000 extension length 3600 2024-02-23T17:06:22+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:06:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711583 2024-02-23T17:07:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:07:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:07:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:07:23 +0000 extension length 3600 2024-02-23T17:07:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:07:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711643 2024-02-23T17:08:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:08:22+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:08:22+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:08:22 +0000 extension length 3600 2024-02-23T17:08:22+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:08:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711703 2024-02-23T17:09:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:09:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:09:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:09:23 +0000 extension length 3600 2024-02-23T17:09:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:09:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711763 2024-02-23T17:10:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:10:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:10:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:10:23 +0000 extension length 3600 2024-02-23T17:10:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:10:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711823 2024-02-23T17:11:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:11:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:11:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:11:23 +0000 extension length 3600 2024-02-23T17:11:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:11:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711883 2024-02-23T17:12:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:12:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:12:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:12:23 +0000 extension length 3600 2024-02-23T17:12:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:12:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708711943 2024-02-23T17:13:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:13:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:13:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:13:23 +0000 extension length 3600 2024-02-23T17:13:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:13:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708712003 2024-02-23T17:14:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:14:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:14:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:14:23 +0000 extension length 3600 2024-02-23T17:14:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:14:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708712063 2024-02-23T17:15:24+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:24+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:24+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:15:24 +0000 extension length 3600 2024-02-23T17:15:24+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:15:24+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708712124 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [c407d9e5feba19b91a25f0f8c64ad03e] 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\ApiHandler) -> Invalid Session attempt to API [user] 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [c407d9e5feba19b91a25f0f8c64ad03e] 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\PingMethod] 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\Method\PingMethod) -> Ping6 Received from: 192.168.88.1 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\System\Session) -> c407d9e5feba19b91a25f0f8c64ad03e has been extended to Fri, 23 Feb 2024 18:15:55 +0000 extension length 3600 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\HandshakeMethod] 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\Api\Method\HandshakeMethod) -> Login6 Attempt, IP: 192.168.88.1 Time: 1708708555 User: PHONEUSER (3) 2024-02-23T17:15:55+00:00 [ampache] (Ampache\Module\System\Session) -> Unable to read value from key ca85cc0248a1c8c3bd76c3a8f0cdd9ec no data found 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Session) -> Session created: 062ed28657477466fabfcf445bd6f72a 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Method\HandshakeMethod) -> Login Success, passphrase matched 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Session) -> fb0f9f50a64b68342db1c0a7d2ad02e6da983173fea1fc4171e1f1795d8a9e7d has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\UserMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats random album 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats highest 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats newest 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats flagged 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats recent 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats frequent 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\PlaylistsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\PlaylistsMethod] 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:56+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:15:56+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:56 +0000 extension length 3600 2024-02-23T17:15:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:57+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:15:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:57+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:15:57+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:15:57+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:15:57+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:57 +0000 extension length 3600 2024-02-23T17:15:57+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:57 +0000 extension length 3600 2024-02-23T17:15:58+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:15:58 +0000 extension length 3600 2024-02-23T17:16:00+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:00+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [062ed28657477466fabfcf445bd6f72a] 2024-02-23T17:16:00+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\GoodbyeMethod] 2024-02-23T17:16:00+00:00 [PHONEUSER] (Ampache\Module\Api\Method\GoodbyeMethod) -> Goodbye Received from 3 192.168.88.1 :: 062ed28657477466fabfcf445bd6f72a 2024-02-23T17:16:00+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 062ed28657477466fabfcf445bd6f72a has been extended to Fri, 23 Feb 2024 18:16:00 +0000 extension length 3600 2024-02-23T17:16:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:16:23 +0000 extension length 3600 2024-02-23T17:16:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:16:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708712183 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\HandshakeMethod] 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Method\HandshakeMethod) -> Login6 Attempt, IP: 192.168.88.1 Time: 1708708585 User: PHONEUSER (3) 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Session) -> Unable to read value from key ca85cc0248a1c8c3bd76c3a8f0cdd9ec no data found 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Session) -> Session created: 88c88427996c1cc57f9fe82614c72fba 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Method\HandshakeMethod) -> Login Success, passphrase matched 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Session) -> 3e0f7af1c7d9b33ccdd1495a0504877751b4cffc12bd756bd6ab6d48594fcc97 has been extended to Fri, 23 Feb 2024 18:16:25 +0000 extension length 3600 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\UserMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:25 +0000 extension length 3600 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats flagged 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:25 +0000 extension length 3600 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats random album 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats highest 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query SQL: SELECT MIN(`rating`.`object_id`) AS `id`, ROUND(AVG(`rating`.`rating`), 2) AS `rating`, COUNT(DISTINCT(`rating`.`user`)) AS `count` FROM `rating` WHERE `object_type` = 'album' GROUP BY `rating`.`object_id` ORDER BY `rating` DESC, `count` DESC, `date` DESC LIMIT 40 [] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Dba) -> Error_query MSG: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ampache.rating.date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:25 +0000 extension length 3600 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats frequent 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\PlaylistsMethod] 2024-02-23T17:16:25+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats recent 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:26 +0000 extension length 3600 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StatsMethod] 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\Api\Method\StatsMethod) -> stats newest 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:26 +0000 extension length 3600 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:26 +0000 extension length 3600 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:26 +0000 extension length 3600 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:16:26+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:16:26+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:26 +0000 extension length 3600 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\PingMethod] 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:41 +0000 extension length 3600 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\System\Session) -> Writing to 88c88427996c1cc57f9fe82614c72fba with expiration 1708712201 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\Api\Method\PingMethod) -> Ping6 Received from: 192.168.88.1 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:41 +0000 extension length 3600 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:16:41+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:16:41+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\UserMethod] 2024-02-23T17:16:41+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:16:41 +0000 extension length 3600 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:17:17+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\AlbumSongsMethod] 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:17:17+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\PlaylistsMethod] 2024-02-23T17:17:17+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:17 +0000 extension length 3600 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:17+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:17+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:17 +0000 extension length 3600 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StreamMethod] 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\Application\ApplicationRunner) -> Found handler "Ampache\Module\Application\Image\ShowAction" for action "show" 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> Session created: af3307628251fd675903e418e080f747 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:18 +0000 extension length 3600 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:18 +0000 extension length 3600 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:18+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StreamMethod] 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> Session created: 5a5ec8e2b4e87fc736d50a0d616e2f53 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:18 +0000 extension length 3600 2024-02-23T17:17:18+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:18 +0000 extension length 3600 2024-02-23T17:17:19+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:19+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:17:19+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StreamMethod] 2024-02-23T17:17:19+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> Session created: cb2d41ff61b35024435d76c12c97e549 2024-02-23T17:17:19+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:19 +0000 extension length 3600 2024-02-23T17:17:19+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:19 +0000 extension length 3600 2024-02-23T17:17:21+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:21+00:00 [ampache] (Ampache\Module\Api\Authentication\Gatekeeper) -> API session [88c88427996c1cc57f9fe82614c72fba] 2024-02-23T17:17:21+00:00 [PHONEUSER] (Ampache\Module\Api\ApiHandler) -> API function [Ampache\Module\Api\Method\StreamMethod] 2024-02-23T17:17:21+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> Session created: 93b5bf4d7023552964e119758abd8529 2024-02-23T17:17:21+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:21 +0000 extension length 3600 2024-02-23T17:17:21+00:00 [PHONEUSER] (Ampache\Module\System\Session) -> 88c88427996c1cc57f9fe82614c72fba has been extended to Fri, 23 Feb 2024 18:17:21 +0000 extension length 3600 2024-02-23T17:17:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:23+00:00 [ampache] (Ampache\Module\System\Dba) -> Database connection... 2024-02-23T17:17:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> 0nrlimps923gmjq6abcd8tlftt has been extended to Fri, 23 Feb 2024 18:17:23 +0000 extension length 3600 2024-02-23T17:17:23+00:00 [PCUSER-ADMIN] (ajax.server) -> Called for page: {index} 2024-02-23T17:17:23+00:00 [PCUSER-ADMIN] (Ampache\Module\System\Session) -> Writing to 0nrlimps923gmjq6abcd8tlftt with expiration 1708712243 ```

I think I will start an issue on the Ampache side to see if the server is configured correctly upstream.

icefields commented 4 months ago

yes, that's what I was going to suggest, try to figure this out with the Ampache developers, they're usually very responsive.

I have one last test I suggest you to try, can you call this url from your browser and tell me the result? http://<your.ampache.server>/server/json.server.php?action=ping

you should either get something like this or a 404.

{
    "server": "6.2.1",
    "version": "6.2.1",
    "compatible": "350001"
}
BlueNalgene commented 4 months ago

Yes, my result is as expected:

server | "6.2.1"
version | "6.2.1"
compatible | "350001"
BlueNalgene commented 4 months ago

I downloaded Android Studio and emulated the app, and I can generate the following error:

Playback error
                                                                                                      androidx.media3.exoplayer.ExoPlaybackException: Source error
                                                                                                          at androidx.media3.exoplayer.ExoPlayerImplInternal.handleIoException(ExoPlayerImplInternal.java:701)
                                                                                                          at androidx.media3.exoplayer.ExoPlayerImplInternal.handleMessage(ExoPlayerImplInternal.java:673)
                                                                                                          at android.os.Handler.dispatchMessage(Handler.java:102)
                                                                                                          at android.os.Looper.loopOnce(Looper.java:205)
                                                                                                          at android.os.Looper.loop(Looper.java:294)
                                                                                                          at android.os.HandlerThread.run(HandlerThread.java:67)
                                                                                                      Caused by: androidx.media3.datasource.HttpDataSource$InvalidResponseCodeException: Response code: 302
                                                                                                          at androidx.media3.datasource.DefaultHttpDataSource.open(DefaultHttpDataSource.java:436)
                                                                                                          at androidx.media3.datasource.DefaultDataSource.open(DefaultDataSource.java:272)
                                                                                                          at androidx.media3.datasource.StatsDataSource.open(StatsDataSource.java:86)
                                                                                                          at androidx.media3.exoplayer.source.ProgressiveMediaPeriod$ExtractingLoadable.load(ProgressiveMediaPeriod.java:1029)
                                                                                                          at androidx.media3.exoplayer.upstream.Loader$LoadTask.run(Loader.java:417)
                                                                                                          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                                                                                                          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:644)
                                                                                                          at java.lang.Thread.run(Thread.java:1012)

It looks like the problem is upstream from this app. I will follow up with this.

icefields commented 4 months ago

that's interesting, you might have a problem redirecting to the url of the stream. You're also getting a source error, that means the player cannot read that url (obviously, due to the failed redirect). The stream url is in fact a redirect url, it looks like this: <serverUrl>/json.server.php?action=stream&auth=<authToken>&type=song&id=<mediaId>&bitrate=<bitrate> Ampache will parse that and generate and redirect you to something like this: <serverUrl>/play/index.php?ssid=<authToken>&type=song&oid=21863&uid=2&player=api&name=songFileName.mp3

Looks like your server is facing issues with redirecting urls (in general maybe). This is supported by the fact that you have no trouble playing directly from the website (no redirection). I would take a look at the general server configuration.

BlueNalgene commented 4 months ago

I'm linking the Ampache discussion thread here: https://github.com/ampache/ampache/discussions/3839

icefields commented 4 months ago

since we moved the issue to Ampache, and there's already a ticket to handle those error responses graciously, I'm going to close this thread

icefields commented 3 months ago

@BlueNalgene hello, would you mind testing the new release(v0.40-rc1)? It's not going to fix your backend issues, but I worked on some workarounds for when the app doesn't receive the User object from the server, and other edge cases. I added some safety nets and the app should now be able to handle some missing data from the server (at least in theory, I can't really test every single edge case).

LINK: https://github.com/icefields/Power-Ampache-2/releases/tag/v0.40-rc1

BlueNalgene commented 3 months ago

Acknowledged in both locations.

Apologies for the late reply. I've been AFK doing field work. I might be a tad slow to reply while I get caught back up on desk work and my teaching materials.

I'm currently testing the release. I get some friendly error messages that let me know that files cannot be played due to connection/corrupt/server issues. It looks likes when playing an album, it tries to loop through each song to play, and it issues an error for each one. I assume this is expected behavior. If not, I can open another issue.

icefields commented 3 months ago

no worries at all! I'd be interested in seeing what's the stacktrace of the error after a song is not played and skipped, because I think I know what's throwing the exception. The error that you told me sounds like it's been thrown by the player service, the hints are the text of the error, and the fact that it automatically skips to the next song (I added skip on error recently). Unfortunately this can mean that the issue is that the player cannot read the song from the server, ie. the server is not streaming, or the file is in a format that the player doesn't recognize (are you playing mp3s?), or if you downloaded the file, this could be malformed (I don't think that is the case). If it's throwing an exception it should be logged by the error logger, would it be ok for you to enable remote logging? It's in Settings. If you haven't already.

BlueNalgene commented 3 months ago

The remote debugging was already enabled. I am running and playing a song right now at ~1430 UTC time in case you have a deluge of other reports that buried the previous one. Let me know what you see.

icefields commented 3 months ago

@BlueNalgene Thanks so much for providing the time in UTC. I see a succession of identical stacktraces between 2024-04-04 14:31:45 and 2024-04-04 14:52:11 UTC. I'm going to copy a sample below. The error is Invalid response code 302 - Found , you are getting a 302 response from the server. I'll keep investigating, but we can almost confirm that the issue is on the server side.

 --------------------------------------------
2024-04-04  14:34:32  
0.40-rc1 (40) - DB: 80
onPlayerError Invalid response code 302 - Found - PlaybackException 
This track cannot be played. The issue could be related to your connection, the file might be corrupt, or issues with your server.
If it's an offline track please try delete and re-download
 {"isRecoverable":false,"mediaPeriodId":{"adGroupIndex":-1,"adIndexInAdGroup":-1,"nextAdGroupIndex":-1,"periodUid":{"first":{},"second":{}},"windowSequenceNumber":8},"rendererFormatSupport":4,"rendererIndex":-1,"type":0,"errorCode":2004,"timestampMs":1703345756,"cause":{"headerFields":{"null":["HTTP/1.1 302 Found"],"Access-Control-Allow-Origin":["*"],"Connection":["Keep-Alive"],"Content-Length":["0"],"Content-Type":["application/json; charset\u003dUTF-8"],"Date":["Thu, 04 Apr 2024 14:34:32 GMT"],"Keep-Alive":["timeout\u003d5, max\u003d88"],"Location":["http://bluenalgene.com/ampache/play/index.php?ssid\u003dc68e7b3a7ff40f11833652b4906d0847\u0026type\u003dsong\u0026oid\u003d80815\u0026uid\u003d3\u0026client\u003dapi\u0026player\u003dapi\u0026name\u003dAgalloch%20-%20A%20Desolation%20Song.mp3"],"Server":["Apache/2.4.57 (Ubuntu)"],"X-Android-Received-Millis":["1712241272201"],"X-Android-Response-Source":["NETWORK 302"],"X-Android-Selected-Protocol":["http/1.1"],"X-Android-Sent-Millis":["1712241272026"]},"responseBody":[],"responseCode":302,"responseMessage":"Found","dataSpec":{"absoluteStreamPosition":0,"flags":6,"httpMethod":1,"httpRequestHeaders":{"Icy-MetaData":"1"},"length":-1,"position":0,"uri":{},"uriPositionOffset":0},"type":1,"reason":2004,"detailMessage":"Response code: 302","stackTrace":[{"declaringClass":"androidx.media3.datasource.DefaultHttpDataSource","fileName":"DefaultHttpDataSource.java","lineNumber":436,"methodName":"open"},{"declaringClass":"androidx.media3.datasource.DefaultDataSource","fileName":"DefaultDataSource.java","lineNumber":275,"methodName":"open"},{"declaringClass":"androidx.media3.datasource.StatsDataSource","fileName":"StatsDataSource.java","lineNumber":86,"methodName":"open"},{"declaringClass":"androidx.media3.exoplayer.source.ProgressiveMediaPeriod$ExtractingLoadable","fileName":"ProgressiveMediaPeriod.java","lineNumber":1029,"methodName":"load"},{"declaringClass":"androidx.media3.exoplayer.upstream.Loader$LoadTask","fileName":"Loader.java","lineNumber":421,"methodName":"run"},{"declaringClass":"java.util.concurrent.ThreadPoolExecutor","fileName":"ThreadPoolExecutor.java","lineNumber":1145,"methodName":"runWorker"},{"declaringClass":"java.util.concurrent.ThreadPoolExecutor$Worker","fileName":"ThreadPoolExecutor.java","lineNumber":644,"methodName":"run"},{"declaringClass":"java.lang.Thread","fileName":"Thread.java","lineNumber":1012,"methodName":"run"}]},"detailMessage":"Source error","stackTrace":[{"declaringClass":"androidx.media3.exoplayer.ExoPlayerImplInternal","fileName":"ExoPlayerImplInternal.java","lineNumber":713,"methodName":"handleIoException"},{"declaringClass":"androidx.media3.exoplayer.ExoPlayerImplInternal","fileName":"ExoPlayerImplInternal.java","lineNumber":685,"methodName":"handleMessage"},{"declaringClass":"android.os.Handler","fileName":"Handler.java","lineNumber":102,"methodName":"dispatchMessage"},{"declaringClass":"android.os.Looper","fileName":"Looper.java","lineNumber":233,"methodName":"loopOnce"},{"declaringClass":"android.os.Looper","fileName":"Looper.java","lineNumber":344,"methodName":"loop"},{"declaringClass":"android.os.HandlerThread","fileName":"HandlerThread.java","lineNumber":67,"methodName":"run"}]}

--------------------------------------------
2024-04-04  14:34:32  
0.40-rc1 (40) - DB: 80
androidx.media3.exoplayer.ExoPlaybackException: Source error
    at androidx.media3.exoplayer.ExoPlayerImplInternal.handleIoException(ExoPlayerImplInternal.java:713)
    at androidx.media3.exoplayer.ExoPlayerImplInternal.handleMessage(ExoPlayerImplInternal.java:685)
    at android.os.Handler.dispatchMessage(Handler.java:102)
    at android.os.Looper.loopOnce(Looper.java:233)
    at android.os.Looper.loop(Looper.java:344)
    at android.os.HandlerThread.run(HandlerThread.java:67)
Caused by: androidx.media3.datasource.HttpDataSource$InvalidResponseCodeException: Response code: 302
    at androidx.media3.datasource.DefaultHttpDataSource.open(DefaultHttpDataSource.java:436)
    at androidx.media3.datasource.DefaultDataSource.open(DefaultDataSource.java:275)
    at androidx.media3.datasource.StatsDataSource.open(StatsDataSource.java:86)
    at androidx.media3.exoplayer.source.ProgressiveMediaPeriod$ExtractingLoadable.load(ProgressiveMediaPeriod.java:1029)
    at androidx.media3.exoplayer.upstream.Loader$LoadTask.run(Loader.java:421)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:644)
    at java.lang.Thread.run(Thread.java:1012)