profiel aanpassen = error

[mark1]

Hallo,

Ik krijg een fout als ik me avatar wil verwijderen, hopelijk weten jullie de fout.

Fout:

Code: Selecteer alles

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_country = 'netherlands', user_gender = '1' WHERE user_id = 2' at line 2

UPDATE phpbb_users SET user_email = 'eminem_style1990@hotmail.com', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = 'Markweb', user_sig_bbcode_uid = '2989c82698', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_notes_mail = 1, user_timezone = 2, user_dateformat = 'd M Y h:i a', user_lang = 'dutch', user_style = 1, user_email_new_gb = 0, user_active = user_active, user_actkey = 'user_actkey', user_avatar = '', user_avatar_img = null, user_avatar_type = 0, user_allowavatar = , user_country = 'netherlands', user_gender = '1' WHERE user_id = 2

Line : 641
File : usercp_register.php

Usercp_register.php:

Code: Selecteer alles

$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_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', 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_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_notes_mail = $notes_mail, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_email_new_gb = $gb_email, user_active = $user_active, user_actkey = '$user_actkey'" . $avatar_sql . ", user_allowavatar = $allowavatar, user_country = '" . str_replace("\'", "''", $user_country) . "', user_gender = '$gender'
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
			}

Bij voorbaat dank

[Salomon]

wat is lijn 641?

Moet volgens mij in 2.0.xx support

[mark1]

Code: Selecteer alles

if ( !($result = $db->sql_query($sql)) )
			{
641: message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
			}

[Stef]

Verander het eens met dit gedeelte, er zit namelijk wat fout... bij $avatar_sql, denk ik.

Code: Selecteer alles

$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_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', 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_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_notes_mail = $notes_mail, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_email_new_gb = $gb_email, user_active = $user_active, user_allowavatar = $allowavatar, user_gender = '$gender', user_country = '" . str_replace("\'", "''", $user_country) . "', user_actkey = '$user_actkey'" . $avatar_sql . "
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
			}

Laat even weten of het is gelukt, succes!


Bij voorbaat dank[/quote]

[mark1]

Krijg nog steeds dezelfde fout iedegeval wel alvast bedankt

[Paul]

verander in de query dit:

Code: Selecteer alles

user_allowavatar = $allowavatar,

n naar:

Code: Selecteer alles

user_allowavatar = '$allowavatar',

(Ja ik weet, niet de netste oplossing maar hij werkt denk ik wel )

[mark1]

Bedankt, het is opgelost hartelijk dank