LZ,感谢分享!我的宠物系统出现问题了,按照全新安装步骤做,并修改了个人资料显示宠物信息,点击用户信息后出现如下错误提示:
Discuz! info: MySQL Query Error
User: yunings
Time: 2006-2-24 1:43pm
Script: /sc_gbk/viewpro.php
SQL: SELECT m.*, mf.*,b.mypetname,b.mypet,b.mypetlevel,b.mypetdead,b.openpk,b.mypethp,b.mypetsp,b.mypetexp,b.mypetsex,b.mypetsx,b.mypetnowmaxhp,b.mypetnowmaxsp,b.petep,b.spf,b.hpf,b.petnowexp,b.petnextlvexp
, u.grouptitle, u.type, u.creditshigher, u.creditslower, u.readaccess,
u.color AS groupcolor, u.stars AS groupstars, u.allownickname, u.allowuseblog, r.ranktitle,
r.color AS rankcolor, r.stars AS rankstars , o.thismonth AS thismonthol, o.total AS totalol
FROM cdb_members m
LEFT JOIN cdb_memberfields mf ON mf.uid=m.uidLEFT JOIN cdb_mypetdata b ON b.username=m.username
LEFT JOIN cdb_usergroups u ON u.groupid=m.groupid
LEFT JOIN cdb_ranks r ON m.posts>=r.postshigher
LEFT JOIN cdb_onlinetime o ON o.uid=m.uid
WHERE m.uid='2'ORDER BY r.postshigher DESC LIMIT 1
Error: Unknown column 'm.uidLEFT' in 'on clause'
程序文件跟数据库有冲突,请使用正确的程序文件上传上去覆盖
Similar error report has beed dispatched to administrator before.
不知何解?帮帮忙,我非常想要这个宠物系统,其他的功能都能正常显示。 |