[Bug 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 --- Comment #3 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: reza reza.ene...@gmail.com Date: Thu, 08 Dec 2011 23:15:35 --- thank you now it is correct but why Fields are not the same as help and trunk? -- 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 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #7 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: h...@online.de CC list: reza.ene...@gmail.com, h...@online.de, wikimedia-bugzi...@dabpunkt.eu -- 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 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 --- Comment #5 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: DaB. d...@ts.wikimedia.org Date: Thu, 08 Dec 2011 23:27:12 --- Please notice that ts_wl_user_touched_cropped is not a cropped wl_notificationtimestamp, but a cropped user_touched (the watchlist-table is joined with the user-table for that view). -- 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 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 --- Comment #4 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Hoo man h...@online.de Date: Thu, 08 Dec 2011 23:21:34 --- Great ![][1] The toolserver tables don't include all information the real databases do, mostly because of privacy reasons. So in the given example the timestamp is cropped so that only year, month and day can be seen. [1]: https://jira.toolserver.org/images/icons/emoticons/smile.gif -- 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 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 --- Comment #6 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: reza reza.ene...@gmail.com Date: Thu, 08 Dec 2011 23:58:20 --- Thank you -- 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 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 --- Comment #1 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: reza reza.ene...@gmail.com Date: Thu, 08 Dec 2011 00:12:52 --- also for SELECT Wl_title,Count(Wl_title) FROM watchlist JOIN page ON page_title=Wl_title WHERE page_title=فرح_پهلوی AND Wl_namespace=0 AND page_len0 GROUP BY Wl_title; and http://toolserver.org/~mzmcbride/watcher/?db=fawiki_ptitles=%D9%81%D8%B1%D8%AD_%D9%BE%D9%87%D9%84%D9%88%DB%8C has different answers -- 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 59442] DBQ-171 Bug In wachlist Query
https://bugzilla.wikimedia.org/show_bug.cgi?id=59442 --- Comment #2 from Bugzilla Bug Importer (valhallasw) wmf.bugconver...@gmail.com --- --- From: Hoo man h...@online.de Date: Thu, 08 Dec 2011 22:46:24 --- In the query within the comment you forgot AND page_namespace=0 So the right query is: SELECT Wl_title,Count(Wl_title) FROM watchlist JOIN page ON page_title=Wl_title WHERE page_title=فرح_پهلوی AND Wl_namespace=0 AND page_len0 AND page_namespace=0 GROUP BY Wl_title; Which should be equal to SELECT Wl_title,Count(Wl_title) FROM watchlist WHERE wl_title = 'فرح_پهلوی' AND wl_namespace = 0; I think you did the same mistake in the queries within the description, but I don't have enough time to test that atm... It would be fine, if you could tell, if it's the solution. -- 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