勋章中心 For 5.0正式版[增加演示]

Warning: mysql_query() [function.mysql-query]: Unable to save result set in D:\Discuz\include\db_mysql.class.php on line 65

Discuz! info: MySQL Query Error

User: zhangda745
Time: 2006-10-25 9:51pm
Script: /sellmedal.php

SQL: SELECT u.grouptitle,m.username,mf.uid,mf.medals,mf.last AS time FROM cdb_memberfields mf
LEFT JOIN cdb_members m ON mf.uid=m.uid
LEFT JOIN cdb_usergroups u ON u.groupid=m.groupid WHERE mf.medals!=''
Error: Table 'mf' is marked as crashed and should be repaired
Errno.: 1194

Similar error report has beed dispatched to administrator before.

希望高手解决，谢谢！

menu.inc.php那里找?

admin目录下找menu.inc.php

原帖由 zhangda7455 于 2006-10-31 03:20 发表
Warning: mysql_query() : Unable to save result set in D:\Discuz\include\db_mysql.class.php on line 65

Discuz! info: MySQL Query Error

User: zhangda745
Time: 2006-10-25 9:51pm
Script: /sel ...

修改不对～～～

打开cache.func.php

  ——哪里找？谢谢了！

Time: 2006-11-10 5:09pm
Script: /bbs/admincp.php

SQL: UPDATE `cdb_medals` SET `s1`='10000',`r1`='10000',`s2`='10000',`r2`='10000',
`s3`='10000',`r3`='10000',`s4`='',`r4`='',`s5`='',`r5`='',
`s6`='',`r6`='',`s7`='',`r7`='',`s8`='',`r8`='',
`post`='10000',`thread`='10000',`reply`='10000',`credit`='10000',`online`='10000',
`digest`='10000',`regday`='10000',`pageview`='10000',`admin`='1',
`use`='1',`rest`='100' WHERE medalid='1'
Error: Unknown column 's1' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

这是什么问题？

完全按照楼主的方法再次检查修改所有文件，全部正确无误，但是点击“查看该勋章的会员”还是不行
Warning: mysql_query() [function.mysql-query]: Unable to save result set in D:\Discuz\include\db_mysql.class.php on line 65

Discuz! info: MySQL Query Error

User: zhangda745
Time: 2006-11-15 2:20am
Script: /sellmedal.php

SQL: SELECT u.grouptitle,m.username,mf.uid,mf.medals,mf.last AS time FROM cdb_memberfields mf
LEFT JOIN cdb_members m ON mf.uid=m.uid
LEFT JOIN cdb_usergroups u ON u.groupid=m.groupid WHERE mf.medals!=''
Error: Table 'mf' is marked as crashed and should be repaired
Errno.: 1194

Similar error report has beed dispatched to administrator before.




哪里修改不对能说说吗，文件我都检查过了没问题，数据库也想再升级一次，可惜说：

升级错误，MySQL 提示: Duplicate entry 'sellmedals' for key 1

崩溃了。。。。。。

[ 本帖最后由 zhangda7455 于 2006-11-15 02:29 编辑 ]

成功感谢楼主  
http://msnsa.net/bbs/sellmedal.php

谁把反升级语句丢出来撒，我靠！！！！

呵呵


支持一下