16 Jan 2010

记录mysql和php的诡异问题

Loaded Configuration File 被不明原因的指向某个目录下的php.ini ，无法更改，最后将php.ini移出那个目录后解决。但至今没有找到是哪个文件指定了php.ini ？ 让我连重现编译php都无法修改。

令一个问题是由mysql命令引起的，下面是来是php的报错：

Warning: File ‘./cangjk/users.MYD’ not found (Errcode: 24) query: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = ‘675a70120ec04e0085f1b8a0ae2f596e’ in /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc on line 141

Warning: session_start() [function.session-start]: Cannot send session cache limiter – headers already sent (output started at /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc:141) in /home/xiamnn/presite/html/cangjk/includes/bootstrap.inc on line 1492

Warning: File ‘./cangjk/cache.MYD’ not found (Errcode: 24) query: SELECT presite, created, headers, expire, serialized FROM cache WHERE cid = ‘variables’ in /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc on line 141

Warning: File ‘./cangjk/variable.MYD’ not found (Errcode: 24) query: SELECT * FROM variable in /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc on line 141

Warning: File ‘./cangjk/cache.MYD’ not found (Errcode: 24) query: UPDATE cache SET presite = ”, created = 1263630795, expire = 0, headers = ”, serialized = 0 WHERE cid = ‘variables’ in /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc on line 141

Warning: File ‘./cangjk/system.MYD’ not found (Errcode: 24) query: SELECT name, filename, throttle FROM system WHERE type = ‘module’ AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC in /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc on line 141

Warning: Cannot modify header information – headers already sent by (output started at /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc:141) in /home/xiamnn/presite/html/cangjk/includes/bootstrap.inc on line 767

Warning: Cannot modify header information – headers already sent by (output started at /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc:141) in /home/xiamnn/presite/html/cangjk/includes/bootstrap.inc on line 767

Warning: Cannot modify header information – headers already sent by (output started at /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc:141) in /home/xiamnn/presite/html/cangjk/includes/bootstrap.inc on line 767

Warning: File ‘./cangjk/url_alias.MYD’ not found (Errcode: 24) query: SELECT dst FROM url_alias LIMIT 0, 1 in /home/xiamnn/presite/html/cangjk/includes/presitebase.mysql.inc on line 141

这是因为这台服务器曾经用yum安装过mysql，后来虽然被我卸载但是mysql命令还是留了下来。导致php调用mysql的时候还是使用的系统所残留的mysql命令，这就不难理解这个怪异现象了。

[root@www bin]# rm -rf mysql*