phpBB.de

Verfasst: **24.02.2007 15:17**

Hallo,

wenn sich jemand bei mir zu registrien versucht erhalte ich immer diese Fehlermeldung:

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_registered_ip, user_registered_hostname,user_id, username, user_regdate, user_password, user_email, user_regip, 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_phoogle_map_center, user_phoogle_comment, user_phoogle_icon, user_level, user_allow_pm, user_active, user_actkey) VALUES ('50915ff9', 'p50915FF9.dip.t-dialin.net',686, 'TEST1', 1172326440, 'e19457c81e62b6bb21e9031a5a187cdf', 'ur@gmx.de', '50915ff9', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 1, 'd.m.Y, H:i', 'german', 3, '50.875311142200765, 6.7236328125', '', 0, 1, 0, 'c586d6efebcb9')

Line : 640
File : usercp_register.php

was ist denn da doppelt. Kann mir da bitte jemand weiterhelfen??

Danke + Gruß

Jens

Verfasst: **24.02.2007 15:24**

Es werden 40 Spalten genannt aber 41 Werte übergeben..... Das ist das Problem.
Du hast vergessen, den Query in der Datei bei den Spaltennamen zu erweitern. Bei den Values hast Du es gemacht.

Verfasst: **24.02.2007 15:28**

hallo,

ich bin gerade umgezogen auf einen neuen Server.

Wie kann ich das denn jetzt wieder reparieren? Also das mit den Queries. Wo finde ich das?

Verfasst: **24.02.2007 15:36**

In der usercp_register.php VOR Zeile 640.

Verfasst: **24.02.2007 15:43**

hoffe das reicht

Code: Alles auswählen

//
			// Get current date
			//
			$parens = array("(",")");
			$sql = "INSERT INTO " . USERS_TABLE . "	(user_registered_ip, user_registered_hostname,user_id, username, user_regdate, user_password, user_email,  user_regip, 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_phoogle_map_center, user_phoogle_comment, user_phoogle_icon, user_level, user_allow_pm, user_active, user_actkey)
				VALUES ('" . str_replace("\'", "''", $user_registered_ip) . "', '" . str_replace("\'", "''", $user_registered_hostname) . "',$user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email)  . "', '" . $userdata['session_ip']. "', '" . 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,  '" . str_replace($parens,"", $map_center) . "', '" . str_replace("\'", "''", $phoocomm) . "', 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);
			}

Verfasst: **24.02.2007 16:03**

Wenn ich jetzt wüsste, welchen Wert die Spalte user_phoogle_icon erwartet.... Hm.

Probier das:

finde

Code: Alles auswählen

$sql = "INSERT INTO " . USERS_TABLE . "   (user_registered_ip, user_registered_hostname,user_id, username, user_regdate, user_password, user_email,  user_regip, 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_phoogle_map_center, user_phoogle_comment, user_phoogle_icon, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ('" . str_replace("\'", "''", $user_registered_ip) . "', '" . str_replace("\'", "''", $user_registered_hostname) . "',$user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email)  . "', '" . $userdata['session_ip']. "', '" . 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,  '" . str_replace($parens,"", $map_center) . "', '" . str_replace("\'", "''", $phoocomm) . "', 0, 1, ";

tausche aus gegen:

Code: Alles auswählen

$sql = "INSERT INTO " . USERS_TABLE . "   (user_registered_ip, user_registered_hostname,user_id, username, user_regdate, user_password, user_email,  user_regip, 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_phoogle_map_center, user_phoogle_comment, user_phoogle_icon, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ('" . str_replace("\'", "''", $user_registered_ip) . "', '" . str_replace("\'", "''", $user_registered_hostname) . "',$user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email)  . "', '" . $userdata['session_ip']. "', '" . 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,  '" . str_replace($parens,"", $map_center) . "', '" . str_replace("\'", "''", $phoocomm) . "', '', 0, 1, ";

Verfasst: **24.02.2007 16:24**

Miriam hat geschrieben:Wenn ich jetzt wüsste, welchen Wert die Spalte user_phoogle_icon erwartet.... Hm.

Probier das:

finde

Code: Alles auswählen

$sql = "INSERT INTO " . USERS_TABLE . "   (user_registered_ip, user_registered_hostname,user_id, username, user_regdate, user_password, user_email,  user_regip, 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_phoogle_map_center, user_phoogle_comment, user_phoogle_icon, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ('" . str_replace("\'", "''", $user_registered_ip) . "', '" . str_replace("\'", "''", $user_registered_hostname) . "',$user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email)  . "', '" . $userdata['session_ip']. "', '" . 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,  '" . str_replace($parens,"", $map_center) . "', '" . str_replace("\'", "''", $phoocomm) . "', 0, 1, ";

tausche aus gegen:

Code: Alles auswählen

$sql = "INSERT INTO " . USERS_TABLE . "   (user_registered_ip, user_registered_hostname,user_id, username, user_regdate, user_password, user_email,  user_regip, 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_phoogle_map_center, user_phoogle_comment, user_phoogle_icon, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ('" . str_replace("\'", "''", $user_registered_ip) . "', '" . str_replace("\'", "''", $user_registered_hostname) . "',$user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email)  . "', '" . $userdata['session_ip']. "', '" . 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,  '" . str_replace($parens,"", $map_center) . "', '" . str_replace("\'", "''", $phoocomm) . "', '', 0, 1, ";

Du hast den falschen Namen hier. Gott solltest du heißen. Von wegen 2000 Jahre auf den Messias warten.

Vielen, vielen Dank für deine tolle Hilfe!!

Verfasst: **24.02.2007 16:48**

Nenn' mich Miriam.... Das reicht dann schon.

Verfasst: **25.02.2007 09:25**

Hier sind noch mal die genauen Werte für die Spalte user_phoogle_icon - für die die das mal interessieren könnte

FINDE

Code: Alles auswählen

str_replace("\'", "''", $phoocomm) . "', '', 0, 1, ";

REPLACE with

Code: Alles auswählen

str_replace("\'", "''", $phoocomm) . "', '$phooicon', 0, 1, ";

Verfasst: **20.03.2007 21:46**

Ich hoffe, dass ist okay, wenn ich mich hier mal hintendran hänge.

Ich bin gerade beim Einbau des Medal-Mods und bekomme auch die Fehlermeldung:

Column count doesn't match value count at row 1

Die Zeilen sehen wie folgt aus:

INSERT INTO `phpbb_config` VALUES ('allow_medal_display', '0');
INSERT INTO `phpbb_config` VALUES ('medal_display_row', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_col', '1');
INSERT INTO `phpbb_config` VALUES ('medal_display_width', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_height', '');
INSERT INTO `phpbb_config` VALUES ('medal_display_order', '');
INSERT INTO `phpbb_medal_cat` VALUES ('1', 'Default', '10');

Die letzte Zeile hat er geschluckt, aber die oberen 6 nimmt er nicht.

Was muß ich ändern?