|
1
|
# Logfile created on Thu Apr 15 14:55:01 +0800 2010 [4;36;1mSQL (0.0ms)[0m [0;1mSET NAMES 'utf8'[0m
|
|
2
|
[4;35;1mSQL (0.0ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m
|
|
3
|
[4;36;1mSQL (0.0ms)[0m [0;1mSET NAMES 'utf8'[0m
|
|
4
|
[4;35;1mSQL (0.0ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m
|
|
5
|
|
|
6
|
|
|
7
|
Processing WelcomeController#index (for 10.50.240.158 at 2010-04-15 14:56:24) [GET]
|
|
8
|
Parameters: {"action"=>"index", "controller"=>"welcome"}
|
|
9
|
[4;36;1mSetting Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
|
10
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
|
11
|
[4;36;1mUser Columns (16.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
|
12
|
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
|
13
|
[4;36;1mNews Columns (15.0ms)[0m [0;1mSHOW FIELDS FROM `news`[0m
|
|
14
|
[4;35;1mProject Columns (0.0ms)[0m [0mSHOW FIELDS FROM `projects`[0m
|
|
15
|
[4;36;1mNews Load Including Associations (0.0ms)[0m [0;1mSELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5[0m
|
|
16
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5[0m
|
|
17
|
Rendering template within layouts/base
|
|
18
|
Rendering welcome/index
|
|
19
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1[0m
|
|
20
|
[4;35;1mUserPreference Load (0.0ms)[0m [0mSELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1[0m
|
|
21
|
[4;36;1mUserPreference Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `user_preferences`[0m
|
|
22
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
|
|
23
|
[4;36;1mToken Load (0.0ms)[0m [0;1mSELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1[0m
|
|
24
|
[4;35;1mToken Columns (15.0ms)[0m [0mSHOW FIELDS FROM `tokens`[0m
|
|
25
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
|
26
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
|
27
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
|
28
|
[4;35;1mProject Load (16.0ms)[0m [0mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) [0m
|
|
29
|
Completed in 2016ms (View: 1829, DB: 62) | 200 OK [http://10.50.241.20/]
|
|
30
|
[4;36;1mSQL (0.0ms)[0m [0;1mSET NAMES 'utf8'[0m
|
|
31
|
[4;35;1mSQL (0.0ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m
|
|
32
|
|
|
33
|
|
|
34
|
Processing AccountController#logout (for 10.50.240.158 at 2010-04-15 14:57:39) [GET]
|
|
35
|
Parameters: {"action"=>"logout", "controller"=>"account"}
|
|
36
|
[4;36;1mSetting Columns (16.0ms)[0m [0;1mSHOW FIELDS FROM `settings`[0m
|
|
37
|
[4;35;1mSQL (0.0ms)[0m [0mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
|
38
|
[4;36;1mUser Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
|
39
|
[4;35;1mUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) [0m
|
|
40
|
[4;36;1mToken Delete all (0.0ms)[0m [0;1mDELETE FROM `tokens` WHERE (user_id = 3 AND action = 'autologin') [0m
|
|
41
|
[4;35;1mAnonymousUser Columns (0.0ms)[0m [0mSHOW FIELDS FROM `users`[0m
|
|
42
|
[4;36;1mAnonymousUser Load (0.0ms)[0m [0;1mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
|
43
|
Redirected to http://10.50.241.20:3000/
|
|
44
|
Completed in 78ms (DB: 16) | 302 Found [http://10.50.241.20/logout]
|
|
45
|
[4;35;1mSQL (0.0ms)[0m [0mSET NAMES 'utf8'[0m
|
|
46
|
[4;36;1mSQL (0.0ms)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m
|
|
47
|
|
|
48
|
|
|
49
|
Processing WelcomeController#index (for 10.50.240.158 at 2010-04-15 14:57:46) [GET]
|
|
50
|
Parameters: {"action"=>"index", "controller"=>"welcome"}
|
|
51
|
[4;35;1mSetting Columns (0.0ms)[0m [0mSHOW FIELDS FROM `settings`[0m
|
|
52
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
|
53
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1[0m
|
|
54
|
[4;36;1mAnonymousUser Columns (15.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
|
55
|
[4;35;1mAnonymousUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
|
56
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'login_required') LIMIT 1[0m
|
|
57
|
[4;35;1mRole Load (0.0ms)[0m [0mSELECT * FROM `roles` WHERE (`roles`.`builtin` = 2) LIMIT 1[0m
|
|
58
|
[4;36;1mRole Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `roles`[0m
|
|
59
|
[4;35;1mNews Columns (0.0ms)[0m [0mSHOW FIELDS FROM `news`[0m
|
|
60
|
[4;36;1mUser Columns (16.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
|
61
|
[4;35;1mProject Columns (0.0ms)[0m [0mSHOW FIELDS FROM `projects`[0m
|
|
62
|
[4;36;1mNews Load Including Associations (0.0ms)[0m [0;1mSELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (1=0 OR projects.is_public = 1))) ORDER BY news.created_on DESC LIMIT 5[0m
|
|
63
|
[4;35;1mMember Columns (0.0ms)[0m [0mSHOW FIELDS FROM `members`[0m
|
|
64
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT count(DISTINCT `members`.id) AS count_all FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 2 AND (projects.status=1)) [0m
|
|
65
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT * FROM `projects` WHERE (projects.status=1 AND projects.is_public = 1) ORDER BY created_on DESC LIMIT 5[0m
|
|
66
|
Rendering template within layouts/base
|
|
67
|
Rendering welcome/index
|
|
68
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1[0m
|
|
69
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1[0m
|
|
70
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
|
71
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
|
72
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
|
73
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1[0m
|
|
74
|
[4;36;1mProject Load (0.0ms)[0m [0;1mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 2) AND ((projects.status=1))) [0m
|
|
75
|
Completed in 1532ms (View: 1391, DB: 31) | 200 OK [http://10.50.241.20/]
|
|
76
|
[4;35;1mSQL (0.0ms)[0m [0mSET NAMES 'utf8'[0m
|
|
77
|
[4;36;1mSQL (0.0ms)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m
|
|
78
|
|
|
79
|
|
|
80
|
Processing AccountController#login (for 10.50.240.158 at 2010-04-15 14:59:06) [GET]
|
|
81
|
Parameters: {"action"=>"login", "controller"=>"account"}
|
|
82
|
[4;35;1mSetting Columns (0.0ms)[0m [0mSHOW FIELDS FROM `settings`[0m
|
|
83
|
[4;36;1mSQL (0.0ms)[0m [0;1mSELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` [0m
|
|
84
|
[4;35;1mSetting Load (15.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1[0m
|
|
85
|
[4;36;1mAnonymousUser Columns (0.0ms)[0m [0;1mSHOW FIELDS FROM `users`[0m
|
|
86
|
[4;35;1mAnonymousUser Load (0.0ms)[0m [0mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
|
87
|
[4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1[0m
|
|
88
|
Rendering template within layouts/base
|
|
89
|
Rendering account/login
|
|
90
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1[0m
|
|
91
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1[0m
|
|
92
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1[0m
|
|
93
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1[0m
|
|
94
|
[4;35;1mSetting Load (0.0ms)[0m [0mSELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1[0m
|
|
95
|
[4;36;1mSetting Load (0.0ms)[0m [0;1mSELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1[0m
|
|
96
|
[4;35;1mProject Load (0.0ms)[0m [0mSELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 2) AND ((projects.status=1))) [0m
|
|
97
|
Completed in 1015ms (View: 969, DB: 15) | 200 OK [http://10.50.241.20/login]
|