出现MysqlError:MySQL Query Error的处理方法

79hc

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_sessions

repair

note

The storage engine for the table doesn\'t support r...

cdb_uc_vars

repair

note

The storage engine for the table doesn\'t support r...

求高手帮忙解决下，谢谢了！

16086697

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

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

admin

[quote=16086697,99244]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...[/quote] 查询的那个字数据库不认识

79hc

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

16086697

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

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

kaka

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

[quote=优遁,96476]
已经解决！

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

admin

[quote=kaka,99411] 请问是怎么解决的？我也遇到这个问题，希望能够帮忙 ，QQ：631509890[/quote] http://bbs.rccms.com/read/31482