Forum

Folgende Fehlermeldung erscheint beim aufrufen des Downloadbereichs:

WARNING [8] Undefined index: download_cats
FOUND IN [class/class.opn_categorienav.php]
FOUND AT 97

---

WARNING [8] Undefined index: download_cats
FOUND IN [class/class.opn_categorienav.php]
FOUND AT 97

---

SQL-ERROR [256] mysql error: [1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE cat_pid = 0 AND (cat_usergroup IN (0,1,10)) ORDER BY cat] in EXECUTE("SELECT cat_id, cat_name, cat_desc, cat_image FROM WHERE cat_pid = 0 AND (cat_usergroup IN (0,1,10)) ORDER BY cat_pos")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 194

---

SQL-ERROR [256] mysql error: [1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE cat_pid = 0 AND (cat_usergroup IN (0,1,10)) ORDER BY cat] in EXECUTE("SELECT cat_id, cat_name, cat_desc, cat_image FROM WHERE cat_pid = 0 AND (cat_usergroup IN (0,1,10)) ORDER BY cat_pos")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 194

---

Woran könnte das liegen?

Welche Version hast du genau im Einsatz?

Weil mit der openPHPnuke 2.3.0 [Ananke] (Revision 4825) kann ich den Fehler nicht reproduzieren.

Hast du Kategorien angelegt?

Flash

OK also er zeigt keine Kategorien an.
aber ich hab eine angelegt *sicher bin*
er zeigt da jetzt auch fehlermeldungen an:

SQL-ERROR [256] mysql error: [1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE cat_id>0 and cat_pid=0' at line 1] in EXECUTE("SELECT COUNT(cat_id) AS counter FROM WHERE cat_id>0 and cat_pid=0")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 194

---

SQL-ERROR [256] mysql error: [1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE cat_id>0 AND cat_pid=0 ORDER BY cat_pos LIMIT 0, 20' at l] in EXECUTE("SELECT cat_id, cat_name, cat_usergroup, cat_theme_group, cat_pos FROM WHERE cat_id>0 AND cat_pid=0 ORDER BY cat_pos LIMIT 0, 20")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 194

---

SQL-ERROR [256] mysql error: [1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE cat_pid=0 ORDER BY cat_pos' at line 1] in EXECUTE("SELECT cat_id, cat_name from WHERE cat_pid=0 ORDER BY cat_pos")
FOUND IN [include/opndb-errorhandler.php]
FOUND AT 194


Version 2.3.0 hab ich