[Bug 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 Laurent Wandrebeck l.wandreb...@quelquesmots.fr changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |INVALID --- Comment #8 from Laurent Wandrebeck l.wandreb...@quelquesmots.fr --- Updated to 1.22.3, couldn’t get these errors to be reproduced. Really wondering what happened, because I don’t use any cache system, patches always applied without a single problem… Marking that one as resolved. Sorry for the noise. -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 Bawolff (Brian Wolff) bawolff...@gmail.com changed: What|Removed |Added CC||bawolff...@gmail.com Resolution|INVALID |WORKSFORME -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 Jesús Martínez Novo (Ciencia Al Poder) martinezn...@gmail.com changed: What|Removed |Added Priority|Normal |High Severity|normal |critical -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 --- Comment #4 from Tyler Romeo tylerro...@gmail.com --- I cannot seem to reproduce this. I ran the following code: $x = new WantedTemplatesPage; $info = $x-getQueryInfo(); $db = DatabaseBase::factory( 'postgres' ); echo $db-selectSQLText($info['tables'], $info['fields'], $info['conds'], '', $info['options'], $info['join_conds']); And it outputs the same exact SQL, except with different quotes, as in comment 3's MySQL (i.e., it outputs the correct SQL). I've tested this both on master and in 1.22.1 (the indicated version). -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 --- Comment #5 from Laurent Wandrebeck l.wandreb...@quelquesmots.fr --- Whick version of PG do you run ? Here, CentOS 6.5 x86_64, php 5.3.3, PG 9.3.2 with pgbouncer 1.5.4 in session mode. Will try to back out pg changes from 1.22.0-1.22.1 patch now and get back to you. -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 --- Comment #6 from Tyler Romeo tylerro...@gmail.com --- I'm running on MediaWiki-Vagrant, which is Ubuntu 11.04? with php 5.4. Although that really shouldn't matter, since it's code logic at fault here, not platform error. -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 --- Comment #7 from Laurent Wandrebeck l.wandreb...@quelquesmots.fr --- H strange, I get via maintenance/eval.php a correct query too: SELECT tl_namespace AS namespace,tl_title AS title,COUNT(*) AS value FROM templatelinks LEFT JOIN page ON ((page_namespace = tl_namespace) AND (page_title = tl_title)) WHERE (page_title IS NULL) AND tl_namespace = '' GROUP BY tl_namespace,tl_title /me scratches head -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 Andre Klapper aklap...@wikimedia.org changed: What|Removed |Added Keywords||code-update-regression Priority|Unprioritized |Normal Version|1.22.0 |1.22.1 Blocks||384 Summary|1.22.1 orphan files |Orphan files and postgresql |regression with postgresql |in 1.22.1: ERROR: column ||img_name doesn't exist -- 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 60031] Orphan files and postgresql in 1.22.1: ERROR: column img_name doesn't exist
https://bugzilla.wikimedia.org/show_bug.cgi?id=60031 Umherirrender umherirrender_de...@web.de changed: What|Removed |Added CC||tylerro...@gmail.com, ||umherirrender_de...@web.de --- Comment #3 from Umherirrender umherirrender_de...@web.de --- No joins are added to the sql. You wrote: 2014-01-14 09:02:56.881 CET ERROR: column « tl_namespace » doesn’t exist at character 54 2014-01-14 09:02:56.881 CET INSTRUCTION : SELECT /* WantedTemplatesPage::reallyDoQuery Low */ tl_namespace AS namespace,tl_title AS title,COUNT(*) AS value FROM page WHERE (page_title IS NULL) AND tl_namespace = '10' GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT 51 Reformatted is that: SELECT /* WantedTemplatesPage::reallyDoQuery Low */ tl_namespace AS namespace, tl_title AS title, COUNT(*) AS value FROM page WHERE (page_title IS NULL) AND tl_namespace = '10' GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT 51 But the correct sql would be: (example from mysql) SELECT tl_namespace AS namespace, tl_title AS title, COUNT(*) AS value FROM `templatelinks` LEFT JOIN `page` ON ((page_namespace = tl_namespace) AND (page_title = tl_title)) WHERE (page_title IS NULL) AND tl_namespace = '10' GROUP BY tl_namespace,tl_title ORDER BY value DESC LIMIT 51 There is the templatelinks table and with that table the column tl_namespace is known. -- 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