{{Encyclopédie recherche}} - Wikitech-l - lists.wikimedia.org

List overview All Threads
Download

{{Encyclopédie recherche}}

235 Auto unit conversion

skins

Bilal Abdul Kader

17 Nov 2009 17 Nov '09

7:02 p.m.

Greetings, This template is not being parsed on my french local wiki. Any hints on that. I did several search on google but I could not find the problem. bilal -- Verily, with hardship comes ease.

Reply

Show replies by date

Roan Kattouw

17 Nov 17 Nov

7:07 p.m.

New subject: [Wikitech-l] {{Encyclopédie recherche}}

2009/11/18 Bilal Abdul Kader <bilalak(a)gmail.com>om>:

Greetings, This template is not being parsed on my french local wiki. Any hints on that. I did several search on google but I could not find the problem.

Exactly what does happen? Do you see raw template code? Red links? Nothing at all? Roan Kattouw (Catrope)

Reply

Platonides

18 Nov 18 Nov

9:26 a.m.

New subject: [Wikitech-l] {{Encyclopédie recherche}}

Bilal Abdul Kader a écrit:

Greetings, This template is not being parsed on my french local wiki. Any hints on that. I did several search on google but I could not find the problem. bilal -- Verily, with hardship comes ease.

Did you copy to your wiki the templates Encyclopédie_recherche and nobr?

Reply

zh509＠york.ac.uk

19 Nov 19 Nov

9:38 a.m.

New subject: Wikipedia database

Greeting, May I ask the question about wikipedia database. I downloaded the Wikipedia revision current data. and found there are some records have the exactly same rev_id, rev_user and same timestamp. What does it mean? are they the same edit or different? best, Zeyi

Reply

Roan Kattouw

11:21 a.m.

New subject: Wikipedia database

2009/11/19 <zh509(a)york.ac.uk>uk>:

Greeting, May I ask the question about wikipedia database. I downloaded the Wikipedia revision current data. and found there are some records have the exactly same rev_id, rev_user and same timestamp. What does it mean? are they the same edit or different?

If they belong to the same wiki, they're very likely to be the same edit. Of course such duplicates should theoretically not occur. Roan Kattouw (Catrope)

Reply

zh509＠york.ac.uk

11:48 a.m.

New subject: Wikipedia database

On Nov 19 2009, Roan Kattouw wrote:

2009/11/19 <zh509(a)york.ac.uk>uk>:

Greeting, May I ask the question about wikipedia database. I downloaded the Wikipedia revision current data. and found there are some records have the exactly same rev_id, rev_user and same timestamp. What does it mean? are they the same edit or different?

If they belong to the same wiki, they're very likely to be the same edit. Of course such duplicates should theoretically not occur. Roan Kattouw (Catrope)

Thanks, I noted that because i add Revision Table and Page table together. May I ask why for the same page.page_latest, there are two same records on the table? Is that the link between revision and Page is the rev_id=page.page_latest? thanks. Zeyi _______________________________________________

Wikitech-l mailing list Wikitech-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply

Platonides

3:04 p.m.

New subject: Wikipedia database

zh509(a)york.ac.uk wrote:

On Nov 19 2009, Roan Kattouw wrote:

2009/11/19 <zh509(a)york.ac.uk>uk>:

Greeting, May I ask the question about wikipedia database. I downloaded the Wikipedia revision current data. and found there are some records have the exactly same rev_id, rev_user and same timestamp. What does it mean? are they the same edit or different?

If they belong to the same wiki, they're very likely to be the same edit. Of course such duplicates should theoretically not occur. Roan Kattouw (Catrope)

Thanks, I noted that because i add Revision Table and Page table together. May I ask why for the same page.page_latest, there are two same records on the table? Is that the link between revision and Page is the rev_id=page.page_latest?

page.page_latest point to the current revision.rev_id However, you shouldn't be able to have several revisions with the same rev_id. Even if something went horribly wrong at the wiki level, rev_id is a PRIMARY KEY. How did you do the import? I suspect you may have broken something importing or merging.

Reply

zh509＠york.ac.uk

20 Nov 20 Nov

8:23 a.m.

New subject: Wikipedia database

On Nov 19 2009, Platonides wrote:

zh509(a)york.ac.uk wrote:

On Nov 19 2009, Roan Kattouw wrote:

2009/11/19 <zh509(a)york.ac.uk>uk>:

Greeting, May I ask the question about wikipedia database. I downloaded the Wikipedia revision current data. and found there are some records have the exactly same rev_id, rev_user and same timestamp. What does it mean? are they the same edit or different?

If they belong to the same wiki, they're very likely to be the same edit. Of course such duplicates should theoretically not occur. Roan Kattouw (Catrope)

Thanks, I noted that because i add Revision Table and Page table together. May I ask why for the same page.page_latest, there are two same records on the table? Is that the link between revision and Page is the rev_id=page.page_latest?

page.page_latest point to the current revision.rev_id However, you shouldn't be able to have several revisions with the same rev_id. Even if something went horribly wrong at the wiki level, rev_id is a PRIMARY KEY. How did you do the import? I suspect you may have broken something importing or merging.

I took the sub-current data from MediaWiki and import them to Oracle. I found there are two same page_latest ID in the page table. Then when I tried to join Revision table and Page table together, this caused two same rev_id. May I ask why I have two page_latest on page table, what it mean? If I want to put Revision table and Page table together, which should be the link point? thanks, Zeyi

_______________________________________________ Wikitech-l mailing list Wikitech-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply

Platonides

6:03 p.m.

New subject: Wikipedia database

Zeyi wrote:

I took the sub-current data from MediaWiki and import them to Oracle.

Which tool did you use for the import?

I found there are two same page_latest ID in the page table. Then when I tried to join Revision table and Page table together, this caused two same rev_id.

Which pages are those?

May I ask why I have two page_latest on page table, what it mean? If I want to put Revision table and Page table together, which should be the link point?

You shouldn't have that situation. And why are you merging page and revision, anyway?

thanks, Zeyi

Reply

zh509＠york.ac.uk

21 Nov 21 Nov

9:58 a.m.

New subject: Wikipedia database

On Nov 20 2009, Platonides wrote:

Zeyi wrote:

I took the sub-current data from MediaWiki and import them to Oracle.

Which tool did you use for the import?

I used xml2sql tool, which is easy to use.

I found there are two same page_latest ID in the page table. Then when I tried to join Revision table and Page table together, this caused two same rev_id.

Which pages are those?

kinds of every pages, is that page_latest ID unique?

May I ask why I have two page_latest on page table, what it mean? If I want to put Revision table and Page table together, which should be the link point?

You shouldn't have that situation. And why are you merging page and revision, anyway?

I need use rev_user and page_namespace to do crossing-analysis. How i can put them in the one table? thanks again.

thanks, Zeyi

_______________________________________________ Wikitech-l mailing list Wikitech-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply

Roan Kattouw

1:28 p.m.

New subject: Wikipedia database

2009/11/21 <zh509(a)york.ac.uk>uk>:

I need use rev_user and page_namespace to do crossing-analysis. How i can put them in the one table? thanks again.

You don't need to put them in one table, just use a query with a JOIN. Roan Kattouw (Catrope)

Reply

zh509＠york.ac.uk

23 Nov 23 Nov

9:03 a.m.

New subject: Wikipedia database

Thanks. but is that page_latest is unique in page table? On Nov 21 2009, Roan Kattouw wrote:

2009/11/21 <zh509(a)york.ac.uk>uk>:

I need use rev_user and page_namespace to do crossing-analysis. How i can put them in the one table? thanks again.

You don't need to put them in one table, just use a query with a JOIN. Roan Kattouw (Catrope) _______________________________________________ Wikitech-l mailing list Wikitech-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply

Roan Kattouw

9:16 a.m.

New subject: Wikipedia database

2009/11/23 <zh509(a)york.ac.uk>uk>:

Thanks. but is that page_latest is unique in page table?

Yes. Every revision belongs to one page only (rev_page). Roan Kattouw (Catrope)

Reply

5265

days inactive

5270

days old

wikitech-l@lists.wikimedia.org

Manage subscription

12 comments

4 participants

tags (0)

participants (4)

Bilal Abdul Kader
Platonides
Roan Kattouw
zh509＠york.ac.uk