phpBB.de

Verfasst: **15.02.2006 18:19**

Allgemeiner Fehler

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_plz , 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_long, user_lat, user_birthday, user_next_birthday_greeting , user_active, user_actkey) VALUES (4, 'test', 1140025191, '098f6bcd4621d373cade4e832627b4f6', 'mindblower@hotmail.de', '', '', '', '', '', '' , '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 0, 'd.m.Y, H:i', 'german', 1, 0, 1,'', '', 0, 'f47644159ec37e238')

Line : 763
File : usercp_register.php

Verfasst: **15.02.2006 18:51**

Hi,

gib mal den Teil der Fehlermeldung in der Forensuche ein, dann findest du genug.

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

Julian

Verfasst: **15.02.2006 19:03**

in der zeile 763 steht garnichts

Code: Alles auswählen

 					while ($row = $db->sql_fetchrow($result))
 					{
 						$emailer->from($board_config['board_email']);
 						$emailer->replyto($board_config['board_email']);
 						
 						$emailer->email_address(trim($row['user_email']));
 						$emailer->use_template("admin_activate", $row['user_lang']);
 						$emailer->set_subject($lang['Reactivate']);
ZEILE 763
 						$emailer->assign_vars(array(
 							'USERNAME' => preg_replace($unhtml_specialchars_match, $unhtml_specialchars_replace, substr(str_replace("\'", "'", $username), 0, 25)),

Verfasst: **15.02.2006 19:54**

warum wurde der beitrag von fabrizio gelöscht ?

Verfasst: **15.02.2006 20:19**

Ja habe die ganze suche schon durchstöbert , und jeden wurde geholfen

Ich wüßte auch nicht was für ein Mod das verursacht hat ?

Ich habe gar kein Plan was ich machen soll.

Hier mal die verbauten Mod's:

Atlas Mod,Another Online/Offline indicator,Intro + Portal,Chat Box MOD 1.19 von Smartor,CTracker Pro 2nd Edition - Komplettschutz für das Board,SeparateAnnouncementsAndSticky_2.0.0a,Linkliste,Birthday Mod 1.5.7,Intro + Portal Wetter Addon,Photo Albumv2.0.53 -Smartor und noch ein paar kleine !

Und ich habe keine lust das nochmal alles vorn vorne zu machen ,wer echt schön wenn mir jemand hilft !

Verfasst: **15.02.2006 22:30**

sorry für die etlichen post's ,aber kann ich jetze mein board kicken

Verfasst: **15.02.2006 23:35**

Hi ...

suche:

Code: Alles auswählen

			//
			// Get current date
			//
			$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_plz
, 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_long, user_lat, user_birthday, user_next_birthday_greeting
, 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("\'", "''", $plz) . "'
, '" . 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,'" . str_replace("\'", "''", $user_long) . "', '" . str_replace("\'", "''", $user_lat) . "', ";
			if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )

ersetze mit:

Code: Alles auswählen

			//
			// Get current date
			//
			$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_plz, 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_long, user_lat, user_birthday, user_next_birthday_greeting, 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("\'", "''", $plz) . "', '" . 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,'" . str_replace("\'", "''", $user_long) . "', '" . str_replace("\'", "''", $user_lat) . "', ";
			if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )

Markus

Verfasst: **16.02.2006 13:18**

Danke für deine Antwort Markus !!!

Hat leider nicht's geholfen selbes prob noch immer

usercp_register.php
klick mich

Verfasst: **16.02.2006 15:03**

Hi ...

ok ... jetzt sollte es wieder funktionieren ...
suche:

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_plz, 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_long, user_lat, user_birthday, user_next_birthday_greeting, 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("\'", "''", $plz) . "', '" . 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,'" . str_replace("\'", "''", $user_long) . "', '" . str_replace("\'", "''", $user_lat) . "', ";

ersetze mit:

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_plz, 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_long, user_lat, user_birthday, user_next_birthday_greeting, 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("\'", "''", $plz) . "', '" . 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, '" . str_replace("\'", "''", $user_long) . "', '" . str_replace("\'", "''", $user_lat) . "', '$birthday', '$next_birthday_greeting', ";

Markus

Verfasst: **16.02.2006 16:52**

Spitze

DANKE DANKE DANKE !!!

Ich habe bloss schon wieder ein prob hatte jetze ein test user gemacht ,
der lässt sich zwar löschen aber da steht das da :

Could not delete group for this user

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

DELETE FROM phpbb_groups WHERE group_id =

Line : 156
File : admin_users.php

da stimmt doch auch was nicht oder ?

die datei admin_users.txt

phpBB.de

Alles für umsonst oder wie ,reg probleme >>helft mir b

Alles für umsonst oder wie ,reg probleme >>helft mir b