Verfasst: 24.10.2003 14:31
man soll den tag nicht vor dem abend loben !
diese fehlermeldung kommt jetzt beim registrieren.
der ausschnitt aus der usercp_register.php:
ich denke es liegt daran, dass ich nicht nur bei der aufzählung der variablen meine variablen hinzufügen musste, sondern auch unter VALUES diese dazumachen muss oder?
Code: Alles auswählen
Could not insert data into users table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb2_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_vorname, user_name, user_firma, user_telefon, user_emailsys, user_mobilfunk, user_kundennummer, user_inis_seriennummer, user_inis_version, user_kommunikationsmodul, user_internetanbindung, user_inis_serveros, user_inis_pcos, user_winschool_seriennummer, user_winschool_version, user_winschool_serveros, user_winschool_pcos, 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 (9, 'schneider2', 1066998504, 'f156e7995d521f30e6c59a3d6c75e1e5', 'philsASAS@rhymez.net', 'Gesamtschule', '033773', '', '12359 Berlin', '', '', '', '', 0, 0, 'Fritz-Karsen-Schule', '03377303035', 'Onkel-Bräsig-Straße 78', 1, 1, 1, 1, 1, 0, 1, 1, 1, 'd.M.y - H:i', 'german', 3, 0, 1, 1, '')
Line : 780
File : /homepages/39/d87133386/htdocs/forum/includes/usercp_register.phpder ausschnitt aus der usercp_register.php:
Code: Alles auswählen
$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_vorname, user_name, user_firma, user_telefon, user_emailsys, user_mobilfunk, user_kundennummer, user_inis_seriennummer, user_inis_version, user_kommunikationsmodul, user_internetanbindung, user_inis_serveros, user_inis_pcos, user_winschool_seriennummer, user_winschool_version, user_winschool_serveros, user_winschool_pcos, 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("\'", "''", $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 )
