Gebruiker verwijderen maakt foutmelding

[Eefjuh]

Ik gebruik 2.0.17 en krijg dit te zien als ik een lid in het adminpanel wil verwijderen:

Could not update posts for this user

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 ''voernatuurlijk WHERE poster_id = 317' at line 2

UPDATE phpbb_posts SET poster_id = -1, post_username = 'voernatuurlijk WHERE poster_id = 317

Line : 101
File : admin_users.php



War gaat hier fout?


Regel 101:

Code: Selecteer alles

				message_die(GENERAL_ERROR, 'Could not update posts for this user', '', __LINE__, __FILE__, $sql); 

[Paul]

Er mist een ' in de query.

[Eefjuh]

En hoe valt dit op te lossen? :S

[Bee]

Wat regels ervoor te posten, en niet zo'n magerig 1 regeltje.

[Eefjuh]

o

Stukkie:

Code: Selecteer alles

	//
	// Ok, the profile has been modified and submitted, let's update
	//
	if ( ( $mode == 'save' && isset( $HTTP_POST_VARS['submit'] ) ) || isset( $HTTP_POST_VARS['avatargallery'] ) || isset( $HTTP_POST_VARS['submitavatar'] ) || isset( $HTTP_POST_VARS['cancelavatar'] ) )
	{
		$user_id = intval($HTTP_POST_VARS['id']);

		if (!($this_userdata = get_userdata($user_id)))
		{
			message_die(GENERAL_MESSAGE, $lang['No_user_id_specified'] );
		}

		if( $HTTP_POST_VARS['deleteuser'] )
		{
// Begin Map Mod
			$sql = "DELETE FROM " . MAP_MOD_USER_TABLE . "
				WHERE user_id = $user_id";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not delete user coordinates', '', __LINE__, __FILE__, $sql);
			}
// End Map Mod
			$sql = "SELECT g.group_id 
				FROM " . USER_GROUP_TABLE . " ug, " . GROUPS_TABLE . " g  
				WHERE ug.user_id = $user_id 
					AND g.group_id = ug.group_id 
					AND g.group_single_user = 1";
			if( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not obtain group information for this user', '', __LINE__, __FILE__, $sql);
			}

			$row = $db->sql_fetchrow($result);
			
			$sql = "UPDATE " . POSTS_TABLE . "
				SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . "
				WHERE poster_id = $user_id";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not update posts for this user', '', __LINE__, __FILE__, $sql);
			}

[mosymuis]

Code: Selecteer alles

            SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . " 

Vervang met

Code: Selecteer alles

            SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . "' 

[Eefjuh]

Dank je!!!!

Hij doet het weer

Waarschijnlijk dus een fout met upgraden geweest...