79hc 发表于 2013-1-20 00:53:17

数据库错误及无法备份

query:SELECT COUNT(*) as num FROM job_directories WHERE d_cmember=\'jiangqili\' |errno:1146|error:Table \'a1017102256.job_directories\' doesn\'t exist|errmsg:MySQL Query Error
请教下高手出现这个是什么意思，怎么解决?
还有因为cdb_sessions   cdb_uc_vars 两个数据表不知道什么错误导致我现在数据无法备份 用数据库自动修复得到：cdb_sessionsrepairnoteThe storage engine for the table doesn\'t support r...
cdb_uc_varsrepairnoteThe storage engine for the table doesn\'t support r...求高手帮忙解决下，谢谢了！

16086697 发表于 2013-1-20 12:45:56

query:SELECT COUNT(*) as num FROM job_resume INNER JOIN job_member on r_mid=m_id WHERE r_flag=1 and r_cnstatus=1 and r_openness=0 and m_flag=1 and DATEDIFF(m_startdate,\'2013-01-20\')<=0 and DATEDIFF(m_enddate,\'2013-01-20\')>=0 and r_personinfo=1 and r_careerwill=1 and (r_position like \'%閿

admin 发表于 2013-1-20 14:33:11

query:SELECT COUNT(*) as num FROM job_directories WHERE d_cmember=\'jiangqili\' |errno:1146|error:Table \'a1017102256.job_d... a1017102256.job_directories表无法打开，原因可能是表不存在，或者表文件丢失，就上边的表明job_directories，楼主使用的不是我们的人才系统？

admin 发表于 2013-1-20 14:33:48

query:SELECT COUNT(*) as num FROM job_resume INNER JOIN job_member on r_mid=m_id WHERE r_flag=1 and r_cnstatus=1 and r_o... 查询的那个字数据库不认识

79hc 发表于 2013-1-22 10:18:37

怎么弄 兄弟

是的啊 是以前我生日人家送我的 说反正买来也没时间弄 好像是2.1的 现在我装了结果就是数据库无法备份的 就像我刚才说的这个现象 能帮忙解决下吗 兄弟

16086697 发表于 2013-1-23 13:13:00

query:SELECT `a_id`,`a_title` FROM `job_announce` WHERE (`a_channelid`=0 OR `a_isnew`=1) AND (`a_site`=2511 OR `a_site`=0) AND DATEDIFF(\'2013-01-23\',a_dateandtime)<=a_outtime AND (`a_showtype`=0 OR `a_showtype`=1) ORDER BY `a_dateandtime` DESC LIMIT 0,8|errno:2006|error:MySQL server has gone away|errmsg:MySQL Query Error

admin 发表于 2013-1-23 14:00:32

query:SELECT `a_id`,`a_title` FROM `job_announce` WHERE (`a_channelid`=0 OR `a_isnew`=1) AND (`a_site`=2511 OR `a_site`=... MySQL server has gone away
这个问题参考http://www.jb51.net/article/23781.htm

kaka 发表于 2013-1-26 17:33:58

query:SELECT `job2_zphorder`.*,`job2_member`.m_typeid,`job2_member`.m_id FROM `job2_zphorder` INNER JOIN `job2_member` on `zo_mid`=`m_id` where `zo_zid`=2 and `zo_state`=1 ORDER BY `zo_adddate` ASC|errno:1146|error:Table \'s524584db0.job2_zphorder\' doesn\'t exist|errmsg:MySQL Query Error
求助

kaka 发表于 2013-1-27 01:45:44


已经解决！

见帖子 read-htm-tid-31478.html 请问是怎么解决的？我也遇到这个问题，希望能够帮忙 ，QQ：631509890

admin 发表于 2013-1-27 08:01:44

请问是怎么解决的？我也遇到这个问题，希望能够帮忙 ，QQ：631509890 http://bbs.rccms.com/read/31482
页: 1 2 3 [4] 5 6
查看完整版本: 出现MysqlError:MySQL Query Error的处理方法