TL zeigt keine Daten mehr an im Backend
TL zeigt plötzlich einfach keine Daten mehr an im Backend. Obwohl die Daten in der Tabelle vorhanden sind und auch im Frontend ausgegeben werden.
TL meldet:
Code:
Keine Einträge gefunden.
Debug-Ausgabe der betreffenden Tabelle:
PHP-Code:
[4] => Array
(
[0] => DELETE FROM tl_einsaetze WHERE id IN(9,10,11,12,13,14,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64) AND tstamp=0
[1] => 0 rows affected
)
[5] => Array
(
[0] => SELECT DISTINCT(datum) FROM tl_einsaetze
[1] => 39 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_einsaetze
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 44
[Extra] => Using temporary
)
)
[6] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_einsaetze WHERE datum=''
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_einsaetze
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 44
[Extra] => Using where
)
)
[7] => Array
(
[0] => SELECT * FROM tl_einsaetze WHERE datum='' ORDER BY datum LIMIT 0,30
[1] => 0 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_einsaetze
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 44
[Extra] => Using where; Using filesort
)
)
[8] => Array
(
[0] => SELECT COUNT(*) AS total FROM tl_einsaetze WHERE datum=''
[1] => 1 rows returned
[2] => Array
(
[id] => 1
[select_type] => SIMPLE
[table] => tl_einsaetze
[type] => ALL
[possible_keys] =>
[key] =>
[key_len] =>
[ref] =>
[rows] => 44
[Extra] => Using where
)
)
warum erstellt TL solche Statements wie
Code:
SELECT * FROM tl_einsaetze WHERE datum=''
??
schon klar wird nix gefunden, schliesslich sind alle Felder "Datum" gesetzt...
Kann mir Jemand einen Tipp geben, was ich vielleicht in der Datei .../dca/tl_modulename.php zu beachten habe?
Vielen Dank!