phpBB.de

Verfasst: **15.02.2003 18:44**

ich habe die suche verwendet und der thread den ich gefunden hab hat mir nicht weitergeholfen...hier also mein prob:

will sich ein neuer user registrieren kommt dieser fehler:

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 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_gender, user_level, user_allow_pm, user_active, user_actkey) VALUES (10, 'Nox', 1045330644, '202cb962ac59075b964b07152d234b70', 'test@gmx.at', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 'D M Y H:i', 'german', 1, '0', 0, 1, '999999','',1, '')

Line : 563
File : /data/members/free/tripod/de/j/a/p/japancommunity/htdocs/includes/usercp_register.php

ich hoffe mir kann jemand helfen...hier gibts die gesamte usercp_register.php als txt datei: klick

Verfasst: **16.02.2003 12:25**

..liegt sicherlich an dem GenderHack.

$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_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_gender, 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, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$gender', 0, 1, '$birthday','$next_birthday_greeting',";

..bei den Werten (values) steht was vom BirthdayHack, aber nix bei den Feldern (into ()). Überprüfe das nochma..

Verfasst: **16.02.2003 14:28**

dankeschön ^^"

jetzt funktioniert wieder alles!

phpBB.de

could not insert data into users table

could not insert data into users table