Error in registratie

[Ricar87do]

Ben ik weer
ik krijg nu de volgende error in de registratie

Code: Selecteer alles

Could not insert data into users table

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 ' '0' 0, 1, 0, 'f3996c')' at line 2

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 (16, 'phpbb.nl', 1092238485, '25f9e794323b453885f5181f1b624d0b', 'geenidee99@blaat.nl', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 0, 0, 2, 'D d M Y, G:i:s', 'dutch', 4,, '0' 0, 1, 0, 'f3996c')

Line : 535
File : /data/members/free/tripod/nl/r/i/c/ricar87do/htdocs/phpBB2/includes/usercp_register.php

regel 535

Code: Selecteer alles

			//
			// 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_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, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style,, '$gender' 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);
			}

			$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator)
				VALUES ('', 'Personal User', 1, 0)";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql);
			}

[Stef]

Ben jezelf al op het idee gekomen, om je werk eventjes te checken.

[Ricar87do]

jah anders kwam ik het niet hier vragen

[Stef]

Weet je het zeker? Het is anders heel simpel, want de foutmelding zegt precies waar de fout zit.

"''", $user_lang) . "', $user_style,, '$gender' 0, 1, ";

[Ricar87do]

uh nog steeds hetzelfde hoor en ik heb precees die zin erin staan maar nog steeds

Code: Selecteer alles

Could not insert data into users table

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 ' '0' 0, 1, 0, 'de4db9')' at line 2

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 (16, 'phpbb.nl', 1092241080, '25f9e794323b453885f5181f1b624d0b', 'geenidee99@blaat.nl', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 2, 'D d M Y, G:i:s', 'dutch', 4,, '0' 0, 1, 0, 'de4db9')

Line : 535
File : /data/members/free/tripod/nl/r/i/c/ricar87do/htdocs/phpBB2/includes/usercp_register.php

[Leipo]

Ja een foute zin moet je er niet in laten zetten natuurlijk.

Code: Selecteer alles

"''", $user_lang) . "', $user_style,, '$gender' 0, 1, ";

Maak er eens ... van.

Code: Selecteer alles

"''", $user_lang) . "', $user_style, '$gender' 0, 1, ";

[Ricar87do]

nope nog niks sorry

Dat stukje ziet er nu zo uit

Code: Selecteer alles

$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, '$gender' 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);
			}

			$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator)
				VALUES ('', 'Personal User', 1, 0)";
			if ( !($result = $db->sql_query($sql))

[Leipo]

Maak er eens ... van.

Code: Selecteer alles

"''", $user_lang) . "', $user_style, $gender, 0, 1, ";

[Ricar87do]

dan krijg ik:

Code: Selecteer alles

Parse error: parse error in /data/members/free/tripod/nl/r/i/c/ricar87do/htdocs/phpBB2/includes/usercp_register.php on line 618

[Stef]

En wat staat er op 618

[Ricar87do]

is een lege regel

Code: Selecteer alles

				$emailer->assign_vars(array(
					'SITENAME' => $board_config['sitename'],
					'WELCOME_MSG' => sprintf($lang['Welcome_subject'], $board_config['sitename']),
					'USERNAME' => preg_replace($unhtml_specialchars_match, $unhtml_specialchars_replace, substr(str_replace("\'", "'", $username), 0, 25)),
					'PASSWORD' => $password_confirm,
					'EMAIL_SIG' => str_replace('<br />', "\n", "-- \n" . $board_config['board_email_sig']),

					'U_ACTIVATE' => $server_url . '?mode=activate&' . POST_USERS_URL . '=' . $user_id . '&act_key=' . $user_actkey)
				);
			}

[Luuk]

aal die dan eens weg, kijken wat ie dan aangeeft

[Ricar87do]

geen 1 meer alleen nu staat de gender mod fout nammelijk ipv

Geslacht: niet ingevult () mannelijk () vrouwelijk ()

: () () ()

maarja het is een stapje vooruit lol

PS () is het rondje om te selecteren

[Ricar87do]

niemand?

[Luuk]

je hebt de $lang['blabla'] link niet in het .php bestand gezet òf niet in het lang_main.php bestand.

als je de nederlandse taal op je forum hebt, heb je dan de veranderingen van de mod ook in de nederlandse taalbestanden gewijzigt?