Error in Managing Forums

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
niks999
Registered User
Posts: 29
Joined: Wed Apr 11, 2007 8:31 am

Error in Managing Forums

Post by 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 ??
User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: Error in Managing Forums

Post by karlsemple »

How did you update to phpBB 3.0.1? Try uploading the install folder again and running the install/database_update.php
Image
PYBBus
Registered User
Posts: 29
Joined: Fri Mar 21, 2008 7:29 pm

Re: Error in Managing Forums

Post by 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?
Building an Environment for Successful Entrepreneurship! If you are looking at having your legit opportunity hosted, or want to keep from ever being scammed
again, come visit us at http://www.proveyourbusiness.com, or visit our forum at http://proveyourbusiness.com/Board/index.php.
PYBBus
Registered User
Posts: 29
Joined: Fri Mar 21, 2008 7:29 pm

Re: Error in Managing Forums

Post by 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.
Building an Environment for Successful Entrepreneurship! If you are looking at having your legit opportunity hosted, or want to keep from ever being scammed
again, come visit us at http://www.proveyourbusiness.com, or visit our forum at http://proveyourbusiness.com/Board/index.php.
PYBBus
Registered User
Posts: 29
Joined: Fri Mar 21, 2008 7:29 pm

Re: Error in Managing Forums

Post by 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.
Building an Environment for Successful Entrepreneurship! If you are looking at having your legit opportunity hosted, or want to keep from ever being scammed
again, come visit us at http://www.proveyourbusiness.com, or visit our forum at http://proveyourbusiness.com/Board/index.php.
PYBBus
Registered User
Posts: 29
Joined: Fri Mar 21, 2008 7:29 pm

Re: Error in Managing Forums

Post by 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."
Attachments
General error that I am receiving after switch from Windows to Linux
General error that I am receiving after switch from Windows to Linux
General error.JPG (35.02 KiB) Viewed 142 times
not working forum that really needs to work  32 1 1 1 0
not working forum that really needs to work 32 1 1 1 0
not working PYB database.JPG (32.01 KiB) Viewed 139 times
working forum  32 1 1 1 1
working forum 32 1 1 1 1
working PYB01 database.JPG (33.91 KiB) Viewed 143 times
Building an Environment for Successful Entrepreneurship! If you are looking at having your legit opportunity hosted, or want to keep from ever being scammed
again, come visit us at http://www.proveyourbusiness.com, or visit our forum at http://proveyourbusiness.com/Board/index.php.
PYBBus
Registered User
Posts: 29
Joined: Fri Mar 21, 2008 7:29 pm

Re: Error in Managing Forums

Post by 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.
Building an Environment for Successful Entrepreneurship! If you are looking at having your legit opportunity hosted, or want to keep from ever being scammed
again, come visit us at http://www.proveyourbusiness.com, or visit our forum at http://proveyourbusiness.com/Board/index.php.
PYBBus
Registered User
Posts: 29
Joined: Fri Mar 21, 2008 7:29 pm

Re: Error in Managing Forums

Post by 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.
Building an Environment for Successful Entrepreneurship! If you are looking at having your legit opportunity hosted, or want to keep from ever being scammed
again, come visit us at http://www.proveyourbusiness.com, or visit our forum at http://proveyourbusiness.com/Board/index.php.
Locked

Return to “[3.0.x] Support Forum”