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

Discuz! info: MySQL Query Error

User: n
Time: 2007-11-9 11:52am
Script: /space.php

SQL: SELECT * FROM [Table]spacecaches WHERE uid='1'
Error: Table '.\ya60\[Table]spacecaches' is marked as crashed and should be repaired
Errno.: 145

Similar error report has beed dispatched to administrator before.

在打开会员空间的时候出现这个错误，怎么修复？

我论坛是5.5.0扳本,我导入备份数据后,为什么点击率无了,
我原来的也是5.5.0,可能原备份的数据也无点击率

请各位佬大帮忙.........

Discuz! info: MySQL Query Error

User: admin
Time: 2007-11-10 5:58pm
Script: /admincp.php

SQL: CREATE TABLE [Table]medals ( medalid smallint(6) unsigned NOT NULL auto_increment, name varchar(50) NOT NULL default '', available tinyint(1) NOT NULL default '0', image varchar(30) NOT NULL default '', use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NULL default '0', lastuser varchar(32) default '', s1 mediumint(8) NOT NULL default '0', r1 mediumint(8) NOT NULL default '0', s2 mediumint(8) NOT NULL default '0', r2 mediumint(8) NOT NULL default '0', s3 mediumint(8) NOT NULL default '0', r3 mediumint(8) NOT NULL default '0', s4 mediumint(8) NOT NULL default '0', r4 mediumint(8) NOT NULL default '0', s5 mediumint(8) NOT NULL default '0', r5 mediumint(8) NOT NULL default '0', s6 mediumint(8) NOT NULL default '0', r6 mediumint(8) NOT NULL default '0', s7 mediumint(8) NOT NULL default '0', r7 mediumint(8) NOT NULL default '0', s8 mediumint(8) NOT NULL default '0', r8 mediumint(8) NOT NULL default '0', post mediumint(8) NOT NULL default '0', credit mediumint(8) NOT NULL default '0', regday mediumint(8) NOT NULL default '0', digest mediumint(8) NOT NULL default '0', pageview mediumint(8) NOT NULL default '0', online mediumint(8) NOT NULL default '0', admin mediumint(8) NOT NULL default '0', thread mediumint(8) NOT NULL default '0', reply mediumint(8) NOT NULL default '0', PRIMARY KEY (medalid)) TYPE=MyISAM AUTO_INCREMENT=43
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 'use tinyint(1) NOT NULL default '0', rest mediumint(8) NOT NUL
Errno.: 1064

Similar error report has beed dispatched to administrator before.

请问myposts 表中position字段是什么意思!

Discuz! info: MySQL Query Error

Time: 2007-12-8 8:39am
Script: /index.php

SQL: SELECT type FROM [Table]usergroups WHERE groupid='7'
Error: No database selected
Errno.: 1046

Similar error report has beed dispatched to administrator before.

未必要说说这是因为啥？

Discuz! info: Can not connect to MySQL server

Time: 2007-12-13 8:59am
Script: /index.php

Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
服务器端口不对，请咨询空间商正确的端口

Similar error report has beed dispatched to administrator before.



ZenYang JieJue a?

LZ好...

本论坛为6.0 RC1版

现在有一个注册用户总是提示:"对不起，您两次发表间隔少于 X 秒，请不要灌水！"

退出再登陆,均无效.请问我改怎么办??急

Discuz! info: MySQL Query Error

Time: 2008-1-10 10:13pm
Script:

SQL: INSERT INTO [Table]posts VALUES ('111519','21','5588','0',0xcaaed6b8bdf4bfdb,'5','','1196089783',0xb5bdd7eebaf3cbadb6bcb2bbcac7cbadb5c4cbad2e2e,0x3132312e31352e31352e323333,'0','0','1','0','-1','-1','0','0','0','0','0')
Error: Duplicate entry '111519' for key 1
Errno.: 1062

换了服务器后，用注册会员打开版块会出现下面这个，游客不会
Discuz! info: MySQL Query Error

User: ren2003
Time: 2008-1-22 8:14pm
Script: /forumdisplay.php

SQL: SELECT gid, groupname FROM bbs.supe_groupuid WHERE uid='2' AND flag>0
Error: Access denied for user: 'a0122135255@localhost' to database 'bbs'
数据库用户权限不足，请联系空间商解决

Similar error report has beed dispatched to administrator before.

Discuz! info: MySQL Query Error

User: 浪子
Time: 2008-2-12 11:10pm
Script: /admincp.php

SQL: SHOW TABLE STATUS FROM 00103002001 LIKE 'supe_%'
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 '00103002001 LIKE 'supe_%'' at line 1
Errno.: 1064

Similar error report has beed dispatched to administrator before.