message_die problem nach einbau signatur editor

[zorb!]

hi,
ich habe folgendes message_die problem:

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 'd.m.Y, H:i', user_lang = 'german', user_style = 11, user_active

UPDATE phpbb_users SET user_email = 'zorb@superfreunde.info', user_icq = '240397093', user_website = 'http://www.superfreunde.info', user_occ = '', user_from = 'Henstedt-Ulzburg', user_interests = ''', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 0, user_timezone = 1, user_dateformat = 'd.m.Y, H:i', user_lang = 'german', user_style = 11, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 459
File : /homepages/37/d105280836/htdocs/includes/usercp_register.php

das passiert, wenn ich mein profil aktualisieren möchte.

das ist die zeile 459 aus der usercp_register.php

Code: Alles auswählen

message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql);

wer kann mir helfen?

danke zorb!
superfreunde.info

[Markus67]

Hi ...

speichere mal bitte die usercp_register.php als txt-Datei und verlinke sie hier ...
KB:Datei

Markus

[zorb!]

http://www.superfreunde.info/test/usercp_register.txt

[cir0x]

Hai.


ich kenn den mod nicht aber kann das sein dass du n SQL befehl vergessen hast aller

Code: Alles auswählen

INSERT INTO....

oder ähnliches?? kenn das nämlich. bzw prüf deine Variablen ob es auch mit dem Befehl übereinstimmt.

[zorb!]

das ist der mod.

Code: Alles auswählen

################################################################# 
## Mod Title:	Signature Editor/Preview Deluxe ;) 
## Author:	EGO2000 
## Description: This mod adds a really cool Signature Editor to
##		your Board, included Preview & Save & BBCodes
## 
## Installation Level:	Very Easy 
## Installation Time:	2-5 Minutes 
## 
## Files To Edit:   4
##		* profile.php
##		* language/xxx/lang_main.php 
##		* includes/usercp_register.php 
##		* templates/xxx/profil_add_body.tpl 
##           
## Included Files:   2 
##		* includes/usercp_signature.php
##		* templates/xxx/profil_signature.tpl
##
################################################################# 
## Before Adding This MOD To Your Forum, You Should Back Up All 
## Files Related To This MOD 
################################################################# 

# 
#-----[ UPLOAD ]------------------------------------------ 
#
usercp_signature.php => /phpBB/includes
profil_signature.tpl => /phpBB/templates/xxx

# 
#-----[ OPEN ]--------------------------------------------- 
# 
profile.php

#
#-----[ FIND ]---------------------------------------------
#
		include($phpbb_root_path . 'includes/usercp_register.'.$phpEx);
		exit;
	}

# 
#-----[ AFTER, ADD ]-------------------------------------- 
# phpBB 2.0.4 only !!!

	else if ( $mode == 'signature' )
	{
		if ( !$userdata['session_logged_in'] && $mode == 'signature' )
		{
			redirect(append_sid("login.$phpEx?redirect=profile.$phpEx&mode=signature", true));
		}

		include($phpbb_root_path . 'includes/usercp_signature.'.$phpEx);
		exit;
	}

# 
#-----[ AFTER, ADD ]-------------------------------------- 
# phpBB 2.0.x !!!

	else if ( $mode == 'signature' )
	{
		if ( !$userdata['session_logged_in'] && $mode == 'signature' )
		{
			$header_location = ( @preg_match("/Microsoft|WebSTAR|Xitami/", getenv("SERVER_SOFTWARE")) ) ? "Refresh: 0; URL=" : "Location: ";
			header($header_location . append_sid("login.$phpEx?redirect=profile.$phpEx&mode=signature", true));
			exit;
		}

		include($phpbb_root_path . 'includes/usercp_signature.'.$phpEx);
		exit;
	}

# 
#-----[ OPEN ]--------------------------------------------- 
# 
language/lang_english/lang_main.php

#
#-----[ FIND ]---------------------------------------------
#

//
// That's all Folks!
// -------------------------------------------------

?>

# 
#-----[ BEFORE, ADD ]-------------------------------------- 
#
//signature editor
$lang['sig_description'] = "Edit Signature (<b>Preview included</b>)";
$lang['sig_edit'] = "Edit Signature";
$lang['sig_current'] = "Current Signature";
$lang['sig_none'] = "No Signature available";
$lang['sig_save'] = "Save";
$lang['sig_save_message'] = "Signature saved successful !";

# 
#-----[ OPEN ]--------------------------------------------- 
# 
language/lang_german/lang_main.php

#
#-----[ FIND ]---------------------------------------------
#

//
// That's all Folks!
// -------------------------------------------------

?>

# 
#-----[ BEFORE, ADD ]-------------------------------------- 
#
//signature editor
$lang['sig_description'] = "Signatur bearbeiten (<b>inklusive Vorschau</b>)";
$lang['sig_edit'] = "Signatur bearbeiten";
$lang['sig_current'] = "Aktuelle Signatur";
$lang['sig_none'] = "Keine Signatur vorhanden";
$lang['sig_save'] = "Speichern";
$lang['sig_save_message'] = "Signatur erfolgreich gespeichert !";

# 
#-----[ OPEN ]--------------------------------------------- 
# 
includes/usercp_register.php

#
#-----[ FIND ]---------------------------------------------
#
			$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql .

#
#-----[ IN LINE FIND & REMOVE ]---------------------------------------------
#
, user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid'

#
#-----[ FIND ]---------------------------------------------
#
	$template->assign_vars(array(
		'USERNAME' => $username,
		'CUR_PASSWORD' => $cur_password,
		'NEW_PASSWORD' => $new_password,
		'PASSWORD_CONFIRM' => $password_confirm,
		'EMAIL' => $email,
# 
#-----[ AFTER, ADD ]-------------------------------------- 
#
		//signature editor
		'SIG_EDIT_LINK' => append_sid("profile.$phpEx?mode=signature"),
		'SIG_DESC' => $lang['sig_description'],
		'SIG_BUTTON_DESC' => $lang['sig_edit'],
		//signature editor

# 
#-----[ OPEN ]--------------------------------------------- 
# 
templates/xxx/profil_add_body.tpl

#
#-----[ FIND ]---------------------------------------------
#
	<tr> 
	  <td class="row1"><span class="gen">{L_SIGNATURE}:</span><br /><span class="gensmall">{L_SIGNATURE_EXPLAIN}<br /><br />{HTML_STATUS}<br />{BBCODE_STATUS}<br />{SMILIES_STATUS}</span></td>
	  <td class="row2"> 
		<textarea name="signature"style="width: 300px"  rows="6" cols="30" class="post">{SIGNATURE}</textarea>
	  </td>
	</tr>

# 
#-----[ REPLACE WITH ]---------------------------------------
#
	<tr> 
	  <td class="row1"><span class="gen">{SIG_DESC}:</span></span></td>
	  <td class="row2"><INPUT TYPE="button" VALUE="{SIG_BUTTON_DESC}" onclick="window.location.href='{SIG_EDIT_LINK}'"></td>
	</tr>

# 
#-----[ SAVE AND CLOSE ALL FILES ]------------------------------------------ 
#

kannst du mir eventuell ein bisschen deutlicher erklären, was ich prüfen
soll?
danke

[cir0x]

hmmm ich hatte den gleichen felher code weil ich in meiner SQL-Datenbank n befehl vergessen hab zum eingeben.
also hab ich den befehl eingegeben und dann hat es funktioniert.

aber laut beschreibung von dem Mod braucht man keinen Befehl......

[zorb!]

der mod selber läuft auch bestens, nur die aktualisierung des user profils nicht mehr.


meine weiteren problme:
shop mod macht kummer und sorgen

[Markus67]

Hi ...

suche in der usercp_register.php

Code: Alles auswählen

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

ersetze mit:

Code: Alles auswählen

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

Markus

[zorb!]

problem gelöst, DANKE!!!!!!!!!!!