nodebb-plugin-dbsearch icon indicating copy to clipboard operation
nodebb-plugin-dbsearch copied to clipboard

Language support in Postgres

Open PostMidnight opened this issue 6 years ago • 2 comments

Hi Developers,

The plugin won't support any other languages but English when used in conjunction with Postgress.

My current setup: NodeBB latest master, and Postgres v10.2.

To reproduce: Set the index language in ACP and initiating indexing: that will crashes NodeBB.

The reason: postgres.js: line 75: note the function call had "language" spelled incorrectly.

Fixing the spelling mistake does not cure the issue. The revised code failed in line 81 of postgres.js db.pool.query('DROP INDEX "idx__searchtopic__content"', next);

with err = Error: index "idx__searchtopic__content" does not exist at Connection.parseE.

Unfortunately, this issue pertains to the implementation of indexing in Postgress I know very little about.

Any help will be highly appreciated.

PostMidnight avatar Apr 22 '19 05:04 PostMidnight

@BenLubar

barisusakli avatar Apr 22 '19 13:04 barisusakli

If you restart (as in, either of the buttons in the admin panel) your NodeBB forum it should recreate the index: https://github.com/barisusakli/nodebb-plugin-dbsearch/blob/master/lib/postgres.js#L23

BenLubar avatar Apr 24 '19 18:04 BenLubar