Re: [Toolserver-l] Error in Revision Table in lbwiki

2013-03-15 Thread MZMcBride
DaB. wrote: >rev_lenght will remain as it is – the problem is that rev_lenght was not >there >from the very beginning and was never (AFAIK) back-populated; so very old >rows >has no lenght and are NULL. Related: . MZMcBride __

Re: [Toolserver-l] No user_properties table on arwiki_p database

2013-03-15 Thread DaB.
Hello, At Saturday 16 March 2013 01:49:12 DaB. wrote: > First of all thanks for toolserver, it's a great service! > > (I posted this question on jira as well but I'm not sure I found a way to > "assign" it to someone and so if anyone saw it. The issue on Jira is at > https://jira.toolserver.org/br

Re: [Toolserver-l] Error in Revision Table in lbwiki

2013-03-15 Thread DaB.
Hello, At Saturday 16 March 2013 01:41:47 DaB. wrote: > Hi all, > > I have a script running collecting data in multiple wikipedia(s), I started > to notice that revision table in lbwiki_p has some incorrect data. > > Here is an example: > mysql> select rev_id, rev_user, rev_page, rev_deleted, rev

[Toolserver-l] Error in Revision Table in lbwiki

2013-03-15 Thread Anuradha Uduwage
Hi all, I have a script running collecting data in multiple wikipedia(s), I started to notice that revision table in lbwiki_p has some incorrect data. Here is an example: mysql> select rev_id, rev_user, rev_page, rev_deleted, rev_len, rev_timestamp from revision where rev_id = 185751; ++-

[Toolserver-l] No user_properties table on arwiki_p database

2013-03-15 Thread Paolo Massa
First of all thanks for toolserver, it's a great service! (I posted this question on jira as well but I'm not sure I found a way to "assign" it to someone and so if anyone saw it. The issue on Jira is at https://jira.toolserver.org/browse/DBQ-202 ) I have a script which computes statistics on the