数据库常见错误信息和解决方法集中讨论贴

请问以上是什么问题？刚重新导入的论坛数据！

:) :) :)

Discuz! info: MySQL Query Error

User: Jimmy
Time: 2007-10-14 8:52pm
Script: /dzcn/admincp.php

SQL: DROP TABLE IF EXISTS ljmtidilgw_dzcn.supe_ads
Error: DROP command denied to user 'ljmtidilgw'@'hera.dreamhost.com' for table 'supe_ads'
Errno.: 1142

Discuz! info: MySQL Query Error

User: Jimmy
Time: 2007-10-15 9:17pm
Script: /dzcn/admincp.php

SQL: SELECT s.id, s.code, s.url, t.typeid FROM [Table]smilies s LEFT JOIN [Table]imagetypes t ON t.typeid=s.typeid WHERE s.type='smiley' AND s.code<>'' AND t.typeid IS NOT NULL ORDER BY LENGTH(s.code) DESC
Error: Unknown column 's.typeid' in 'on clause'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Discuz! info: MySQL Query Error

User: xmant
Time: 2007-10-17 1:27am
Script: /admincp.php

SQL: SHOW TABLE STATUS FROM sq_mvant LIKE 'supe_%'
Error: Access denied for user 'xmant'@'localhost' to database 'sq_mvant'
数据库用户权限不足，请联系空间商解决

Discuz6.0，用户登录时经常出现错误，就连第一次直接打开首页都会出现错误。然后清空浏览器的临时文件、cookie都是如此。一些错误如下：
Discuz! info: MySQL Query Error

Time: 2007-9-28 7:50pm
Script: /index.php

SQL: SELECT s.sid, s.styleid, s.groupid=\'6\' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques,
m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, m.posts, m.digestposts,
m.oltime, m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5,
m.extcredits6, m.extcredits7, m.extcredits8, m.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
m.lastvisit, m.lastactivity, m.lastpost, m.newpm, m.accessmasks, m.xspacestatus, m.editormode, m.customshow
FROM [Table]sessions s, [Table]members m
WHERE m.uid=s.uid AND s.sid=\'SHTL7g\' AND CONCAT_WS(\'.\',s.ip1,s.ip2,s.ip3,s.ip4)=\'218.1.26.178\' AND m.uid=\'1\'
AND m.password=\'4ea0646af98090bb6cc7b9c29034525d\' AND m.secques=\'\'
Error: Record has changed since last read in table \'s\'
Errno.: 1020

Similar error report has beed dispatched to administrator before.
============
Discuz! info: MySQL Query Error

User: admin
Time: 2007-9-28 6:51pm
Script: /index.php

SQL: SELECT uid, username, groupid, invisible, action, lastactivity, fid FROM [Table]sessions WHERE uid <> 0 ORDER BY uid DESC LIMIT 500
Error: Record has changed since last read in table \'[Table]sessions\'
Errno.: 1020

Similar error report has beed dispatched to administrator before.
=================
Discuz! info: MySQL Query Error

User: admin
Time: 2007-9-28 7:39pm
Script: /index.php

SQL: SELECT uid, username, groupid, invisible, action, lastactivity, fid FROM [Table]sessions WHERE uid <> 0 ORDER BY uid DESC LIMIT 500
Error: Record has changed since last read in table \'[Table]sessions\'
Errno.: 1020

Similar error report has beed dispatched to administrator before.

这是怎么回事呢？空间提供上的环境是Apache 1.3.28 、mysql3.23.28

Discuz! info: MySQL Query Error

Time: 2007-10-19 4:11pm
Script: /bbs/tools.php

SQL: INSERT INTO [Table]posts VALUES ('54535','5','5511','0',0x363331343837353331,'2523','','1168694588',0xb7d6b0aeb0aeb7d6c4d0c4d0c5aec5aec7e9
Error: 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 '' at line 1
Errno.: 1064


数据在原服务器正常，备份到新服务器导入就发生这些问题！
我已经备份了好多次文件了还是一样！

Comsenz 5.0版的有个修改主页文件的，修改后无法进入主页，可以用FTP工具修改主页
请问FTP地址怎么输入的？

Discuz! info: MySQL Query Error

User: 叛逆v孤星
Time: 2007-10-23 12:31pm
Script: /admincp.php

SQL: SELECT f.fid, f.type, f.name, f.fup, f.simple, ff.viewperm, ff.formulaperm, a.uid FROM [Table]forums f LEFT JOIN [Table]forumfields ff ON ff.fid=f.fid LEFT JOIN [Table]access a ON a.fid=f.fid AND a.allowview='1' WHERE f.status>0 ORDER BY f.type, f.displayorder
Error: Got error 28 from table handler
Errno.: 1030

Similar error report has beed dispatched to administrator before.
这什么意思啊~~