ich habe ein wenig weiter probiert,
wenn ich über die Kopfzeile in der Tabelle sortiere, funktioniert das auch nicht bei jeder Spalte.
Sortiert wird nur in den Spalten "Frühstück, Alias und Bezahlt"
bei allen anderen Spalten gibs nur ne Fehlermeldung
z.B.: beim anklicken der Spalte "Helferteam" sieht der Fehlercode so aus:
Code:
Fatal error: Uncaught exception Exception with message Query error:
Unknown column 'TCS' in 'order clause'
(SELECT id,alias,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Name" AND pid=f.id ) AS `TCS-Name`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Vorname" AND pid=f.id ) AS `TCS-Vorname`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Helferteam" AND pid=f.id ) AS `TCS-Helferteam`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Kanal1" AND pid=f.id ) AS `TCS-Kanal1`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Kanal2" AND pid=f.id ) AS `TCS-Kanal2`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Kanal3" AND pid=f.id ) AS `TCS-Kanal3`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Mannschaft" AND pid=f.id ) AS `TCS-Mannschaft`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Erdanker" AND pid=f.id ) AS `TCS-Erdanker`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS-Mittagessen" AND pid=f.id ) AS `TCS-Mittagessen`,
(SELECT value FROM tl_formdata_details WHERE ff_name="TCS_Frühstück" AND pid=f.id ) AS `TCS_Frühstück`,alias,
(SELECT value FROM tl_formdata_details WHERE ff_name="Bezahlt" AND pid=f.id ) AS `Bezahlt`,fd_user,fd_member FROM tl_formdata f WHERE form='Anmeldung Thermik CUP Saar 2010' ORDER BY TCS-Helferteam asc)
thrown in /var/www/sk02278/html/hein/system/libraries/Database.php on line 599
#0 /var/www/sk02278/html/hein/system/libraries/Database.php(546): Database_Statement->query()
#1 /var/www/sk02278/html/hein/system/modules/efg/ModuleFormdataListing.php(1085): Database_Statement->execute('')
#2 /var/www/sk02278/html/hein/system/modules/frontend/Module.php(127): ModuleFormdataListing->compile()
#3 /var/www/sk02278/html/hein/system/modules/efg/ModuleFormdataListing.php(451): Module->generate()
#4 /var/www/sk02278/html/hein/system/modules/frontend/ContentModule.php(70): ModuleFormdataListing->generate()
#5 /var/www/sk02278/html/hein/system/libraries/Controller.php(364): ContentModule->generate()
#6 /var/www/sk02278/html/hein/system/modules/frontend/ModuleArticle.php(179): Controller->getContentElement('176')
#7 /var/www/sk02278/html/hein/system/modules/frontend/Module.php(127): ModuleArticle->compile()
#8 /var/www/sk02278/html/hein/system/modules/frontend/ModuleArticle.php(69): Module->generate()
#9 /var/www/sk02278/html/hein/system/libraries/Controller.php(297): ModuleArticle->generate(false)
#10 /var/www/sk02278/html/hein/system/libraries/Controller.php(184): Controller->getArticle('83', false, false, 'main')
#11 /var/www/sk02278/html/hein/system/modules/frontend/PageRegular.php(68): Controller->getFrontendModule('0', 'main')
#12 /var/www/sk02278/html/hein/index.php(188): PageRegular->generate(Object(DB_Mysql_Result))
#13 /var/www/sk02278/html/hein/index.php(311): Index->run()
#14 {main}
das sieht aus als würde in der Abfrage was nicht stimmen, (ich habe keine Spalte "TCS" !?)
kann mir da jemand einen Tip geben?
Grüße aus dem schönen Saarland
Hein
Lesezeichen