分类目录归档：php

WordPress 2.5.1 500 错误解决方法

发表于由
17

随时听人讲有500错误。
今天在楚云blog上重现了。
抓住机会debug。
结果很快出来：
当你第二次用同样的标题并且标题中含有多字节文字时，有很大机会触发wp一个死循环，然后服务器cpu直接到100%，当运行时间超过max_execution_time时候出现500错误。
死循环在这里：wp-include/post.php
[code lang=”php”]
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;
}
}
[/code]
死循环触发点：wp-include/wp-db.php
[code lang=”php”]
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 功能，最好重新设置一遍）

Leopard 编译 universal php5

发表于由
2

因为自带的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的通讯录以拼音排序

发表于由
1

在iphone中安装php
将代码保存为py.php
ssh 登陆iphone或者在iphone安装Term-vt100
执行 php py.php 等待重启完成
结束

支持的中文貌似很有限，拼音表的处理看来要自己搞一个了，这个在网上找的。

py.php

[code lang=”php”]

* @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;
}
}
?>
[/code]

—-
update 把重起iphone改为重启SpringBoard
update 修正代码中一个逻辑错误和改进一个描述 2008/4/6
update iphone 1.1.3 以后，数据库地址改变

再谈 jre / ZendStudio 中文字体问题

发表于由
1

找了若干资料，终于有了结果
原来如此简单：

把 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

再说关于jre的字体问题

发表于由
回复

其实最简单的解决ZendStudio中文问题方法就是：
(ZDE自带了JRE)
Zendxxx/jre/lib/fonts/
目录下面建一个叫 fallback 的目录，然后 ln 或干脆 cp 一个中文字体进去就OK了，以前还去改什么字体配置文件，真傻B了！
同样sun-jre也是一样的，建立 fallback 目录。
这种方法对 jre1.5 一上版本有效，其他版本据说要修改 lib 下面某个 font开头的文件。

另外说一下，jre1.6 对文字的处理看上去好像调用了操作系统的东西，例如平滑效果。

不知道有没有高人能把 ZendStudio 里的文字效果做成和平果一样的，Courier New 的英文，黑体中文，平滑处理。平果唯一让我怀念的就是这个东西，写代码的时候心情高很多。

Ubuntu 6.10 Edgy 下ZendStudio不能运行的问题。

发表于由
3

升级完发现系统速度居然比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 directory

Launching 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

就可以运行了

好像写得有点白痴，太无聊了吧，想多写两个字。

一个常见的xml解析错误解决方法

发表于由
回复

反正就是莫名其妙的错误，特别是utf-8的页面，出现这种情况的原因大概因为utf-8的编码格式是变长的，规则比较烦，中途少了一个字节或者多了一个字节就容易出现这类问题，后来用ultraedit查看，发现很诡异，都是那种单字节的字符引起的，一些控制码，反正不管怎样，替换掉这些东西就可以了，这些字符本来也不是用来看的。

$xml = preg_replace(‘#[\x00-\x08\x0e-\x1f\x7f]+#’, ”, $xml);