Malformed MATCH expression

[sttrebo]

Joplin 2.2.1 (prod, win32)

Client ID: e0e198d14ded4d22b53bdf20d78bf254
Sync Version: 2
Profile Version: 39
Keychain Supported: No

Revision: 4e0ff1f

portable version running on windows10 pc

just started getting an error 'some items cannot be syncronized'

• SubNotebooks.png (38f1a60029a2407f933f7243a1a4eadb) could not be uploaded: File not found: C:/apps/Joplin/JoplinProfile/resources/38f1a60029a2407f933f7243a1a4eadb.pngRetry

when i look at the log file i see this:
2021-07-11 08:41:21: "Cannot execute MATCH query: 38f1a60029a2407f933f7243a1a4eadb": Error: SQLITE_ERROR: malformed MATCH expression: ["38f1a60029a2407f933f7243a1a4eadb""]:
SELECT
notes_fts.id,
notes_fts.title,
offsets(notes_fts) AS offsets, matchinfo(notes_fts, 'pcnalx') AS matchinfo,
notes_fts.user_created_time,
notes_fts.user_updated_time,
notes_fts.is_todo,
notes_fts.todo_completed,
notes_fts.parent_id
FROM notes_fts
WHERE 1 AND notes_fts MATCH ?: "38f1a60029a2407f933f7243a1a4eadb"""

looking at the SQlite database, i see this:

this is the line from my sync report:
4,38f1a60029a2407f933f7243a1a4eadb,1609606501774,0,

i am currently syncing to a self-hosted nextcloud instance. i've checked both devices and this resource file is nowhere and af far as I can tell, it is not referenced in any of my notes either. any ideas on how to fix this?

[roman_r_m]

The malformed match error is probably unrelated, this is what happens if you search for something like 38f1a60029a2407f933f7243a1a4eadb" (note the quote symbol at the end)

It is still a bug, but I can't see how it could have broken synchronization.

[sttrebo]

thanks for taking a look. but since none of my notes seem to be referencing this resource (i've tried 'goto anything' and also exporting everything the markdown and doing a full-text search), i thoght it was a bit odd.
i just went into the note attachment viewer window and deleted them. all good now.

[roman_r_m]

From the name of the resource is looks like an image that is included in the welcome notes.