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

kaka

query:update job2_level set l_name=\'学徒\',l_integral=\'0\',l_images=level/level1.gif where l_id=1|errno:1054|error:Unknown column \'level\' in \'field list\'|errmsg:MySQL Query Error

16086697

/school/student_more.php

sid=67460

MySQL Query Error 【详细】

query:select s_id,s_adddate,s_jobintent,s_profession,s_edu,s_sex,s_name from job_student where s_sid=67460 order by s_adddate desc|errno:1054|error:Unknown column \'s_profession\' in \'field list\'|errmsg:MySQL Query Error  
症状：院校联盟里的毕业生添加，添加不进去。打开院校联盟里的优秀毕业生提示：MysqlError:MySQL Query Error
求解决！！

ideal

请问为什么会出现这个错误？请官方看下：
query:select h_id,h_comname,h_place from job_hire where h_id in() order by h_adddate desc|errno:1064|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 \') order by h_adddate desc\' at line 1|errmsg:MySQL Query Error

zhangyi_029

你好，这个是没有选中职位所导致的。

ideal

这个错误呢？请官方看下
query:select r_name,r_sex,r_birth,r_edu,r_title,r_email from job_resume where r_id= limit 0,1|errno:1064|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 \'limit 0,1\' at line 1|errmsg:MySQL Query Error

grape

MYSQL

guest

2013-04-10 09:40:46

112.236.225.221

文件/autohtml.php

do=index

MySQL Query Error 【详细】

出现错误

query:SELECT `r_id`,`r_sex`,`r_birth`,`r_edu`,`r_position`,`r_jobtype`,`r_workadd`,`r_adddate`,`r_member`,`r_name`,`m_logo`,`m_nameshow` FROM `job_resume` INNER JOIN `job_member` ON `r_mid`=`m_id` AND `m_flag`=1 AND `r_openness`=0 AND `r_personinfo`=1 AND `r_careerwill`=1 AND `r_flag`=1 AND `r_cnstatus`=1 AND `m_comm`=1 AND `m_logostatus`=1 AND `m_logoflag`=1 AND `m_logo`<>\'\' AND `m_logo`<>\'nologo.gif\' AND `m_logo`<>\'error.gif\' ORDER BY r_adddate desc LIMIT 0,10|errno:145|error:Table \'.\\send\\job_resume\' is marked as crashed and should be repaired|errmsg:MySQL Query Error

zhangterry56

guoxumeng

guoxumeng

错误提示和帖子总结的情况不太一样哈。

zgcbcc

query:SELECT `s_site`,`s_siten` FROM `job_site` ORDER BY `s_id` ASC|errno:1146|error:Table \'frcms.job_site\' doesn\'t exist|errmsg:MySQL Query Error  ，请问这个怎么解决？