phpBB.nl

Code: Selecteer alles

 
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 ' user_birthday, user_next_birthday_greeting VALUES (32, 'St

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_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_active, user_actkey), user_birthday, user_next_birthday_greeting VALUES (32, 'Stargirl', 1090493478, 'fd7cd77a13f02953e1146991eb0983ba', 'stargirl@hotmail.com', '', '', '', '', '', 'Geen enkele ster is zo mooi als Mijn Ster!', '8582c0ee41', '', 0, 0, '', '', 'stargirl@hotmail.com', 1, 1, 0, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'dutch', 2, 0, 1, , '4952', '2004' 1, '')

Line : 598
File : /home/dreambutterfly.nl/1565/phpBB2/includes/usercp_register.php 
  

Code: Selecteer alles

#
#-----[ FIND ]------------------------------------------------
#
# NOTICE - IMPORTENT SECURITY RISK
#
# If you some how do not preform the following VERY carefully you have the
# potential to compromise your forum SECURITY, your users may easyly get ADMIN access if you make mistake
# meny users do make mistake in the step, so please be very exact, if this fail, then do not run your code on live forum
#
			$sql = "INSERT INTO " . USERS_TABLE . "

#
#-----[ IN-LINE FIND ]----------------------------------------
#
, user_active, user_actkey)

#
#-----[ IN-LINE BEFORE, ADD ]---------------------------------
#
, user_birthday, user_next_birthday_greeting

Code: Selecteer alles

Could not insert data into users table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

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_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_active, user_actkey) VALUES (36, 'Annouska', 1090578190, 'a9d74d4018e45143163dde57e6a26815', 'annouskamiddelhoek@hotmail.com', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 2, 'D M d, Y g:i a', 'dutch', 2, 0, 1, '999999', '', 1, '')

Line : 598
File : /home/dreambutterfly.nl/1565/phpBB2/includes/usercp_register.php