Fehler bei Userregistrierung

[Fice]

In meinem Board laufen einige Mods, und es ging auch alles einwandfrei(dachte ich). Jetzt hat mir nen Kumpel gesagt er kann sich nicht registrieren. Folgende Fehlermeldung taucht auf:


Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb2_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_option, 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_no_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (4, 'Derda', 1071406087, '202cb962ac59075b964b07152d234b70', 'derda@duda.de', '', '', 'Azubi', 'MZ', '', '', '', '', '', 'Is es der da????', 'ae84d446a0', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'd.m.Y, H:i', 'german', 3, 0, 1, 0, 'f719d6')

Line : 618
File : /home/ficeinfo/public_html/community/Forum/phpBB2/includes/usercp_register.php

Hier ist wohl der Knackpunkt:

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_option, 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_no_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("\'", "''", $user_codea) . "', '" . str_replace("\'", "''", $user_codeb) . "', '" . str_replace("\'", "''", $user_codec) . "', '" . str_replace("\'", "''", $user_coded) . "', '" . 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, $no_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";

[Nico Haase]

ich tippe auf unterschiedlich lange felder- und eintragslisten, da haste dich bei irgendeinem script verschluckt...

[Fice]

Un wie kann ich das Prob beheben???

[Fice]

hat keiner ne ahnung????

[Henne]

Code: Alles auswählen

', '" . str_replace("\'", "''", $user_codea) . "', '" . str_replace("\'", "''", $user_codeb) . "', '" . str_replace("\'", "''", $user_codec) . "', '" . str_replace("\'", "''", $user_coded) 

Hast das selber eingebaut?

Was willst du denn da machen? Musst schon Datenbankfelder angeben, in die du das reinschreiben möchtest...

[Gast]

Sorry!

Hier die ganzen DB Felder in der users Tabelle:
user_id mediumint(8) No 0 Change Drop Primary Index Unique Fulltext
user_active tinyint(1) Yes 1 Change Drop Primary Index Unique Fulltext
username varchar(25) No Change Drop Primary Index Unique Fulltext
user_password varchar(32) No Change Drop Primary Index Unique Fulltext
user_session_time int(11) No 0 Change Drop Primary Index Unique Fulltext
user_session_page smallint(5) No 0 Change Drop Primary Index Unique Fulltext
user_lastvisit int(11) No 0 Change Drop Primary Index Unique Fulltext
user_regdate int(11) No 0 Change Drop Primary Index Unique Fulltext
user_level tinyint(4) Yes 0 Change Drop Primary Index Unique Fulltext
user_posts mediumint(8) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
user_timezone decimal(5,2) No 0.00 Change Drop Primary Index Unique Fulltext
user_style tinyint(4) Yes NULL Change Drop Primary Index Unique Fulltext
user_lang varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_dateformat varchar(14) No d M Y H:i Change Drop Primary Index Unique Fulltext
user_new_privmsg smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
user_unread_privmsg smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
user_last_privmsg int(11) No 0 Change Drop Primary Index Unique Fulltext
user_emailtime int(11) Yes NULL Change Drop Primary Index Unique Fulltext
user_viewemail tinyint(1) Yes NULL Change Drop Primary Index Unique Fulltext
user_option tinyint(1) Yes 0 Change Drop Primary Index Unique Fulltext
user_attachsig tinyint(1) Yes NULL Change Drop Primary Index Unique Fulltext
user_allowhtml tinyint(1) Yes 1 Change Drop Primary Index Unique Fulltext
user_allowbbcode tinyint(1) Yes 1 Change Drop Primary Index Unique Fulltext
user_allowsmile tinyint(1) Yes 1 Change Drop Primary Index Unique Fulltext
user_allowavatar tinyint(1) No 1 Change Drop Primary Index Unique Fulltext
user_allow_pm tinyint(1) No 1 Change Drop Primary Index Unique Fulltext
user_allow_viewonline tinyint(1) No 1 Change Drop Primary Index Unique Fulltext
user_notify tinyint(1) No 1 Change Drop Primary Index Unique Fulltext
user_notify_pm tinyint(1) No 0 Change Drop Primary Index Unique Fulltext
user_popup_pm tinyint(1) No 0 Change Drop Primary Index Unique Fulltext
user_no_pm tinyint(1) Yes 1 Change Drop Primary Index Unique Fulltext
user_rank int(11) Yes 0 Change Drop Primary Index Unique Fulltext
user_avatar varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext
user_avatar_type tinyint(4) No 0 Change Drop Primary Index Unique Fulltext
user_email varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_icq varchar(15) Yes NULL Change Drop Primary Index Unique Fulltext
user_website varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext
user_from varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext
user_sig text Yes NULL Change Drop Primary Index Unique Fulltext
user_sig_bbcode_uid varchar(10) Yes NULL Change Drop Primary Index Unique Fulltext
user_aim varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_yim varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_msnm varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_occ varchar(100) Yes NULL Change Drop Primary Index Unique Fulltext
user_interests varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_actkey varchar(32) Yes NULL Change Drop Primary Index Unique Fulltext
user_newpasswd varchar(32) Yes NULL Change Drop Primary Index Unique Fulltext
user_profile_view smallint(5) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
user_last_profile_view int(11) No 0 Change Drop Primary Index Unique Fulltext
user_custom_rank varchar(255) Yes NULL Change Drop Primary Index Unique Fulltext
user_reminded tinyint(4) No 0 Change Drop Primary Index Unique Fulltext
user_codea varchar(10) No Change Drop Primary Index Unique Fulltext
user_codeb varchar(7) No Change Drop Primary Index Unique Fulltext
user_codec varchar(7) No Change Drop Primary Index Unique Fulltext
user_coded char(1) No Change Drop Primary Index Unique Fulltext
user_disable_pass tinyint(1) No 0 Change Drop Primary Index Unique Fulltext
no_report_popup tinyint(1) No 0 Change Drop Primary Index Unique Fulltext
refresh_report_popup tinyint(1) No 0 Change Drop Primary Index Unique Fulltext
no_report_mail tinyint(1) No 0 Change Drop Primary Index Unique Fulltext
user_points mediumint(8) UNSIGNED No 0 Change Drop Primary Index Unique Fulltext
user_traffic int(255) Yes 0 Change Drop Primary Index Unique Fulltext


Ich hoffe du kannst mir dabei helfen ;-)

[Fice]

Kann mir wirklich keiner helfen?????

[Schumi]

Versuche es so:
(Es hat ein Teil eines Mods gefehlt)

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_codea, user_codeb, user_codec, user_coded, user_option, 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_no_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("\'", "''", $user_codea) . "', '" . str_replace("\'", "''", $user_codeb) . "', '" . str_replace("\'", "''", $user_codec) . "', '" . str_replace("\'", "''", $user_coded) . "', '" . 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, $no_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";