全球主机交流论坛

标题: php高手看下,这个是什么mysql错误 [打印本页]

作者: send    时间: 2014-4-6 11:56
标题: php高手看下,这个是什么mysql错误
提交设置后显示的错误代码



  1. Error:Query error:UPDATE qs_setmeal SET `setmeal_name`='月度会员', `days`='30', `expense`='100', `jobs_ordinary`='15', `download_resume_ordinary`='100', `download_resume_senior`='50', `interview_ordinary`='100', `interview_senior`='50', `talent_pool`='100', `recommend_num`='0', `recommend_days`='0', `stick_num`='0', `stick_days`='0', `emergency_num`='0', `emergency_days`='0', `highlight_num`='0', `highlight_days`='0', `change_templates`='0', `map_open`='0', `show_order`='0', `display`='1', `apply`='1', `added`='', `refresh_jobs_space`='0', `refresh_jobs_time`='0' WHERE id=2
复制代码


然后单独拿出来SQL语句在phpmyadmin中执行



  1. UPDATE qs_setmeal SET `setmeal_name`='月度会员', `days`='30', `expense`='100', `jobs_ordinary`='15', `download_resume_ordinary`='100', `download_resume_senior`='50', `interview_ordinary`='100', `interview_senior`='50', `talent_pool`='100', `recommend_num`='0', `recommend_days`='0', `stick_num`='0', `stick_days`='0', `emergency_num`='0', `emergency_days`='0', `highlight_num`='0', `highlight_days`='0', `change_templates`='0', `map_open`='0', `show_order`='0', `display`='1', `apply`='1', `added`='', `refresh_jobs_space`='0', `refresh_jobs_time`='0' WHERE id=2
复制代码


然后phpmyadmin中错误提示

  1. #1054 - Unknown column 'refresh_jobs_space' in 'field list'
复制代码

作者: cun    时间: 2014-4-6 12:12
没字段吧?
作者: SKIDROW    时间: 2014-4-6 12:26
没这个字段:refresh_jobs_space?
作者: 暮雨秋晨    时间: 2014-4-6 13:59
尼玛~你翻译了看看会死啊?浪费表情!
作者: enta    时间: 2014-4-6 16:51
没有那个数据列




欢迎光临 全球主机交流论坛 (https://hostloc-workers.ikyomon.com/) Powered by Discuz! X3.4