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

Discuz! info: MySQL Query Error

Time: 2006-6-1 1:34am
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
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='SRzkaD' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='222.248.225.174' AND m.uid='1'
AND m.password='76419c58730d9f35de7ac538c2fd6737' AND m.secques='6b0338c6'
Error: No database selected
Errno.: 1046

Similar error report has beed dispatched to administrator before.


数据文件是以前3.X版里的，直接拷贝到4.1的mysql里的，现在登录到mysql里去后看不到论坛的相关数据库。ie访问出现上面的错误。

转移服务器，恢复数据时。。出现错误


Discuz! info: MySQL Query Error

User: admin
Time: 2006-7-16 11:05pm
Script: /admincp.php

SQL: CREATE TABLE `cdb_advertisements` ( `advid` mediumint(8) unsigned NOT NULL auto_increment, `available` tinyint(1) NOT NULL default '0', `type` varchar(50) NOT NULL default '0', `displayorder` tinyint(3) NOT NULL default '0', `title` varchar(50) NOT NULL default '', `targets` text NOT NULL, `parameters` text NOT NULL, `code` text NOT NULL, `starttime` int(10) unsigned NOT NULL default '0', `endtime` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`advid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1
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 'DEFAULT CHARSET=gbk AUTO_INCREMENT=1' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.

童虎老大...发贴错误啊...
Discuz! info: MySQL Query Error

User: 清幽
Time: 2006-7-17 10:40am
Script: /bbs/post.php

SQL: SELECT email FROM cdb_subscriptions WHERE uid<>'2' AND tid='1' AND lastnotify<'1153017629'
Error: Unknown column 'email' in 'field list'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before.

错误报告邮件内容:

There seems to have been a problem with the database of your Discuz! Board

Discuz! info: MySQL Query Error

User: admin
Time: 2006-7-17 8:13am
Script: /bbs/post.php

SQL: SELECT email FROM cdb_subscriptions WHERE uid&lt;&gt;'1' AND tid='1' AND lastnotify&lt;'1153008818'
Error:  Unknown column 'email' in 'field list'
Errno.:  1054

Please check-up your MySQL server and forum scripts, similar errors will not be reported again in recent 24 hours
If you have troubles in solving this problem, please visit Discuz! Community http://www.Discuz.net.

开始时我用SS/XS的文件覆盖了论坛原来的文件,但重新覆盖回正常文件时却不断出错,请帮忙啊

顶上去,童虎大哥快来帮忙

数据库查询不了?


这个论坛
http://www.hiall.com.cn/bbs/index.php
Discuz!版本是D4.1.0

现在需要在网站外部逐条查询用户信息.  
http://www.hiall.com.cn/bbs/viewpro.php?uid=1
网站上显示现在已经有超过15万用户
所以需要查询UID从1到15万的所有信息

可是,我发现,从UID=24275开始,后面的用户信息显示就出现问题了
能查询到用户名,但是Email地址一栏为空.

从已经查询出来的1-30000条数据来看,
UID从1到24275这些基本上都能查询到用户Email,1万条中仅有少于10条数据查询出来Email为空
但是从UID=24275到30000(已经查询出来的部分),这数千条数据之中仅仅有可怜的几条数据是正常的,
也就是只有几条可以查询到Email

而且,通过查询我自己在那个网站上的信息,发现也不能查询到Email
但是我注册的时候是绝对填写了Email的.
http://www.hiall.com.cn/bbs/viewpro.php?uid=152593
这就基本可以排除没有Email的这部分用户根本还没注册的假设.

另外,刚刚在Discuz!的这个主论坛上小小的测试了一下,发现似乎也有同样的问题.
https://discuz.dismall.com/profile-uid-414920.html   jakelee

请问这是论坛的Bug吗?
有没有办法改进呢?

童虎大哥帮忙看下吧  谢谢


因为内存溢出 我使用的是faisunSQL3.9  我在原空间进行导出后 使用FTP上传到了新的空间下 然后运行/sqlback.php后 。提示这样的错误

MySQL语句错误！您可能发现了程序的BUG！请报告开发者。
版本：V3.9
语句：
CREATE TABLE `cdb_access` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `fid` smallint(6) unsigned NOT NULL default '0',
  `allowview` tinyint(1) NOT NULL default '0',
  `allowpost` tinyint(1) NOT NULL default '0',
  `allowreply` tinyint(1) NOT NULL default '0',
  `allowgetattach` tinyint(1) NOT NULL default '0',
  `allowpostattach` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`,`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk
错误信息： 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 'ENGINE=MyISAM DEFAULT CHARSET=gbk' at line 10

后来经人提示将

全部的'ENGINE=MyISAM DEFAULT CHARSET=gbk' at line 10

改成'ENGINE=MyISAM

但是仍然出现

MySQL语句错误！您可能发现了程序的BUG！请报告开发者。
版本：V3.9
语句：
CREATE TABLE `cdb_access` (
  `uid` mediumint(8) unsigned NOT NULL default '0',
  `fid` smallint(6) unsigned NOT NULL default '0',
  `allowview` tinyint(1) NOT NULL default '0',
  `allowpost` tinyint(1) NOT NULL default '0',
  `allowreply` tinyint(1) NOT NULL default '0',
  `allowgetattach` tinyint(1) NOT NULL default '0',
  `allowpostattach` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`uid`,`fid`)
) ENGINE=MyISAM
错误信息： 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 'ENGINE=MyISAM' at line 10

请问怎么解决～～谢谢

Discuz! info: Can not connect to MySQL server

Time: 2006-11-2 9:59am
Script: /index.php

Error: Access denied for user: 'root@localhost' (Using password: YES)
数据库帐户密码不对，请联系空间商
请问一下这是怎么回事？我升级论坛时遇到的问题

数据表缺失,请恢复备份数据

Similar error report has beed dispatched to administrator before.

[ 本帖最后由 xinruby02 于 2006-11-5 17:45 编辑 ]

我的問題是：

Discuz! info: MySQL Query Error

Time: 2006-11-12 5:07pm
Script: /index.php

SQL: SELECT COUNT(*) FROM cdb_forums WHERE status='1' AND threadcaches>0
Error: Unknown column 'threadcaches' in 'where clause'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

那怎麼可解決這個問題？