clld / phoible

PHOIBLE Online
http://phoible.org
Apache License 2.0
42 stars 13 forks source link

Broken URL #9

Closed bambooforest closed 9 years ago

bambooforest commented 9 years ago

http://phoible.org/parameters/D90087B832A91083C733048A0EA8614B#1/11/124

on the wikipedia "W" symbol, resolves to:

http://en.wikipedia.org//www.mediawiki.org/

xrotwang commented 9 years ago

This happens 47 times:

phoible=# select count(*) from parameter where jsondata like '%mediawiki%';
-[ RECORD 1 ]
count | 47
xrotwang commented 9 years ago

Fortunately it is very specific, so should be a simple db migration:

phoible=# select count(*) from parameter where jsondata = '{"wikipedia_url": "http://en.wikipedia.org//www.mediawiki.org/"}';
-[ RECORD 1 ]
count | 47