Ticket #219 (closed 用户报障: 已处理)

Opened 12 years ago

Last modified 12 years ago

家居网“备用”版块（fid=9）的子版没有显示

Reported by: chenguohao Owned by: dingjianyong
Priority: 重要的（3） Milestone:
Component: 家居网论坛 Version:
Keywords: Cc:
Due Date: 23/12/2013

Description

“备用”版块（fid=9）的子版没有显示；

Change History

comment:1 Changed 12 years ago by chenguohao

  • Owner changed from sunxiang to dingjianyong
  • Status changed from new to assigned

comment:2 Changed 12 years ago by dingjianyong

  • Status changed from assigned to closed
  • Resolution set to 已处理

找DBA查看forum表数据，发现数据出现问题，fid=9的表是有子版的，但是haschildren字段为0，导致了在版块树中没有显示出来。（因为版块树的逻辑是判断haschildren=1才会读取子版的）

新建版块测试，发现不会出现此问题，此问题应该是旧数据引起的。
执行以下sql，解决此问题
update bbs7_forum set haschildren=1 where fid=9

Note: See TracTickets for help on using tickets.