Hello,
There is an issue in the sql files for search in pgweb, as schema.sql does not correspond to what is used in
functions.sql.
functions.sql uses sites.baseurl, which is not a field in schema.sql. I replaced it with sites.hostname, which I guess
isthe targeted field.
Without that patch, I get the following error when performing a search:
Traceback (most recent call last):
File "/srv/pgweb/local/pgweb/search/views.py", line 284, in search
'internal': include_internal,
psycopg2.errors.UndefinedColumn: column sites.baseurl does not exist
LINE 1: SELECT sites.id AS siteid, sites.baseurl, webpages.suburl, t...
^
QUERY: SELECT sites.id AS siteid, sites.baseurl, webpages.suburl, ts_rank_cd(fti,tsq) * relprio AS ts_rank_cd FROM
web
pages INNER JOIN sites ON webpages.site=sites.id WHERE fti @@ tsq AND site=1 AND (includeinternal OR NOT isinternal)
OR
DER BY ts_rank_cd(fti,tsq) * relprio DESC LIMIT 1000
CONTEXT: PL/pgSQL function site_search(text,integer,integer,text,boolean) line 21 at OPEN
Cheers,
--
Célestin Matte