Individual posts per page

SQL Error when chaing post number in UCP - Individual posts per page

SQL Error when chaing post number in UCP

by sysz » Fri Feb 06, 2015 9:30 pm

When trying to change the number of topics and thread shown via UCP => Board Preferences => Edit display options i get an sql error. What does it mean?

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

UPDATE phpbb_users SET user_options = '230271', user_topic_sortby_type = 't', user_post_sortby_type = 't', user_topic_sortby_dir = 'd', user_post_sortby_dir = 'a', user_topic_show_days = 0, user_post_show_days = 0, user_topics_per_page = 10, user_posts_per_page = 10, S_SCL_UCP_ENABLED = NULL, S_SNOW_UCP_ENABLED = NULL, user_similar_topics = 1, user_topic_preview = 1 WHERE user_id = 2

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/ucp/ucp_prefs.php
LINE: 316
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: ucp_prefs->main()

FILE: [ROOT]/ucp.php
LINE: 369
CALL: p_master->load_active()
Currently working on the community
User avatar
sysz
Registered User
Posts: 278
Joined: Mon Jan 30, 2012 11:36 pm
Location: Sweden, Helsingborg
Name: Kimmy Lindell Ekström
Contact:

Re: SQL Error when chaing post number in UCP

by divingbrit » Sat Feb 07, 2015 9:55 am

I get the same result , so what ever you have done so have I
Shy but working at it
divingbrit
Registered User
Posts: 86
Joined: Fri Mar 21, 2003 3:18 pm
Contact:

Re: SQL Error when chaing post number in UCP

by Elsensee » Wed Feb 18, 2015 11:08 pm

Hm okay... I guess you both have the Snowstorm & Lights extension installed. Does the error still occur when my extension is disabled and you want to change something in display settings?
Development Team Member
I don't make bugs - I make features
User avatar
Elsensee
Former Team Member
Posts: 122
Joined: Sat May 07, 2011 11:04 am
Location: Hamburg, Germany
Name: Oliver Schramm
Contact:

Re: SQL Error when chaing post number in UCP

by sysz » Sat Feb 28, 2015 8:23 am

Yes that seems to be the problem, it works fine now.
Will there perhaps be an fix in next version?
Currently working on the community
User avatar
sysz
Registered User
Posts: 278
Joined: Mon Jan 30, 2012 11:36 pm
Location: Sweden, Helsingborg
Name: Kimmy Lindell Ekström
Contact:

Re: SQL Error when chaing post number in UCP

by Elsensee » Sat Feb 28, 2015 6:29 pm

I can't do anything here. You must ask the author of the Snowstorm & Lights extension.
But I sent him a pull request on GitHub - you can see the changes here. :) ;)
Development Team Member
I don't make bugs - I make features
User avatar
Elsensee
Former Team Member
Posts: 122
Joined: Sat May 07, 2011 11:04 am
Location: Hamburg, Germany
Name: Oliver Schramm
Contact: