search

wbstack / deploy

Cloud and Kubernetes configuration for deployment for wbstack.com. You'll want to look at the wikibase.cloud deploy repository soon!
12 stars 6 forks source link

Unify emacswiki in interwiki tables #22

Open addshore opened 3 years ago

addshore commented 3 years ago

A tiny bit of leftover fallout from the 1.35 update was that the interwiki table for old side will now be slightly out of date https://github.com/wbstack/private/issues/118

This relates to the following change

From (UNHEX('656D61637377696B69'), 'https://www.emacswiki.org/cgi-bin/wiki.pl?$1', '', UNHEX(''), 0, 0),
To (UNHEX('656D61637377696B69'), 'https://www.emacswiki.org/emacs/$1', '', UNHEX(''), 0, 0)

A query that can fix this is:

UPDATE mwdb_8a8233711a.mwt_cd26270ed7_interwiki
SET iw_url = 'https://www.emacswiki.org/emacs/$1'
WHERE iw_prefix = UNHEX('656D61637377696B69')

This needs to be run on all sites to bring them back in line