Language support in Postgres

[PostMidnight]

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.

[barisusakli]

@BenLubar

[BenLubar]

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