'Now Playing' filter displays no games

[git-hub-user-71]

RomM version
4.6.1

Describe the bug
When filtering a search to display games that are check as 'Now Playing', no games are displayed.

To Reproduce
Steps to reproduce the behavior:

1. Select games as 'Now Playing'.
2. Open the Search window from the menu, open the Filter menu, scroll down and select 'Now Playing' from the 'Status' dropdown.
3. the filter menu disappears, the filter menu stays (seems odd).
4. No matching games are shown.

Expected behavior
Games that have been selected as 'Now Playing', should display.

Screenshots
Video Provided at: https://discord.com/channels/1138838206532554853/1467629939695026237

Server (please complete the following information):

• RomM, on Portainer, on Synology NAS

Client (please complete the following information):

• Device: PC
• OS: Windows 11
• Browser: Firefox & Edge
• Version: 147.0.2 (Firefox)

Log Details
The steps shown above, provide the following items in the DB log:

2026-02-02 03:02:39.699 UTC [118] ERROR:  invalid input value for enum romuserstatus: "Now Playing"

2026-02-02 03:02:39.699 UTC [118] CONTEXT:  unnamed portal parameter $7 = '...'

2026-02-02 03:02:39.699 UTC [118] STATEMENT:  SELECT anon_1.letter AS anon_1_letter, min(anon_1.position - $1::INTEGER) AS position 

    FROM (SELECT roms.id AS id, roms.name AS name, SUBSTRING(trim(REGEXP_REPLACE(lower(roms.name), $2::VARCHAR, $3::VARCHAR, 'i')) FROM $4::INTEGER FOR $5::INTEGER) AS letter, row_number() OVER (ORDER BY trim(REGEXP_REPLACE(lower(roms.name), $2::VARCHAR, $3::VARCHAR, 'i'))) AS position 

    FROM roms LEFT OUTER JOIN rom_user ON rom_user.rom_id = roms.id AND rom_user.user_id = $6::INTEGER 

    WHERE rom_user.status = $7 AND rom_user.hidden IS false ORDER BY trim(REGEXP_REPLACE(lower(roms.name), $8::VARCHAR, $9::VARCHAR, 'i')) ASC) AS anon_1 GROUP BY anon_1.letter ORDER BY anon_1.letter

[PowerHeinz]

Hi folks, I can confirm the exact same bug on MariaDB (not Postgres). In my case the API/UI returns 200 but an empty result set (no DB exception), because the query compares an invalid value against an ENUM.

RomM version: 4.6.1
DB: MariaDB 12.1.2

Schema (rom_user)

backlogged and now_playing are boolean columns, while status is an ENUM with only these values:
INCOMPLETE, FINISHED, COMPLETED_100, RETIRED, NEVER_PLAYING

Output:

DESCRIBE rom_user;
...
backlogged  tinyint(1) NOT NULL
now_playing tinyint(1) NOT NULL
status enum('INCOMPLETE','FINISHED','COMPLETED_100','RETIRED','NEVER_PLAYING') NULL

Actual SQL executed when filtering “Backlogged”

Captured via mysql.general_log while applying the “Backlogged” filter in the Search UI:

SELECT roms.id, ... 
FROM roms 
LEFT OUTER JOIN rom_user ON rom_user.rom_id = roms.id AND rom_user.user_id = 1
WHERE rom_user.status = 'Backlogged' AND rom_user.hidden IS false
ORDER BY ...
LIMIT 0, 72;

This explains the behavior: Backlogged/Now Playing are checkboxes (booleans), not enum status values, but the backend/UI filter maps them to rom_user.status = 'Backlogged' (and similarly for “Now Playing”), which can never match the enum. On MariaDB this yields an empty list; on Postgres it can raise an invalid enum error.

Expected mapping:
• Backlogged → rom_user.backlogged IS true
• Now Playing → rom_user.now_playing IS true
• Status dropdown values → rom_user.status IN (...)

Happy to provide more logs if needed.

[jhstatewide]

I ran into similar behavior when wanting to build a search for games I've marked backlogged. No matter what I do, it doesn't seem to have any matches.