Unknown column 'display_subforum_list' in 'field list'

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Hovik
Registered User
Posts: 46
Joined: Thu Mar 23, 2006 4:04 pm
Location: Claremont, CA
Contact:

Unknown column 'display_subforum_list' in 'field list'

Post by Hovik »

Hello friends,
I'm getting the following error when trying to edit a forum name in ACP. Any idea's?
When trying to update from 3.0.0 to 3.0.1 there were some errors that occurred when updating the database and it said it probably wouldn't effect anything and just to continue so i did. Maybe this has something to do with that?
Any help will be appreciated.
Cheers

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'display_subforum_list' in 'field list' [1054]

SQL

UPDATE phpbb_forums SET parent_id = 24, forum_type = 1, forum_status = 0, forum_parents = '', forum_name = 'FREE Translation Service', forum_link = '', forum_desc = 'If you have any item that needs translation, please post it here. (See Instructions inside)', forum_desc_uid = '', forum_desc_options = 7, forum_desc_bitfield = '', forum_rules = '', forum_rules_uid = '', forum_rules_options = 7, forum_rules_bitfield = '', forum_rules_link = '', forum_image = '', forum_style = 0, display_subforum_list = 0, display_on_index = 1, forum_topics_per_page = 0, enable_indexing = 1, enable_icons = 0, enable_prune = 0, prune_days = 0, prune_viewed = 0, prune_freq = 0, forum_flags = 34 WHERE forum_id = 22

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1234
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 176
CALL: acp_forums->update_forum_data()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_forums->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
Last edited by stickerboy on Mon Jun 09, 2008 9:24 am, edited 1 time in total.
Reason: Topic icon changed
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51906
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Unknown column 'display_subforum_list' in 'field list'

Post by stevemaury »

Use phpMyAdmin to go to your database. Select the forums table on the left and click the Structure tab on the right. Near the bottom, it will give you an option to Add 1 field. Add it after prune_freq. Its parameters are:

Field = display_subforum_list
Type = tinyint
Length = 1
Attributes = unsigned
Null = not null
Default = 1

Leave everything else blank and click Go.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Hovik
Registered User
Posts: 46
Joined: Thu Mar 23, 2006 4:04 pm
Location: Claremont, CA
Contact:

Re: Unknown column 'display_subforum_list' in 'field list'

Post by Hovik »

stevemaury,

a thousand thank you's, it worked like a charm!

Hovik
Locked

Return to “[3.0.x] Support Forum”