phpBB.de

Code: Alles auswählen

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 '/-- fin mod : Advanced Group Color Management -----------------

UPDATE phpbb_users SET user_email = '', user_icq = '300275898', user_website = 'http://sockel0815.12m.de', user_occ = '', user_from = 'test2', user_interests = '', user_sig = 'Computer helfen uns Probleme zu lösen, die wir ohne sie garnicht hätten.', user_sig_bbcode_uid = '88b3b3ac10', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = 'sockel0815@gmx.de', 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 M Y h:i a', user_group_id = '', user_lang = 'german', user_style = 1, user_active = 1, user_actkey = '' //-- fin mod : Advanced Group Color Management --------------------------------- WHERE user_id = 4

Line : 530
File : usercp_register.php

Code: Alles auswählen

//-- mod : Advanced Group Color Management -------------------------------------
// here we added
//	 user_group_id = '$user_group_id',
//-- modify
			$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_group_id = '$user_group_id', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "
//-- fin mod : Advanced Group Color Management ---------------------------------
				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']);