Get Error when Try Change My board style

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Lamer4o
Registered User
Posts: 98
Joined: Tue Dec 22, 2009 9:29 pm

Get Error when Try Change My board style

Post by Lamer4o »

Hello to all i got a General error when i try to change My board style in my user profile i don't know When or How i got this error but i need help fast to change it..

Code: Select all

General Error
SQL ERROR [ mysqli ]

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

SQL

UPDATE phpbb_users SET user_allow_pm = 1, user_allow_viewemail = 1, user_allow_massemail = 1, user_allow_viewonline = 1, user_notify_type = '0', user_notify_pm = 1, user_options = '231295', user_dst = 0, user_dateformat = 'D M d, Y g:i a', user_lang = 'en', user_timezone = 0, user_style = 4, allow_all_comment = 0, allow_friend_only = 0, allow_friend_view = 0, allow_comment_email = 0 WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_prefs.php
LINE: 108
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 519
CALL: ucp_prefs->main()

FILE: ucp.php
LINE: 321
CALL: p_master->load_active()
This is the Error Help me fast!
User avatar
battye
Extension Customisations
Extension Customisations
Posts: 10965
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: Get Error when Try Change My board style

Post by battye »

There is no 'allow_all_comment' column in the users table for a default phpBB3 installation, so chances are you are getting this as a result of a MOD install gone awry.

Have you recently tried to install a MOD? By any chance did you try and then give up? It might be the case that you left some code behind, or you forgot to run the appropriate SQL query to install the MOD fully.
Customisations Team Member

https://github.com/battye/php-array-parser - Give it a Star! :D
Lamer4o
Registered User
Posts: 98
Joined: Tue Dec 22, 2009 9:29 pm

Re: Get Error when Try Change My board style

Post by Lamer4o »

i try to install the mod Simple Profile Comments But i get errors (whit Automod) and leave it that way (i didn't think the code will stick when it was not install so what i have to do now?
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51554
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Get Error when Try Change My board style

Post by stevemaury »

Replace the files you edited with unmodded versions.
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)
Lamer4o
Registered User
Posts: 98
Joined: Tue Dec 22, 2009 9:29 pm

Re: Get Error when Try Change My board style

Post by Lamer4o »

stevemaury wrote:Replace the files you edited with unmodded versions.
So now i have to Read the Install.xhtml and remove all the change's on Hand... :S
Locked

Return to “[3.0.x] Support Forum”