升级出错

ideal

SELECT
`n_id`,`n_sid`,`n_cid`,`n_pic`,`n_title`,`n_sorttit`,`n_overview`,`n_color`,`n_addtime`,`s_name`
FROM `job_news` INNER JOIN `job_newssort` ON `n_sid`=`s_id` AND `n_cid`=6 AND
`n_sid`=1 AND `n_ishome`=1 ORDER BY `n_id` desc LIMIT 0,20

admin

错误提示是什么？

上网溜达

请楼主告诉一下错误代码

ideal

[quote=上网溜达,99459]请楼主告诉一下错误代码[/quote]

上网溜达

请问你是不是整合了UC 或者更换了配置文件？请检查一下配置文件中的SQL 相关信息是否和你的数据库一致。

ideal

[quote=admin,98654]错误提示是什么？[/quote] select n_sid,n_cid,n_title,n_content,n_addtime,n_overview,n_from,n_author,n_editor,n_hits,s_name,n_keywords,n_description from job_news,job_newssort where n_sid=s_id and n_state=1 and n_id=606|errno:1054|error:Unknown column \'n_state\' in \'where clause\'|errmsg:MySQL Query Error

ideal

[quote=admin,98654]错误提示是什么？[/quote] 后台老会出现这个错误。。

灰鸽子

n_state 没有这个表吧。哪个文件提示的 把 and n_state删除

ideal

[quote=灰鸽子,104223]n_state 没有这个表吧。哪个文件提示的 把 and n_state删除[/quote] 那这个错呢？
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