主題: sql_error.log 中的錯誤訊息 作者: ted 於 四月 21, 2007, 12:48:03 下午 在經過測試 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 主題: Re: sql_error.log 中的錯誤訊息 作者: ted 於 四月 22, 2007, 02:32:49 下午 我已在英文版的論壇提問並獲得解決, 請參見
http://forums.lifetype.net/viewtopic.php?t=6336 主題: Re: sql_error.log 中的錯誤訊息 作者: ted 於 四月 23, 2007, 04:57:08 上午 好不容易問題解決了, 今天又看到一些 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 (http://hvfbyvfa.com) 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 (http://hvfbyvfa.com) 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 主題: Re: sql_error.log 中的錯誤訊息 作者: markwu 於 四月 24, 2007, 04:30:27 上午 mmm .... 傷腦筋,還是 Mysql5 strict mode 的問題,我今天晚一點再來看,這應該是很快就可以修復了。
Mark 主題: Re: sql_error.log 中的錯誤訊息 作者: ted 於 四月 24, 2007, 10:44:11 上午 謝謝 mark :-)
主題: Re: sql_error.log 中的錯誤訊息 作者: markwu 於 四月 26, 2007, 01:46:27 下午 怪了!我查了一下,這個 bug 我在 1.2.1 中已經修復了啊?你是是用哪一版的?
Mark 主題: Re: sql_error.log 中的錯誤訊息 作者: ted 於 四月 26, 2007, 02:23:21 下午 我用的是 lifetype-1.2.1_r5303
|