phpBB.de

Code: Alles auswählen

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);

Code: Alles auswählen

@define('PHPBB_INSTALLED', true);
@define('DEBUG', true);
 @define('DEBUG_EXTRA', true);

Code: Alles auswählen

//

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

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 2 [1064]

SQL

DELETE FROM phpbb_dl_favorites WHERE fav_user_id =

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 3382
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_user.php
LINE: 283
CALL: group_set_user_default()

FILE: includes/ucp/ucp_register.php
LINE: 324
CALL: user_add()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_register->main()

FILE: includes/functions_module.php
LINE: 802
CALL: p_master->load_active()

FILE: ucp.php
LINE: 67
CALL: p_master->load()

Code: Alles auswählen

		break;
	}

	$db->sql_transaction('begin');

	$table_ary = array(USERS_TABLE, USER_GROUP_TABLE, TOPICS_WATCH_TABLE, FORUMS_WATCH_TABLE, ACL_USERS_TABLE, TOPICS_TRACK_TABLE, TOPICS_POSTED_TABLE, FORUMS_TRACK_TABLE, PROFILE_FIELDS_DATA_TABLE, MODERATOR_CACHE_TABLE, DRAFTS_TABLE, BOOKMARKS_TABLE, SESSIONS_KEYS_TABLE, PRIVMSGS_FOLDER_TABLE, PRIVMSGS_RULES_TABLE);
	$table_ary = array_merge($table_ary, array(DL_NOTRAF_TABLE));
	
	foreach ($table_ary as $table)
	{
		$sql = "DELETE FROM $table
			WHERE user_id = $user_id";
		$db->sql_query($sql);
	}

	$cache->destroy('sql', MODERATOR_CACHE_TABLE);
	
	// Delete Download Favorites from this user
    $sql = "DELETE FROM " . DL_FAVORITES_TABLE . "
    WHERE fav_user_id = $user_id";
    $db->sql_query($sql); 

	// Delete user log entries about this user
	$sql = 'DELETE FROM ' . LOG_TABLE . '
		WHERE reportee_id = ' . $user_id;
	$db->sql_query($sql);

Code: Alles auswählen

if ($update_listing)
	{
		group_update_listings($group_id);
	}

	// Because some tables/caches use usercolour-specific data we need to purge this here.
	$cache->destroy('sql', MODERATOR_CACHE_TABLE);
	// Delete Download Favorites from this user
	$sql = "DELETE FROM " . DL_FAVORITES_TABLE . "
		WHERE fav_user_id = $user_id";
	$db->sql_query($sql);
}

Code: Alles auswählen

if ($update_listing)
	{
		group_update_listings($group_id);
	}

	// Because some tables/caches use usercolour-specific data we need to purge this here.
	$cache->destroy('sql', MODERATOR_CACHE_TABLE);
}