缺少一个字段?
【 在 roctall (蛇王阿奔) 的大作中提到: 】
: 直接找出相应sql语句在mysql里查询
: mysql> SELECT nodes.uid , nid , subject
: -> FROM nodes use index(visitcount) ,users
: -> WHERE access = 0
: -> AND nodes.uid = users.uid
: -> AND nodetype = 0
: -> AND pctype < 4
: -> GROUP BY uid
: -> ORDER BY nodes.visitcount DESC
: -> LIMIT 0 ,10;
: ERROR 1072: Key column 'visitcount' doesn't exist in table
: 最后的错误信息不是太明白,没创建什么么?
--
FROM 218.28.14.*