1.03迴響時出現問題

引用自: markwu 於七月 03, 2006, 02:39:25 下午

下次有這樣的問題，請把

1. Apache 的 error.log, 與
2. ./tmp/sql_error.log

一起貼上來，這樣才好幫你找問題。

Mark

這些天機器很不穩定，Apache一直當掉，我就重灌，倒回資料庫第一次還正常，再灌再倒，問題就來了，部落格也是迴響時發生「將留言新增至資料庫時發生問題」，新增文章時，發表之後是空白的，但是舊文章可以修改發表。

Apache還是很不穩定，最急迫要解決的是blog問題：

1.sql_error.log

程式碼:

D:\stes_site\htdocs\stesblog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\stes_site\htdocs\stesblog\class\logger\logger\logger.class.php(137): Logger.log
D:\stes_site\htdocs\stesblog\class\dao\model.class.php(146): Logger.error
D:\stes_site\htdocs\stesblog\class\dao\model.class.php(402): Model.Execute
D:\stes_site\htdocs\stesblog\class\dao\commentscommon.class.php(57): Model.add
D:\stes_site\htdocs\stesblog\class\action\addcommentaction.class.php(184): CommentsCommon.addComment
D:\stes_site\htdocs\stesblog\class\controller\controller.class.php(310): AddCommentAction.perform
D:\stes_site\htdocs\stesblog\index.php(50): Controller.process

 24-12-2006 20:32:24 ERROR - The following query = 
INSERT INTO `lt_articles_comments` (article_id, blog_id, topic, text, date, user_email, user_url, user_name, parent_id, client_ip, send_notification, status, spam_rate, type, normalized_text, normalized_topic) VALUES ('1513', '6', '', '<p>test</p>
', '20061224203224', '', '', 'yunol', '0', '220.134.97.225', '0', '0', '0', '1', 'test', '')generated the following error message = 
Field 'properties' doesn't have a default value
D:\stes_site\htdocs\stesblog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\stes_site\htdocs\stesblog\class\logger\logger\logger.class.php(137): Logger.log
D:\stes_site\htdocs\stesblog\class\dao\model.class.php(146): Logger.error
D:\stes_site\htdocs\stesblog\class\dao\model.class.php(444): Model.Execute
D:\stes_site\htdocs\stesblog\class\dao\articlecategories.class.php(296): Model.update
D:\stes_site\htdocs\stesblog\class\dao\articles.class.php(702): ArticleCategories.updateCategory
D:\stes_site\htdocs\stesblog\class\dao\articles.class.php(721): Articles.deletePostCategoriesLink
D:\stes_site\htdocs\stesblog\class\dao\articles.class.php(959): Articles.updatePostCategoriesLink
D:\stes_site\htdocs\stesblog\class\action\admin\adminupdatepostaction.class.php(121): Articles.updateArticle
D:\stes_site\htdocs\stesblog\class\controller\controller.class.php(310): AdminUpdatePostAction.perform
D:\stes_site\htdocs\stesblog\admin.php(43): Controller.process

 24-12-2006 20:33:19 ERROR - The following query = 
UPDATE `lt_articles_categories` SET `name`='大自然', `url`='', `blog_id`='6', `parent_id`='', `description`='大自然', `in_main_page`='1', `last_modification`='2006-12-21 14:30:43', `properties`='', `num_articles`='16', `num_published_articles`='16', `mangled_name`='ec' WHERE id = '18'generated the following error message = 
Out of range value adjusted for column 'parent_id' at row 1
D:\stes_site\htdocs\stesblog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\stes_site\htdocs\stesblog\class\logger\logger\logger.class.php(137): Logger.log
D:\stes_site\htdocs\stesblog\class\dao\model.class.php(146): Logger.error
D:\stes_site\htdocs\stesblog\class\dao\model.class.php(444): Model.Execute
D:\stes_site\htdocs\stesblog\class\dao\articlecategories.class.php(296): Model.update
D:\stes_site\htdocs\stesblog\class\dao\articles.class.php(674): ArticleCategories.updateCategory
D:\stes_site\htdocs\stesblog\class\dao\articles.class.php(725): Articles.addPostCategoriesLink
D:\stes_site\htdocs\stesblog\class\dao\articles.class.php(959): Articles.updatePostCategoriesLink
D:\stes_site\htdocs\stesblog\class\action\admin\adminupdatepostaction.class.php(121): Articles.updateArticle
D:\stes_site\htdocs\stesblog\class\controller\controller.class.php(310): AdminUpdatePostAction.perform
D:\stes_site\htdocs\stesblog\admin.php(43): Controller.process

2.Apache的error.log並沒什麼警告

程式碼:

[Mon Dec 25 04:32:50 2006] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Mon Dec 25 04:32:50 2006] [notice] Apache/2.2.2 (Win32) PHP/5.1.4 configured -- resuming normal operations
[Mon Dec 25 04:32:50 2006] [notice] Server built: Apr 29 2006 18:32:31
[Mon Dec 25 04:32:50 2006] [notice] Parent: Created child process 1652
[Mon Dec 25 04:32:50 2006] [notice] Disabled use of AcceptEx() WinSock2 API
[Mon Dec 25 04:32:50 2006] [notice] Child 1652: Child process is running
[Mon Dec 25 04:32:50 2006] [notice] Child 1652: Acquired the start mutex.
[Mon Dec 25 04:32:50 2006] [notice] Child 1652: Starting 64 worker threads.
[Mon Dec 25 04:32:50 2006] [notice] Child 1652: Listening on port 8080.
[Mon Dec 25 04:32:57 2006] [error] [client 220.181.19.187] File does not exist: D:/stes_site/htdocs/yunol/learning/pc7f.htm
[Mon Dec 25 04:33:01 2006] [error] [client 220.181.19.187] File does not exist: D:/stes_site/htdocs/yunol/learning/pc8f.htm
[Mon Dec 25 04:33:16 2006] [error] [client 220.181.19.187] File does not exist: D:/stes_site/htdocs/yunol/learning/pc9f.htm
[Mon Dec 25 04:34:37 2006] [error] [client 220.181.19.187] File does not exist: D:/stes_site/htdocs/yunol/stes/edu/92computest
[Mon Dec 25 04:34:57 2006] [error] [client 220.181.19.187] File does not exist: D:/stes_site/htdocs/yunol/stes/dwmx/htm
[Mon Dec 25 04:36:13 2006] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Mon Dec 25 04:36:13 2006] [notice] Apache/2.2.2 (Win32) PHP/5.1.4 configured -- resuming normal operations
[Mon Dec 25 04:36:13 2006] [notice] Server built: Apr 29 2006 18:32:31
[Mon Dec 25 04:36:13 2006] [notice] Parent: Created child process 272
[Mon Dec 25 04:36:13 2006] [notice] Disabled use of AcceptEx() WinSock2 API
[Mon Dec 25 04:36:13 2006] [notice] Child 272: Child process is running
[Mon Dec 25 04:36:13 2006] [notice] Child 272: Acquired the start mutex.
[Mon Dec 25 04:36:13 2006] [notice] Child 272: Starting 64 worker threads.
[Mon Dec 25 04:36:13 2006] [notice] Child 272: Listening on port 8080.

環境：
WinXP
Appserv2.5.6
麻煩各位，先謝過囉！