wp post 时500错误重要更新
应该有些人用了我修改过的db.php文件,发现一bug,请尽快更新。
详情链接:http://www.nimab.org/2008/05/01/39.html
应该有些人用了我修改过的db.php文件,发现一bug,请尽快更新。
详情链接:http://www.nimab.org/2008/05/01/39.html
随时听人讲有500错误。
今天在楚云blog上重现了。
抓住机会debug。
结果很快出来:
当你第二次用同样的标题并且标题中含有多字节文字时,有很大机会触发wp一个死循环,然后服务器cpu直接到100%,当运行时间超过max_execution_time时候出现500错误。
死循环在这里:wp-include/post.php
...... if ( 'draft' != $post_status ) { $post_name_check = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM $wpdb->posts WHERE post_name = %s AND post_type = %s AND ID != %d AND post_parent = %d LIMIT 1", $post_name, $post_type, $post_ID, $post_parent)); if ($post_name_check || in_array($post_name, $wp_rewrite->feeds) ) { $suffix = 2; do { $alt_post_name = substr($post_name, 0, 200-(strlen($suffix)+1)). "-$suffix"; // expected_slashed ($alt_post_name, $post_name, $post_type) $post_name_check = $wpdb->get_var($wpdb->prepare("SELECT post_name FROM $wpdb->posts WHERE post_name = '$alt_post_name' AND post_type = '$post_type' AND ID != %d AND post_parent = %d LIMIT 1", $post_ID, $post_parent)); $suffix++; } while ($post_name_check); $post_name = $alt_post_name; } }
死循环触发点:wp-include/wp-db.php
...... /** * Prepares a SQL query for safe use, using sprintf() syntax */ function prepare($args=NULL) { if ( NULL === $args ) return; $args = func_get_args(); $query = array_shift($args); $query = str_replace("'%s'", '%s', $query); // in case someone mistakenly already singlequoted it $query = str_replace('"%s"', '%s', $query); // doublequote unquoting $query = str_replace('%s', "'%s'", $query); // quote the strings array_walk($args, array(&$this, 'escape_by_ref')); return @vsprintf($query, $args); }
post_name 中的的多字节文字被 urlencode 成这样 "%e6%88%91%e6%93%8d%ef%bc%81",只要 % 后面跟了 bcdeufFosxX 中任意一个(覆盖了大半个中文区域),就造成 vsprintf 函数调用失败,返回 false,而上层的循环一直在等它返回一个非false的值,直到程序死掉。
解决方法很简单:
修改 wp-include/wp-db.php
用下面的代码替换掉之前贴出的代码:
...... /** * Prepares a SQL query for safe use, using sprintf() syntax */ function prepare($args=NULL) { if ( NULL === $args ) return; $args = func_get_args(); $query = array_shift($args); $query = str_replace("'%s'", '%s', $query); // in case someone mistakenly already singlequoted it $query = str_replace('"%s"', '%s', $query); // doublequote unquoting $query = str_replace('%s', "'%s'", $query); // quote the strings array_walk($args, array(&$this, 'escape_by_ref')); // 旧的方法会引起其他问题 // $query = preg_replace("#(%[0-f]{2})#sie", "urldecode('$1')", $query); // $query = @vsprintf($query, $args); // $query = preg_replace("#([\x80-\xff])#se", "strtolower(urlencode('$1'))", $query); // 新的方法只针对重复标题时的死循环问题 $reg = "#post_name = '((?:%[0-9a-f]{2})+.+)'#Usi"; if (preg_match($reg, $query, $match)) { $he = $match[1]; $hd = urldecode($he); $query = str_replace($he, $hd, $query); $query = @vsprintf($query, $args); $query = str_replace($hd, $he, $query); } else { $query = @vsprintf($query, $args); } return $query; }
后来楚云坚持认为wp可以不用修改任何原始代码解决所有问题,所以找到了下面的方法:
下载这个文件:db.tgz 解压后得到 db.php 将它放到 wp-content/ 下。
---------
或许这只是其中一个造成500的原因,下次遇到再说吧。
--------- update --------
补充,此db.php为2.5.1的,后来才知道2.5.1比2.5.0也有更新,不保证其他版本没有意外情况。
--------- update 2008/05/10 --------
发现bug,更新了方法以及db.php下载链接。以前的方法太粗暴,一些其他的查询也被强制转码造成数据错误。
解决方法:重新下载db.php或按照前文代码重新修改wp-db.php。已经出错的数据,可重新编辑保存。已知会引发错误的地方:http://yourwpuri/wp-admin/widgets.php (也就是说你使用了之前的 db 文件后,有设置过 widgets 功能,最好重新设置一遍)
因为自带的php没有gd所以要重编
因为服务器用的是x86_64 httpd+php5所以要编 x86_64
因为自带的httpd+php是 universal ,所以要这样做
自带的httpd很好,所以不搞它了
参考:
ppc就不要了
export MACOSX_DEPLOYMENT_TARGET=10.5
export ARCHFLAGS='-arch i386 -arch x86_64'
export CFLAGS='-arch i386 -arch x86_64 -O3 -pipe'
export CXXFLAGS='-arch i386 -arch x86_64 -O3 -pipe'
export LDFLAGS='-arch i386 -arch x86_64 -bind_at_load'
make时候可能出现这样的提示:
gcc-4.0: -E, -S, -save-temps and -M options are not allowed with multiple -arch flags
在 configure 的时候加上 --disable-dependency-tracking
'./configure' \
'--prefix=/usr' \
'--with-config-file-path=/private/etc' \
'--sysconfdir=/private/etc' \
'--with-apxs2=/usr/sbin/apxs' \
'--with-iconv=/usr/local' \
'--with-mhash=/usr/local' \
'--with-gettext=/usr/local' \
'--with-mysql=/usr/local' \
'--with-mysqli=/usr/local/bin/mysql_config' \
'--with-pdo-mysql=/usr/local' \
'--with-openssl=/usr' \
'--with-zlib=/usr' \
'--with-curl=/usr' \
'--with-gd' \
'--with-png-dir=/usr/X11' \
'--with-jpeg-dir=/usr/local' \
'--with-freetype-dir=/usr/X11' \
'--with-xpm-dir=/usr/X11' \
'--enable-gd-native-ttf' \
'--enable-mbstring' \
'--enable-sockets' \
已有的库就不重装了,只需自己安装 gawk, libiconv, mhash, gettext, mysql, jpeg
需要特别注意:系统自带的liviconv有问题,需要自己编一份到/usr/local(小心不要覆盖以前的,否则可能连sh都不能执行了),php在configure时就算指定了 --with-iconv=/usr/local 它还是首先找到 /usr/include/iconv.h ,而且 --help 里只提到 --with-iconv-dir=,应该使用 --with-iconv=
解决方法:
sh#mv /usr/include/iconv.h /usr/include/iconv.h.bak
在iphone中安装php
将代码保存为py.php
ssh 登陆iphone或者在iphone安装Term-vt100
执行 php py.php 等待重启完成
结束
支持的中文貌似很有限,拼音表的处理看来要自己搞一个了,这个在网上找的。
py.php
/** * @desc 将iPhone的通讯录以拼音排序, 需要安装PHP * @author Kafeifei <http://www.nimab.org> * @version 0.2beta */ error_reporting(0); $sqlite_file = '/private/var/root/Library/AddressBook/AddressBook.sqlitedb'; // 1.1.3 以前的版本 $sqlite_file = '/private/var/mobile/Library/AddressBook/AddressBook.sqlitedb'; // 1.1.3 以后的版本 if (!file_exists($sqlite_file)) { println("SQLiteDB:File Notfound."); die; } $dsn = "sqlite:{$sqlite_file}"; try { $dbh = new PDO($dsn); println("Open {$dsn} OK."); } catch (Exception $e) { println("Open {$dsn} ERROR:".$e->getMessage()); die; } $stmt = $dbh->query("SELECT ROWID, First, Last FROM ABPerson"); while ($person = $stmt->fetch(PDO::FETCH_ASSOC)) { $first = ucfirst(Py::parse(u2g($person['First']))); $last = ucfirst(Py::parse(u2g($person['Last']))); $dbh->query("update ABPerson set FirstSort='{$first}', LastSort='{$last}' where ROWID = {$person['ROWID']} ;\n"); println("{$person['ROWID']}\tOK."); } println("done."); println("rebooting..."); system('launchctl stop com.apple.SpringBoard'); function u2g($str) { return iconv('utf-8', 'gbk', $str); } function println($str) { echo "$str\n"; flush(); } class Py { private static $table = array( array("a",-20319), array("ai",-20317), array("an",-20304), array("ang",-20295), array("ao",-20292), array("ba",-20283), array("bai",-20265), array("ban",-20257), array("bang",-20242), array("bao",-20230), array("bei",-20051), array("ben",-20036), array("beng",-20032), array("bi",-20026), array("bian",-20002), array("biao",-19990), array("bie",-19986), array("bin",-19982), array("bing",-19976), array("bo",-19805), array("bu",-19784), array("ca",-19775), array("cai",-19774), array("can",-19763), array("cang",-19756), array("cao",-19751), array("ce",-19746), array("ceng",-19741), array("cha",-19739), array("chai",-19728), array("chan",-19725), array("chang",-19715), array("chao",-19540), array("che",-19531), array("chen",-19525), array("cheng",-19515), array("chi",-19500), array("chong",-19484), array("chou",-19479), array("chu",-19467), array("chuai",-19289), array("chuan",-19288), array("chuang",-19281), array("chui",-19275), array("chun",-19270), array("chuo",-19263), array("ci",-19261), array("cong",-19249), array("cou",-19243), array("cu",-19242), array("cuan",-19238), array("cui",-19235), array("cun",-19227), array("cuo",-19224), array("da",-19218), array("dai",-19212), array("dan",-19038), array("dang",-19023), array("dao",-19018), array("de",-19006), array("deng",-19003), array("di",-18996), array("dian",-18977), array("diao",-18961), array("die",-18952), array("ding",-18783), array("diu",-18774), array("dong",-18773), array("dou",-18763), array("du",-18756), array("duan",-18741), array("dui",-18735), array("dun",-18731), array("duo",-18722), array("e",-18710), array("en",-18697), array("er",-18696), array("fa",-18526), array("fan",-18518), array("fang",-18501), array("fei",-18490), array("fen",-18478), array("feng",-18463), array("fo",-18448), array("fou",-18447), array("fu",-18446), array("ga",-18239), array("gai",-18237), array("gan",-18231), array("gang",-18220), array("gao",-18211), array("ge",-18201), array("gei",-18184), array("gen",-18183), array("geng",-18181), array("gong",-18012), array("gou",-17997), array("gu",-17988), array("gua",-17970), array("guai",-17964), array("guan",-17961), array("guang",-17950), array("gui",-17947), array("gun",-17931), array("guo",-17928), array("ha",-17922), array("hai",-17759), array("han",-17752), array("hang",-17733), array("hao",-17730), array("he",-17721), array("hei",-17703), array("hen",-17701), array("heng",-17697), array("hong",-17692), array("hou",-17683), array("hu",-17676), array("hua",-17496), array("huai",-17487), array("huan",-17482), array("huang",-17468), array("hui",-17454), array("hun",-17433), array("huo",-17427), array("ji",-17417), array("jia",-17202), array("jian",-17185), array("jiang",-16983), array("jiao",-16970), array("jie",-16942), array("jin",-16915), array("jing",-16733), array("jiong",-16708), array("jiu",-16706), array("ju",-16689), array("juan",-16664), array("jue",-16657), array("jun",-16647), array("ka",-16474), array("kai",-16470), array("kan",-16465), array("kang",-16459), array("kao",-16452), array("ke",-16448), array("ken",-16433), array("keng",-16429), array("kong",-16427), array("kou",-16423), array("ku",-16419), array("kua",-16412), array("kuai",-16407), array("kuan",-16403), array("kuang",-16401), array("kui",-16393), array("kun",-16220), array("kuo",-16216), array("la",-16212), array("lai",-16205), array("lan",-16202), array("lang",-16187), array("lao",-16180), array("le",-16171), array("lei",-16169), array("leng",-16158), array("li",-16155), array("lia",-15959), array("lian",-15958), array("liang",-15944), array("liao",-15933), array("lie",-15920), array("lin",-15915), array("ling",-15903), array("liu",-15889), array("long",-15878), array("lou",-15707), array("lu",-15701), array("lv",-15681), array("luan",-15667), array("lue",-15661), array("lun",-15659), array("luo",-15652), array("ma",-15640), array("mai",-15631), array("man",-15625), array("mang",-15454), array("mao",-15448), array("me",-15436), array("mei",-15435), array("men",-15419), array("meng",-15416), array("mi",-15408), array("mian",-15394), array("miao",-15385), array("mie",-15377), array("min",-15375), array("ming",-15369), array("miu",-15363), array("mo",-15362), array("mou",-15183), array("mu",-15180), array("na",-15165), array("nai",-15158), array("nan",-15153), array("nang",-15150), array("nao",-15149), array("ne",-15144), array("nei",-15143), array("nen",-15141), array("neng",-15140), array("ni",-15139), array("nian",-15128), array("niang",-15121), array("niao",-15119), array("nie",-15117), array("nin",-15110), array("ning",-15109), array("niu",-14941), array("nong",-14937), array("nu",-14933), array("nv",-14930), array("nuan",-14929), array("nue",-14928), array("nuo",-14926), array("o",-14922), array("ou",-14921), array("pa",-14914), array("pai",-14908), array("pan",-14902), array("pang",-14894), array("pao",-14889), array("pei",-14882), array("pen",-14873), array("peng",-14871), array("pi",-14857), array("pian",-14678), array("piao",-14674), array("pie",-14670), array("pin",-14668), array("ping",-14663), array("po",-14654), array("pu",-14645), array("qi",-14630), array("qia",-14594), array("qian",-14429), array("qiang",-14407), array("qiao",-14399), array("qie",-14384), array("qin",-14379), array("qing",-14368), array("qiong",-14355), array("qiu",-14353), array("qu",-14345), array("quan",-14170), array("que",-14159), array("qun",-14151), array("ran",-14149), array("rang",-14145), array("rao",-14140), array("re",-14137), array("ren",-14135), array("reng",-14125), array("ri",-14123), array("rong",-14122), array("rou",-14112), array("ru",-14109), array("ruan",-14099), array("rui",-14097), array("run",-14094), array("ruo",-14092), array("sa",-14090), array("sai",-14087), array("san",-14083), array("sang",-13917), array("sao",-13914), array("se",-13910), array("sen",-13907), array("seng",-13906), array("sha",-13905), array("shai",-13896), array("shan",-13894), array("shang",-13878), array("shao",-13870), array("she",-13859), array("shen",-13847), array("sheng",-13831), array("shi",-13658), array("shou",-13611), array("shu",-13601), array("shua",-13406), array("shuai",-13404), array("shuan",-13400), array("shuang",-13398), array("shui",-13395), array("shun",-13391), array("shuo",-13387), array("si",-13383), array("song",-13367), array("sou",-13359), array("su",-13356), array("suan",-13343), array("sui",-13340), array("sun",-13329), array("suo",-13326), array("ta",-13318), array("tai",-13147), array("tan",-13138), array("tang",-13120), array("tao",-13107), array("te",-13096), array("teng",-13095), array("ti",-13091), array("tian",-13076), array("tiao",-13068), array("tie",-13063), array("ting",-13060), array("tong",-12888), array("tou",-12875), array("tu",-12871), array("tuan",-12860), array("tui",-12858), array("tun",-12852), array("tuo",-12849), array("wa",-12838), array("wai",-12831), array("wan",-12829), array("wang",-12812), array("wei",-12802), array("wen",-12607), array("weng",-12597), array("wo",-12594), array("wu",-12585), array("xi",-12556), array("xia",-12359), array("xian",-12346), array("xiang",-12320), array("xiao",-12300), array("xie",-12120), array("xin",-12099), array("xing",-12089), array("xiong",-12074), array("xiu",-12067), array("xu",-12058), array("xuan",-12039), array("xue",-11867), array("xun",-11861), array("ya",-11847), array("yan",-11831), array("yang",-11798), array("yao",-11781), array("ye",-11604), array("yi",-11589), array("yin",-11536), array("ying",-11358), array("yo",-11340), array("yong",-11339), array("you",-11324), array("yu",-11303), array("yuan",-11097), array("yue",-11077), array("yun",-11067), array("za",-11055), array("zai",-11052), array("zan",-11045), array("zang",-11041), array("zao",-11038), array("ze",-11024), array("zei",-11020), array("zen",-11019), array("zeng",-11018), array("zha",-11014), array("zhai",-10838), array("zhan",-10832), array("zhang",-10815), array("zhao",-10800), array("zhe",-10790), array("zhen",-10780), array("zheng",-10764), array("zhi",-10587), array("zhong",-10544), array("zhou",-10533), array("zhu",-10519), array("zhua",-10331), array("zhuai",-10329), array("zhuan",-10328), array("zhuang",-10322), array("zhui",-10315), array("zhun",-10309), array("zhuo",-10307), array("zi",-10296), array("zong",-10281), array("zou",-10274), array("zu",-10270), array("zuan",-10262), array("zui",-10260), array("zun",-10256), array("zuo",-10254) ); private function __construct() {} private static function get($num) { if($num > 0 && $num < 160){ return chr($num); } elseif($num < -20319 || $num > -10247) { return ''; } else { for ($i = count(self::$table)-1; $i>=0; $i--) { if(self::$table[$i][1] <= $num) break; } return self::$table[$i][0]; } } public static function parse($str) { if (empty($str)) { return ''; } $r=""; for($i = 0; $i < strlen($str); $i++) { $p = ord(substr($str, $i, 1)); if($p > 160){ $q = ord(substr($str, ++$i, 1)); $p = $p * 256 + $q - 65536; } $r .= self::get($p); } return $r; } }
----
update 把重起iphone改为重启SpringBoard
update 修正代码中一个逻辑错误和改进一个描述 2008/4/6
update iphone 1.1.3 以后,数据库地址改变
找了若干资料,终于有了结果
原来如此简单:
把 Courier New 的几个字体文件 copy 到 jre/lib/fonts/
cd xxx/jre/lib/fonts
mkfontscale
cp fonts.scale fonts.dir
cd ../
cp fontconfig.properties.src fontconfig.properties
vi fontconfig.properties
修改相关位置:
monospaced.plain.latin-1=-monotype-courier new-medium-r-normal--0-0-0-0-m-0-iso8859-1
monospaced.bold.latin-1=-monotype-courier new-bold-r-normal--0-0-0-0-m-0-iso8859-1
monospaced.italic.latin-1=-monotype-courier new-medium-i-normal--0-0-0-0-m-0-iso8859-1
monospaced.bolditalic.latin-1=-monotype-courier new-bold-i-normal--0-0-0-0-m-0-iso8859-1
最后再 cp 一个你喜欢的中文字体到 xxx/jre/fonts/fallback/
打开 ZDE,设置字体为 monospaced
这下爽了,我顶你个肺!
注意:此方法只在 Ubuntu 下测试通过,另外 Windows 是不适用的,如果是suse或者redhat之类的系统,主意看 xxx/jre/lib 下面的fontconfig.xxxx 文件,与当前系统相关做相应的修改就可以(没试过)
相关网址:http://java.sun.com/j2se/1.5.0/docs/guide/intl/fontconfig.html
其实最简单的解决ZendStudio中文问题方法就是:
(ZDE自带了JRE)
Zendxxx/jre/lib/fonts/
目录下面建一个叫 fallback 的目录,然后 ln 或干脆 cp 一个中文字体进去就OK了,以前还去改什么字体配置文件,真傻B了!
同样sun-jre也是一样的,建立 fallback 目录。
这种方法对 jre1.5 一上版本有效,其他版本据说要修改 lib 下面某个 font开头的文件。
另外说一下,jre1.6 对文字的处理看上去好像调用了操作系统的东西,例如平滑效果。
不知道有没有高人能把 ZendStudio 里的文字效果做成和平果一样的,Courier New 的英文,黑体中文,平滑处理。平果唯一让我怀念的就是这个东西,写代码的时候心情高很多。
升级完发现系统速度居然比6.06更快!
其他都还不错,只是ZDE不能运行了,出现以下错误信息:
Configuring the installer for this system's environment...
nawk: error while loading shared libraries: libm.so.6: cannot open shared object file: No such file or directory
dirname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/bin/ls: error while loading shared libraries: librt.so.1: cannot open shared object file: No such file or directory
basename: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
dirname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
basename: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
hostname: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directoryLaunching installer...
grep: error while loading shared libraries: libc.so.6: cannot open shared object file: No such file or directory
/tmp/install.dir.9288/Linux/resource/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory
尝试手动链接 /usr/lib/ 下的文件也不行,发现原来这些文件在 /lib/ 下都是存在的,google以后找到问题所在,然后看到 http://192.150.14.120/cfusion/knowledgebase/index.cfm?id=tn_18831 写的好像是叫修改版本号,具体的搞不懂 echo $LD_ASSUME_KERNEL 也是空的,最后还是注释刁解决问题:
修改 ZDE 把第1488行注释掉(可能是其他行)。
1448 #export LD_ASSUME_KERNEL=2.2.5
另外安装文件也有同样的问题,看引用文写了个脚本:
#!/bin/bash
if [ "x$1" == "x" ]
then
echo "usage: $0 filename";
fi
newfile="new_$1";
cat $1 | sed "s/export LD_ASSUME_KERNEL/#xport LD_ASSUME_KERNEL/" > $newfile;
chmod +x $newfile;
echo $newfile;
保存为例如 newglibc
$chmod +x newglibc
以后遇到这种问题直接:
$ ./glibcFix ZendStudio-xxx.bin
new_ZendStudio-xxx.bin
$ ./new_ZendStudio-xxx.bin
就可以运行了
好像写得有点白痴,太无聊了吧,想多写两个字。
反正就是莫名其妙的错误,特别是utf-8的页面,出现这种情况的原因大概因为utf-8的编码格式是变长的,规则比较烦,中途少了一个字节或者多了一个字节就容易出现这类问题,后来用ultraedit查看,发现很诡异,都是那种单字节的字符引起的,一些控制码,反正不管怎样,替换掉这些东西就可以了,这些字符本来也不是用来看的。
$xml = preg_replace('#[\x00-\x08\x0e-\x1f\x7f]+#', ", $xml);