- SupeSite info: MySQL Query Error
- User: Guest
- Time: 2009-1-10 6:40pm
- Script: /xp/index.php
- SQL: SELECT t.tid, t.subject, t.fid, t.views, t.replies, t.dateline, t.lastpost FROM `[Table]threads` t WHERE t.blog='1' AND t.authorid='1' AND t.displayorder>=0 ORDER BY t.tid DESC LIMIT 0,10
- Error: Unknown column 't.blog' in 'where clause'
- Errno.: 1054
复制代码 登陆 http://lixq.cn/xp/?1/ 时候发现
执行- ALTER TABLE lixq_threads ADD COLUMN blog tinyint(1) NOT NULL DEFAULT '0'
复制代码 后运行正常 |