phpBB.de

Verfasst: **16.04.2007 15:53**

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 '= '*****@**.de', user_icq = '', user_website = '', user_occ = '', user_from' at line 1

UPDATE phpbb_usersSET user_email = '*****@***.de', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', , user_custom_rank = 'rwa', user_sig = '[img:d066f6181f]http://img244.imageshack.us/img244/1520/**********.jpg[/img:d066f6181f]', user_sig_bbcode_uid = 'd066f6181f', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, karma_setonoff = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 0, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 536
File : usercp_register.php

Dieser Fehler kommt wen ich auf "profil" gehe und was in den Rangname eingebe und dan "absenden" klicke.

Ich hoffe das mir jemmand helfen kann.
Danke!

Verfasst: **16.04.2007 16:11**

Hallo!

Bitte die usercp_register.php zum Download bereitstellen.

Viele Grüße,
Bálint

Verfasst: **16.04.2007 16:34**

Balint hat geschrieben:Hallo!

Bitte die usercp_register.php zum Download bereitstellen.

Viele Grüße,
Bálint

Okay hier bitte
http://dramaforum.dr.funpic.de/usercp_register.txt

Verfasst: **16.04.2007 16:38**

Hier

Code: Alles auswählen

"SET "

vor SET ein Leerzeichen einfügen

Verfasst: **16.04.2007 16:46**

punkface hat geschrieben:Hier
Code: Alles auswählen
"SET "
vor SET ein Leerzeichen einfügen

danke für deine hilfe aber jetzt kommt dieser fehler.

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 ' user_custom_rank = 'Admin B.O.S.S', user_sig = '[img:8a3e4b6390]http://img244.i' at line 1

UPDATE phpbb_users SET user_email = 'liri_king@web.de', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', , user_custom_rank = 'Admin B.O.S.S', user_sig = '[img:8a3e4b6390]http://img244.imageshack.us/img244/1520 ... signv9.jpg[/img:8a3e4b6390]', user_sig_bbcode_uid = '8a3e4b6390', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, karma_setonoff = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 0, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 536
File : usercp_register.php

Verfasst: **16.04.2007 16:47**

Das ist es nicht ganz, die Einsetzung von $user_title ist ebenfalls falsch:

Suche:

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_title, 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, karma_setonoff = $karmashow, 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 . "

Ersetze mit:

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_title, 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, karma_setonoff = $karmashow, 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 . "

Viele Grüße,
Bálint

Verfasst: **16.04.2007 16:58**

Hey Balint vielen vielen dank für deine Hilfe!!

Top Arbeit!!

weiter so!!

phpBB.de

Custom User Rank Fehler!! Hilfe!!!

Custom User Rank Fehler!! Hilfe!!!