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

我也遇到这个问题了，兄弟，解决没？

偶是新手,刚刚在飞龙科技上申请了一个免费的虚拟主机(300M),想装个论坛试试,
可是装到第三步的时候出现问题了！


先是这样：


于是偶就把数据库的名称改：new Discuz
可是新问题又出现了：




请问题各位高手偶该怎么办？？帮帮偶啊！！

Discuz! info: MySQL Query Error

User: 8XXXXX
Time: 2007-5-26 3:34pm
Script: /msb/admincp.php

SQL: SELECT * FROM settings WHERE variable IN ('attachmentdir', 'attachmenturl')
Error: Table 'sq_chinanet.settings' doesn't exist
数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.





数据文件不存在: 可能服务器不允许上传文件或尺寸超过限制。

[ 本帖最后由 8251316 于 2007-5-26 15:48 编辑 ]

Discuz! info: MySQL Query Error

User: Laconic
Time: 2007-5-27 6:39pm
Script: /space.php

SQL: SELECT t.tid, t.subject, t.special, t.price, t.fid, t.views, t.replies, t.author, t.authorid, t.lastpost, t.lastposter, t.attachment, p.pid, p.message FROM [Table]mythreads m INNER JOIN [Table]posts p ON p.tid=m.tid AND p.first='1'
INNER JOIN [Table]threads t ON t.blog='0' AND t.authorid='2' AND t.author!='' AND t.price='0' AND t.fid IN (0,1,2,3,4,5,7,8,9,10,12,13,14,16,17,18,19,20,21,23,22) AND t.displayorder>='0' AND t.readperm<='10'
WHERE m.uid='2' AND m.tid=t.tid ORDER BY t.lastpost DESC LIMIT 5
Error: Can't create/write to file 'C:\WINDOWS\TEMP\#sql_738_0.MYD' (Errcode: 17)
Errno.: 1

Similar error report has beed dispatched to administrator before.


1出问题了?空间进不去啊

Discuz! info: MySQL Query Error

Time: 2007-5-28 12:50pm
Script: /bbs/forumdisplay.php

SQL: SELECT t.* FROM [Table]threads t
WHERE t.tid IN (876,1295,2411,2454) AND t.displayorder IN (2, 3)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 0, 4
Error: Can't open file: '[Table]threads.MYI'. (errno: 145)
文件无法打开，请修复数据表

Similar error report has beed dispatched to administrator before.
这是什么原因?

有点问题，:)

Script: /index.php

SQL: SELECT t.*, f.name FROM [Table]threads t, [Table]forums f WHERE t.fid<>'0' AND f.fid=t.fid AND f.fid NOT IN () AND t.displayorder>=0 ORDER BY t.dateline DESC LIMIT 0, 10
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 ') AND t.displayorder>=0 ORDER BY t.dateline DESC LIMIT 0, 10' at line 1
Errno.: 1064

我在转移论坛的数据库,在安装后出现了这个问题
Discuz! info: MySQL Query Error

User: admin
Time: 2007-6-2 9:47am
Script: /discuz/admincp.php

SQL: CREATE TABLE [Table]albumcla ( id int(10) unsigned NOT NULL auto_increment, parentid int(10) unsigned NOT NULL default '0', claname char(30) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', photoname char(100) NOT NULL default '', createtime int(10) unsigned NOT NULL default '0', updatetime int(10) unsigned NOT NULL default '0', sortid int(10) unsigned NOT NULL default '0', clatype tinyint(1) unsigned NOT NULL default '0', photocount smallint(5) unsigned NOT NULL default '0', viewtype tinyint(1) unsigned NOT NULL default '1', passwd char(16) NOT NULL default '111111', clicktimes mediumint(8) unsigned NOT NULL default '0', describe char(50) NOT NULL default '', KEY id (id), KEY uid (uid), KEY parentid (parentid), KEY viewtype (viewtype), KEY photocount (photocount), KEY sortid (sortid)) ENGINE=MyISAM DEFAULT CHARSET=gbk 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 'describe char(50) NOT NULL default '', KEY id (id), KEY uid (uid), KEY parent' at line 1
Errno.: 1064

这是怎么回事啊?

1. Warning: main(): Failed opening 'E:\webhost\wwww\www\bbs\./forumdata/templates/1_show_promotion.tpl.php' for inclusion (include_path='.') in E:\webhost\wwww\www\bbs\plugins\promotion\show_promotion.inc.php on line 89

复制代码

打开设施插件就显示上面一段代码

用普通会员打开却是一片空白

求解决方法 。。。。。。。。。

在搜索的时候数据库提示出错，请问有朋友遇到吗？如何解决？谢谢。版本：DZ5.0

Discuz! info: MySQL Query Error

User: welcomef
Time: 2007-6-3 11:58pm
Script: /search.php

SQL: INSERT INTO cdb4_searchindex (keywords, searchstring, useip, uid, dateline, expiration, threads, tids)
VALUES ('600963', 'title|600963|0||\'63\',\'99\',\'100\',\'101\',\'27\',\'34\',\'4\',\'103\',\'44\',\'45\',\'51\',\'22\',\'46\',\'38\',\'52\',\'81\',\'92\',\'40\',\'102\',\'78\',\'79\',\'94\',\'96\',\'80\',\'95\'|0|0|all', '124.240.124.170', '3', '1180886310', '1180889910', '28', '0,112643,108738,95894,95375,92187,83882,83570,83488,79196,77307,75429,74016,67519,66895,63532,62274,61210,58504,58423,57697,55808,52090,51791,51701,50354,49450,49250,24074')
Error: Duplicate entry '974' for key 1
Errno.: 1062