SQL Error : 1064 / was stimmt da nicht?
Verfasst: 05.06.2007 14:28
wenn ich das profil aktualisieren möchte, kommt diese fehlermeldung:
hab bereits mit der suche gesucht (kommen ziemmlich viele ergebnisse)
jedoch passt irgendwie nix
hier der code dazuCould 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 'user_actkey', no_report_popup = 0, no_report_mail = 0 WHERE user_id = 3' at line 2
UPDATE phpbb_users SET user_email = '---------', user_icq = '', user_website = '-------', user_occ = '-------', user_from = 'AG^^', user_interests = '---------', user_sig = '[img:9e83a68254]http://img183.imageshack.us/img183/3962 ... 998ki1.gif[/img:9e83a68254] [img:9e83a68254]http://www.danasoft.com/sig/happy-habbi.jpg[/img:9e83a68254] test', user_sig_bbcode_uid = '9e83a68254', 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, games_block_pm = 0, user_popup_pm = 0, user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 1, user_active = user_active, user_actkey = 'user_actkey'user_actkey', no_report_popup = 0, no_report_mail = 0 WHERE user_id = 3
Line : 561
File : usercp_register.php
Code: Alles auswählen
$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, games_block_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, 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, $games_block_pm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";jedoch passt irgendwie nix
