Ok
It's very simple.
1/ Go to your administration panel and create yourself a new USER (TEST).
2/ After that, this user (TEST) is in the member List and it 's ok, but now go in your phpBB admin panel, part user admin and link management, search this new user (TEST).
3/ Now try in the bottom of the page to delete this user (TEST)
4/ It's Ok TEST is deleted BUT you have an SQL ERROR like this:
Code:
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 2
DELETE FROM nuke_bbgroups WHERE group_id =
This is the first part of this bug repport.
The seconde part is:
If this user called TEST have writte posts in the forum, the posts stay in place but the name of the user disapear and there is nothing at the place of is name.
For whatever reason sometimes users don't have a group_id set which will result in this error, one thing you could try is looking for this block of code in that file:
Code:
$sql = "DELETE FROM " . GROUPS_TABLE . "
WHERE group_id = " . $row['group_id'];
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);
}
$sql = "DELETE FROM " . AUTH_ACCESS_TABLE . "
WHERE group_id = " . $row['group_id'];
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not delete group for this user', '', __LINE__, __FILE__, $sql);
}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Latest: 
Visitation: 
