Editing a smart playlist with a date based search term results in SQL error

[Offerel]

• I have checked the FAQ for answers.
• I have checked the Changelog that the issue is not already fixed.
• I believe this issue is a bug, and not a general technical issue, question or feature requests that can be discussed on the forum.

Describe the bug
I think there is a bug with Intelligent Playlists. When i try to edit my playlist, i get a error message:

Unable to execute SQL query: Kein Abfrage Der Datensatz konnte nicht abgeholt werden<br />Failed query: SELECT ROWID,title, album, artist, albumartist, track, disc, year, originalyear, genre, compilation, composer, performer, grouping, comment, lyrics, artist_id, album_id, song_id, beginning, length, bitrate, samplerate, bitdepth, source, directory_id, url, filetype, filesize, mtime, ctime, unavailable, fingerprint, playcount, skipcount, lastplayed, lastseen, compilation_detected, compilation_on, compilation_off, compilation_effective, art_automatic, art_manual, effective_albumartist, effective_originalyear, cue_path, rating, acoustid_id, acoustid_fingerprint, musicbrainz_album_artist_id, musicbrainz_artist_id, musicbrainz_original_artist_id, musicbrainz_album_id, musicbrainz_original_album_id, musicbrainz_recording_id, musicbrainz_track_id, musicbrainz_disc_id, musicbrainz_release_group_id, musicbrainz_work_id FROM songs WHERE (genre LIKE '%Rock%' AND genre LIKE '%Soundtrack%' AND DATE(lastplayed, 'unixepoch', 'localtime') LIKE '%DATE(949363200, 'unixepoch', 'localtime')%') AND unavailable = 0 ORDER BY albumartist DESC

Additionally, I miss a way to specify something like not played in the last x - months. I think this was possible some time ago, but im not sure.

To Reproduce

• Create a intelligent playlist
• Edit the playlist

Expected behavior
No error message

Screenshots:
Screenshot

System Information:

• Operating system: Manjaro Linux
• Strawberry Version: 3.0.16

Additional context
It seems, the compare argument is empty? I dont know, if this is a symptom or part of the issue...

[jonaski]

This looks like the same as https://forum.strawberrymusicplayer.org/topic/1053/sql-failure-on-my-smart-playlists, I can't reproduce this issue.

[Offerel]

OK. What do you need to reproduce this? Date is not 1 (as in the example), but the single quotes are also in my example.

[SerializedSmartPlaylists]
songs\1\data=@ByteArray(\0\0\0\0\x2\x11\0\0\0\x14\x2\0)
songs\1\name=Newest tracks
songs\1\type=1
songs\10\data=@ByteArray(\0\0\0\0\0\x3\0\0\0\x14\x2\x1)
songs\10\name=Dynamic random mix
songs\10\type=1
songs\11\data=@ByteArray(\0\0\0\x3\b\x1\0\0\0\n\0\0\0\0\b\0R\0o\0\x63\0k\0\0\0\0\x1\0\b\x1\0\0\0\n\0\0\0\0\x14\0S\0o\0u\0n\0\x64\0t\0r\0\x61\0\x63\0k\0\0\0\0\x1\0\x15\x5\0\0\0\x4\0\0\0\0\0\x38\xe6\x8d\x80\0\0\0\0\x1\0\x1\x2\0\0\x2X\0\x1)
songs\11\name=AutoPhone
songs\11\type=1
songs\2\data=@ByteArray(\0\0\0\0\0\x3\0\0\0\x32\x2\0)
songs\2\name=50 random tracks
songs\2\type=1
songs\3\data=@ByteArray(\0\0\0\x1\x13\x4\0\0\0\x2\0\0\0\0\0\0\0\0\0\x1\0\0\x3\0\0\0\x14\0\0)
songs\3\name=Ever played
songs\3\type=1
songs\4\data=@ByteArray(\0\0\0\x1\x13\x6\0\0\0\x2\0\0\0\0\0\0\0\0\0\x1\0\0\x3\0\0\0\x14\0\0)
songs\4\name=Never played
songs\4\type=1
songs\5\data=@ByteArray(\0\0\0\0\x2\x15\0\0\0\x14\x2\0)
songs\5\name=Last played
songs\5\type=1
songs\6\data=@ByteArray(\0\0\0\0\x2\x13\0\0\0\x14\x2\0)
songs\6\name=Most played
songs\6\type=1
songs\7\data=@ByteArray(\0\0\0\0\x2\x16\0\0\0\x14\x2\0)
songs\7\name=Favourite tracks
songs\7\type=1
songs\8\data=@ByteArray(\0\0\0\x2\x16\x5\0\0\0\x6\0?\xe0\0\0\0\0\0\0\0\0\0\0\x1\0\x14\x4\0\0\0\x2\0\0\0\0\x4\0\0\0\0\x1\0\x2\x14\0\0\0\x14\x1\0)
songs\8\name=Least favourite tracks
songs\8\type=1
songs\9\data=@ByteArray(\0\0\0\0\x1\x1\xff\xff\xff\xff\x2\0)
songs\9\name=All tracks
songs\9\type=1
songs\size=11
songs_version=3

All is fine, until the point, when i add a condition "Last played".