Adding Forum gt SQL Error
I installed phpBB with great success, and have added a couple of modifications here and there as well after adding all the forums I'd like displayed on my board. Now, I've tried to go back and add another forum, but suddenly I get this error:
Couldn't insert row in forums 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 'prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delet' at line 1
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, forum_enter_limit prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('26', 'Junior Administrators Only', 3, -1, 'This forum is restricted to Junior Administrators and Administrators only.', 80, 0, 0, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1)
Line : 532
File : admin_forums.php
I looked at admin_forums.php and line 532 is coming up as somewhere around this bit:
//
// Assign the template variables.
//
$template->assign_vars(array(
'FORUM_NAME' => $forum_name,
'L_FORUM' => $lang['Forum'],
'L_FORUM_PRUNE' => $lang['Forum_Prune'],
'L_FORUM_PRUNE_EXPLAIN' => $lang['Forum_Prune_explain'],
'L_DO_PRUNE' => $lang['Do_Prune'],
'S_FORUMPRUNE_ACTION' => append_sid("admin_forum_prune.$phpEx"),
'S_PRUNE_DATA' => $prune_data,
'S_HIDDEN_VARS' => $hidden_input)
);
}
}
//
// Actually output the page here.
//
$template->pparse('body');
include('./page_footer_admin.'.$phpEx);
?>
Your board's URL: http://board.pash-auctions.net
Version of phpBB2: 2.0.22
MODs you have installed: Account Activation, Admin User Notes, Advanced Karma, Banner Rotation, COPPA Notice, Easy Sub-Forums, E-mail Notify on User Ban, E-mail Topic, Flashing PM, Global Announcement, Ignore Avatar, Junior Administrators, Password Protected Forums, Admin Panel Permissions, Quick Reply, Post Limit to Access Forum, Referral Plus, Report System, Avatar Gallery (installed but not working)
I'd appreciate any help I could get The thing is if it's a mod that did this, I have absolutely no clue which one because I never tried adding a forum after installing each mod.
Last edited by ric323 on Wed Jan 02, 2008 10:24 pm, edited 1 time in total.
Reason: Topic icon changed
|
