Im getting an error when trying to use search:

2025-09-03T18:50:04.315Z [4567/1274390] - error: GET /api/search?_=1756925050948
error: operator does not exist: bigint = text
    at .../NodeBB/node_modules/pg-pool/index.js:45:11
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async exports.search (.../NodeBB/node_modules/nodebb-plugin-dbsearch/lib/postgres.js:94:15)
    at async search.filterSearchQuery [as method] (.../NodeBB/node_modules/nodebb-plugin-dbsearch/lib/dbsearch.js:201:29)
    at async fireMethod (.../NodeBB/src/plugins/hooks.js:170:11)
    at async Object.fireFilterHook [as filter] (.../NodeBB/src/plugins/hooks.js:177:12)
    at async Hooks.fire (.../NodeBB/src/plugins/hooks.js:106:17)
    at async doSearch (.../NodeBB/src/search.js:66:19)
    at async Promise.all (index 1)
    at async searchInContent (.../NodeBB/src/search.js:109:19)

Im using Ubuntu 24.04, PostgreSQL 17.6, nodebb-plugin-dbsearch 6.3.1

sweetp did this start after the upgrade?

Julian tbh, Im not 100% sure. But I think so. After each upgrade I usually quickly click through various parts of the UI to see if my custom theme needs any updates. And I would have noticed this after the 4.4.6 upgrade

sweetp I can reproduce it so I will take a look.

sweetp install nodebb-plugin-dbsearch@6.3.2 and run ./nodebb upgrade again, the issue should be resolved.

baris yup, that fixed it, thanks!

E-Mail notifications about new chat message doesn’t work after upgrading to 4.5.0 . DB MongoDB version v7.0.23

Notifications is enabled, but not function properly after the upgrade. Other notifications work fine, so far, so good…

Ah, it was partly my bad, nevertheless chat notification seems to be slowed down a bit. As if a queue or polling has been implemented, with a delay of 2-3 minutes. Is queue implemented for this kind of messages for now ?

Twissell hmm, chat notifications have always been delayed by a minute or so. Maybe less.

It is done so that subsequent messages sent within the same rough time frame can be batched together.

This is less of an issue with notifications on site, but can be an issue when you are emailed for every single chat message.

Hi everyone! I’m trying to upgrade from v4.4.6 to v4.5.2 and after connecting to Redis, it just stucks and I don’t know where yet. There is no error. The HTTP server doesn’t start. Our forum has a lot of users, uploads, posts. We had several issues in the past. I will try to figure out what’s wrong, but if anyone have an idea what might be the problem in v4.5.x, it would help me. Thanks, Tomas