[PATCH] pgweb: Search: bugfix: replace sites.baseurl with sites.hostname - Mailing list pgsql-www

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