phpBB.nl

Code: Selecteer alles

############################################################## 
## MOD Title:          Birthday 
## MOD Author:         Niels < ncr@db9.dk > (Niels Chr. Rød) http://mods.db9.dk 
## MOD Description:    This mod will add a birthday field into your
##                     user's profile and make users age viewable
##                     to others when viewing posts.
## MOD Version:        1.5.8

Code: Selecteer alles

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'user_sig = '', user_sig_bbcode_uid = '', user_viewemail = , user_aim = '', user_' at line 2

UPDATE phpbb_users SET user_email = '', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_birthday = '999999', user_next_birthday_greeting = '' user_sig = '', user_sig_bbcode_uid = '', user_viewemail = , user_aim = '', user_yim = '', user_msnm = '', user_skype = '', 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_active = 1, user_actkey = '' WHERE user_id = 

Line : 657
File : usercp_register.php 

Code: Selecteer alles

Could not insert data into users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near '0, '06fc8004e8f')' 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_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_skype, 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 (249, '', 1144015800, '', '', '', '', '', '', '', user_birthday = '999999', user_next_birthday_greeting = '' '', '', '', 0, 0, '', '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'dutch', 1, 0, 1, '999999', '' 0, '06fc8004e8f')

Line : 781
File : usercp_register.php

Code: Selecteer alles

Apparently the whole data that your forum tries to save is absolutely empty, times are on 999999, the rest on '' (empty string) or NULL/nothing. There has not even the user_id of the profile that should be updated been transmitted, so it can't find the data set that is supposed to be updated. 

Code: Selecteer alles

,

Code: Selecteer alles

user_next_birthday_greeting = ''

Code: Selecteer alles

user_next_birthday_greeting = '',

Code: Selecteer alles

,

Code: Selecteer alles

$user_active

Code: Selecteer alles

$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_skype = '" . str_replace("\'", "''", $skype) . "', 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";
			if ( !($result = $db->sql_query($sql)) )

Code: Selecteer alles

$user_active,

Code: Selecteer alles

user_next_birthday_greeting ='',

Code: Selecteer alles

Geboortedatum 01 Jan 2007 12:00 am 01 Jan 2007 12:00 am Cookies 
Gefeliciteerd! Cookies 

Code: Selecteer alles

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 ''-2110', '', user_email = 'mijn@adres.nl', user_

UPDATE phpbb_users SET user_password = '6512bd43d9caa6e02c990b0a82652dca', '-2110', '', user_email = 'mijn@adres.nl', user_icq = '', user_website = 'http://mijn.homepage.nl', user_occ = '', user_from = 'Helmond', user_interests = 'Wielrennen, Beagle, Formule 1, Pc`s en alles wat daarbij hoort, en nog veel meer', user_birthday = '-2110', user_next_birthday_greeting = '2007', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 2, user_dateformat = 'l, d F Y, H:i', user_lang = 'dutch', user_style = 2, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 589
File : usercp_register.php

Code: Selecteer alles

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