Last modified: 2014-06-13 12:14:20 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T54151, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 52151 - hebrew wikipedia tools databases in tools


Summary:	hebrew wikipedia tools databases in tools

Status:	RESOLVED INVALID

Product:	Wikimedia Labs
Classification:	Unclassified
Component:	Infrastructure (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal
Target Milestone:	---
Assigned To:	Ryan Lane

URL:
Whiteboard:	aklapper-moreinfo
Keywords:

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2013-07-27 16:58 UTC by orenbochman
Modified:	2014-06-13 12:14 UTC (History)
CC List:	4 users (show)

See Also:
Web browser:	---
Mobile Platform:	---
Assignee Huggle Beta Tester:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description orenbochman 2013-07-27 16:58:36 UTC

When running the following query on the a query on the Hebrew language database in tool labs there are some Unexpected results.

SELECT `rev_user_text`, `page_title` FROM `revision`
JOIN `page` ON `page_id` = `rev_page`
JOIN `user_groups` ON `ug_user` = `rev_user`
WHERE `page_namespace` = '3' 
AND `page_is_redirect` = '0' 
AND `ug_group` != 'bot' 
AND `page_title` NOT LIKE '%/%';

Methinks This may be a collation issue or something to do with slash definition.

Comment 1 Tim Landscheidt 2013-07-27 17:37:35 UTC

What's the expected output, what do you get instead?

Comment 2 Andre Klapper 2014-03-11 10:37:31 UTC

Oren: 

(In reply to Tim Landscheidt from comment #1)
> What's the expected output, what do you get instead?

Also, is this still a problem?

Comment 3 Andre Klapper 2014-06-13 12:14:20 UTC

Unfortunately closing this report as no further information has been provided.

orenbochman: Please feel free to reopen this report if you can provide the information asked for in comment 1 and comment 2, and if this still happens. Thanks!

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links