Fout melding na instaleren group icons mod

[PaulusB]

Ik heb de group icons mod geinstaleerd alleen krijg deze melding als mensen zich willen registreren zover werkt de mod goed.

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_reg_ip, user_reg_host,user_id, username, user_regdate, user_password, user_email, user_birthday, user_icq, user_website, user_occ, user_from, user_interests, user_profile_view_popup, user_name_first, user_name_last, 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_email_new_gb, user_timezone, user_dateformat, user_lang, user_style, user_gender, user_level, user_allow_pm, user_active, user_actkey) VALUES ( '82.170.14.73', '82-170-14-73.dsl.ip.tiscali.nl',132, 'test23', 1162328010, '098f6bcd4621d373cade4e832627b4f6', 'p-beijer@hotmail.com', 02131981, '', '', '', '', '', 0, 'test', 'test', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'D M d, Y G:i', 'dutch', 3, '0', 0, 1, 0, 'da3ed11ff76c0a')

Line : 825
File : usercp_register.php

in usercp_register.php nou heb ik daar voor die mod dus dit toegevoegt maar wat is er fout

Code: Selecteer alles

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

#
#-----[ FIND ]------------------------------------------
#
$allowsmilies = ( isset($HTTP_POST_VARS['allowsmilies']) ) ? ( ($HTTP_POST_VARS['allowsmilies']) ? TRUE : 0 ) : $board_config['allow_smilies'];

#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Group Icons MOD - Start
//
$showgroupicons = ( isset($HTTP_POST_VARS['showgroupicons']) ) ? ( ($HTTP_POST_VARS['showgroupicons']) ? TRUE : 0 ) : TRUE;
//
// Group Icons MOD - End
//

#
#-----[ FIND ]------------------------------------------
#
$allowsmilies = ( isset($HTTP_POST_VARS['allowsmilies']) ) ? ( ($HTTP_POST_VARS['allowsmilies']) ? TRUE : 0 ) : $userdata['user_allowsmile'];

#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Group Icons MOD - Start
//
$showgroupicons = ( isset($HTTP_POST_VARS['showgroupicons']) ) ? ( ($HTTP_POST_VARS['showgroupicons']) ? TRUE : 0 ) : $userdata['user_showgroupicons'];
//
// Group Icons MOD - End
//

#
#-----[ FIND ]------------------------------------------
#
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."',

#
#-----[ IN-LINE FIND ]------------------------------------------
#
user_allowhtml = $allowhtml

#
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------
#
user_showgroupicons = $showgroupicons, 

#
#-----[ FIND ]------------------------------------------
#
$sql = "INSERT INTO " . USERS_TABLE . "	(user_id, username, user_regdate, user_password

#
#-----[ IN-LINE FIND ]------------------------------------------
#
user_allowhtml

#
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------
#
user_showgroupicons, 

#
#-----[ FIND ]------------------------------------------
#
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password)

#
#-----[ IN-LINE FIND ]------------------------------------------
#
$allowhtml

#
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------
#
$showgroupicons, 

#
#-----[ FIND ]------------------------------------------
#
$allowsmilies = $userdata['user_allowsmile'];

#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Group Icons MOD - Start
//
$showgroupicons = $userdata['user_showgroupicons'];
//
// Group Icons MOD - End
//

#
#-----[ FIND ]------------------------------------------
#
display_avatar_gallery($mode, $avatar_category, $user_id, $email,

#
#-----[ IN-LINE FIND ]------------------------------------------
#
$allowviewonline

#
#-----[ IN-LINE BEFORE, ADD ]------------------------------------------
#
$showgroupicons, 

#
#-----[ FIND ]------------------------------------------
#
'ALLOW_AVATAR' => $board_config['allow_avatar_upload'],

#
#-----[ BEFORE, ADD ]------------------------------------------
#
//
// Group Icons MOD - Start
//
'SHOW_GROUP_ICONS_YES' => ( $showgroupicons ) ? 'checked="checked"' : '',
'SHOW_GROUP_ICONS_NO' => ( !$showgroupicons ) ? 'checked="checked"' : '',
//
// Group Icons MOD - End
//

#
#-----[ FIND ]------------------------------------------
#
'L_ALWAYS_ADD_SIGNATURE' => $lang['Always_add_sig'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
//
// Group Icons MOD - Start
//
'L_SHOW_GROUP_ICONS' => $lang['Show_group_icons'],
//
// Group Icons MOD - End
//

Hier bij de file http://www.tt-forum.nl/garage/usercp_register.txt

[PaulusB]

Opgelost

:thumb: