Ticket #48 (closed 故障: 已处理)

Opened 13 years ago

Last modified 13 years ago

汽车网发贴机的数据问题

Reported by: qinhongyuan Owned by: qinhongyuan
Priority: 次要的（4） Milestone:
Component: 汽车网论坛 Version:
Keywords: 发帖机 汽车网论坛 翻页 Cc: qinhongyuan
Due Date: 29/01/2013

Description

某个人用在修改帖子下看不到翻页调

Change History

comment:1 Changed 13 years ago by qinhongyuan

查：查看后台输出定位问题，由于在pst_topic表插入了数据，但pst_post没有插入到数据，引起该问题
处理：
SELECT * FROM pst_topic a

WHERE a.status = 1 AND a.forumid IN (15820,14674,14505,17448,17458,16765,17115,17602)
AND NOT EXISTS (SELECT 1 FROM pst_post b WHERE a.topicid = b.topicid)

把用户所属的forumid修改一下，运行改脚本即可。
如果有则可以把改数据删掉

comment:2 Changed 13 years ago by qinhongyuan

  • Status changed from new to closed
  • Resolution set to fixed
Note: See TracTickets for help on using tickets.