[Bug 24166] API error when using rvprop=tags
https://bugzilla.wikimedia.org/show_bug.cgi?id=24166 --- Comment #3 from Reedy s...@reedyboy.net 2010-09-01 16:35:15 UTC --- SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest,ts_tags,old_id,old_text,old_flags FROM `mw_page`,`mw_revision` JOIN `mw_text` LEFT JOIN `mw_tag_summary` ON ((rev_id=ts_rev_id)) WHERE (page_id = rev_page) AND (rev_text_id=old_id) AND rev_id = '33' ORDER BY rev_id LIMIT 2; Fixes it Per http://www.delphifaq.com/faq/databases/mysql/f1110.shtml a join before the last table before the left join :/ Mmmm, Hax? -- 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 24166] API error when using rvprop=tags
https://bugzilla.wikimedia.org/show_bug.cgi?id=24166 Reedy s...@reedyboy.net changed: What|Removed |Added Status|NEW |RESOLVED Resolution||FIXED --- Comment #4 from Reedy s...@reedyboy.net 2010-09-01 16:47:43 UTC --- r72116 -- 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 24166] API error when using rvprop=tags
https://bugzilla.wikimedia.org/show_bug.cgi?id=24166 --- Comment #2 from Reedy s...@reedyboy.net 2010-08-28 00:14:30 UTC --- http://192.168.0.190/w/api.php?action=queryprop=revisionstitle=User:Tisane/Test1rvprop=ids|flags|timestamp|user|size|comment|content|tagsrevids=33 Query 6 (slave): SELECT /* ApiQueryRevisions::execute 192.168.0.133 */ rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest,ts_tags,old_id,old_text,old_flags FROM `mw_page`,`mw_revision`,`mw_text` LEFT JOIN `mw_tag_summary` ON ((rev_id=ts_rev_id)) WHERE (page_id = rev_page) AND (rev_text_id=old_id) AND rev_id = '33' ORDER BY rev_id LIMIT 2 SQL ERROR: Unknown column 'rev_id' in 'on clause' (localhost) -- 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 24166] API error when using rvprop=tags
https://bugzilla.wikimedia.org/show_bug.cgi?id=24166 --- Comment #1 from Derk-Jan Hartman hart...@videolan.org 2010-06-29 01:01:47 CEST --- RoanKattouw It's the MySQL 5 regression where SELECT * FROM foo, bar LEFT JOIN baz ON baz_id=foo_id breaks -- 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