Bug 505498

Created attachment 182208 [details]
Manually edited and working channel database of Kaffeine

SUMMARY
The channel number of a soon-to-broadcast French DVB-T channel can not be edited. Kaffeine immediately crashes on clicking 'OK' on the channel edition window. This bug affects the latest release of Kaffeine: 2.0.19

Whether Kaffeine's installation comes from the Arch Linux official repositories or Flatpak (Flathub) the bug is present.

STEPS TO REPRODUCE
*For the ease of reproduction I will give instructions for the Flatpak version.*

1. Install Kaffeine's latest Flatpak package `flatpak install org.kde.kaffeine`
2. Scan DVB-T channels, add all selected channels or all filtered channels (on the right pane) to the saved channels list (on the left pane)
3. Click 'OK' (to save)

*Kaffeine at the time being affects channels number by the order the channels were scanned*

4. Edit / correct the 'NOVO19' channel's number to '19' via the channel edition form
5. Click 'OK' (to save), Kaffeine immediately crashes

OBSERVED RESULT
Kaffeine crashes and upon restart the channel number change hasn't been saved.

EXPECTED RESULT
Kaffeine shall not crash and the channel number change shall have been saved.

SOFTWARE/OS VERSIONS
Operating System: Arch Linux
KDE Plasma Version: 6.3.5
KDE Frameworks Version: 6.14.0
Qt Version: 6.9.1
Kernel Version: 6.12.33-1-lts (64-bit)
Graphics Platform: X11

ADDITIONAL INFORMATION
DVB-T Device: DiBcom 7000PC Hauppauge WinTV-NOVA-TD (Dual tuner with Diversity mode)

A few channels have changed of frequencies and new channels have been attributed frequencies of former channels in France recently.
I had done a full rescan of the channels from scratch and was ordering correctly the channels when I noticed one could not be edited.

The 'NOVO19' channel is a new channel, its broadcast will debut on the 1st of September 2025 however its frequency is already reserved.

WORKAROUND
*For the ease of comprehension I will use the standard location of Kaffeine's configuration files in the following steps.*
**The Kaffeine's user configuration directory used by the Flatpak package can be found under this location: `~/.var/app/org.kde.kaffeine/data/kaffeine/`**

1. Edit the `~/.local/share/kaffeine/sqlite.db` file with the SQLite editor of your choice

2. Manually change the channel number to '19' (make sure no other channel uses already this number)

3. Save the file

4. Run Kaffeine, the 'NOVO19' channel now has the number '19'

POSSIBLE CAUSE

In the `~/.local/share/kaffeine/sqlite.db` file, all channels have an AudioPid set to a positive integer but not the 'NOVO19' channel which has has an AudioPid value of '-1'.

ATTACHMENT

Attached is a working `sqlite.db` file, which is the result of a full scan from scratch with channel numbers reassignated correctly with Kaffeine's UI, exception of the 'NOVO19' channel which had its channel number corrected as described in the workaround above. The scan has been performed from Orléans, France (https://www.tvnt.net/forum/45-loiret-t12707.html).