[chaley]

Originally Posted by un_pogaz

Little bug report:
Impossible to create/edit new notes.
Probably Windows specific.

apsw.SQLError: SQLError: unknown function: unixepoch()

Spoiler:

calibre, version 6.26.0
ERREUR : Exception non gérée: <b>SQLError</b>:SQLError: unknown function: unixepoch()

calibre 6.26* embedded-python: True
Windows-10-10.0.19045-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19045')
Python 3.10.1
Windows: ('10', '10.0.19045', 'SP0', 'Multiprocessor Free')
Interface language: fr
Successfully initialized third party plugins: DeACSM (0, 0, 16) && LCPL Input (0, 0, 5) && Gather KFX-ZIP (from KFX Input) (2, 5, 0) && DeDRM (10, 0, 3) && Package KFX (from KFX Input) (2, 5, 0) && ACE (1, 1, 6) && Access Aide (0, 1, 15) && Action Chains (1, 18, 12) && Comments Cleaner (1, 12, 0) && Count Pages (1, 13, 2) && DOC Input (1, 0, 1) && Diaps Editing Toolbag (0, 4, 0) && Editor Chains (0, 9, 1) && Embed Comic Metadata (1, 6, 6) && EpubMerge (2, 16, 0) && EpubSplit (3, 6, 0) && Extract ISBN (1, 6, 0) && Find Duplicates (1, 10, 8) && Generate Cover (2, 3, 3) && KFX metadata reader (from KFX Input) (2, 5, 0) && KFX Input (2, 5, 0) && KePub Input (3, 6, 6) && KePub Metadata Reader (3, 4, 3) && KindleUnpack - The Plugin (0, 83, 1) && Kobo Books (1, 9, 2) && Kobo Utilities (2, 16, 10) && Manage Series (1, 5, 1) && Manga (0, 1, 0) && Markdown Output (1, 0, 3) && Mass Search-Replace (1, 7, 4) && Modify ePub (1, 8, 1) && OPDS Reader (2, 2, 1) && Obok DeDRM (10, 0, 3) && Open With (1, 8, 1) && Perrypedia (1, 8, 1) && Quality Check (1, 13, 6) && Reformat plugin (2, 4, 0) && Search The Internet (1, 10, 1) && View Manager (1, 10, 2) && Wiki Reader (2, 2, 1) && ePub Extended Metadata {Writer} (0, 10, 1) && ePub Extended Metadata {Reader} (0, 10, 1) && ePub Extended Metadata (0, 10, 1) && noosfere DB (1, 2, 0)
Traceback (most recent call last):
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\gui2\dialogs\edit_category_notes.py", line 324, in accept
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\gui2\dialogs\edit_category_notes.py", line 284, in commit
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\db\cache.py", line 88, in call_func_with_lock
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\db\cache.py", line 705, in set_notes_for
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\db\backend.py", line 983, in set_notes_for
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\db\notes\connect.py", line 246, in set_note
File "F:\Users\un_pogaz\Projet\GitHub\calibre\src\calib re\db\backend.py", line 376, in get
apsw.SQLError: SQLError: unknown function: unixepoch()

You need a new calibre binary. Use the beta or 6.27.

EDIT: I haven't yet tried 6.27. Doing that now.
EDIT 2: 6.27 works, as Kovid said it would.