Zitat:
Fatal error: Uncaught exception Exception with message Query error: Unknown column 'main' in 'order clause' (SELECT id,alias,(SELECT value FROM tl_formdata_details WHERE ff_name="firstname" AND pid=f.id ) AS `firstname`,(SELECT value FROM tl_formdata_details WHERE ff_name="name" AND pid=f.id ) AS `name`,(SELECT value FROM tl_formdata_details WHERE ff_name="team" AND pid=f.id ) AS `team`,(SELECT value FROM tl_formdata_details WHERE ff_name="main-position" AND pid=f.id ) AS `main-position`,(SELECT value FROM tl_formdata_details WHERE ff_name="age" AND pid=f.id ) AS `age`,(SELECT value FROM tl_formdata_details WHERE ff_name="height" AND pid=f.id ) AS `height`,(SELECT value FROM tl_formdata_details WHERE ff_name="number" AND pid=f.id ) AS `number`,(SELECT value FROM tl_formdata_details WHERE ff_name="nation" AND pid=f.id ) AS `nation`,(SELECT value FROM tl_formdata_details WHERE ff_name="photo-1" AND pid=f.id ) AS `photo-1`,fd_user,fd_member FROM tl_formdata f WHERE (published=1) AND form='Player Profil' ORDER BY main-position asc) thrown in /homepages/16/d72467577/htdocs/domain.de/system/libraries/Database.php on line 677
Bei diesem Fehler wollte ich nach der Spalte mit der Überschrift "Main Position" sortieren. Die Feldbezeichnung lautet: "main-position".