Probleme beim regestrieren!!!

[dennyk20]

Could not insert data into users table

DEBUG MODE
Hallo!!!


INSERT INTO phpbb_users (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_upi2db_which_system, user_upi2db_new_word, user_upi2db_edit_word, user_upi2db_unread_color, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting user_active, user_actkey) VALUES (7, 'ddd', 1171570971, '343d9040a671c45832ee5381860e2996', 'denny.@t-online.de', '', '', '', '', '', '', '', '', 0, 0, 0, 0, 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 'D d M, Y H:i', 'german', 4, 0, 1, '999999', '' 1, '')

Line : 722
File : usercp_register.php



Woran liegt das? Es wollte sich gerade jemand regestrieren und dann kamm diese meldung bin etwas hilflos..

[dennyk20]

beim regestrieren ist das problem weg..habe einen mod wieder rausgemacht per emi. nun ist aber noch folgender fehler wenn ich mein profil verändern will!

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 'SET user_email = 'to-talk-about@freenet.de', user_icq = '', user_website = '', u' at line 3

UPDATE phpbb_users SET user_email = 'to-talk-about@freenet.de', user_icq = '', user_website = '', user_occ = 'Veräuferin (Erziehungsurlaub)', user_from = 'nähe Braunschweig', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D d M, Y H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' SET user_email = 'to-talk-about@freenet.de', user_icq = '', user_website = '', user_occ = 'Veräuferin (Erziehungsurlaub)', user_from = 'nähe Braunschweig', user_interests = '', user_birthday = '5848', user_next_birthday_greeting = '2008', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D d M, Y H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 598
File : usercp_register.php

verzweifle fast...

[Garnele]

Hallo

Hast du dir deine Query mal genau angesehen?

UPDATE phpbb_users SET user_email = 'to-talk-about@freenet.de', user_icq = '', user_website = '', user_occ = 'Veräuferin (Erziehungsurlaub)', user_from = 'nähe Braunschweig', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D d M, Y H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' SET user_email = 'to-talk-about@freenet.de', user_icq = '', user_website = '', user_occ = 'Veräuferin (Erziehungsurlaub)', user_from = 'nähe Braunschweig', user_interests = '', user_birthday = '5848', user_next_birthday_greeting = '2008', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D d M, Y H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2

Das ist ein gemisch aus doppelt und nicht

So ist richtig:

Code: Alles auswählen

UPDATE phpbb_users SET user_email = 'to-talk-about@freenet.de', user_icq = '', user_website = '', user_occ = 'Veräuferin (Erziehungsurlaub)', user_from = 'nähe Braunschweig', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D d M, Y H:i', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '', user_birthday = '5848', user_next_birthday_greeting = '2008' WHERE user_id = 2 

Lg
garnele

edit: ups, zu viel markiert

[dennyk20]

Hallo!

mal ne frage könntest du genau posten was da reinkommt? leider hab ich an dem backup auch was verändert und gespeichert und habe über haupt keine zeile mehr....*heul*


Danke schon mal...Gruß Denny

[Garnele]

Hallo

Also wie meinst du das?

LG
garnele

[dennyk20]

Naja in meiner datei steht momentan das: $sql = "UPDATE " . USERS_TABLE . "
SET user_email = 'dennyk20@freenet.de', user_icq = '', user_website = '', user_occ = 'Kfz-Mechaniker', user_from = 'nähe Wolfsburg', user_interests = '',user_birthday = '5972', user_next_birthday_greeting = '2007' user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_upi2db_which_system = 0, user_upi2db_new_word = 1, user_upi2db_edit_word = 1, user_upi2db_unread_color = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_dateformat = 'D d M, Y H:i', user_lang = 'german', user_style = 4, user_active = 1, user_actkey = '' WHERE user_id = 3

aber das ist ja falsch hab ausversehen das orginal gelöscht und nun weiß ich net was da rein kommt *schäm*

[Garnele]

HAllo

Such mal in deiner profile.php nach

Code: Alles auswählen

$sql = "UPDATE " . USERS_TABLE . "
SET user_email =

Poste dann einmal die komplete Variable.

LG
garnele

[dennyk20]

also wenn ich die datei ändere und sie so mache ist der fehler weg...

$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_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";

Baue ich aber den birthday mod wieder ein ist der fehler wieder da! so sieht die eingebaute datei aus!

$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_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting, 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_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"

und dann gehts wieder nicht!!!

[Garnele]

Hallo

Versuchs mal damit:

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_birthday='$birthday', user_next_birthday_greeting='$next_birthday_greeting', 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_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"

LG
Garnele

[dennyk20]

das kommt jetzt!! Parse error: syntax error, unexpected T_IF in /usr/export/www/vhosts/funnetwork/hosting/totalk/includes/usercp_register.php on line 602

Danke für die nette hilfe...