phpBB.de

Could not query hierarchie title

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'AND cfp.parent_forum_id = f.forum_id AND cfp.cat_id = AND f.cat_id = c.cat_' at line 5

SELECT concat(c.cat_title, ', ', f.forum_name) AS hierarchie_title, f.forum_id, f.forum_hier_level + 1 AS hierarchie_level FROM forumnew_categories c, forumnew_cat_rel_cat_parents ccp, forumnew_forums f, forumnew_cat_rel_forum_parents cfp WHERE ccp.parent_cat_id = c.cat_id AND ccp.cat_id = AND cfp.parent_forum_id = f.forum_id AND cfp.cat_id = AND f.cat_id = c.cat_id ORDER BY c.cat_hier_level, f.forum_hier_level

Line : 328
File : /usr/www/users/xe7hqy4x/benjamin/forum/viewtopic.php

#
#-----[ FIND ]------------------------------------------
#

$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . "
WHERE $join_sql
AND f.forum_id = t.forum_id
$order_sql";

#
#-----[ REPLACE WITH ]------------------------------------------
#

// DJ-Begin, 24.3.02
$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . ", f.cat_id
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . "
WHERE $join_sql
AND f.forum_id = t.forum_id
$order_sql";
// DJ-End, 24.3.02

WHERE $join_sql
AND f.forum_id = t.forum_id
$order_sql";