/* About ----- This directory contains extra files to make the 'fancy urls' feature even more fancier, by eliminating the 'index.php'-part of the URL Installation ------------ 1. Copy all files in this directory (except for index.html) to your main nucleus dir (where your index.php and action.php file are) If you have an already existing .htaccess file (most ftp-programs don't show hidden files by default, so don't start uploading it without checking your server). If you do, download that old one first, and copy the contents of the new .htaccess file (from the fancyurls folder) in your old one, and upload that... 2. Edit this file so that $CONF['Self'] points to your main directory. NOTE: this time, and only this time, the URL should NOT end in a slash 3. Also edit the $CONF['Self'] variable in your index.php, if you don't want to end up with index.php/item/1234 urls when people come via that way 4. Enable 'Fancy URLs' in the Nucleus admin area (nucleus management / edit settings) 5. Off you go! If it doesn't work: ------------------- Remove the files again (don't forget the hidden file .htaccess). Voila. */ // remember: this URL should _NOT_ end with a slash. $CONF['Self'] = 'http://www.momoso-net.com/~ms08'; ?>
2006-11-09: MySQL5へバージョンアップ
とりあえず現在はこんな感じです。
gentooez8 ~ # emerge -pv mysql
These are the packages that would be merged, in order:
Calculating dependencies... done!
[ebuild U ] dev-db/mysql-5.0.26-r1 [4.1.21] USE="berkdb latin1 perl ssl -big-tables -cluster -debug -embedded -extraengine -max-idx-128% -minimal (-selinux) -srvdir -static (-raid%)" 25,380 kB
Total size of downloads: 25,380 kB
それではバージョンアップをします。
gentooez8 ~ # emerge -u mysql
終わるまで待つ。終わったらmysqlの依存関係をチェックする。
gentooez8 ~ # equery d mysql
[ Searching for packages depending on mysql... ]
net-libs/courier-authlib-0.58
net-libs/libwww-5.4.0-r7
dev-lang/php-5.1.6-r6
gnome-extra/libgda-1.2.3
dev-perl/DBD-mysql-2.9007
dev-libs/cyrus-sasl-2.1.22-r1
net-fs/samba-3.0.22-r3
net-dns/bind-9.3.2-r4
x11-libs/qt-4.1.4-r2
x11-libs/qt-3.3.6-r1
net-ftp/proftpd-1.3.0-r2
net-analyzer/snort-2.4.5
net-www/mod_auth_mysql-3.0.0
こんな感じなんだけど時間はかかるが全てコンパイルします。
あとはMySQLを再起動して終了だったのだがこんなところに落とし穴が!!
nucleusのプラグインNP_MultipleCategories.phpがこんなメッセージをだしてしまった。
mySQL error with query SELECT i.inumber as itemid, i.ititle as title, i.ibody as body, m.mname as author, m.mrealname as authorname, UNIX_TIMESTAMP(i.itime) as timestamp, i.itime, i.imore as more, m.mnumber as authorid, c.cname as category, i.icat as catid, i.iclosed as closed FROM nucleus_item as i, nucleus_member as m, nucleus_category as c LEFT JOIN nucleus_plug_multiple_categories as p ON i.inumber=p.item_id WHERE i.iauthor=m.mnumber and i.iblog=1 and i.icat=c.catid and i.idraft=0 and i.itime<="2006-11-09 13:20:28" and ((i.inumber=p.item_id and (p.categories REGEXP "(^|,)6(,|$)" or i.icat=6)) or (i.icat=6 and p.item_id IS NULL)) ORDER BY i.itime DESC LIMIT 0,20: Unknown column 'i.inumber' in 'on clause'
これはPHP5とMySQL5が問題なんだとか。
NP_MultipleCategories.phpの中2ヶ所を修正しなくてはいけないようです。
$query .= ' FROM '.sql_table('item').' as i, '.sql_table('member').' as m, '.sql_table('category').' as c';
↓
$query .= ' FROM '.sql_table('category').' as c, '.sql_table('member').' as m, '.sql_table('item').' as i';
いまのところ大丈夫!
Category: Gentoo Linux No Trackbacks