Content-Type: multipart/mixed; boundary="------------yF2LYHK1wneyBWixSe4KzTqx"
Message-ID: <3ee3217a-b014-7601-47f5-775428d1e39d@cmatte.me>
Date: Mon, 25 Oct 2021 18:19:49 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.2.0
Content-Language: en-US
To: pgsql-www@lists.postgresql.org
References: <21fbb020-83c6-33e5-9cfe-0aee56badf3e@cmatte.me>
 <CABUevExDQhiAwL7qAKR1=DFmrFVzb+zHKpfurUo8P78hoATe6A@mail.gmail.com>
From: =?UTF-8?Q?C=c3=a9lestin_Matte?= <celestin.matte@cmatte.me>
Subject: Re: [PATCH] pgweb: Search: bugfix: replace sites.baseurl with
 sites.hostname
In-Reply-To: 
 <CABUevExDQhiAwL7qAKR1=DFmrFVzb+zHKpfurUo8P78hoATe6A@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/3ee3217a-b014-7601-47f5-775428d1e39d%40cmatte.me>
Precedence: bulk

This is a multi-part message in MIME format.
--------------yF2LYHK1wneyBWixSe4KzTqx
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Hello,

> But short term, I believe the correct thing to do is to add the baseurl field to the table in the SQL file. I'll go push a patch taht does that.

This broke data.sql as baseurl is NOT NULL. Attached patch fixes that.
This might have also broken the crawler but I haven't installed it to test that.

Cheers,
-- 
Célestin Matte
--------------yF2LYHK1wneyBWixSe4KzTqx
Content-Type: text/x-patch; charset=UTF-8;
 name="0001-Fix-data.sql-after-addition-of-baseurl-in-52455885.patch"
Content-Disposition: attachment;
 filename*0="0001-Fix-data.sql-after-addition-of-baseurl-in-52455885.patc";
 filename*1="h"
Content-Transfer-Encoding: base64

RnJvbSAwZTg3NmE1MmNhZjcwZGZhOWYwYmMzYjZiYmYyNjY4YmUwMjU4ZmUyIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/Qz1DMz1BOWxlc3Rpbj0yME1hdHRl
Pz0gPGdpdGxhYkBjbWF0dGUubWU+CkRhdGU6IE1vbiwgMjUgT2N0IDIwMjEgMTg6MTY6NDgg
KzAyMDAKU3ViamVjdDogW1BBVENIXSBGaXggZGF0YS5zcWwgYWZ0ZXIgYWRkaXRpb24gb2Yg
YmFzZXVybCBpbiA1MjQ1NTg4NQoKLS0tCiB0b29scy9zZWFyY2gvc3FsL2RhdGEuc3FsIHwg
MTIgKysrKysrLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNiBpbnNlcnRpb25zKCspLCA2IGRl
bGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL3Rvb2xzL3NlYXJjaC9zcWwvZGF0YS5zcWwgYi90
b29scy9zZWFyY2gvc3FsL2RhdGEuc3FsCmluZGV4IDVlMTJlOWQyLi42NGJlMjQyOSAxMDA2
NDQKLS0tIGEvdG9vbHMvc2VhcmNoL3NxbC9kYXRhLnNxbAorKysgYi90b29scy9zZWFyY2gv
c3FsL2RhdGEuc3FsCkBAIC0xLDExICsxLDExIEBACi1JTlNFUlQgSU5UTyBzaXRlcyAoaWQs
IGhvc3RuYW1lLCBkZXNjcmlwdGlvbiwgcGFnZWNvdW50KQotIFZBTFVFUyAoMSwgJ3d3dy5w
b3N0Z3Jlc3FsLm9yZycsICdNYWluIFBvc3RncmVTUUwgV2Vic2l0ZScsIDApOworSU5TRVJU
IElOVE8gc2l0ZXMgKGlkLCBob3N0bmFtZSwgYmFzZXVybCwgZGVzY3JpcHRpb24sIHBhZ2Vj
b3VudCkKKyBWQUxVRVMgKDEsICd3d3cucG9zdGdyZXNxbC5vcmcnLCAnaHR0cHM6Ly93d3cu
cG9zdGdyZXNxbC5vcmcnLCAnTWFpbiBQb3N0Z3JlU1FMIFdlYnNpdGUnLCAwKTsKIAotSU5T
RVJUIElOVE8gc2l0ZXMgKGlkLCBob3N0bmFtZSwgZGVzY3JpcHRpb24sIHBhZ2Vjb3VudCkK
LSBWQUxVRVMgKDIsICd3d3cucGdhZG1pbi5vcmcnLCdwZ0FkbWluIElJSScsIDApOworSU5T
RVJUIElOVE8gc2l0ZXMgKGlkLCBob3N0bmFtZSwgYmFzZXVybCwgZGVzY3JpcHRpb24sIHBh
Z2Vjb3VudCkKKyBWQUxVRVMgKDIsICd3d3cucGdhZG1pbi5vcmcnLCAnaHR0cHM6Ly93d3cu
cGdhZG1pbi5vcmcnLCAncGdBZG1pbiBJSUknLCAwKTsKIAotSU5TRVJUIElOVE8gc2l0ZXMg
KGlkLCBob3N0bmFtZSwgZGVzY3JpcHRpb24sIHBhZ2Vjb3VudCkKLSBWQUxVRVMgKDMsICdq
ZGJjLnBvc3RncmVzcWwub3JnJywnSkRCQyBkcml2ZXInLCAwKTsKK0lOU0VSVCBJTlRPIHNp
dGVzIChpZCwgaG9zdG5hbWUsIGJhc2V1cmwsIGRlc2NyaXB0aW9uLCBwYWdlY291bnQpCisg
VkFMVUVTICgzLCAnamRiYy5wb3N0Z3Jlc3FsLm9yZycsICdodHRwczovL2pkYmMucG9zdGdy
ZXNxbC5vcmcnLCAnSkRCQyBkcml2ZXInLCAwKTsKIAogCiBJTlNFUlQgSU5UTyBzaXRlX2V4
Y2x1ZGVzIFZBTFVFUyAoMiwnXi9hcmNoaXZlcycpOwotLSAKMi4zMy4xCgo=
--------------yF2LYHK1wneyBWixSe4KzTqx--