LifeType 中文開發論壇

這是sql_error.log
2
07-07-2005 07:23:39 ERROR - The following query =
SELECT COUNT(*) AS 'count', DAYOFMONTH(date) AS 'day', id AS 'id', date AS 'date' FROM plog_articles WHERE status = 1 AND blog_id = 42 AND date <= NOW() AND MONTH(date) = nt AND YEAR(date) = tale GROUP BY DAYOFMONTH(date);
generated the following error message =
Unknown column 'nt' in 'where clause'
07-07-2005 07:24:10 ERROR - The following query =
SELECT COUNT(*) AS 'count', DAYOFMONTH(date) AS 'day', id AS 'id', date AS 'date' FROM plog_articles WHERE status = 1 AND blog_id = 42 AND date <= NOW() AND MONTH(date) = nt AND YEAR(date) = tale GROUP BY DAYOFMONTH(date);
generated the following error message =
Unknown column 'nt' in 'where clause'

網站開起來是
Exception message: fopen(tmp/sql_error.log): failed to open stream: Permission denied
Error code: 2
-- Backtrace --
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/appender/fileappender.class.php(57): fopen
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/appender/fileappender.class.php(43): fileappender.openfp
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(142): fileappender.fileappender
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(114): loggermanager.createappenderinstance
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(87): loggermanager._loadloggerconfig
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(177): loggermanager.loggermanager
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(192): loggermanager.getinstance
/usr/home/customer/wowtw.game.tw/www/blog/class/template/template.class.php(56): loggermanager.getlogger
/usr/home/customer/wowtw.game.tw/www/blog/class/template/cachedtemplate.class.php(30): cachedtemplate.template
/usr/home/customer/wowtw.game.tw/www/blog/class/template/templateservice.class.php(173): cachedtemplate.cachedtemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/template/templateservice.class.php(112): templateservice.cachedtemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/summary/view/summarycachedview.class.php(35): templateservice.customtemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/summary/view/summarycachedview.class.php(29): summarycachedview.generatetemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/summary/action/summarydefaultaction.class.php(31): summarycachedview.summarycachedview
/usr/home/customer/wowtw.game.tw/www/blog/class/controller/controller.class.php(305): summarydefaultaction.perform
/usr/home/customer/wowtw.game.tw/www/blog/summary.php(80): summarycontroller.process

Exception message: Cannot open log file: tmp/sql_error.log
Error code: 0
-- Backtrace --
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/appender/fileappender.class.php(59): throw
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/appender/fileappender.class.php(43): fileappender.openfp
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(142): fileappender.fileappender
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(114): loggermanager.createappenderinstance
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(87): loggermanager._loadloggerconfig
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(177): loggermanager.loggermanager
/usr/home/customer/wowtw.game.tw/www/blog/class/logger/loggermanager.class.php(192): loggermanager.getinstance
/usr/home/customer/wowtw.game.tw/www/blog/class/template/template.class.php(56): loggermanager.getlogger
/usr/home/customer/wowtw.game.tw/www/blog/class/template/cachedtemplate.class.php(30): cachedtemplate.template
/usr/home/customer/wowtw.game.tw/www/blog/class/template/templateservice.class.php(173): cachedtemplate.cachedtemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/template/templateservice.class.php(112): templateservice.cachedtemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/summary/view/summarycachedview.class.php(35): templateservice.customtemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/summary/view/summarycachedview.class.php(29): summarycachedview.generatetemplate
/usr/home/customer/wowtw.game.tw/www/blog/class/summary/action/summarydefaultaction.class.php(31): summarycachedview.summarycachedview
/usr/home/customer/wowtw.game.tw/www/blog/class/controller/controller.class.php(305): summarydefaultaction.perform
/usr/home/customer/wowtw.game.tw/www/blog/summary.php(80): summarycontroller.process

不知道發生什麼問題-.- 麻煩各位指導一下，非常感謝.........

發問前請先參考
http://forum.lifetype.org.tw/index.php?topic=2.0

另外這個問題是剛裝好就出現，還是用了一段時間才出現的，中間有任何的環境變動嗎?

Hi ginnywen:

如果這是你的錯誤訊息

Exception message: fopen(tmp/sql_error.log): failed to open stream: Permission denied

那表示你的這個檔案室無法寫入或是開啟的，你能確認他的屬性嗎？必須要是 777 或是 apache 這個 owner能夠修改才行。

另外，要不然就直接把這個檔案砍掉，再試試。

Mark