hier mal einen sehr häufig auftretenden Fehler:
MySQL Error: 1054 : Unknown column 'pos' in 'order clause' in Query: SELECT * FROM `ic1_config` ORDER BY kat,pos,typ ASC Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ allg.php:105 -- db_query(...) @ admin.php:23 -- require_once(...) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/virtual/agrimm.de/htdocs/include/includes/func/db/mysql.php on line 58
Diesen Fehler habe ich im Adminmenü unter Konfiguration, und auf meinem Forum habe ich auch folgenden Fehler:
MySQL Error: 1054 : Unknown column 'k.cid' in 'where clause' in Query: SELECT a.id, a.cid, a.name, a.besch, a.topics, a.posts, b.name as topic, c.id as pid, c.tid, b.rep, c.erst, c.time, a.cid, k.name as cname FROM ic1_forums a LEFT JOIN ic1_forumcats k ON k.id = a.cid LEFT JOIN ic1_posts c ON a.last_post_id = c.id LEFT JOIN ic1_topics b ON c.tid = b.id LEFT JOIN ic1_groupusers vg ON vg.uid = 1 AND vg.gid = a.view LEFT JOIN ic1_groupusers rg ON rg.uid = 1 AND rg.gid = a.reply LEFT JOIN ic1_groupusers sg ON sg.uid = 1 AND sg.gid = a.start WHERE ((-9 <= a.view AND a.view < 1) OR (-9 <= a.reply AND a.reply < 1) OR (-9 <= a.start AND a.start < 1) OR vg.fid IS NOT NULL OR rg.fid IS NOT NULL OR sg.fid IS NOT NULL OR -9 = -9) AND k.cid = 0 ORDER BY k.pos, a.pos Debug backtrace: @ mysql.php:32 -- debug_bt() @ mysql.php:50 -- db_check_error(...) @ show_forum.php:48 -- db_query(...) @ forum.php:129 -- require_once(...) @ index.php:24 -- require_once(...) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/virtual/agrimm.de/htdocs/include/includes/func/db/mysql.php on line 58
Weiß aber nicht wie ich die beheben kann!
Bitte um Hilfe