Error in Managing Forums

[niks999]

Hi,

I'm on phpBB 3.0.1....

When I try to change anything of the forums like name, description etc i.e ACP-->Forums-->Manage Forums

I get this error :

Code: Select all

General Error
SQL ERROR [ mysql4 ]

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

SQL

UPDATE phpbb_forums SET parent_id = 61, forum_type = 1, forum_status = 0, forum_parents = '', forum_name = 'News & Announcements', forum_link = '', forum_desc = 'Get all the latest news about NixBoxLive.....!!!!!!!', 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 = 1

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()

What should I do ??

[karlsemple]

How did you update to phpBB 3.0.1? Try uploading the install folder again and running the install/database_update.php

[PYBBus]

I recently switched from Windows Hosting to Linux Hosting. Started on the evening of 05/02/08. During the switch, I ended up loosing the whole forum and had to do a complete new install. The new install also included having the files from the update of 3.0.0 to 3.0.1 already uncompressed.

I could not get the new forum to read any of the backedupped database files. To do the install I could do nothing but create a new database, which was done anyway through the switch from windows to Linux.

To finally get the forum working, I manually renamed all the old back upfiles with the prefix of the new database. This worked fine until I did it with the config file and the board was lost again. Went through the process again and left the config file alone but changed all the others. The forum was restored and works properly other than the above mentioned error with basically the same scenario.

I downloaded the update package again and went through the "Install" instructions. Was instructed that my forum was up to date, but it would check for file compatibility anyway.

I have 81 of 141 files with differences. There was nothing that stated the files were fixed and the forum still receives the above mentioned error when "Submitting" after editing a forum. I repeated the update install process to get the exact number of mismatched files.

Is there a simple solution to fixing this without loosing the forum for another 36 hours?

[PYBBus]

I have it where it now says "All files are up to date, please log in...." However, I still receive the same error when trying to edit any forum.

Please help.

[PYBBus]

I went through and created a dummy board and started renaming an imported database as I have done to restore my forum from windows to Linux Switch.

I checked for the error after each rename and did not receive this error until I renamed "forums"

Hope this helps.

[PYBBus]

I have figured out where and why the error is originating. I just don't know how to fix it. Below find a picture of the error. The copy of the datase Sm_PYB01 which has working managable forums.

And, a picture of database Sm_PYB which does not have working managable forums. All I need is the working code and told where to place it.

I can't get the pictures to upload any clearer. Basically, the working forum has a script of "display_subforum_list" and the non working forum does not have this script. Somewhere the script is lost in the renaming of the database. Example: to restore the lost forum, I have to rename newphpBBForums to PYB forums. When I do this, I get the forums to show on the board, but loose control of managing the forums.

When I first install the forum, I can manage and edit forums, I just don't have any to manage other than the original "My first forum."

[PYBBus]

Another thought, if I could be directed as to where to download the latest version of phpBB 3.0.0 without the upgrade to 3.0.1 The board was originally installed on Mar 10,2008 with 3.0.0 and if I reinvent a board with 3.0.0, copy the forum files to this board, run the upgrade, then the files should have the missing script inserted into them.

[PYBBus]

The board I was using can be found here: http://www.php.net/downloads.php

To fix the error. Uploaded above file. Installed the forum. Had it read existing database files. Ran the upgrade. Everything works fine. Thanks Everybody.