phpBB • Free and Open Source Forum Software

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

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

I get the same result , so what ever you have done so have I

Elsensee · 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?

sysz · 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?

Elsensee · 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.

Individual posts per page

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

advertisements