2nd website

[Diablo Gamer]

ik krijg deze error naar de 2de website ingevuld te hebben

Code: Selecteer alles

 
Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'user_website2 = 'http://www.phpbbhacks.com/', user_occ = '', user_from = 'Dalen/' at line 2

UPDATE phpbb_users SET user_email = 'michaelwiekens@gmail.com', user_icq = '315324956', user_website = 'http://www.torrentgame.nl/forum'user_website2 = 'http://www.phpbbhacks.com/', user_occ = '', user_from = 'Dalen/Drenthe/Holland', user_interests = 'alles wat met een computer temalen heeft', user_birthday = '6007', user_next_birthday_greeting = '2006', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = 'Diablo_Gamer', user_msnm = 'michaelwiekens@hotmail.com', user_attachsig = 0, user_allowsmile = 1, user_autospell = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 2, user_dateformat = 'd M Y h:i a', user_lang = 'dutch', user_style = 2, user_active = 1, user_actkey = '', user_country = 'netherlands' WHERE user_id = 2

Line : 619
File : usercp_register.php 

Line : 619 =

Code: Selecteer alles

			{

Code: Selecteer alles

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_register.php

# 
#-----[ FIND ]------------------------------------------ 
# 
$strip_var_list = array('username' =>

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
'website' => 'website',

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
'website2' => 'website2',

# 
#-----[ FIND ]------------------------------------------ 
# 
validate_optional_fields

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
$website

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
$website2

# 
#-----[ FIND ]------------------------------------------ 
# 
$website = stripslashes($website);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$website = stripslashes($website);

# 
#-----[ FIND ]------------------------------------------ 
# 
if ( $website != '' )
	{
		rawurlencode($website);
	}
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
if ( $website2 != '' )
	{
		rawurlencode($website2);
	}

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "UPDATE " . USERS_TABLE . "

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
user_website = '" . str_replace("\'", "''", $website) . "'

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
user_website2 = '" . str_replace("\'", "''", $website2) . "'

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "INSERT INTO " . USERS_TABLE .

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
user_website,

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
user_website2,

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "UPDATE " . USERS_TABLE . "

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
'" . str_replace("\'", "''", $website) . "',

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
'" . str_replace("\'", "''", $website2) . "',

# 
#-----[ FIND ]------------------------------------------ 
# 
'WEB_SITE' => $website,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'WEB_SITE2' => $website2,

# 
#-----[ FIND ]------------------------------------------ 
# 
$website = stripslashes($website);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$website2 = stripslashes($website2);

# 
#-----[ FIND ]------------------------------------------ 
# 
$website = $userdata['user_website'];


# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$website2 = $userdata['user_website2'];

# 
#-----[ FIND ]------------------------------------------ 
# 
display_avatar_gallery

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
$website,

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
$website2,

# 
#-----[ FIND ]------------------------------------------ 
# 
'WEBSITE' => $website,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
'WEBSITE2' => $website2,

# 
#-----[ OPEN ]------------------------------------------ 
# 

[Paul]

Je hebt de mod niet goed uitgevoerd, loop hem noge ens na
(En dan vooral usercp_regiser.php )

[Bee]

Je ziet natuurlijk zelf ook wel dat op die lijn nooit een fout kan zitten. Je hebt een paar regels eerder een SQL opdracht verkeerd gemod, waardoor er nu een komma ontbreekt voor user_website2

[Diablo Gamer]

lijn 600 tot 620

ik kan er geen fout aan vinden zelf als ik de install bestand naar loop

Code: Selecteer alles

				$key_len = 54 - ( strlen($server_url) );
				$key_len = ( $key_len > 6 ) ? $key_len : 6;
				$user_actkey = substr($user_actkey, 0, $key_len);

				if ( $userdata['session_logged_in'] )
				{
					session_end($userdata['session_id'], $userdata['user_id']);
				}
			}
			else
			{
				$user_active = 1;
				$user_actkey = '';
			}

			$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) ."', user_website2 = '" . str_replace("\'", "''", $website2) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_autospell = $spellcheck, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . ", user_country = '" . str_replace("\'", "''", $user_country) . "'
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )

[Paul]

Weet je zeker dat je niks veranderd hebt? Want hier staat de , er wel gewoon :S

EN mischien ook het SQL deel uitvoeren