phpBB.de

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..

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...

Hallo

Hast du dir deine Query mal genau angesehen?

Query hat geschrieben: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:

Lg
garnele

edit: ups, zu viel markiert

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

Hallo

Also wie meinst du das?

LG
garnele

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*

HAllo

Such mal in deiner profile.php nach
Poste dann einmal die komplete Variable.

LG
garnele

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!!!

Hallo

Versuchs mal damit:

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...