本帖最后由 cjlyr 于 2009-3-11 09:11 编辑
按照说明安装后出现:
MySQL Error
Message: MySQL Query Error
SQL: select u.username,h.uid,h.nongli,( case when `birthmonth`=0 or `birthday`=0 then 99999999 when concat(right(concat(0,`birthmonth`),2),right(concat(0,`birthday`),2))>=0215 then concat(2008,right(concat(0,`birthmonth`),2),right(concat(0,`birthday`),2)) else concat(2009,right(concat(0,`birthmonth`),2),right(concat(0,`birthday`),2)) end ) as days from `home_spacefield` h left join `uc_members` u on u.uid=h.uid where h.nongli>0 order by days limit 0,30
Error: Table 'uchome_s.home_spacefield' doesn't exist
数据表缺失,请恢复备份数据
不知何故!
已经在表`***_spacefield`中添加字段:nongli,类型 tinyint(1) |