Pagina 1 van 1
Gebruiker verwijderen maakt foutmelding
Geplaatst: 29 nov 2005, 19:58
door 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);
Geplaatst: 29 nov 2005, 20:05
door Paul
Er mist een ' in de query.
Geplaatst: 29 nov 2005, 20:30
door Eefjuh
En hoe valt dit op te lossen? :S
Geplaatst: 29 nov 2005, 22:07
door Bee
Wat regels ervoor te posten, en niet zo'n magerig 1 regeltje.
Geplaatst: 30 nov 2005, 00:18
door 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);
}
Geplaatst: 30 nov 2005, 00:47
door mosymuis
Code: Selecteer alles
SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . "
Code: Selecteer alles
SET poster_id = " . DELETED . ", post_username = '" . str_replace("\\'", "''", addslashes($this_userdata['username'])) . "'
Geplaatst: 30 nov 2005, 11:40
door Eefjuh
Dank je!!!!
Hij doet het weer
Waarschijnlijk dus een fout met upgraden geweest...