数据库常见错误信息和解决方法

支持了

Discuz! info: MySQL Query Error

Time: 2008-5-7 11:58am
Script: /forumdisplay.php

SQL: SELECT t.* FROM [Table]threads t
WHERE t.tid IN (40,1271,2705) AND t.displayorder IN (2, 3)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 0, 3
Error: Table '.\xmtl\[Table]threads' is marked as crashed and should be repaired
Errno.: 145

Similar error report has beed dispatched to administrator before.
  

以上的问题怎么处理呢？求助！ 谢谢指导。  （www.xmtl.net）

这个要好好学习一下

我使用phpmyadmin时候提示没有权限建立数据库？
我应该怎么办呢？

SQL: UPDATE [Table]usergroups SET grouptitle='管理员', radminid='1', system='private', allowvisit='1',
readaccess='255', allowmultigroups='1', allowtransfer='1', allowviewpro='1',
allowviewstats='1', allowinvisible='1', allowsearch='2', allowavatar='3',
reasonpm='0', allowuseblog='1', allownickname='1', allowcstatus='1',
disableperiodctrl='1', maxpmnum='200', maxpostsperhour='0', maxinvitenum='0', maxinviteday='10', allowpost='1', allowreply='1',
allowanonymous='1', allowsetreadperm='1', maxprice='30', allowhidecode='1',
allowhtml='0', allowpostpoll='1', allowdirectpost='3', allowvote='1',
allowcusbbcode='1', allowsigbbcode='1', allowsigimgcode='1', allowinvite='0', allowmailinvite='0', raterange='1 -30 30 500',
maxsigsize='500', allowgetattach='1', allowpostattach='1',
allowsetattachperm='1', allowpostreward='1', maxrewardprice='0', minrewardprice='1', inviteprice='0',
maxattachsize='307200', maxsizeperday='0', attachextensions='jpg, gif, png',
allowbiobbcode='1', allowbioimgcode='1', maxbiosize='0',
maxtradeprice='0', mintradeprice='1', tradestick='5', allowposttrade='1', allowpostactivity='1', allowmagics='2', maxmagicsweight='200', magicsdiscount='0', allowpostdebate='1' WHERE groupid='1'
Error: Unknown column 'maxpmnum' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖
怎么解决啊~

Unknown column 'maxpmnum' in 'field list'
我根本找不到maxpmnum
请童虎帮助解决，谢谢~

升级错误，MySQL 提示: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=gbk' at line 1 ，请返回。

多谢指教

多谢指教