Habe ein ähnliches Problem, kann sich das mal einer ansehen?
Fehler:
Could not update users table
DEBUG MODE
SQL Error : 1064 You have an error in your SQL syntax near ' user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm' at line 2
UPDATE alejnu_phpbb_users SET user_email = '
webmaster@alejnu.de', user_icq = '104413793', user_website = '
http://alejnu.de', user_occ = '', user_from = '', user_interests = '', user_sig = '[color=teal:cefbc414fb][size=9:cefbc414fb]The greatest thing you ever learn is just to love and be loved in return. - Moulin Rouge ------------------------------------------------------------------------------------------------------------------------------ .:What is real? How do you define real? If you''re talking about what you can feel, what you can smell, what you can taste and see, then real is simply electrical signals interpreted by your brain:.[/color:cefbc414fb][/size:cefbc414fb]', user_viewemail = 1, user_aim = 'Alejnu', user_yim = '', user_msnm = '
alejnu@aol.com', user_attachsig = 1, user_setbm = 0, user_sig_bbcode_uid = 'cefbc414fb', user_allowsmile = 1, user_allowhtml = 0, user_allowavatar = , user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm = , user_notify_pm = 1, user_popup_pm = 1, user_lang = 'german', user_style = 1, user_timezone = 1, user_dateformat = 'd.m.Y - H:i', user_active = , user_rank = WHERE user_id = 5
Line : 444
File : /kunden/mdw-hosting.de/hosting/4859/alejnu.de/phpBB/includes/usercp_register.php
Code:
Code: Alles auswählen
$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_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_setbm = $setbm, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank" . $avatar_sql . "
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
)