[Bug 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #17 from Umherirrender umherirrender_de...@web.de 2012-09-29 10:44:13 UTC --- No more question on wiki about wrong new messages bars, so there was something done. Thanks. -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #16 from Umherirrender umherirrender_de...@web.de 2012-09-04 18:51:32 UTC --- Please add a status info. Thanks. -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #15 from Umherirrender umherirrender_de...@web.de 2012-08-27 19:25:07 UTC --- Please add a status info. Thanks. -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #14 from Umherirrender umherirrender_de...@web.de 2012-07-07 20:26:51 UTC --- Please add a status info. Thanks. -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #13 from Umherirrender umherirrender_de...@web.de 2012-04-14 19:23:37 UTC --- current(In reply to comment #12) PAGE makes it unhappy means a sql error or a long query run time? Feel free to make the query better or split it in two queries (one for users and one for anons) -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #11 from Reedy s...@reedyboy.net 2011-09-16 12:50:31 UTC --- Everywhere is now MySQL 5.1 -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #12 from Reedy s...@reedyboy.net 2011-09-16 12:52:59 UTC --- SELECT * FROM user_newtalk WHERE user_id IN ( SELECT n.user_id FROM ( user_newtalk n JOIN user u ON u.user_id = n.user_id ) LEFT JOIN page p ON u.user_name = p.page_title AND p.page_namespace =3 WHERE p.page_title IS NULL ) OR user_ip IN ( SELECT n.user_ip FROM user_newtalk n LEFT JOIN page p ON n.user_ip = p.page_title AND p.page_namespace =3 WHERE p.page_title IS NULL AND n.user_id =0 ); PAGE makes it unhappy -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #10 from Reedy s...@reedyboy.net 2011-07-08 22:20:10 UTC --- (In reply to comment #7) Special:Version says it's MySQL 5.1.46-facebook-r3489-log now ... and why is it Facebook? It's a facebook optimised version of MySQL There's still some clusters with MySQL from memory... -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #6 from Umherirrender umherirrender_de...@web.de 2010-07-30 09:44:31 UTC --- (In reply to comment #5) Subqueries cannot be used in MySQL 4. Thanks for that informationen. Have anybody a better query? Each of the subquery should work stand alone. -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Liangent liang...@gmail.com changed: What|Removed |Added CC||liang...@gmail.com --- Comment #7 from Liangent liang...@gmail.com 2010-07-30 10:02:14 UTC --- Special:Version says it's MySQL 5.1.46-facebook-r3489-log now ... and why is it Facebook? -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #8 from p858snake p858sn...@gmail.com 2010-07-30 10:07:38 UTC --- (In reply to comment #7) Special:Version says it's MySQL 5.1.46-facebook-r3489-log now ... and why is it Facebook? Which install are you looking at? -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 --- Comment #9 from p858snake p858sn...@gmail.com 2010-07-30 10:07:53 UTC --- bah i see it -- 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 23847] Clean up table user_newtalk
https://bugzilla.wikimedia.org/show_bug.cgi?id=23847 Niklas Laxström niklas.laxst...@gmail.com changed: What|Removed |Added CC||niklas.laxst...@gmail.com Summary|cleanup table user_newtalk |Clean up table user_newtalk -- 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