phpBB 上的 SQL 错误
当尝试更新 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()
我过去在那里进行了一些更改，但我确信我删除了数据库以及与我所做的更改相关的代码。 您能告诉我在哪里查找与该错误相关的任何内容吗？ ：卷：
I get this error when trying to update the profile in 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()
I have made some changes there in the past,but I'm sure that I removed the database and the code that's related to the changes I made.
Can you tell me where to look for anything related to that error ? :roll:
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
该表不包含
see_porn_cat列，因此您需要使用此查询
This table does not contain the column
see_porn_catSo you need to use this query