phpBB.de

Hallo

ich habe den o.g. Mod eingebaut.
Bei mir funktioniert er einwandfrei.
Nur meine Mitglieder sagen mir das sie diese Fehlermeldung bekommen.

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_plz = 'Reptilien, Frettchen, PC und Internet', '64289', user_birthday = '-' at line 2
...
...

Line : 531
File : /www/htdocs/xxx/phpbb2/includes/usercp_register.php
Was hab ich falsch gemacht.?
Das db_update_wetter_addon.php habe ich Erfolgreich ausgefürt

hi...

poste doch mal die Zeile 530 - 540 von der usercp_register.php....

hier die zeilen

{
$user_active = 1;
$user_actkey = '';
}

$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, user_plz = '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $plz) . "', user_plz = '", 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_blending = $blending
, 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 . ", user_gender = '$gender'
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);
}

if ( !$user_active )
{
//
// The users account has been deactivated, send them an email with a new activation key
//
include($phpbb_root_path . 'includes/emailer.'.$phpEx);
$emailer = new emailer($board_config['smtp_delivery']);

Suche:
Ersetze:

So wies aussieht hast du etwas verwechselt

Es geht immer noch nicht.

$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) . "' . str_replace("\'", "''", $interests) . "', user_plz = '" . str_replace("\'", "''", $plz) . "', 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_blending = $blending
, 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 . ", user_gender = '$gender'
WHERE user_id = $user_id";
if ( !($result = $db->sql_query($sql)) )

Bekomme nun diese meldung
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /www/htdocs/xxx/phpbb2/includes/usercp_register.php on line 526

Verlinke doch bitte mal deine ganze Datei als Text - Datei...

Hier der ganze Text

http://www.mitglied.lycos.de/collaris/u ... gister.txt

Versuche es mal mit dieser:

www.habbofanclub.com/downloads/usercp_register.zip

Immer noch dieser Fehler
Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /www/htdocs/xxx/phpbb2/includes/usercp_register.php on line 526

Hi ...

damit sollte es passen ...
Markus