phpBB.de

Could not insert data into users table

DEBUG MODE

SQL Error : 1062 Duplicate entry '1' for key 1


INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (1, 'Partysan', 1063687526, '1a46a0b6fe9d440d68e07c9619c0ba0a', 'partysan@partyrun.de', '', '', 'Bankkaufmann, Student WiIng', 'Hamburg', 'Golf, Hockey, Skifahren, Boarden, alles was Spass macht!!!', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'german', 2, 0, 1, 0, '263cbfcc2c6c')

Line : 550
File : /www/htdocs/xxxxxxx/forum/includes/usercp_register.php

#
#-----[ OPEN ]------------------------------------------
#

includes/usercp_register.php

#
#-----[ FIND ]------------------------------------------
#

$message = $lang['Profile_updated'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx") . '">', '</a>');

#
#-----[ REPLACE WITH ]------------------------------------------
#

$message = $lang['Profile_updated'] . '<br /><br />' . sprintf($lang['Click_return_index'], '<a href="' . append_sid("index.$phpEx?view=sig") . '">', '</a>');


#
#-----[ FIND ]------------------------------------------
#

$template->assign_vars(array(
"META" => '<meta http-equiv="refresh" content="5;url=' . append_sid("index.php") . '">')
);


#
#-----[ REPLACE WITH ]------------------------------------------
#

$template->assign_vars(array(
"META" => '<meta http-equiv="refresh" content="5;url=' . append_sid("index.php?view=sig") . '">')
);

#
#-----[ FIND ]------------------------------------------
#

message_die(GENERAL_MESSAGE, $message);
}
else
{
$sql = "SELECT MAX(user_id) AS total
FROM " . USERS_TABLE;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain next user_id information', '', __LINE__, __FILE__, $sql);
}


#
#-----[ REPLACE WITH ]------------------------------------------
#

include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);
$bbcode_uid = ( $bbcode_on ) ? make_bbcode_uid() : '';
$user_sig = ( $userdata['user_sig'] != '' && $board_config['allow_sig'] ) ? $userdata['user_sig'] : '';
// $user_sig = $signature;
load_bbcode_template();
//$user_sig = $signature;
if( $user_sig != '' )
{

$user_sig = bbencode_second_pass($user_sig, $userdata['user_sig_bbcode_uid']);
$user_sig = bbencode_first_pass($user_sig, $userdata['user_sig_bbcode_uid']);
$user_sig = make_clickable($user_sig);
$user_sig = smilies_pass($user_sig);
$user_sig = '_________________<br />' . $user_sig;
$user_sig = nl2br($user_sig);
}
else
{
$user_sig = $lang['None'];
}
message_die(GENERAL_MESSAGE, $message . '<br /><br /><b>' . $lang['SignaturePreviewOld'] . ':</b><hr>' . $user_sig . '<hr>');
}
else
{
$sql = "SELECT MAX(user_id) AS total
FROM " . USERS_TABLE;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain next user_id information', '', __LINE__, __FILE__, $sql);
}

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
#EoM