TerraFrost wrote: This post explains what's happening and what you can do to fix it :
http://www.phpbb.com/community/viewtopi ... 5&t=527421
Code: Select all
if ( !$board_config['bday_lock'] || $userdata['user_birthday'] == 0 )
{
$block = ( $board_config['bday_require'] == TRUE ) ? 'birthday_required' : 'birthday_optional';
$template->assign_block_vars($block, array());
$template->birthday_interface();
}
Fatal error: Call to undefined function: birthday_interface() in /home/content/v/f/l/vfleming/html/forum/includes/usercp_register.php on line 1260
Code: Select all
if ( !$board_config['bday_lock'] || $userdata['user_birthday'] == 0 )
{
$block = ( $board_config['bday_require'] == TRUE ) ? 'birthday_required' : 'birthday_optional';
$template->assign_block_vars($block, array());
$template->birthday_interface();
}
Hello,
I have tried signing up for the forums three times, but each time I receive
a "general error". Can you assist me please? Full error message as
follows:
Could not insert data into users table
DEBUG MODE
SQL Error : 1048 Column 'birthday_display' cannot be null
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password,
user_email, user_birthday2, birthday_display, birthday_greeting,
user_birthday, user_kids_birthday, user_kids2_birthday, user_kids_name,
user_kids2_name, user_icq, user_regip, user_website, user_occ, user_from,
user_interests, user_custom_title, user_sig, user_sig_bbcode_uid,
user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim,
user_msnm, user_attachsig, user_allowsmile, user_showavatars,
user_showsignatures, 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 (868, 'wildflower',
1174730493, '247184f5fcf8c0afea1291676dc6df8f',
'[email protected]', 01011973, NULL, 3, 0, 00000000, 00000000, '',
'', '', '3ba759bf', '', '', 'Melbourne', '', '', '', '', '', 0, 0, '', '',
'', 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 10, 'D M d, Y g:i a', 'english', 18, 0, 1,
0, '15488a')
Line : 837
File : usercp_register.php
Code: Select all
<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
<tr>
<td class="catHead" colspan="2" height="28"><table width="100%">
<tr>
<td width="50%" align="left"><span class="cattitle"><a href="{U_VIEWONLINE}" class="cattitle">{L_WHO_IS_ONLINE}</a></span></td>
<td width="50%" align="right"><span class="cattitle"><a href="{U_MARK_READ}" class="cattitle">{L_MARK_FORUMS_READ}</a></span></td>
</tr>
</table></td>
</tr>
<tr>
<td class="row1" align="left" colspan="2"><span class="gensmall">{TOTAL_USERS_ONLINE} [ {L_WHOSONLINE_ADMIN} ] [ {L_WHOSONLINE_MOD} ]<br />{RECORD_USERS}<br />{LOGGED_IN_USER_LIST}<br />{L_ONLINE_EXPLAIN}</span></td>
</tr>
<!-- BEGIN birthdays -->
<tr>
<td class="catHead" colspan="2" height="28"><span class="cattitle">{L_TODAYS_BIRTHDAYS}</span></td>
</tr>
<tr>
<td class="row1" align="center" valign="middle"><img src="templates/subSilver/images/icon_birthday.gif" alt="{L_VIEW_BIRTHDAYS}" /></td>
<td class="row1" align="left" width="100%">
<span class="gensmall">{BIRTHDAYS}
<!-- BEGIN upcoming -->
<br />{UPCOMING}
<!-- END upcoming -->
</span>
</td>
</tr>
<!-- END birthdays -->
<tr>
<td class="catHead" colspan="2" height="28"><span class="cattitle">Chat Room</span></td>
<!-- BEGIN switch_user_logged_out -->
[ {L_LOGIN_TO_JOIN_CHAT} ]
<!-- END switch_user_logged_out -->
<!-- BEGIN switch_user_logged_in -->
[ <a href="javascript:void(0);" onClick="window.open('{S_JOIN_CHAT}','{CHATBOX_NAME}','scrollbars=no,width=540,height=450')">{L_CLICK_TO_JOIN_CHAT}</a> ]
<!-- END switch_user_logged_in -->
<br />{CHATTERS_LIST}
</span>
</td>
</tr>
<tr>
<td class="catHead" colspan="3" height="28"><span class="cattitle">Board Statistics - Forum Legend</span></td>
</tr>
<tr>
<td class="row2" align="left"><span class="gensmall">{TOTAL_POSTS}<br />{TOTAL_USERS}<br />{NEWEST_USER}</span></td>
<td class="row1" align="right"><table cellspacing="3" border="0" align="center" cellpadding="0">
<tr>
<td width="20" align="center"><img src="templates/SoftBlue/images/folder_new_big.gif" alt="{L_NEW_POSTS}"/></td>
<td><span class="gensmall">{L_NEW_POSTS}</span></td>
<td> </td>
<td width="20" align="center"><img src="templates/SoftBlue/images/folder_big.gif" alt="{L_NO_NEW_POSTS}" /></td>
<td><span class="gensmall">{L_NO_NEW_POSTS}</span></td>
<td> </td>
<td width="20" align="center"><img src="templates/SoftBlue/images/folder_locked_big.gif" alt="{L_FORUM_LOCKED}" /></td>
<td><span class="gensmall">{L_FORUM_LOCKED}</span></td>
</tr>
</table>
</td>
</tr>
</table>
<!-- Begin: Top Posters on Index -->
<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
<tr>
<td class="catHead" align ="left" colspan="2" nowrap="nowrap"><span class="genmed"><b>{L_TOP_POSTERS}</b></td>
</tr>
<tr>
<td class="row1" align="left" valign="middle" width="100%"><span class="genmed">{TOP_POSTERS}</span></td>
</tr>
</table>
<!-- End: Top Posters on Index -->
</div>
<br clear="all" />
Code: Select all
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password,
user_email, user_birthday2, birthday_display, birthday_greeting,
user_birthday,
Code: Select all
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password,
user_email, user_birthday, user_birthday2, birthday_display, birthday_greeting,
Code: Select all
<!-- BEGIN birthdays -->
<tr>
<td class="catHead" colspan="2" height="28"><span class="cattitle">{L_TODAYS_BIRTHDAYS}</span></td>
</tr>
<tr>
<td class="row1" align="center" valign="middle"><img src="templates/subSilver/images/icon_birthday.gif" alt="{L_VIEW_BIRTHDAYS}" /></td>
<td class="row1" align="left" width="100%">
<span class="gensmall">{BIRTHDAYS}
<!-- BEGIN upcoming -->
<br />{UPCOMING}
<!-- END upcoming -->
</span>
</td>
</tr>
<!-- END birthdays -->
Code: Select all
<!-- BEGIN birthdays -->
<tr>
<td class="catHead" colspan="2" height="28"><span class="cattitle">{L_TODAYS_BIRTHDAYS}</span></td>
</tr>
<tr>
<td class="row1" colspan="2"><table cellpadding="0" cellspacing="0" border="0">
<tr>
<td align="center" valign="middle" style="padding-right: 3px"><img src="templates/subSilver/images/icon_birthday.gif" alt="{L_VIEW_BIRTHDAYS}" /></td>
<td align="left" width="100%">
<span class="gensmall">{BIRTHDAYS}
<!-- BEGIN upcoming -->
<br />{UPCOMING}
<!-- END upcoming -->
</span>
</td>
</tr>
</table></td>
</tr>
<!-- END birthdays -->