SQL Error : 1136 Column count doesn't match value count at r

[uran2358]

Hallo,

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

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_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

[Miriam]

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.

[uran2358]

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?

[Miriam]

In der usercp_register.php VOR Zeile 640.

[uran2358]

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);
			}

[Miriam]

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, ";

[uran2358]

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!!

[Miriam]

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

[uran2358]

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, ";

[Maria77]

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?