Fehler bei Registrierung!

[me_reflex]

Nach dem Absenden der Registrierungsdaten erscheint folgender Fehler

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_level, user_allow_pm, user_active, user_actkey) VALUE

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_vorname, user_name, user_strasse, user_ort, user_telefon, user_skype, 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, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender user_level, user_allow_pm, user_active, user_actkey) VALUES (71, 'test', 1124230822, '193ae91fa483cb14a0e6869acf745443', 'test@cs-4players.de.tk', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 0, 'd.m.Y H:i', 'german', 7, '1' 0, 1, 1, '')
Line : 608
File : usercp_register.php

Woran könnte das liegen?

//edit

hier die usercp_register.php als txt


In der Zeile 608 steht irgendwie nix drin :/

[kellanved]

Zwischen user_gender und user_level fehlt ein Komma.

[me_reflex]

Hab das editiert

nun bekomme ich den Fehler

Could not insert data into 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 '0, 1, 1, '')' at line 2

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_vorname, user_name, user_strasse, user_ort, user_telefon, user_skype, 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, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender, user_level, user_allow_pm, user_active, user_actkey) VALUES (71, 'test', 1124231983, '193ae91fa483cb14a0e6869acf745443', 'test@cs-4players.de.tk', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 0, 'd.m.Y H:i', 'german', 7, '0' 0, 1, 1, '')
Line : 608
File : usercp_register.php

[kellanved]

Das gleiche Problem findet sich auch bei den Werten.

'0', 0, 1, 1, '')

[me_reflex]

äähm...wo kann ich die ändern??

[kellanved]

Finde diese Stelle:

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_vorname, user_name, user_strasse, user_ort, user_telefon, user_skype, 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, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_gender 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("\'", "''", $vorname) . "', '" . str_replace("\'", "''", $name) . "', '" . str_replace("\'", "''", $strasse) . "', '" . str_replace("\'", "''", $ort) . "', '" . str_replace("\'", "''", $telefon) . "', '" . str_replace("\'", "''", $skype) . "', '" . 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, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, '$gender' 0, 1, ";

Ganz am Ende ist das Problem:

'$gender' 0, 1, ";

zwischen '$gender' und 0 gehört ein Komma.

[me_reflex]

Hat funktioniert!

Dankeschön!