Hello, I'm asking why not all tables are replicated? Of course I don't mean user data - one of recent MediaWiki update introduced new table - page_restrictions. It means that page_restrictions field from page table is no more used. Lack of this table prevents me from writing a tool which will list all protected pages in Wikipedia. It would be helpful because special page Protectedpages (http://pl.wikipedia.org/wiki/Specjalna:Protectedpages) doesn't work.
Localhost: mysql> select * from page_restrictions; +---------+---------+----------+------------+---------+-----------+ | pr_page | pr_type | pr_level | pr_cascade | pr_user | pr_expiry | +---------+---------+----------+------------+---------+-----------+ | 1 | edit | sysop | 1 | NULL | infinity | | 1 | move | sysop | 1 | NULL | infinity | +---------+---------+----------+------------+---------+-----------+
Hemlock: mysql> select * from page_restrictions; ERROR 1146 (42S02): Table 'plwiki_p.page_restrictions' doesn't exist
Hello, Am Samstag, den 27.01.2007, 12:27 +0100 schrieb Adam "Dodek" Michalik:
Hello,
Hemlock: mysql> select * from page_restrictions; ERROR 1146 (42S02): Table 'plwiki_p.page_restrictions' doesn't exist
The table was replicated without problems, just the fitting views was missing. I created the views know, please note, that the view for enwiki is missing because the new table isn't there because the replag.
Please fill in a bugreport at the bugzilla next time :). I fixed the eMail-notife-system there a few days ago.
Sincerly, DaB.
toolserver-l@lists.wikimedia.org