[Bug 26415] add I to AllPages redirects

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26415

--- Comment #17 from Happy-melon happy-me...@live.com 2010-12-31 10:10:49 UTC 
---
(In reply to comment #15)
 because you won't put the i there, even though your style for
 it is italic anyway. 

Ok, serious WTF.  Italics is not our style; MediaWiki does not have 'a'
style.  It has a *default* style, and wikis can use what they think is
appropriate and change what they think is not.  We have implemented italics as
the default style for redirects entirely because you browbeat everyone into
submission on bug 26266; you've said *yourself* that it is not universally
suitable.  Why on earth would we want to lock in a style which is not
accessible in an entire character set?

(In reply to comment #16)
 But can't they just overpower it back in MediaWiki:Common.css as I have shown
 in Bug 26519 Comment 6 ?

Your entire argument in this bug report is that this is precisely what users of
text browsers *cannot* do.  Which is it?  You can't have your cake and eat it;
users cannot be flexible when they want to do something different to you, but
uncompromising when they want to do what you want.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26522] New: 'Subscribe to the release announcements mailing list.' check box is missing in the 'Name' page

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26522

   Summary: 'Subscribe to the release announcements mailing list.'
 check box is missing in the 'Name' page
   Product: MediaWiki
   Version: 1.18-svn
  Platform: PC
OS/Version: Windows XP
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: Installation
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: nade...@gmail.com
CC: innocentkil...@gmail.com


Created attachment 7943
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7943
Screenshot from the latest wiki

Steps to Reproduce ::

1) Complete the MediaWiki installation upto the 'Database settings' page.
2) Observe the 'Administrator account' section in the 'Name' page.


 'Subscribe to the release announcements mailing list.' check box s missing 

Please refer the screenshot with/without 'Subscribe to the release
announcements mailing list.' check box.


Expected Outcome ::
'Subscribe to the release announcements mailing list.' check box should be
display below the 'E-mail address:' field.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26522] 'Subscribe to the release announcements mailing list.' check box is missing in the 'Name' page

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26522

--- Comment #1 from Nadeesha nade...@gmail.com 2010-12-31 10:24:21 UTC ---
Created attachment 7944
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7944
Screenshot from the old wiki

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26522] 'Subscribe to the release announcements mailing list.' check box is missing in the 'Name' page

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26522

p858snake p858sn...@gmail.com changed:

   What|Removed |Added

 CC||p858sn...@gmail.com

--- Comment #2 from p858snake p858sn...@gmail.com 2010-12-31 10:25:59 UTC ---
I believe it's been removed till a method where they can actually subscribe
people is implemented.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26523] New: 'Back' button is missing in the 'Complete' page of the MediaWiki installation

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26523

   Summary: 'Back' button is missing in the 'Complete' page of the
MediaWiki installation
   Product: MediaWiki
   Version: 1.18-svn
  Platform: All
OS/Version: All
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: Installation
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: nade...@gmail.com
CC: innocentkil...@gmail.com


Created attachment 7945
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7945
Back button not available in the latest version

Steps to Reproduce ::

1) Complete the MediaWiki installation upto the 'Complete' page.

 'Back' button is missing
Please refer the screenshot with/without the 'Back' button.


Expected Outcome ::
'Back' button should be available.
Note : If the 'Back' button is available, even after completing the
installation, user is able to change the values.
 If the 'Back' button is not present, user needs the restart the installation
and re-enter all values, if he wish to change the value of any field.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26523] 'Back' button is missing in the 'Complete' page of the MediaWiki installation

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26523

--- Comment #1 from Nadeesha nade...@gmail.com 2010-12-31 10:33:47 UTC ---
Created attachment 7946
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7946
Back button available old

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26415] add I to AllPages redirects

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26415

--- Comment #18 from jida...@jidanni.org 2010-12-31 11:14:54 UTC ---
(In reply to comment #17)
Maybe I should give up the ghost as nobody seems to remember what those
HTML tags were originally for.

And even if you were to implement it for me, the next guy probably would
just come along a little later and like the funny videos below, and
Bug 26442, chuck it back out.

E.g., Facebook just says 'Sorry, we're not cool enough to support your
browser. Please keep it real with one of the following browsers...'

They do seem to have a m.facebook.com site that does work with text
browsers though.

Maybe if I put an 'm' in front of my wiki's URL, it will too. Ha ha.

Anyway, I was just thinking if there was is, then on 
http://radioscanningtw.jidanni.org/index.php?title=Special:Allpages
even text browsers could see which links were redirects.

You might say if I give you that, next thing you'll be asking for is
some HTML tag for redlinks!

Well, no. I can move the cursor upon a link and see where it will go
before clicking it, thus able to tell if a link is a redlink by its URL.

But I can't do that for redirects. They all look the same as normal
links URL-wise. I would have to look at the HTML page source to tell.

And if you put the is in the code, with powerful CSS, anybody can
take them right back out for themselves.

However, if you don't put them in, then the text user has nothing to
grasp on. No way to stick them in himself.

I think accessibility would also allow a whole range of future super
slim devices to use MediaWiki, without having to implement sytlesheets.

Anyway, it seems that I should just keep my text browser habit to myself
these days. I'm even too embarrassed to say which one I use.

*Stale old stuff http://www.youtube.com/watch?v=VM3QqTcM55k
*Can't even pronounce this one http://www.youtube.com/watch?v=M6a0OPefhi0

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26343] Extension req: embed Mozilla Skywriter editor for CSS, JS pages with syntax highlighting

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26343

Kevin Ernst ernstke+mwbugzi...@gmail.com changed:

   What|Removed |Added

 CC||ernstke+mwbugzi...@gmail.co
   ||m

--- Comment #1 from Kevin Ernst ernstke+mwbugzi...@gmail.com 2010-12-31 
11:39:47 UTC ---
(In reply to comment #0)
 Would be nice for power users to be able to use a code editor that does syntax
 hightlighting etc for JavaScript and CSS pages. An extension that uses the
 Mozilla Skywriter (formerly Bespin) editor widget as a drop-in replacement on
 those pages could be quite handy indeed.

Furthermore, I think a Skywriter plugin FOR WIKITEXT would be fantastic. Some
simple color cues would help immensely when you're dealing with a complicated
article with templates calling templates, embedded HTML (a no-no, I know, but
it happens), complicated nested tables, and so forth.

I haven't looked to see what's out there recently (within the last year), but
the closest I was ever able to manage in years past was jEdit with the mwjed
plugin. And as I recall, some assembly was required. Skywriter seems poised
to make syntax highlighting of wikitext articles as simple as installing a
MediaWiki extension, if someone could be bothered to write the glue to make
it work.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26524] New: auto redirect facility in Tamil Wiktionary

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26524

   Summary: auto redirect facility in Tamil Wiktionary
   Product: Wikimedia
   Version: unspecified
  Platform: All
   URL: http://ta.wiktionary.org
OS/Version: All
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: General/Unknown
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: mahi...@gmail.com


Hi

In Enwiktionary we have auto redirect facility for eg. if i type Demography it
redirect to demography where in tawiktionary its not redirecting..

can you please enhance this feature? 

Thanks  Regards
Mahir

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26525] New: Clicking a commons image should immediately open the Commons page

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26525

   Summary: Clicking a commons image should immediately open the
Commons page
   Product: Wikimedia
   Version: unspecified
  Platform: All
OS/Version: All
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: General/Unknown
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: amir.ahar...@mail.huji.ac.il


A friend of mine found a significant factual mistake in an image description
and wanted to correct it. Knowing that i frequently edit Wikipedia he called
me. I told him to click the edit button and change it himself, but he couldn't
find the edit button - only a create button.

Nowadays on Wikimedia projects, when a user clicks an image that is hosted on
Commons, the page that is opened is a virtual page, local to that project. It
doesn't actually exist - it just shows the image. It's possible to create it;
but correct me if i'm wrong, but it seems completely pointless to me.

It's quite confusing to the user who wants to change its description - it would
make more sense if there would be an edit tab, not a create tab. To edit
the description the user needs to know what Commons is and to find the link
to the file description on Commons (which is quite different in different
projects).

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26526] New: Some absolute links should be relative

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26526

   Summary: Some absolute links should be relative
   Product: MediaWiki extensions
   Version: any
  Platform: All
OS/Version: All
Status: NEW
  Severity: minor
  Priority: Normal
 Component: LiquidThreads
AssignedTo: agarr...@wikimedia.org
ReportedBy: hart...@videolan.org
CC: bhar...@wikimedia.org


Created attachment 7947
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7947
screenshot of the problem

Some links of the LQT interface use absolute paths, instead of relative paths,
causing the CSS selector for https:// links to add a lock icon. All links
should use relative paths whenever possible.

See attachment for issue

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 3665] Auto-detect interface language for anonymous users

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=3665

Roan Kattouw roan.katt...@gmail.com changed:

   What|Removed |Added

 CC||roan.katt...@gmail.com

--- Comment #13 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 14:21:20 
UTC ---
(In reply to comment #12)
 It's very dissapointing that nothing was improved anent this bug during six
 years.
 
Although I agree with your argument that English always is not necessarily
nice, there's a technical reason we haven't done anything in six years,
presented in comment #2: Squid caching would suffer severely. The pile of
rubble part may not be as accurate today as it was in 2005 (we gained some
capacity since then), but please understand this is not an easy change at all.
Back in 2005 our servers really did rely on every anonymous user seeing the
same thing at the same URL for the servers not to melt down; and I'm not so
sure Accept-Language detection for anonymous users would be feasible in
2010/2011 either.

 Many people in my surrounding really hate English and would never contribute 
 to
 a project that appears totally in this language, without an easy and fast way
 to switch it.
 
an easy and fast way to switch it might just be what we *can* do. We could
use JavaScript to obtain the user's Accept-Language preferences from the API or
something (which wouldn't go through Squid cache, but that's OK: it's just a
language list, not an entire wiki page) and use that information to display a
link with the native language name (i.e. 'Deutsch' for German, 'Français' for
French, etc.) that would then lead to the account creation form in that
language or maybe trigger persistent uselang (language selection for anonymous
users, basically) if and when we have that.

In fact, I once wrote some proof-of-concept code that obtained the user's
Accept-Language settings from the API, stored it in a cookie (to avoid
repetitive API requests) and used it to reorder the In other languages links
in the sidebar. We never ended up using it but it's still lying around
somewhere.

tl;dr: Automatically showing wiki pages in the browser language for anonymous
users is probably not gonna happen, but a feature offering to switch languages
based on the browser language isn't hard to do.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26498] allow LinksUpdate with API

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26498

Roan Kattouw roan.katt...@gmail.com changed:

   What|Removed |Added

 CC||roan.katt...@gmail.com

--- Comment #4 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 14:24:17 
UTC ---
(In reply to comment #3)
 Hmm.
 
 It's doable through the interface, so the API could allow it. It's just about
 doing mass null edits that we might have issues...
As long as null edits would count towards the rate limit, this shouldn't create
any new problems, right?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26517] On install - Database returned error 1071: Specified key was too long;

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26517

Roan Kattouw roan.katt...@gmail.com changed:

   What|Removed |Added

 CC||domas.mitu...@gmail.com,
   ||roan.katt...@gmail.com

--- Comment #2 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 14:26:09 
UTC ---
I thought s/varchar/varbinary/ was the way to fix this?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26416] Ability to view the revision follow-up tree

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26416

--- Comment #3 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 14:29:53 
UTC ---
(In reply to comment #2)
 Do you want a list of what this rev links to in it's summary (predecessors)
 (and any manually referenced), followups to it's followups in the table (or
 similar) at the bottom?
A more graphical tree would be cool, but a predecessor list and an
infinite-depth follow-up list would be useful already.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 3665] Auto-detect interface language for anonymous users

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=3665

Niklas Laxström niklas.laxst...@gmail.com changed:

   What|Removed |Added

 CC||niklas.laxst...@gmail.com

--- Comment #14 from Niklas Laxström niklas.laxst...@gmail.com 2010-12-31 
14:31:59 UTC ---
If WMF cannot do it, it doesn't mean MediaWiki cannot do it. In fact the
LanguageSelector extension does it already. In my opinion it would be nice to
pick the automatic language detection code from it to core (disablable for WMF
and other cached sites of course).

Lets not mix two issues in this bug.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26522] 'Subscribe to the release announcements mailing list.' check box is missing in the 'Name' page

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26522

Roan Kattouw roan.katt...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||roan.katt...@gmail.com
 Resolution||INVALID

--- Comment #3 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 14:32:19 
UTC ---
Yes, it's been deliberately removed, see r79089.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26416] Ability to view the revision follow-up tree

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26416

Niklas Laxström niklas.laxst...@gmail.com changed:

   What|Removed |Added

 CC||niklas.laxst...@gmail.com

--- Comment #4 from Niklas Laxström niklas.laxst...@gmail.com 2010-12-31 
14:34:36 UTC ---
How about an API module first? Maybe someone wants to innovate with the data...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25809] License tags for Commons should be located to the Information box defaultly

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25809

Raimond Spekking raimond.spekk...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||WONTFIX

--- Comment #2 from Raimond Spekking raimond.spekk...@gmail.com 2010-12-31 
14:42:06 UTC ---
Permission != license.

The permission field is for OTRS ticket or similar, the license templates are
sometimes quite extensive and should stay in a separate section like now. All
new extensions (Upload wizard, Add Media Wizard) do it the same way.

IMO the see below text is superfluous and could be suppressed in the output.
This is something to be done in Commons, but not in code.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26416] Ability to view the revision follow-up tree

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26416

--- Comment #5 from Reedy s...@reedyboy.net 2010-12-31 15:15:56 UTC ---
(In reply to comment #4)
 How about an API module first? Maybe someone wants to innovate with the 
 data...

I was just thinking the same. It's certainly something that could be done
better ajaxy

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26503] imagelinks not updated for cascade protection

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26503

Umherirrender umherirrender_de...@web.de changed:

   What|Removed |Added

Summary|check also for images in|imagelinks not updated for
   |Article::doCascadeProtectio |cascade protection
   |nUpdates|

--- Comment #1 from Umherirrender umherirrender_de...@web.de 2010-12-31 
15:34:57 UTC ---
When a cascade protected page contains time-dependent imagelinks than the
imagelinks table is not updated after a purge of the cascade protected page and
so the wrong image is cascade protected.

It works when there are also templatelinks to update, because
Article::doCascadeProtectionUpdates handles the special case of time-dependent
transclusion of templates. It is called when the html page is parsed the first
time after the purge.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23549] SMW::getUnusedPropertySubjects causes MySQL error 1044

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23549

J Kishore Kumar just...@gmail.com changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 CC||just...@gmail.com
 Resolution|INVALID |

--- Comment #3 from J Kishore Kumar just...@gmail.com 2010-12-31 16:26:55 UTC 
---
I can confirm this bug with Semantic Mediawiki 1.5.4 and Postgresql 8.5.4

When opening Special:UnusedProperties page with $wgShowExceptionDetails = true;
I get the following,

A database error has occurred
Query: DELETE FROM smw_tmp_unusedprops USING smw_tmp_unusedprops INNER JOIN
smw_rels2 INNER JOIN smw_ids ON p_id=smw_id AND title=smw_title AND smw_iw=''
Function: SMW::getUnusedPropertySubjects
Error: 1 ERROR: syntax error at end of input
LINE 1: ...OIN smw_ids ON p_id=smw_id AND title=smw_title AND smw_iw=''
^
Backtrace:

#0 /home/jkk/mediawiki-1.16.0/w/includes/db/Database.php(538):
DatabasePostgres-reportQueryError('ERROR: syntax ...', 1, 'DELETE FROM
smw...', 'SMW::getUnusedP...', false)
#1
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(1106):
DatabaseBase-query('DELETE FROM smw...', 'SMW::getUnusedP...')
#2
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/specials/QueryPages/SMW_SpecialUnusedProperties.php(100):
SMWSQLStore2-getUnusedPropertiesSpecial(Object(SMWRequestOptions))
#3
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/specials/QueryPages/SMW_QueryPage.php(49):
SMWUnusedPropertiesPage-getResults(Object(SMWRequestOptions))
#4
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/specials/QueryPages/SMW_SpecialUnusedProperties.php(45):
SMWQueryPage-doQuery(0, 50)
#5 /home/jkk/mediawiki-1.16.0/w/includes/SpecialPage.php(559):
SMWSpecialUnusedProperties-execute(NULL)
#6 /home/jkk/mediawiki-1.16.0/w/includes/Wiki.php(254):
SpecialPage::executePath(Object(Title))
#7 /home/jkk/mediawiki-1.16.0/w/includes/Wiki.php(64):
MediaWiki-handleSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#8 /home/jkk/mediawiki-1.16.0/w/index.php(117):
MediaWiki-performRequestForTitle(Object(Title), NULL, Object(OutputPage),
Object(User), Object(WebRequest))
#9 /home/jkk/mediawiki-1.16.0/w/index.php5(1): require('/home/jkk/media...')
#10 {main}

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26498] allow LinksUpdate with API

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26498

--- Comment #5 from Reedy s...@reedyboy.net 2010-12-31 16:28:14 UTC ---
Indeed

Marking it as action=purgenulledit maybe

As nulledit makes more sense in the wiki community, than linkupdate

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26498] allow LinksUpdate with API

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26498

--- Comment #6 from Umherirrender umherirrender_de...@web.de 2010-12-31 
16:46:01 UTC ---
(In reply to comment #5)
 Indeed
 Marking it as action=purgenulledit maybe
 As nulledit makes more sense in the wiki community, than linkupdate

linkupdate is technical, that is right, but in my opinion the best description.
But feel free to name it, like you find the best.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25502] start parameter of list=coderevisions isn't right

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25502

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||FIXED

--- Comment #1 from Reedy s...@reedyboy.net 2010-12-31 16:46:59 UTC ---
r79348

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26498] allow LinksUpdate with API

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26498

Krinkle krinklem...@gmail.com changed:

   What|Removed |Added

 CC||krinklem...@gmail.com

--- Comment #7 from Krinkle krinklem...@gmail.com 2010-12-31 16:49:30 UTC ---
linkupdate may or may not be right depending on what will happen when one uses
it ;-)

if this new parameter will make a nulledit there is most likely more happening
then just 'linkupdate'.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26527] New: image replaced by link in stable version of article

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26527

   Summary: image replaced by link in stable version of article
   Product: MediaWiki
   Version: unspecified
  Platform: Macintosh
   URL: http://de.wikipedia.org/wiki/Phasenrauschen
OS/Version: Mac OS X 10.6
Status: NEW
  Severity: normal
  Priority: Normal
 Component: General/Unknown
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: fp...@web.de


Created attachment 7948
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7948
screenshot of display with links instead of images

When I visit the current version of
http://de.wikipedia.org/wiki/Phasenrauschen, depending on how exactly I visit
it, I sometimes get correct images and sometimes just links instead of the
images. Specifically, I get correct images if I

-- go to http://de.wikipedia.org/wiki/Phasenrauschen when logged in
-- go to
http://de.wikipedia.org/w/index.php?title=Phasenrauschenoldid=74345560

I get links instead of the images if I

-- go to http://de.wikipedia.org/wiki/Phasenrauschen anonymously
-- go to
http://de.wikipedia.org/w/index.php?title=Phasenrauschenstableid=74345560
-- download http://de.wikipedia.org/wiki/Phasenrauschen from the command line
(using curl)

It appears that the problem occurs whenever the version is being shown as a
stable version, although in this should be the same as the current version; the
oldid and the stableid are the same.

I'm attaching a screen shot of the page displayed with links instead of images.

The problem occurs both in Safari and in Chromium.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26527] image replaced by link in stable version of article

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26527

--- Comment #1 from Felix Pahl fp...@web.de 2010-12-31 16:54:58 UTC ---
Created attachment 7949
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7949
HTML saved from browser using
http://de.wikipedia.org/w/index.php?title=Phasenrauschenoldid=74345560

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26527] image replaced by link in stable version of article

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26527

--- Comment #2 from Felix Pahl fp...@web.de 2010-12-31 16:55:44 UTC ---
Created attachment 7950
  -- https://bugzilla.wikimedia.org/attachment.cgi?id=7950
HTML saved from browser using
http://de.wikipedia.org/w/index.php?title=Phasenrauschenstableid=74345560

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23549] SMW::getUnusedPropertySubjects causes MySQL error 1044

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23549

J Kishore Kumar just...@gmail.com changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution||FIXED

--- Comment #4 from J Kishore Kumar just...@gmail.com 2010-12-31 17:49:29 UTC 
---
I am terribly sorry, I just reopened the wrong bug.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 19948] Special:UnusedProperties produces database error for PostgreSQL

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=19948

J Kishore Kumar just...@gmail.com changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 CC||just...@gmail.com
 Resolution|FIXED   |

--- Comment #12 from J Kishore Kumar just...@gmail.com 2010-12-31 17:52:17 
UTC ---
I can confirm this bug with Semantic Mediawiki 1.5.4 and Postgresql 8.5.4

When opening Special:UnusedProperties page with $wgShowExceptionDetails = true;
I get the following,

A database error has occurred
Query: DELETE FROM smw_tmp_unusedprops USING smw_tmp_unusedprops INNER JOIN
smw_rels2 INNER JOIN smw_ids ON p_id=smw_id AND title=smw_title AND smw_iw=''
Function: SMW::getUnusedPropertySubjects
Error: 1 ERROR: syntax error at end of input
LINE 1: ...OIN smw_ids ON p_id=smw_id AND title=smw_title AND smw_iw=''
^
Backtrace:

#0 /home/jkk/mediawiki-1.16.0/w/includes/db/Database.php(538):
DatabasePostgres-reportQueryError('ERROR: syntax ...', 1, 'DELETE FROM
smw...', 'SMW::getUnusedP...', false)
#1
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(1106):
DatabaseBase-query('DELETE FROM smw...', 'SMW::getUnusedP...')
#2
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/specials/QueryPages/SMW_SpecialUnusedProperties.php(100):
SMWSQLStore2-getUnusedPropertiesSpecial(Object(SMWRequestOptions))
#3
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/specials/QueryPages/SMW_QueryPage.php(49):
SMWUnusedPropertiesPage-getResults(Object(SMWRequestOptions))
#4
/home/jkk/mediawiki-1.16.0/w/extensions/SemanticMediaWiki/specials/QueryPages/SMW_SpecialUnusedProperties.php(45):
SMWQueryPage-doQuery(0, 50)
#5 /home/jkk/mediawiki-1.16.0/w/includes/SpecialPage.php(559):
SMWSpecialUnusedProperties-execute(NULL)
#6 /home/jkk/mediawiki-1.16.0/w/includes/Wiki.php(254):
SpecialPage::executePath(Object(Title))
#7 /home/jkk/mediawiki-1.16.0/w/includes/Wiki.php(64):
MediaWiki-handleSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#8 /home/jkk/mediawiki-1.16.0/w/index.php(117):
MediaWiki-performRequestForTitle(Object(Title), NULL, Object(OutputPage),
Object(User), Object(WebRequest))
#9 /home/jkk/mediawiki-1.16.0/w/index.php5(1): require('/home/jkk/media...')
#10 {main}

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #10 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-12-31 
18:21:21 UTC ---
(In reply to comment #7)
 mysql describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
 comments,cr_path,cr_message,cr_author,cr_timestamp FROM
 `mw_code_tags`,`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id =
 cr_repo_id AND cc_rev_id = cr_id)) WHERE cr_repo_id = '3' AND (ct_repo_id =
 '3') AND (cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY cr_id ORDER BY cr_id
 DESC LIMIT 51;
 ++-+-++---++-++--+---+
 | id | select_type | table   | type   | possible_keys 
  
   | key| key_len | ref
  
   | rows | Extra |
 ++-+-++---++-++--+---+
 |  1 | SIMPLE  | mw_code_tags| ref| PRIMARY,ct_repo_id
  
   | PRIMARY| 4   | const  
  
   |1 | Using where; Using index; Using temporary; Using filesort |
 |  1 | SIMPLE  | mw_code_rev | eq_ref |
 PRIMARY,cr_repo_id,cr_repo_author | PRIMARY| 8   |
 const,wikidb.mw_code_tags.ct_rev_id|1 |   
  
   |
 |  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time   
  
   | cc_repo_id | 8   |
 wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id |1 | Using index   
  
   |
 ++-+-++---++-++--+---+
 3 rows in set (0.00 sec)

This is a classic pitfall for the MySQL optimizer.  What version are you using?
 On the toolserver, 5.1.53, it avoids the filesort.

The problem is that you have a few separate conditions that you need indexes
for, aside for join conditions and assuming MySQL is smart enough to do
equality propagation (not always a good bet): ct_tag = 'api', ct_repo_id = '3',
and the order by/group by.  No one index will work for all of them, so MySQL
has to choose which index it wants to use.  Since there's a LIMIT, the filesort
option is probably the worst, but it chooses that option anyway.  Often in this
case a FORCE INDEX will fix the problem.  On the toolserver, it's smart enough
to select from code_rev first and not do a filesort, and then do extra scanning
on code_tags.

In this case, your best bet is probably to add an index on (ct_repo_id, ct_tag,
ct_rev_id), if this query is a problem in practice after you stop it from
filesorting.  If you're not ever ordering or grouping by ct_tag, you can just
change the primary key (but I'd guess you sometimes do group by it).

I'd also clean up the query a bit to avoid relying on equality propagation,
changing cr_repo_id = '3' to cr_repo_id = ct_repo_id and changing GROUP BY
cr_id ORDER BY cr_id DESC to GROUP BY ct_rev_id ORDER BY ct_rev_id DESC. 
But the latter part is probably not necessary, just makes it clearer how you
expect the query to execute.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #11 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-12-31 
18:22:29 UTC ---
(Of course, the query isn't scalable anyway due to COUNT().  It will have to
scan arbitrarily many rows.  The only way to fully fix it would be to use a
summary table of some kind, but those are a pain to maintain, so better not to
do that unless you can't fix it some other way.  It's not like we're going to
have 100 million code reviews anytime soon.)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26528] New: wgAction variable needs to represent what PHP actually does, not just what the URL suggests

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26528

   Summary: wgAction variable needs to represent what PHP actually
does, not just what the URL suggests
   Product: MediaWiki
   Version: 1.18-svn
  Platform: All
OS/Version: All
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: Javascript
AssignedTo: d...@ucsc.edu
ReportedBy: krinklem...@gmail.com
CC: tpars...@wikimedia.org


Going to any of the following URLs causes the wgAction variable in JavaScript
to be wrong:

- Links that appear in core -
*
http://translatewiki.net/w/i.php?title=User:Krinkle/EnhancedChangesdiff=prevoldid=2586573
* http://commons.wikimedia.org/?diff=47668654oldid=47668650rcid=48853202
** wgAction: view; should be 'historysubmit' or 'diff'

- Links manually constructed -
* http://translatewiki.net/wiki/Main_Page?diff=curr
** wgAction: view; should be 'historysubmit' or 'diff'

* http://translatewiki.net/wiki/Main_Page?action=historysubmit
** wgAction: historysubmit; should be: 'view'

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #12 from Reedy s...@reedyboy.net 2010-12-31 19:21:15 UTC ---
(In reply to comment #10)
 This is a classic pitfall for the MySQL optimizer.  What version are you 
 using?
  On the toolserver, 5.1.53, it avoids the filesort.

re...@ubuntu64-esxi:~$ mysql --version
mysql  Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline
6.1


What comes with Ubuntu 10.10 x64 Server

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #13 from Reedy s...@reedyboy.net 2010-12-31 19:45:12 UTC ---
-- Freetext tagging for revisions
CREATE TABLE /*_*/code_tags (
  ct_repo_id int not null,
  ct_rev_id int not null,
  ct_tag varbinary(255) not null,

  primary key (ct_repo_id,ct_rev_id,ct_tag)
) /*$wgDBTableOptions*/;

CREATE INDEX /*i*/ct_repo_id ON /*_*/code_tags (ct_repo_id,ct_tag,ct_rev_id);

That suggested index is seemingly already there...


It seems like on general you're agreeing with the just leave them be...
Versions that improve/fix the optimiser will improve queries, and like you
said, we're not going to have millions upon millions of revisions...

For the equality propagation, the originals had foo = bar AND bar = 3 (or
something similar), i was just poking around and changed for explicit values.

Seemingly, the best thing is maybe getting it to do FORCE INDEX.. But it isn't
garunteed to help

Maybe just remove the technical restrictions people have put in, which are
causing some annoyances, and close the bugs...?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #14 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-12-31 
19:49:18 UTC ---
Oops, yeah, I missed the index.  Try adding FORCE INDEX (ct_repo_id) and see
what that gives you.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #15 from Reedy s...@reedyboy.net 2010-12-31 20:01:59 UTC ---
mysql describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp FROM
`mw_code_tags`,`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id =
cr_repo_id AND cc_rev_id = cr_id)) WHERE cr_repo_id = ct_repo_id AND
(ct_repo_id = '3') AND (cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY cr_id
ORDER BY cr_id DESC LIMIT 51;
++-+-++-++-++--+---+
| id | select_type | table   | type   | possible_keys  
| key| key_len | ref   
| rows | Extra |
++-+-++-++-++--+---+
|  1 | SIMPLE  | mw_code_tags| ref| PRIMARY,ct_repo_id 
| PRIMARY| 4   | const 
|1 | Using where; Using index; Using temporary; Using filesort |
|  1 | SIMPLE  | mw_code_rev | eq_ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 8   |
const,wikidb.mw_code_tags.ct_rev_id|1 | Using where
  |
|  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time
| cc_repo_id | 8   |
wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id |1 | Using index
  |
++-+-++-++-++--+---+
3 rows in set (0.00 sec)

mysql describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_tags` FORCE
INDEX (ct_repo_id),`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id =
cr_repo_id AND cc_rev_id = cr_id)) WHERE cr_repo_id = ct_repo_id AND
(ct_repo_id = '3') AND (cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY cr_id
ORDER BY cr_id DESC LIMIT 51;
++-+-++-++-++--+---+
| id | select_type | table   | type   | possible_keys  
| key| key_len | ref   
| rows | Extra |
++-+-++-++-++--+---+
|  1 | SIMPLE  | mw_code_tags| ref| ct_repo_id 
| ct_repo_id | 261 | const,const   
|1 | Using where; Using index; Using temporary; Using filesort |
|  1 | SIMPLE  | mw_code_rev | eq_ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 8   |
const,wikidb.mw_code_tags.ct_rev_id|1 | Using where
  |
|  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time
| cc_repo_id | 8   |
wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id |1 | Using index
  |
++-+-++-++-++--+---+
3 rows in set (0.00 sec)


No improvement unfortunately :(

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #16 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-12-31 
20:04:49 UTC ---
Then it's probably lack of equality propagation.  Change cr_id to ct_rev_id in
the ORDER BY and GROUP BY clauses.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #17 from Reedy s...@reedyboy.net 2010-12-31 20:07:08 UTC ---
mysql describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_tags` FORCE
INDEX (ct_repo_id),`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id =
cr_repo_id AND cc_rev_id = cr_id)) WHERE cr_repo_id = ct_repo_id AND
(ct_repo_id = '3') AND (cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY ct_rev_id
ORDER BY ct_rev_id DESC LIMIT 51;
++-+-++-++-++--+--+
| id | select_type | table   | type   | possible_keys  
| key| key_len | ref   
| rows | Extra|
++-+-++-++-++--+--+
|  1 | SIMPLE  | mw_code_tags| ref| ct_repo_id 
| ct_repo_id | 261 | const,const   
|1 | Using where; Using index |
|  1 | SIMPLE  | mw_code_rev | eq_ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 8   |
const,wikidb.mw_code_tags.ct_rev_id|1 | Using where
 |
|  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time
| cc_repo_id | 8   |
wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id |1 | Using index
 |
++-+-++-++-++--+--+
3 rows in set (0.00 sec)

mysql describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_tags`,
`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cr_repo_id AND
cc_rev_id = cr_id)) WHERE cr_repo_id = ct_repo_id AND (ct_repo_id = '3') AND
(cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY ct_rev_id ORDER BY ct_rev_id DESC
LIMIT 51;
++-+-++-++-++--+--+
| id | select_type | table   | type   | possible_keys  
| key| key_len | ref   
| rows | Extra|
++-+-++-++-++--+--+
|  1 | SIMPLE  | mw_code_tags| ref| PRIMARY,ct_repo_id 
| PRIMARY| 4   | const 
|1 | Using where; Using index |
|  1 | SIMPLE  | mw_code_rev | eq_ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 8   |
const,wikidb.mw_code_tags.ct_rev_id|1 | Using where
 |
|  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time
| cc_repo_id | 8   |
wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id |1 | Using index
 |
++-+-++-++-++--+--+
3 rows in set (0.00 sec)


Removing the force index, and just changing the order by/group by improves
it...

Coool

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #18 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 20:12:02 
UTC ---
(In reply to comment #11)
 (Of course, the query isn't scalable anyway due to COUNT().  It will have to
 scan arbitrarily many rows.  The only way to fully fix it would be to use a
 summary table of some kind, but those are a pain to maintain, so better not to
 do that unless you can't fix it some other way.  It's not like we're going to
 have 100 million code reviews anytime soon.)

Yes, the COUNT() should be killed. Its results aren't displayed in trunk
anymore anyway. The point about the code_rev table being smallish is also true,
that's why these queries aren't much of a problem in practice.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #19 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 20:17:29 
UTC ---
(In reply to comment #18)
 Yes, the COUNT() should be killed. Its results aren't displayed in trunk
 anymore anyway.
Ignore me, this is a different COUNT

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 CC||s...@reedyboy.net,
   ||simetrical+wikib...@gmail.c
   ||om

--- Comment #2 from Reedy s...@reedyboy.net 2010-12-31 20:33:36 UTC ---
mysql describe SELECT cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT
cc_id) AS comments,cr_path,cr_message,cr_author,cr_timestamp  FROM
`mw_code_paths` INNER JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id
= cp_rev_id)) LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND
cc_rev_id = cp_rev_id))  WHERE cp_repo_id = '3' AND (cp_path  LIKE
'/trunk/extensions/Cite/cite\_text%' ) AND (cp_rev_id  58352)  GROUP BY
cp_rev_id ORDER BY cp_rev_id;
++-+-+---+-++-+--+---+--+
| id | select_type | table   | type  | possible_keys   
   | key| key_len | ref
 | rows  | Extra|
++-+-+---+-++-+--+---+--+
|  1 | SIMPLE  | mw_code_rev | range |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 8   | NULL  
  | 21804 | Using where; Using
temporary; Using filesort |
|  1 | SIMPLE  | mw_code_paths   | ref   | PRIMARY 
   | PRIMARY| 8   | const,wikidb.mw_code_rev.cr_id 
 | 2 | Using where; Using index |
|  1 | SIMPLE  | mw_code_comment | ref   | cc_repo_id,cc_repo_time 
   | cc_repo_id | 8   |
wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index 
|
++-+-+---+-++-+--+---+--+
3 rows in set (0.00 sec)


mysql describe SELECT cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT
cc_id) AS comments,cr_path,cr_message,cr_author,cr_timestamp  FROM
`mw_code_paths` INNER JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id
= cp_rev_id)) LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND
cc_rev_id = cp_rev_id))  WHERE cp_repo_id = '3' AND (cp_path  LIKE
'/trunk/extensions/Cite/cite\_text%' ) GROUP BY cp_rev_id ORDER BY cp_rev_id;
++-+-+--+-++-+--+---+-+
| id | select_type | table   | type | possible_keys
  | key| key_len | ref 
| rows  | Extra   |
++-+-+--+-++-+--+---+-+
|  1 | SIMPLE  | mw_code_rev | ref  |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 4   | const 
  | 49838 | Using temporary; Using
filesort |
|  1 | SIMPLE  | mw_code_paths   | ref  | PRIMARY  
  | PRIMARY| 8   | const,wikidb.mw_code_rev.cr_id  
| 2 | Using where; Using index|
|  1 | SIMPLE  | mw_code_comment | ref  | cc_repo_id,cc_repo_time  
  | cc_repo_id | 8   |
wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index 
   |
++-+-+--+-++-+--+---+-+
3 rows in set (0.00 sec)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26523] 'Back' button is missing in the 'Complete' page of the MediaWiki installation

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26523

Chad H. innocentkil...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||INVALID

--- Comment #2 from Chad H. innocentkil...@gmail.com 2010-12-31 20:33:45 UTC 
---
This was also done on purpose, see r78165.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 CC||simetrical+wikib...@gmail.c
   ||om

--- Comment #1 from Reedy s...@reedyboy.net 2010-12-31 20:38:32 UTC ---
if ( $this-mStartRev  ( $lastRev - 1 ) ) {
global $wgOut;
$wgOut-addHtml( wfMsgHtml( 'code-release-badrange' ) );
return;
}

Seems this one is 10k now ;)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26194] WikiEditor + Liquidthreads: addModules is called once for each comment, increasing page load times drastically

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26194

Roan Kattouw roan.katt...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||FIXED

--- Comment #3 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 20:39:40 
UTC ---
Deployed your patch, thanks.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

--- Comment #2 from Chad H. innocentkil...@gmail.com 2010-12-31 20:40:15 UTC 
---
I bumped it to 10k and committed to trunk. Was this merged to deployment?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

--- Comment #3 from Reedy s...@reedyboy.net 2010-12-31 20:42:58 UTC ---
mysql DESCRIBE SELECT cr_message,cr_author,cr_id,ct_tag AS rnotes  FROM
`mw_code_rev` LEFT JOIN `mw_code_tags` ON ((ct_repo_id = cr_repo_id AND
ct_rev_id = cr_id AND ct_tag = release-notes))  WHERE cr_repo_id = '3' AND
(cr_status NOT IN('reverted','deferred','fixme')) AND (cr_message != '') AND
(cr_id BETWEEN 77000 AND 78000 AND (cr_path  LIKE '/trunk/phase3/%'  OR cr_path
= '/trunk/phase3'))  ORDER BY cr_id DESC ;
++-+--++-+-+-+--+--+-+
| id | select_type | table| type   | possible_keys 
 | key | key_len | ref 
| rows | Extra   |
++-+--++-+-+-+--+--+-+
|  1 | SIMPLE  | mw_code_rev  | range  |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 8   | NULL 
   | 2370 | Using where |
|  1 | SIMPLE  | mw_code_tags | eq_ref | PRIMARY,ct_repo_id
 | PRIMARY | 265 |
wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id,const |1 | Using
index |
++-+--++-+-+-+--+--+-+
2 rows in set (0.00 sec)


That query looks fine :|

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

--- Comment #4 from Reedy s...@reedyboy.net 2010-12-31 20:50:55 UTC ---
Doing that query... With SQL_NO_CACHE

327 rows in set (0.00 sec)

I'm thinking this isn't too bad. I'm gonna remove the technical restrictions
later on today and close this bug :)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 19699] Deploy LiquidThreads extension when ready

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=19699

--- Comment #3 from Rob Lanphier ro...@wikimedia.org 2010-12-31 20:57:04 UTC 
---
Brandon and Andrew, is it still appropriate to ask Ops to get through this
backlog, or do you prefer they hold off until the next version of LQT?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

--- Comment #3 from Aryeh Gregor simetrical+wikib...@gmail.com 2010-12-31 
21:03:07 UTC ---
As Roan suggests, this should be fixed by storing paths more redundantly, so
the LIKE can be made into an equality check.  Otherwise there's no way to get
it to play nice with the grouping/ordering.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Roan Kattouw roan.katt...@gmail.com changed:

   What|Removed |Added

 CC||roan.katt...@gmail.com

--- Comment #4 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 21:07:31 
UTC ---
(In reply to comment #3)
 As Roan suggests, this should be fixed by storing paths more redundantly, so
 the LIKE can be made into an equality check.  Otherwise there's no way to get
 it to play nice with the grouping/ordering.

Elaborating on my suggestion on IRC:

Currently we only store the path of each changed file in the paths table. If
instead we also stored the paths of all of their ancestors, we could simply do
WHERE cp_path='/trunk/phase3' instead of WHERE cp_path LIKE '/trunk/phase3%' ,
which will search directories recursively.

For example, for a commit that touches ApiQueryBase.php and MessagesEn.php,
we'd store the following paths:

/trunk/phase3/includes/api/ApiQueryBase.php
/trunk/phase3/includes/api
/trunk/phase3/includes
/trunk/phase3/languages/messages/MessagesEn.php
/trunk/phase3/languages/messages
/trunk/phase3/languages
/trunk/phase3
/trunk

This would improve query performance at the expense of table size.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 19699] Deploy LiquidThreads extension when ready

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=19699

--- Comment #4 from Brandon Harris bhar...@wikimedia.org 2010-12-31 21:07:36 
UTC ---
I'd prefer to hold off.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

--- Comment #5 from Reedy s...@reedyboy.net 2010-12-31 21:55:03 UTC ---
Interesting. We'd also need to presumably back populate this for the old
revs...

No database changes, just some more coding changes to split stuff down...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26520] Add HTML relative links and PREVIOUS, NEXT buttons to WikiBooks sections

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26520

Bawolff bawolff...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||DUPLICATE

--- Comment #1 from Bawolff bawolff...@gmail.com 2010-12-31 21:39:31 UTC ---
How is this a DPL issue?

If this was to be implemented (I believe opera supports such links, so does
lynx, which are obviously not a large portion of the market share, but some
people do support it, so its not exactly change for change sake) it would
probably be implemented manually by wiki-editors using
{{#link:some_page|type=next}} -ish syntax (with certain types whitelisted.
Don't want people adding css/etc obviously)

--- Comment #2 from Bawolff bawolff...@gmail.com 2010-12-31 22:07:14 UTC ---


*** This bug has been marked as a duplicate of bug 1437 ***

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 1437] Adding HTML-Metadata in link-Tags?

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=1437

Bawolff bawolff...@gmail.com changed:

   What|Removed |Added

 CC||jida...@jidanni.org

--- Comment #4 from Bawolff bawolff...@gmail.com 2010-12-31 22:07:14 UTC ---
*** Bug 26520 has been marked as a duplicate of this bug. ***

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

--- Comment #6 from Roan Kattouw roan.katt...@gmail.com 2010-12-31 22:19:51 
UTC ---
(In reply to comment #5)
 Interesting. We'd also need to presumably back populate this for the old
 revs...
 
Yes. I could do that locally and measure the size increase that way.

 No database changes, just some more coding changes to split stuff down...
Exactly.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26517] On install - Database returned error 1071: Specified key was too long;

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26517

--- Comment #3 from David Foote urbanvint...@gmail.com 2010-12-31 23:30:41 
UTC ---
@Reedy, Changing to a Latin Collation seems to have to effect.  The database
charset is Unicode too though, which I need it to be incidentally

@Roan - Not sure what you mean?  Can you explain further

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26517] On install - Database returned error 1071: Specified key was too long;

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26517

--- Comment #4 from Roan Kattouw roan.katt...@gmail.com 2011-01-01 00:39:09 
UTC ---
(In reply to comment #3)
 @Roan - Not sure what you mean?  Can you explain further
My question was directed to the MySQL experts around here. IIRC changing
varchar to varbinary in the table definition was previously used to fix a
similar case.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26529] New: Run CodeReview repopulateCodePaths maintenance script on mediawiki wiki

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26529

   Summary: Run CodeReview repopulateCodePaths maintenance script
on mediawiki wiki
   Product: Wikimedia
   Version: unspecified
  Platform: All
OS/Version: All
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: Site requests
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: s...@reedyboy.net
Depends on: 24479


Run CodeReview populateFollowupRevisions maintenance script on mediawiki wiki,
so we can use the more efficient path searching :)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks||26529

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26529] Run CodeReview repopulateCodePaths maintenance script on mediawiki wiki

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26529

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Depends on|24479   |23720

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks||26529

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks|26529   |

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26416] Ability to view the revision follow-up tree

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26416

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks||23855

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23855] Non Core API Tracking bug

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23855

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Depends on||26416

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

--- Comment #7 from Reedy s...@reedyboy.net 2011-01-01 00:49:41 UTC ---
r79379, r79381, r79382, r79384...

Before:
mysql select count(*) from mw_code_paths WHERE cp_repo_id = 3 AND cp_rev_id 
1 AND cp_rev_id  1000;
+--+
| count(*) |
+--+
| 2580 |
+--+
1 row in set (0.02 sec)


After:

mysql select count(*) from mw_code_paths WHERE cp_repo_id = 3 AND cp_rev_id 
1 AND cp_rev_id  1000;
+--+
| count(*) |
+--+
| 6600 |
+--+
1 row in set (0.00 sec)

After the first 1000 done

mysql select count(*) from mw_code_paths WHERE cp_repo_id = 3;
+--+
| count(*) |
+--+
|   516313 |
+--+
1 row in set (0.26 sec)


After the whole repo (78352 locally)

mysql select count(*) from mw_code_paths WHERE cp_repo_id = 3;
+--+
| count(*) |
+--+
|   988825 |
+--+
1 row in set (1.93 sec)


Not really fast, but hardly slow either. Took a few minutes to execute

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Depends on||23720

--- Comment #5 from Reedy s...@reedyboy.net 2011-01-01 00:50:45 UTC ---
Linking to 23720, as this has a similar path based bug

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks||25437

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||FIXED

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26529] Run CodeReview repopulateCodePaths maintenance script on mediawiki wiki

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26529

Bug 26529 depends on bug 23720, which changed state.

Bug 23720 Summary: CodeReview doesn't show ancient revisions for a path
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

   What|Old Value   |New Value

 Status|NEW |RESOLVED
 Resolution||FIXED

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

Bug 25437 depends on bug 23720, which changed state.

Bug 23720 Summary: CodeReview doesn't show ancient revisions for a path
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

   What|Old Value   |New Value

 Status|NEW |RESOLVED
 Resolution||FIXED

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 23720] CodeReview doesn't show ancient revisions for a path

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks||24479
 Depends on|24479   |

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks|23720   |
 Depends on||23720

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks||24479
 Depends on|24479   |

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Blocks|25437   |
 Depends on||25437

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25437] Increase release notes range

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

Reedy s...@reedyboy.net changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution||FIXED

--- Comment #6 from Reedy s...@reedyboy.net 2011-01-01 01:09:18 UTC ---
r79395, r79400

And the stuff to improve the way all the paths were saved beforehand

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Bug 24479 depends on bug 25437, which changed state.

Bug 25437 Summary: Increase release notes range
https://bugzilla.wikimedia.org/show_bug.cgi?id=25437

   What|Old Value   |New Value

 Status|NEW |RESOLVED
 Resolution||FIXED

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many unindexed queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #20 from Reedy s...@reedyboy.net 2011-01-01 01:22:55 UTC ---
So, 2 explicitally reported bugs now fixed.

Improved query for Tags in r79365 based on the above help...

Wonder what else needs fixing up...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26528] wgAction variable needs to represent what PHP actually does, not just what the URL suggests

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26528

Krinkle krinklem...@gmail.com changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 CC||krinklem...@gmail.com
 Resolution||DUPLICATE

--- Comment #1 from Krinkle krinklem...@gmail.com 2011-01-01 02:05:33 UTC ---


*** This bug has been marked as a duplicate of bug 25800 ***

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 25800] wgAction incorrectly asumes 'view' instead of 'historysubmit' on diff-pages without a action parameter

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=25800

--- Comment #1 from Krinkle krinklem...@gmail.com 2011-01-01 02:05:33 UTC ---
*** Bug 26528 has been marked as a duplicate of this bug. ***

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many inefficient queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

Reedy s...@reedyboy.net changed:

   What|Removed |Added

Summary|CodeReview has many |CodeReview has many
   |unindexed queries   |inefficient queries

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many inefficient queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #21 from Reedy s...@reedyboy.net 2011-01-01 02:20:54 UTC ---
Filtered by path and status
mysql describe SELECT /* IndexPager::reallyDoQuery (SvnRevStatusTablePager)
Reedy */  cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp  FROM `mw_code_paths` INNER
JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id = cp_rev_id)) LEFT
JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND cc_rev_id = cp_rev_id))
 WHERE cp_repo_id = '3' AND cp_path = '/trunk' AND cr_status = 'new'  GROUP BY
cp_rev_id ORDER BY cp_rev_id DESC LIMIT 51;
++-+-++-++-+--+---+--+
| id | select_type | table   | type   | possible_keys  
| key| key_len | ref   
  | rows  | Extra|
++-+-++-++-+--+---+--+
|  1 | SIMPLE  | mw_code_rev | ref|
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 4   | const 
  | 45393 | Using where; Using
temporary; Using filesort |
|  1 | SIMPLE  | mw_code_paths   | eq_ref | PRIMARY
| PRIMARY| 265 | const,wikidb.mw_code_rev.cr_id,const  
  | 1 | Using where; Using index |
|  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time
| cc_repo_id | 8   |
wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index 
|
++-+-++-++-+--+---+--+
3 rows in set (0.00 sec)

Filtered by path

mysql describe SELECT /* IndexPager::reallyDoQuery (SvnRevTablePager) Reedy */
 cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS
comments,cr_path,cr_message,cr_author,cr_timestamp  FROM `mw_code_paths` INNER
JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id = cp_rev_id)) LEFT
JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND cc_rev_id = cp_rev_id))
 WHERE cp_repo_id = '3' AND cp_path = '/trunk'  GROUP BY cp_rev_id ORDER BY
cp_rev_id DESC LIMIT 51;
++-+-++-++-+--+---+-+
| id | select_type | table   | type   | possible_keys  
| key| key_len | ref   
  | rows  | Extra   |
++-+-++-++-+--+---+-+
|  1 | SIMPLE  | mw_code_rev | ref|
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY| 4   | const 
  | 45393 | Using temporary; Using
filesort |
|  1 | SIMPLE  | mw_code_paths   | eq_ref | PRIMARY
| PRIMARY| 265 | const,wikidb.mw_code_rev.cr_id,const  
  | 1 | Using where; Using index|
|  1 | SIMPLE  | mw_code_comment | ref| cc_repo_id,cc_repo_time
| cc_repo_id | 8   |
wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index 
   |
++-+-++-++-+--+---+-+
3 rows in set (0.00 sec)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many inefficient queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #22 from Reedy s...@reedyboy.net 2011-01-01 02:23:12 UTC ---
Both of the above can be made nice by sorting and grouping by cr_id rather
than cp_rev_id

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many inefficient queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #23 from Reedy s...@reedyboy.net 2011-01-01 02:30:46 UTC ---
Above ones fixed in r79409

Filesort:


mysql describe SELECT /* IndexPager::reallyDoQuery
(CodeStatusChangeTablePager) Reedy */ 
cpc_timestamp,cpc_user_text,cpc_rev_id,cr_author,cr_message,cpc_removed,cpc_added,cr_status
 FROM `mw_code_prop_changes` LEFT JOIN `mw_code_rev` ON ((cpc_repo_id =
cr_repo_id AND cpc_rev_id = cr_id))  WHERE cpc_repo_id = '3' AND cpc_attrib =
'status'  ORDER BY cpc_timestamp DESC LIMIT 51;
++-+--++-+---+-++--+-+
| id | select_type | table| type   | possible_keys 
 | key   | key_len | ref   
| rows | Extra 
 |
++-+--++-+---+-++--+-+
|  1 | SIMPLE  | mw_code_prop_changes | ref|
cpc_repo_rev_time,cpc_repo_time | cpc_repo_rev_time | 4   | const  
   |   10 |
Using where; Using filesort |
|  1 | SIMPLE  | mw_code_rev  | eq_ref |
PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY   | 8   |
wikidb.mw_code_prop_changes.cpc_repo_id,wikidb.mw_code_prop_changes.cpc_rev_id
|1 | |
++-+--++-+---+-++--+-+
2 rows in set (0.00 sec)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26530] New: Enabling compare feature between pages using the same infobox

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26530

   Summary: Enabling compare feature between pages using the
same infobox
   Product: MediaWiki
   Version: unspecified
  Platform: All
OS/Version: All
Status: NEW
  Keywords: shell
  Severity: enhancement
  Priority: Normal
 Component: Javascript
AssignedTo: d...@ucsc.edu
ReportedBy: rehman.wikime...@live.com
CC: tpars...@wikimedia.org, rehman.wikime...@live.com


The summary pretty much says it all:

To enable a compare button (as what you see when purchasing electronics on
certain websites), which would compare the infobox fields of two separate pages
using the same infobox.

For example:

If you have two articles for two camera models, using the same Infobox
camera, clicking the compare button would:

1. Open a new page in a new window/tab (probably a Special: page)

2. The new page will contain two fields (with maybe a + to add more), in
which you may enter the pages to compare. The first field would be pre-filled
with the page title of which the user clicked compare. Suggestions could be
enabled on these fields, just like the Wikipedia Search Bar.

3. After selecting the articles, clicking compare now on the new page would
load a table containing: columns for each article, and rows to compare each
fields.

For those infoboxes that are not fully filled, a simple [N/A] or [No info]
could be displayed in its place, with hover-text explaining further.

This would be a really cool feature for readers...

BTW, Happy New Year 2011! :)

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 24479] CodeReview has many inefficient queries

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=24479

--- Comment #24 from Reedy s...@reedyboy.net 2011-01-01 02:38:52 UTC ---
I'm guessing this one might need another index...

It's doing

cpc_repo_id, cpc_rev_id in the LEFT JOIN

And then

cpc_repo_id cpc_attrib cpc_timestamp



Also, this table doesn't have a Primary Key..

--
-- Changes to review metadata for a single code revision.
--
CREATE TABLE /*_*/code_prop_changes (
  -- Repository ID
  cpc_repo_id int not null,
  -- Native ID number of this revision within the repository.
  cpc_rev_id int not null,

  -- The item that was changed
  cpc_attrib enum('status','tags') not null,
  -- How it was changed
  cpc_removed blob,
  cpc_added blob,

  -- Timestamp of the change, in MediaWiki format.
  cpc_timestamp binary(14) not null default '',

  -- User id/name of the commenter
  cpc_user int not null,
  cpc_user_text varchar(255) not null
) /*$wgDBTableOptions*/;

CREATE INDEX /*i*/cpc_repo_rev_time ON /*_*/code_prop_changes (cpc_repo_id,
cpc_rev_id, cpc_timestamp);
CREATE INDEX /*i*/cpc_repo_time ON /*_*/code_prop_changes (cpc_repo_id,
cpc_timestamp);


code_signoffs also doesn't have a PK... But does have a unique index...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26530] Enabling compare feature between pages using the same infobox

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26530

--- Comment #1 from Reedy s...@reedyboy.net 2011-01-01 02:54:24 UTC ---
A special compare pages has already been added in SVN..

So this would just be targetting it at a subset of the article...

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26529] Run CodeReview repopulateCodePaths maintenance script on mediawiki wiki

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26529

Reedy s...@reedyboy.net changed:

   What|Removed |Added

   Keywords||shell

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26530] Enabling compare feature between pages using the same infobox

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26530

Reedy s...@reedyboy.net changed:

   What|Removed |Added

   Keywords|shell   |

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26524] auto redirect facility in Tamil Wiktionary

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26524

--- Comment #1 from Reedy s...@reedyboy.net 2011-01-01 02:59:05 UTC ---
This is by default - On english wiktionary, they want [[Test]] to be different
to [[test]]

To be able to have this changed made, needs community agreement to make this
change

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26263] Remove Wikimedia specific maintenance scripts from phase3

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26263

Reedy s...@reedyboy.net changed:

   What|Removed |Added

Summary|dumpInterwiki.php is|Remove Wikimedia specific
   |Wikimedia specific  |maintenance scripts from
   ||phase3

--- Comment #1 from Reedy s...@reedyboy.net 2011-01-01 03:46:51 UTC ---
dumpInterwiki.php and addwiki.php

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26531] New: Double redirect

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26531

   Summary: Double redirect
   Product: MediaWiki
   Version: wikimedia-deployment
  Platform: All
   URL: http://www.niwanetwork.org/forums/index.php?topic=713.
msg14049#msg14049
OS/Version: All
Status: NEW
  Severity: enhancement
  Priority: Normal
 Component: Redirects
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: bud0...@gmail.com


I apologize if this is a duplicate of another bug, i searched around and didn't
find one that looked similar to mine.

 

Bulbapedia has redirects to pages on other wiki's using that wiki's interwiki
code. 

It works perfectly, but it fills up the double redirects list (see
http://bulbapedia.bulbagarden.net/wiki/Special:DoubleRedirects). 


See the related forum post:
http://www.niwanetwork.org/forums/index.php?topic=713.msg14049#msg14049

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26531] Double redirect with interwiki codes

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26531

bud0...@gmail.com changed:

   What|Removed |Added

Summary|Double redirect |Double redirect with
   ||interwiki codes

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26531] Redirect to Semantic wiki listed in Special:DoubleRedirects

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26531

Krinkle krinklem...@gmail.com changed:

   What|Removed |Added

 CC||krinklem...@gmail.com
Summary|Double redirect with|Redirect to Semantic wiki
   |interwiki codes |listed in
   ||Special:DoubleRedirects

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 26531] Redirect to Semantic wiki listed in Special:DoubleRedirects

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=26531

--- Comment #1 from bud0...@gmail.com 2011-01-01 05:24:37 UTC ---
If you don't mind me asking, what's a Semantic wiki?

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l


[Bug 20231] Allow archiving of CentralNotice templates

2010-12-31 Thread bugzilla-daemon
https://bugzilla.wikimedia.org/show_bug.cgi?id=20231

Philippe Beaudette pbeaude...@wikimedia.org changed:

   What|Removed |Added

 CC||pbeaude...@wikimedia.org
   Severity|minor   |normal

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l