{"issue":{"state":"closed","created_at":"2011-11-29T18:45:42Z","updated_at":"2011-11-29T18:45:48Z","user":{"gravatar_id":"256406243346b9253f8610fb1d1e05f6","id":1215373,"url":"https://api.github.com/users/importer","avatar_url":"https://secure.gravatar.com/avatar/256406243346b9253f8610fb1d1e05f6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"importer"},"comments":5,"body":"Hallo Leo,\nBei der Auflistung einer \"nicht TL\" Tabelle über das Modul Auflistung erhalte ich die Fehlermeldung\n\n```\nFatal error: Uncaught exception Exception with message Query error: Unknown column 'id' in 'field list' (SELECT id, ... system/libraries/Database.php on line 599 ...\n```\n\nProblem ist hier, dass nicht alle Tabellen eine Spalte mit dem Namen 'id' haben. Füge ich der Tabelle eine Spalte \"id\" hinzu, klappt es mit der Auflistung.\n\nBei meiner Suche bin ich auf Zeile 159 in der system/modules/listing/ModuleListing.php gestoßen, dort ist das Feld \"id\" fest eingetragen.\n\n```\n\t\t/**\n\t\t * Get the selected records\n\t\t */\n\t\t$strQuery = \"SELECT id,\" . $this->list_fields . \" FROM \" . $this->list_table;\n```\n\nNehme ich \"id,\" heraus -> $strQuery = \"SELECT \" ... geht auch die Anzeige der Tabelle ohne Fehlermeldung über das Modul Auflistung.\n\nFür den Fall, dass die \"id,\" dort nicht gebraucht wird, könnte der Eintrag doch herausgenommen werden, so können auch ohne Eingriff in das Modul bzw. in die Datenbanktabelle externe Tabellen ohne die Spalte \"id\" angezeigt werden.\n\nViele Grüße\nAndré\n\n--- _Originally created by andre.5tz on May 6th, 2010, at 09:51pm (ID 1932)_","assignee":{"gravatar_id":"87d2e5aefadcb310f9155df28c2b3582","id":1192057,"url":"https://api.github.com/users/leofeyer","avatar_url":"https://secure.gravatar.com/avatar/87d2e5aefadcb310f9155df28c2b3582?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"leofeyer"},"id":2389965,"number":1932,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"labels":[{"name":"Feature","color":"4183c4","url":"https://api.github.com/repos/contao/import/labels/Feature"},{"name":"listing","color":"e6e6e6","url":"https://api.github.com/repos/contao/import/labels/listing"}],"title":"Modul Auflistung: Query error: Unknown column 'id' in 'field list'","closed_at":"2011-11-29T18:45:48Z","html_url":"https://github.com/contao/import/issues/1932","url":"https://api.github.com/repos/contao/import/issues/1932","milestone":{"state":"closed","created_at":"2011-11-29T15:29:48Z","due_on":null,"closed_issues":39,"creator":{"gravatar_id":"87d2e5aefadcb310f9155df28c2b3582","id":1192057,"url":"https://api.github.com/users/leofeyer","avatar_url":"https://secure.gravatar.com/avatar/87d2e5aefadcb310f9155df28c2b3582?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"leofeyer"},"number":25,"description":"Contao 2.9.0 (minor release)","title":"2.9.0","open_issues":0,"url":"https://api.github.com/repos/contao/import/milestones/25"}},"action":"created","comment":{"created_at":"2011-11-29T18:45:47Z","updated_at":"2011-11-29T18:45:47Z","user":{"gravatar_id":"87d2e5aefadcb310f9155df28c2b3582","id":1192057,"url":"https://api.github.com/users/leofeyer","avatar_url":"https://secure.gravatar.com/avatar/87d2e5aefadcb310f9155df28c2b3582?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","login":"leofeyer"},"body":"--- _Originally completed on May 30th, 2010, at 12:21pm_","id":2941070,"url":"https://api.github.com/repos/contao/import/issues/comments/2941070"}}