DT资讯文章生成静态出现MySQL Error解决办法
今天有个朋友的DT系统生成静态出现
MySQL Query:SELECT * FROM [pre]article_21 WHERE status=3 and itemid<>516548 and keyword like '%龙慧祺 ORDER BY addtime desc LIMIT 0,10 MySQL 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 addtime desc LIMIT 0,10' at line 1 MySQL Errno:0 Message:MySQL Query Error
所以具体解决办法:
用mysql工具进行查询:
update destoon_article_21 set fromurl = replace(fromurl,"[db:来源链接]","http://www.kaotop.com/"); update destoon_article_21 set title = replace(title,""",""); update destoon_article_21 set introduce = replace(introduce,""",""); update destoon_article_21 set keyword= replace(keyword,""",""); update destoon_article_21 set tag = replace(tag,""","");
这样就能解决了,如果有其他好方法,可以一起共享!
千行代码,Bug何处藏。 纵使上线又怎样,朝令改,夕断肠。