Page MenuHomePhabricator

Many Battlestar wikis are broken
Closed, ResolvedPublic

Description

Only the English and German wikis are working correctly.

The other languages ('fr', 'zh', 'es', 'ms', 'tr', 'simple') all return errors on loading the main page.

http://simple.battlestarwiki.org/wiki/

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/www/users/bsgwiki/common/w/includes/db/DatabaseMysql.php on line 16
Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "MessageCache::loadFromDB(simple)". Database returned error "126: Incorrect key file for table './bsgwiki_simple/revision.MYI'; try to repair it (localhost)".

http://es.battlestarwiki.org/wiki/

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/www/users/bsgwiki/common/w/includes/db/DatabaseMysql.php on line 16
MediaWiki internal error.

Exception caught inside exception handler

http://fr.battlestarwiki.org/wiki/Accueil (slightly functional)

Erreur de la base de données
Une erreur de syntaxe de la requête dans la base de données est survenue. Ceci peut indiquer un bogue dans le logiciel. La dernière requête traitée par la base de données était :

    (Requête SQL cachée)

depuis la fonction « User::checkNewtalk ». La base de données a renvoyé l’erreur « 126 : Incorrect key file for table './bsgwiki_fr/user_newtalk.MYI'; try to repair it (localhost) ».

http://ms.battlestarwiki.org/wiki/

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/www/users/bsgwiki/common/w/includes/db/DatabaseMysql.php on line 16
Ralat pangkalan data
Ralat sintaks pertanyaan pangkalan data telah terjadi. Ini mungkin menandakan pepijat dalam perisian wiki ini. Pertanyaan pangkalan data yang terakhir ialah:

    (Pertanyaan SQL disorokkan)

daripada fungsi "MessageCache::loadFromDB(ms)". Pangkalan data memulangkan ralat "126: Incorrect key file for table './bsgwiki_ms/revision.MYI'; try to repair it (localhost)".

http://tr.battlestarwiki.org/wiki/Ana_sayfa

Veritabanı hatası
Veritabanı sorgu sözdizimi hatası oluştu. Bu yazılımdaki bir hatadan kaynaklanabilir. "Block::load" işlevinden denenen son sorgulama:

    (SQL gizli sorgu)

. Veritabanının rapor ettiği hata "126: Incorrect key file for table './bsgwiki_tr/ipblocks.MYI'; try to repair it (localhost)".

(tr has some pages working ok. e.g. http://tr.battlestarwiki.org/wiki/Sezon_1_%28Yeni%29 and http://tr.battlestarwiki.org/wiki/G%C3%BCncel_olaylar)

http://zh.battlestarwiki.org/w/index.php?title=%E9%A6%96%E9%A1%B5&variant=zh

数据库错误
发生了数据库查询语法错误,可能是由于软件自身的错误所引起。最后一次数据库查询指令是:

    (SQL查询已隐藏)

来自函数“Title::loadRestrictions”内。数据库返回错误“126: Incorrect key file for table './bsgwiki_zh/page_restrictions.MYI'; try to repair it (localhost)”。

The English and German sites have interwiki links to these other wikis, e.g. http://en.battlestarwiki.org/wiki/Maelstrom links to the Chinese language site.

This presents quite a problem, as we can not simply remove these codes from the family file, otherwise interwiki tools will fail to recognise these interwikis correctly, and we can not put them in Family.obsolete (recently split into Family.interwiki_removals and Family.interwiki_replacements) otherwise interwiki tools with recognise them as interwikis and remove them.

We would need to check with the community whether they want these interwikis removed, as they may be in the process of restoring/rebuilding the other language wikis.

If the community does not want the interwikis removed, we need to either

  1. add a new Family data attribute to hold codes which are interwikis and that should be ignored (and implement that), or
  2. fix the problems relating to loading interwikis crashing if the server's API cant be accessed and used.

Event Timeline

jayvdb raised the priority of this task from to Needs Triage.
jayvdb updated the task description. (Show Details)
jayvdb added a project: Pywikibot.
jayvdb added a subscriber: jayvdb.

We have a response via facebook: https://www.facebook.com/battlestarwiki/posts/10153114391814209

Those Wikis have been taken off line as there is no interest them to justify their continued existence.

It looks like the wikis were disabled some time between May and August 2014.

fwiw, the interwikimap still includes these languages

<?xml version="1.0"?>
<api>
  <query>
    <interwikimap>
      <iw prefix="4400" url="http://www.the4400wiki.org/$1" />
      <iw prefix="amazon" url="http://astore.amazon.com/battlestarwik-20/detail/$1" />
      <iw prefix="bs" language="Bosanski" url="http://www.battlestarpegasus.com/wiki/$1" />
      <iw prefix="bsp" url="http://www.battlestarpegasus.com/wiki/$1" />
      <iw prefix="de" local="" language="Deutsch" url="http://de.battlestarwiki.org/wiki/$1" />
      <iw prefix="en" local="" language="English" url="http://en.battlestarwiki.org/wiki/$1" />
      <iw prefix="es" local="" language="Español" url="http://es.battlestarwiki.org/wiki/$1" />
      <iw prefix="ew" url="http://en.eurekawiki.org/wiki/$1" />
      <iw prefix="FlashGordonWiki" url="http://flashgordon.wikia.com/wiki/$1" />
      <iw prefix="fr" local="" language="Français" url="http://fr.battlestarwiki.org/wiki/$1" />
      <iw prefix="frakr" url="http://wiki.frakr.com/en/$1" />
      <iw prefix="hb" local="" url="http://hb.battlestarwiki.org/wiki/$1" />
      <iw prefix="IMDB" url="http://us.imdb.com/Title?$1" />
      <iw prefix="Lostpedia" url="http://en.lostpedia.com/wiki/$1" />
      <iw prefix="m-w" url="http://www.m-w.com/dictionary/$1" />
      <iw prefix="md" local="" url="http://media.battlestarwiki.org/wiki/$1" />
      <iw prefix="MemoryAlpha" url="http://www.memory-alpha.org/wiki/$1" />
      <iw prefix="MetaWikiPedia" url="http://meta.wikimedia.org/wiki/$1" />
      <iw prefix="ms" local="" language="Bahasa Melayu" url="http://ms.battlestarwiki.org/wiki/$1" />
      <iw prefix="props" local="" url="http://props.battlestarwiki.org/wiki/$1" />
      <iw prefix="rc" url="http://www.robotchicken.org/index.php?title=$1" />
      <iw prefix="Scifipedia" url="http://scifipedia.scifi.com/index.php/$1" />
      <iw prefix="simple" local="" language="Simple English" url="http://simple.battlestarwiki.org/wiki/$1" />
      <iw prefix="SW" url="http://www.sanctuarywiki.org/wiki/$1" />
      <iw prefix="tr" local="" language="Türkçe" url="http://tr.battlestarwiki.org/wiki/$1" />
      <iw prefix="w" url="http://en.wikipedia.org/wiki/$1" />
      <iw prefix="Wikipedia" url="http://www.wikipedia.org/wiki/$1" />
      <iw prefix="Wookieepedia" url="http://starwars.wikia.com/wiki/$1" />
      <iw prefix="zh" local="" language="中文" url="http://zh.battlestarwiki.org/wiki/$1" />
    </interwikimap>
  </query>
</api>

"bs" looks like it isnt supposed to be an inter language interwiki ; http://www.battlestarpegasus.com/wiki/ is a redirect to http://www.galacticageek.com/wiki/ , which doesnt load.

I wonder what http://hb.battlestarwiki.org/wiki/ was supposed to be; hb isnt a lang code. https://web.archive.org/web/20081121091947/http://hb.battlestarwiki.org/wiki/ just shows English..?

http://props.battlestarwiki.org/wiki/ also doesnt load.

Does #wikiteam have recent dumps of these wikis?

https://wikiapiary.com/wiki/Farm:Battlestar_Wiki suggests that some of these wikis, eg zh and fr, were quite decent wikis, and gives last sample dates which are more recent.

Can't find: https://archive.org/search.php?query=battlestarwikiorg
Seems lost. :/ Asking a dump from the sysadmin would be nice.

According to Battlestar_Wiki:Interwiki:

  • props is "BS Props Wiki"
  • hb is "Hangerbay (Test) Wiki"

And archive.org shows props was "Welcome to the Battlestar Props Wiki, A collaborative catalog of the props of the Battlestar Galactica sagas. — 119 articles —"

This facebook posts says Spanish and Chinese were unavailable in January 2014.

The Battlestar Wiki:Interwiki also says:

"These happen on each of the pages that have interwiki links. However, let's say you are working on the German Wiki and you add interwiki links to a page that lead to a valid article name on other wikis, the Interwiki Bot automatically cross-references by reading the German article and adding the correct interwiki links on those other pages. This allows correct formatting of these links and keeps everything clean. To request the Interwiki Bot to run, contact Shane. "

And the Interwiki Bot page says "Hello. I am the InterBot makes corrections in Interwiki links between the languages. I am built using the pywikipediabot Python code. Though I have other functions, I am only going to be used for Interwiki-linking."

The last contributions by Interwiki Bot were in 2009, it was using compat, and the bot operator Shane was last active in 2010.

Ugh. It looks like German Battlestarwiki is also dying; recentchanges is not working http://de.battlestarwiki.org/wiki/Spezial:Letzte_%C3%84nderungen

Change 223019 had a related patch set uploaded (by John Vandenberg):
Remove broken wikis from battlestarwiki family

https://gerrit.wikimedia.org/r/223019

Ugh. It looks like German Battlestarwiki is also dying; recentchanges is not working http://de.battlestarwiki.org/wiki/Spezial:Letzte_%C3%84nderungen

As expected, many API calls on de.battlestarwiki fail with DBQueryError.
https://travis-ci.org/jayvdb/pywikibot-core/jobs/69895010

en.battlestarwiki tests run pending:
https://travis-ci.org/jayvdb/pywikibot-core/jobs/69898472

Change 223019 merged by jenkins-bot:
Remove broken wikis from battlestarwiki family

https://gerrit.wikimedia.org/r/223019

Can't find: https://archive.org/search.php?query=battlestarwikiorg
Seems lost. :/ Asking a dump from the sysadmin would be nice.

All my attempts to reach the sysadmins/senior chiefs via email (where they had public email addresses) have failed with mailer-daemon errors.
I've asked for dumps on facebook
https://www.facebook.com/battlestarwiki/posts/10153114391814209?comment_id=10153115322739209&reply_comment_id=10153124732779209&total_comments=2&comment_tracking={%22tn%22%3A%22R%22}
And I've requested an account, so that I may use special:emailuser to contact people.

We may need to look to the sysops to obtain a decent communication channel with the sysadmins.

@Catrope is a sysop.
Two others might be reachable via special:emailuser on en.wp
https://en.wikipedia.org/wiki/Special:Contributions/BlueResistance is likely the most active user on en.battlestarwiki
https://en.wikipedia.org/wiki/User:April_Arcus appears to be http://en.battlestarwiki.org/wiki/User:Peter_Farago
https://en.wikipedia.org/wiki/User:JubalHarshaw is sysop http://en.battlestarwiki.org/wiki/User:JubalHarshaw

NOTE: A tr.battlestarwiki build is very interesting; it passes! due to all relevant tests being skipped due to exception trying to load the front page
pywiki: ERROR: TestAPIMWException: accessing http://tr.battlestarwiki.org caused exception:
pywiki: ERROR: 'utf8' codec can't decode byte 0xfc in position 8914: invalid start byte

Pywikibot fails to be able to startup on these wikis, as it needs siteinfo , and the api.py Request class also adds userinfo with several uiprops to every meta request.

API error on siteinfo: simple and es

API error on siteinfo|userinfo (but each work OK separately): zh & ms

API error only on userinfo hasmsg: fr

API error only on userinfo blockinfo: tr


But if it could start up, could it fetch all content? Turns out, list=allpages works OK on all sites.

However, prop=revision fails on simple, zh and ms.

rvprop fails on es: http://es.battlestarwiki.org/w/api.php?action=query&titles=33&prop=revisions&rvprop=content

fr and tr serve real content, so we could theoretically create a backup dump using only list=allpages and prop=revisions.

Change 223883 had a related patch set uploaded (by Merlijn van Deen):
Remove broken wikis from battlestarwiki family

https://gerrit.wikimedia.org/r/223883

Change 223883 merged by jenkins-bot:
Remove broken wikis from battlestarwiki family

https://gerrit.wikimedia.org/r/223883

Xqt claimed this task.
Xqt removed Xqt as the assignee of this task.
Xqt added a subscriber: Xqt.