php - phpBB 上的 SQL 错误

Question

尝试更新 ucp 中的配置文件时出现此错误

SQL ERROR [ mysql4 ]

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

SQL

UPDATE phpbb_users SET user_icq = '', user_aim = '', user_msnm = '', user_yim = '', user_jabber = '', user_website = 'http://footballbb.org', user_from = '', user_occ = '', user_interests = '', user_notify_type = '0', see_porn_cat = NULL, user_custom_title = 'U JELLY?' WHERE user_id = 9086

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_profile.php
LINE: 423
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_profile->main()

FILE: ucp.php
LINE: 327
CALL: p_master->load_active()

我过去在那里做了一些更改，但我确信我删除了数据库和与我所做的更改相关的代码。您能告诉我在哪里查找与该错误相关的任何内容吗？ :滚动:

Answer 1

此表不包含列see_porn_cat

所以你需要使用这个查询

UPDATE phpbb_users SET user_icq = '', user_aim = '', user_msnm = '', user_yim = '', user_jabber = '', user_website = 'http://footballbb.org', user_from = '', user_occ = '', user_interests = '', user_notify_type = '0', user_custom_title = 'U JELLY?' WHERE user_id = 9086