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

Discuz! info: MySQL Query Error

Time: 2007-5-3 3:59pm
Script: /bbs/logging.php

SQL: SELECT 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.styleid AS styleidmem, m.lastvisit, m.lastpost, u.allowinvisible
FROM [Table]members m LEFT JOIN [Table]usergroups u USING (groupid)
WHERE m.username='城市童话'
Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for operation '='
Errno.: 1267

SupeSite info: Can not connect to MySQL server

User: guest
Time: 2007-5-5 12:15am
Script: /index.php

Error: 链接过多，请联系空间商
Errno.: 1040

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

Time: 2007-5-6 11:47pm
Script: /bbs/index.php

SQL: SELECT itemid, uid, username, type, subject FROM sqlweb_942.supe_spaceitems WHERE folder=1 AND type<>'news' ORDER BY dateline DESC LIMIT 0
Error: SELECT command denied to user 'whs164'@'localhost' for table 'supe_spaceitems'
Errno.: 1142

Similar error report has beed dispatched to administrator before.

admincp.php : Access denied for user '5dzx_008_net'@'localhost' to database 'discuz' - SELECT * FROM discuz.supe_settings WHERE variable IN ('attachmentdir', 'attachmenturl')
出现这种情况是什么原因

还有以下情况如何解决，急！！！！在线等答案。
Discuz! info: MySQL Query Error

User: admin
Time: 2007-5-8 2:14pm
Script: /bbs/admincp.php

SQL: SELECT * FROM discuz.supe_settings WHERE variable IN ('attachmentdir', 'attachmenturl')
Error: Access denied for user '5dzx_008_net'@'localhost' to database 'discuz'
Errno.: 1044

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: 血色De命神
Time: 2007-5-11 2:11pm
Script: /bbs/plugin.php

SQL: select uid,gender,hw, from [Table]members WHERE username='血色De命神'
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 'from [Table]members WHERE username='血色De命神'' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.

谢谢你 问题已经解决了 是童虎帅哥帮我弄的  真的很谢谢很谢谢

呵呵有时候真的不知道说什么好 谢谢你

>>论坛升级第 2 步: 调整论坛数据表结构

升级数据表 [ 0 ] cdb_usergroups :
[/table][/table][/table]
Discuz! info: MySQL Query Error

Time: 2007-5-11 12:16pm
Script:

SQL: ALTER TABLE [Table]usergroups CHANGE minrewardprice minrewardprice smallint(6) NOT NULL default '1'
Error: Access denied for user 'exe86'@'localhost' to database 'exe86'
数据库用户权限不足，请联系空间商解决

Similar error report has beed dispatched to administrator before.


各位高手来帮助一下,我是新手。

收藏，发个帖子凑数量

首先，我对于版主看我的贴子表示感谢，对于解决我的问题表示感激并给予崇高的敬意:) 我的问题如下，心急如焚 ：
NO.1：
　　　请看，在我的网站管理平台里的“资讯管理”这一栏出现的问题是无法打开，提示如图所示：
点击“资讯管理”再现如下附件图提示：