phpBB.de

Code: Alles auswählen

Error by getting reported posts.

DEBUG MODE

SQL Error : 1054 Unknown column 'p.poster_id' in 'on clause'

SELECT f.forum_name, f.forum_id, t.topic_title, t.topic_id, p.post_id, pt.post_subject, p.post_username, u.username, u.user_id, u2.username as reportername, u2.user_id as reporter_id FROM phpbb_forums f, phpbb_topics t, phpbb_posts p, phpbb_posts_text pt LEFT JOIN phpbb_users u ON u.user_id = p.poster_id LEFT JOIN phpbb_users u2 ON u2.user_id = p.reporter_id WHERE p.reporter_id <> 0 AND f.forum_id = p.forum_id AND t.topic_id = p.topic_id AND pt.post_id = p.post_id ORDER BY p.post_id ASC

Line : 253
File : report.php

Code: Alles auswählen

The queries failed. Try again later or mail me the follow errors. - 
Die Queries konnten nicht ausgeführt werden. Versuchen sie es später noch einmal oder schicken sie mit die folgenden Fehlermeldungen.

Error list:
SQL Error: 1060 Duplicate column name 'no_report_mail'
SQL Query: ALTER TABLE phpbb_users ADD no_report_mail TINYINT(1) DEFAULT '0' NOT NULL

SQL Error: 1062 Duplicate entry 'report_no_guestes' for key 1
SQL Query: INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_no_guestes', '0'), ('report_no_auth_users', ''), ('report_no_auth_groups', ''), ('report_disabled_users', ''), ('report_disabled_groups', ''), ('report_only_admin', '0'), ('report_popup_height', '250'), ('report_popup_width', '700'), ('report_popup_links_target', '2'), ('report_post_hack_version', '1.0.5')


DEBUG MODE

SQL Error : 1062 Duplicate entry 'report_no_guestes' for key 1

Code: Alles auswählen

$sql = "SELECT f.forum_name, f.forum_id, t.topic_title, t.topic_id, p.post_id, pt.post_subject, p.post_username,  u.username, u.user_id, u2.username as reportername, u2.user_id as reporter_id
			FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id
				LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id
			WHERE p.reporter_id <> 0
				$forums_sql
				AND f.forum_id = p.forum_id
				AND t.topic_id = p.topic_id
				AND pt.post_id = p.post_id
				ORDER BY p.post_id ASC";

Code: Alles auswählen

$sql = "SELECT f.forum_name, f.forum_id, t.topic_title, t.topic_id, p.post_id, pt.post_subject, p.post_username,  u.username, u.user_id, u2.username as reportername, u2.user_id as reporter_id
			FROM " . FORUMS_TABLE . " f INNER JOIN " . TOPICS_TABLE . " t INNER JOIN " . POSTS_TABLE . " p INNER JOIN " . POSTS_TEXT_TABLE . " pt
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id
				LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id
			WHERE p.reporter_id <> 0
				$forums_sql
				AND f.forum_id = p.forum_id
				AND t.topic_id = p.topic_id
				AND pt.post_id = p.post_id
				ORDER BY p.post_id ASC";

Code: Alles auswählen

$sql = "SELECT f.forum_name, f.forum_id, t.topic_title, t.topic_id, p.post_id, pt.post_subject, p.post_username,  u.username, u.user_id, u2.username as reportername, u2.user_id as reporter_id
			FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id
				LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id
			WHERE p.reporter_id <> 0
				$forums_sql
				AND f.forum_id = p.forum_id
				AND t.topic_id = p.topic_id
				AND pt.post_id = p.post_id
				ORDER BY p.post_id ASC";

Code: Alles auswählen

$sql = "SELECT f.forum_name, f.forum_id, t.topic_title, t.topic_id, p.post_id, pt.post_subject, p.post_username,  u.username, u.user_id, u2.username as reportername, u2.user_id as reporter_id
			FROM " . FORUMS_TABLE . " f INNER JOIN " . TOPICS_TABLE . " t INNER JOIN " . POSTS_TABLE . " p INNER JOIN " . POSTS_TEXT_TABLE . " pt
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id
				LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = p.reporter_id
			WHERE p.reporter_id <> 0
				$forums_sql
				AND f.forum_id = p.forum_id
				AND t.topic_id = p.topic_id
				AND pt.post_id = p.post_id
				ORDER BY p.post_id ASC";