Bei mir kommt wenn ich mein Profil ändere Folgende Warnmeldung:
Could not update 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, user_option = 0, user_custom_rank = '', user_sig = 'mfg Fic
UPDATE phpbb2_users SET user_email = '
fice@arcor.de', user_icq = '', user_website = '
http://www.fice.info/', user_occ = '', user_from = 'Hessen', user_interests = 'Diese SeiteRudern, Schiessen alles rund um PCs', user_codea = '4189267195', user_codeb = '8711256', user_codec = '1110078', user_coded = '2', 0, user_option = 0, user_custom_rank = '', user_sig = 'mfg Fice', user_sig_bbcode_uid = '5325b3617b', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 0, user_popup_pm = 1, user_no_pm = 1, user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 3, user_active = 1, user_actkey = '' WHERE user_id = 2
Line : 535
File : /home/ficeinfo/public_html/community/Forum/phpBB2/includes/usercp_register.php
Weist du wo der Fehler sein könnte?
Ich poste hier mal den Code um Zeile 535:
Code: Alles auswählen
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_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_codea = '" . str_replace("\'", "''", $user_codea) . "', user_codeb = '" . str_replace("\'", "''", $user_codeb) . "', user_codec = '" . str_replace("\'", "''", $user_codec) . "', user_coded = '" . str_replace("\'", "''", $user_coded) . "', $option, user_option = $option, user_custom_rank = '" . str_replace("\'", "''", $custom_rank) . "', 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 = $popuppm, user_no_pm = $no_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 . "
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}