DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 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_herkunftsland, user_realname, user_geburtstag, user_provider, user_geschwindigkeit, user_cpu, user_mb, user_ram, user_sc, user_graca, user_maus, user_mauspad, user_monitor, user_zusatz, 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 (6, 'test', 1067632401, '1e86fda74cc803129b971d7d0e70df3f', 'test@test.de', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 1, 'd.m.Y, H:i', 'german', 1, 0, 1, 1, '')
Line : 535
File : /home/www/web46/html/gamernation/forum/phpBB2/includes/usercp_register.php
Habe den Mod für weitere Eingabefelder angewandt. Was muss ich nun machen ? Er bringt diesen Fehler wenn ich ein User registrieren will
ADD: der mod war es http://www.phpbb.de/viewtopic.php?t=392 ... 05b4440133
Code von zeile 515-535
Code: Alles auswählen
//
// Get current date
//
$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_herkunftsland, user_realname, user_geburtstag, user_provider, user_geschwindigkeit, user_cpu, user_mb, user_ram, user_sc, user_graca, user_maus, user_mauspad, user_monitor, user_zusatz, 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 ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $herkunftsland) . "', '" . str_replace("\'", "''", $realname) . "', '" . str_replace("\'", "''", $geburtstag) . "', '" . str_replace("\'", "''", $provider) . "', '" . str_replace("\'", "''", $geschwindigkeit) . "', '" . str_replace("\'", "''", $cpu) . "', '" . str_replace("\'", "''", $mb) . "', '" . str_replace("\'", "''", $ram) . "', '" . str_replace("\'", "''", $sc) . "', '" . str_replace("\'", "''", $graca) . "', '" . str_replace("\'", "''", $maus) . "', '" . str_replace("\'", "''", $mauspad) . "', '" . str_replace("\'", "''", $monitor) . "', '" . str_replace("\'", "''", $zusatz) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";
if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
{
$user_actkey = gen_rand_string(true);
$key_len = 54 - (strlen($server_url));
$key_len = ( $key_len > 6 ) ? $key_len : 6;
$user_actkey = substr($user_actkey, 0, $key_len);
$sql .= "0, '" . str_replace("\'", "''", $user_actkey) . "')";
}
else
{
$sql .= "1, '')";
}
if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )
{
message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql);
