(Report Post) Fehlermeldung: Error by getting reports.

[Nighthawk]

Hallo

Beim Aufrufen vom Report Post (Version 1.1.2) bekomme ich diese Fehlermeldung:

Error by getting reports.

DEBUG MODE

SQL 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 '' at line 9

SELECT r.report_id, rr.reason_name, r.reporter_id, r.reporter_username, u.username AS reportername, r.report_time, r.report_status, r.report_last_edit_user_id, u2.username AS report_last_edit_username, r.report_last_edit_time FROM phpbb_reports r LEFT JOIN phpbb_users u ON u.user_id = r.reporter_id LEFT JOIN phpbb_users u2 ON u2.user_id = r.report_last_edit_user_id LEFT JOIN phpbb_report_reasons rr ON rr.reason_id = r.report_reason WHERE r.report_status <= 2 ORDER BY r.report_status ASC, r.report_last_edit_time DESC, r.report_id DESC LIMIT -0,

Line : 1182
File : report.php

Dies ist der Code:

Code: Alles auswählen

$page_title = ( $mode == 'archive' ) ? $lang['Report_archive'] : $lang['Report_list'];
		define('NO_REPORT_POPUP', true);
		include($phpbb_root_path . 'includes/page_header.'.$phpEx);
		$template->set_filenames(array('body' => 'report_list_body.tpl'));

		$sql = "SELECT r.report_id, rr.reason_name, r.reporter_id, r.reporter_username, u.username AS reportername, r.report_time, r.report_status, r.report_last_edit_user_id, u2.username AS report_last_edit_username, r.report_last_edit_time
			FROM " . REPORTS_TABLE . " r
				LEFT JOIN " . USERS_TABLE . " u ON u.user_id = r.reporter_id
				LEFT JOIN " . USERS_TABLE . " u2 ON u2.user_id = r.report_last_edit_user_id
				LEFT JOIN " . REPORT_REASONS_TABLE . " rr ON rr.reason_id = r.report_reason
				$auth_left_join
			WHERE $status_sql
				$auth_sql
				ORDER BY $order_by_sql ";
		if ( $page != -1 )
		{
			$sql .= "LIMIT $start, " . $board_config['report_per_page'];
		}
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, "Error by getting reports.", "", __LINE__, __FILE__, $sql);
		}

In der Headline bekomme ich diese Meldung:

Warning: Division by zero in /var/www/xxxxxx/xxxxxx/phpBB2/report.php on line 1133

Warning: Cannot modify header information - headers already sent by (output started at /var/www/xxxxxx/xxxxxx/phpBB2/report.php:1133) in /var/www/xxxxxx/xxxxxx/phpBB2/includes/page_header.php on line 799

Warning: Cannot modify header information - headers already sent by (output started at /var/www/xxxxxx/xxxxxx/phpBB2/report.php:1133) in /var/www/xxxxxx/xxxxxx/phpBB2/includes/page_header.php on line 801

Warning: Cannot modify header information - headers already sent by (output started at /var/www/xxxxxx/xxxxxx/phpBB2/report.php:1133) in /var/www/xxxxxx/xxxxxx/phpBB2/includes/page_header.php on line 802

Und das ist der Code (Line 1133):

Code: Alles auswählen

$total_pages = ceil($total_reports / $board_config['report_per_page']);
		if ( $page < 1 && $page != -1 )

Wie kann ich das Problem aus der Welt schaffen?

Thanks for your help!

[Nighthawk]

Das Problem hat sich erledigt. Ich habe alle Tabellen betreffend Report Post aus der Datenbank gelöscht und die install_rp_hack.php nochmals durchlaufen lassen. Jetzt klappt das Ganze wieder...

[Ram-Brand]

Habe festgestellt, das bei mir einige Punkte die das Script in die php_config schreibt dort nicht standen.

Habe manuell mit phpMyAdmin das Problem gelöst.

Code: Alles auswählen

INSERT INTO phpbb_config (config_name, config_value) VALUES ('report_no_guestes', '1'),
('report_no_auth_users', ''),
('report_no_auth_groups', ''),
('report_disabled_users', ''),
('report_disabled_groups', ''),
('report_only_admin', '0'),
('report_popup_height', '200'),
('report_popup_width', '400'),
('report_view_user', '0'),
('report_post_hack_version', '1.1.2'),
('report_edit_user', '0'),
('report_list_user', '0'),
('report_self', '1'),
('report_per_page', '40');