sql_error.log 中的錯誤訊息

[ted]

在經過測試 1.2.1 後, 看來是沒有大問題了,所以今天就把blog 由 1.1.4 升級至 1.2.1
我的OS 是 windows 2003
做法是先把原有的blog資料夾備份,然後清空, 再把 1.2.1 的copy 過來

運作起來基本上沒有問題, 但發現在 tmp 下的sql_error.log 中會有錯誤訊息
我看不出來是那裡出了問題, 有人可以幫忙一下嗎?

謝謝

剛裝好,只要瀏覽blog就會有下面的錯誤訊息
D:\AppServ\www\blog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\AppServ\www\blog\class\logger\logger\logger.class.php(137): Logger.log
D:\AppServ\www\blog\class\dao\model.class.php(142): Logger.error
D:\AppServ\www\blog\class\dao\model.class.php(364): Model.Execute
D:\AppServ\www\blog\class\dao\permissions.class.php(29): Model.add
D:\AppServ\www\blog\plugins\templateeditor\plugintemplateeditor.class.php(75): Permissions.addPermission
D:\AppServ\www\blog\class\plugin\pluginmanager.class.php(316): PluginTemplateEditor.register
D:\AppServ\www\blog\class\view\blogview.class.php(270): PluginManager.getPlugins
D:\AppServ\www\blog\class\controller\controller.class.php(379): BlogView.render
D:\AppServ\www\blog\index.php(51): Controller.process
D:\AppServ\www\blog\class\object\loader.class.php(6): include_once
D:\AppServ\www\blog\trackbacks(22): lt_include

 21-04-2007 09:39:16 ERROR - The following query =
INSERT INTO `plog_permissions` (permission, description, core_perm, admin_only) VALUES ('edit_blog_templates', 'edit_blog_templates_desc', '0', '')generated the following error message =
Out of range value adjusted for column 'admin_only' at row 1
D:\AppServ\www\blog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\AppServ\www\blog\class\logger\logger\logger.class.php(137): Logger.log
D:\AppServ\www\blog\class\dao\model.class.php(142): Logger.error
D:\AppServ\www\blog\class\dao\model.class.php(364): Model.Execute
D:\AppServ\www\blog\class\dao\permissions.class.php(29): Model.add
D:\AppServ\www\blog\plugins\templateeditor\plugintemplateeditor.class.php(75): Permissions.addPermission
D:\AppServ\www\blog\class\plugin\pluginmanager.class.php(316): PluginTemplateEditor.register
D:\AppServ\www\blog\class\view\blogview.class.php(270): PluginManager.getPlugins
D:\AppServ\www\blog\class\view\defaultview.class.php(100): BlogView.render
D:\AppServ\www\blog\class\controller\controller.class.php(379): DefaultView.render
D:\AppServ\www\blog\index.php(51): Controller.process
D:\AppServ\www\blog\class\object\loader.class.php(6): include_once
D:\AppServ\www\blog\error.php(40): lt_include
D:\AppServ\www\blog\class\object\loader.class.php(6): include_once
D:\AppServ\www\blog\blog.php(19): lt_include
D:\AppServ\www\blog\blog(8): include_once

 21-04-2007 09:39:25 ERROR - The following query =
INSERT INTO `plog_permissions` (permission, description, core_perm, admin_only) VALUES ('edit_blog_templates', 'edit_blog_templates_desc', '0', '')generated the following error message =
Out of range value adjusted for column 'admin_only' at row 1
D:\AppServ\www\blog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\AppServ\www\blog\class\logger\logger\logger.class.php(137): Logger.log
D:\AppServ\www\blog\class\dao\model.class.php(142): Logger.error
D:\AppServ\www\blog\class\dao\model.class.php(364): Model.Execute
D:\AppServ\www\blog\class\dao\permissions.class.php(29): Model.add
D:\AppServ\www\blog\plugins\templateeditor\plugintemplateeditor.class.php(75): Permissions.addPermission
D:\AppServ\www\blog\class\plugin\pluginmanager.class.php(316): PluginTemplateEditor.register
D:\AppServ\www\blog\class\view\blogview.class.php(270): PluginManager.getPlugins
D:\AppServ\www\blog\class\controller\controller.class.php(379): BlogView.render
D:\AppServ\www\blog\index.php(51): Controller.process
D:\AppServ\www\blog\class\object\loader.class.php(6): include_once
D:\AppServ\www\blog\trackbacks(22): lt_include

 21-04-2007 09:39:26 ERROR - The following query =
INSERT INTO `plog_permissions` (permission, description, core_perm, admin_only) VALUES ('edit_blog_templates', 'edit_blog_templates_desc', '0', '')generated the following error message =
Out of range value adjusted for column 'admin_only' at row 1

[ted]

我已在英文版的論壇提問並獲得解決, 請參見

http://forums.lifetype.net/viewtopic.php?t=6336

[ted]

好不容易問題解決了, 今天又看到一些 error (數量還不少), 看起來好像是跟 comment 有關?! 能否幫忙看看是那裡出了問題? 謝謝

D:\AppServ\www\blog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\AppServ\www\blog\class\logger\logger\logger.class.php(137): Logger.log
D:\AppServ\www\blog\class\dao\model.class.php(142): Logger.error
D:\AppServ\www\blog\class\dao\model.class.php(364): Model.Execute
D:\AppServ\www\blog\class\dao\commentscommon.class.php(58): Model.add
D:\AppServ\www\blog\class\security\bayesianfilter.class.php(123): CommentsCommon.addComment
D:\AppServ\www\blog\class\security\pipeline.class.php(138): BayesianFilter.filter
D:\AppServ\www\blog\class\action\blogaction.class.php(83): Pipeline.process
D:\AppServ\www\blog\class\action\addcommentaction.class.php(42): BlogAction.BlogAction
D:\AppServ\www\blog\class\controller\controller.class.php(340): AddCommentAction.AddCommentAction
D:\AppServ\www\blog\index.php(51): Controller.process

 22-04-2007 14:39:10 ERROR - The following query =
INSERT INTO `plog_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, properties, user_id) VALUES ('195', '1', 'cfiaztbl', ' <a href="http://citiypgu.com">fbhgoqko</a>  ndxswhlx  uuseoanh http://wftvpwwn.com jeuxptfm dtuvsnxx ', '20070422143910', 'smswbbvv@gwhfjwpf.com', 'http://dqyzywau.com', 'cfiaztbl', '0', '122.34.124.162', '0', '1', '0', '1', 'fbhgoqko ndxswhlx uuseoanh http://wftvpwwn.com jeuxptfm dtuvsnxx', 'cfiaztbl', 'a:0:{}', '')generated the following error message =
Out of range value adjusted for column 'user_id' at row 1
D:\AppServ\www\blog\class\logger\logger\logger.class.php(157): PatternLayout.format
D:\AppServ\www\blog\class\logger\logger\logger.class.php(137): Logger.log
D:\AppServ\www\blog\class\dao\model.class.php(142): Logger.error
D:\AppServ\www\blog\class\dao\model.class.php(364): Model.Execute
D:\AppServ\www\blog\class\dao\commentscommon.class.php(58): Model.add
D:\AppServ\www\blog\class\security\bayesianfilter.class.php(123): CommentsCommon.addComment
D:\AppServ\www\blog\class\security\pipeline.class.php(166): BayesianFilter.filter
D:\AppServ\www\blog\class\action\blogaction.class.php(83): Pipeline.process
D:\AppServ\www\blog\class\action\addcommentaction.class.php(42): BlogAction.BlogAction
D:\AppServ\www\blog\class\controller\controller.class.php(340): AddCommentAction.AddCommentAction
D:\AppServ\www\blog\index.php(51): Controller.process


ps. 我看到也有人跟我一樣的情形,但還沒獲得解決就是了
http://forum.lifetype.org.tw/index.php?topic=3598.0

[markwu]

mmm .... 傷腦筋，還是 Mysql5 strict mode 的問題，我今天晚一點再來看，這應該是很快就可以修復了。

Mark

[ted]

謝謝 mark

[markwu]

怪了！我查了一下，這個 bug 我在 1.2.1 中已經修復了啊？你是是用哪一版的？

Mark

[ted]

我用的是 lifetype-1.2.1_r5303