ChiliProject is not maintained anymore. Please be advised that there will be no more updates.
We do not recommend that you setup new ChiliProject instances and we urge all existing users to migrate their data to a maintained system, e.g. Redmine. We will provide a migration script later. In the meantime, you can use the instructions by Christian Daehn.
chili1.txt
1 | # RAILS_ENV="production" rake db:migrate |
---|---|
2 | == BuildProjectsTree: migrating ============================================== |
3 | == BuildProjectsTree: migrated (0.4724s) ===================================== |
4 | |
5 | == RemoveProjectsProjectsCount: migrating ==================================== |
6 | -- remove_column(:projects, :projects_count) |
7 | -> 0.1241s |
8 | == RemoveProjectsProjectsCount: migrated (0.1243s) =========================== |
9 | |
10 | == AddOpenIdAuthenticationTables: migrating ================================== |
11 | -- create_table(:open_id_authentication_associations, {:force=>true}) |
12 | -> 0.0722s |
13 | -- create_table(:open_id_authentication_nonces, {:force=>true}) |
14 | -> 0.0833s |
15 | == AddOpenIdAuthenticationTables: migrated (0.1558s) ========================= |
16 | |
17 | == AddIdentityUrlToUsers: migrating ========================================== |
18 | -- add_column(:users, :identity_url, :string) |
19 | -> 0.1077s |
20 | == AddIdentityUrlToUsers: migrated (0.1078s) ================================= |
21 | |
22 | == AddWatchersUserIdTypeIndex: migrating ===================================== |
23 | -- add_index(:watchers, [:user_id, :watchable_type], {:name=>:watchers_user_id_type}) |
24 | -> 0.2011s |
25 | == AddWatchersUserIdTypeIndex: migrated (0.2013s) ============================ |
26 | |
27 | == AddQueriesSortCriteria: migrating ========================================= |
28 | -- add_column(:queries, :sort_criteria, :text) |
29 | -> 0.1076s |
30 | == AddQueriesSortCriteria: migrated (0.1077s) ================================ |
31 | |
32 | == AddProjectsTrackersUniqueIndex: migrating ================================= |
33 | -- add_index(:projects_trackers, [:project_id, :tracker_id], {:unique=>true, :name=>:projects_trackers_unique}) |
34 | -> 0.1117s |
35 | == AddProjectsTrackersUniqueIndex: migrated (0.1328s) ======================== |
36 | |
37 | == ExtendSettingsName: migrating ============================================= |
38 | -- change_column(:settings, :name, :string, {:null=>false, :limit=>255, :default=>""}) |
39 | -> 0.1253s |
40 | == ExtendSettingsName: migrated (0.1255s) ==================================== |
41 | |
42 | == AddTypeToEnumerations: migrating ========================================== |
43 | -- add_column(:enumerations, :type, :string) |
44 | -> 0.0993s |
45 | == AddTypeToEnumerations: migrated (0.0994s) ================================= |
46 | |
47 | == UpdateEnumerationsToSti: migrating ======================================== |
48 | == UpdateEnumerationsToSti: migrated (0.0410s) =============================== |
49 | |
50 | == AddActiveFieldToEnumerations: migrating =================================== |
51 | -- add_column(:enumerations, :active, :boolean, {:null=>false, :default=>true}) |
52 | -> 0.1076s |
53 | == AddActiveFieldToEnumerations: migrated (0.1078s) ========================== |
54 | |
55 | == AddProjectToEnumerations: migrating ======================================= |
56 | -- add_column(:enumerations, :project_id, :integer, {:null=>true, :default=>nil}) |
57 | -> 0.1076s |
58 | -- add_index(:enumerations, :project_id) |
59 | -> 0.1916s |
60 | == AddProjectToEnumerations: migrated (0.3083s) ============================== |
61 | |
62 | == AddParentIdToEnumerations: migrating ====================================== |
63 | -- add_column(:enumerations, :parent_id, :integer, {:null=>true, :default=>nil}) |
64 | -> 0.0993s |
65 | == AddParentIdToEnumerations: migrated (0.0994s) ============================= |
66 | |
67 | == AddQueriesGroupBy: migrating ============================================== |
68 | -- add_column(:queries, :group_by, :string) |
69 | -> 0.0995s |
70 | == AddQueriesGroupBy: migrated (0.0996s) ===================================== |
71 | |
72 | == CreateMemberRoles: migrating ============================================== |
73 | -- create_table(:member_roles) |
74 | -> 0.0659s |
75 | == CreateMemberRoles: migrated (0.0661s) ===================================== |
76 | |
77 | == PopulateMemberRoles: migrating ============================================ |
78 | == PopulateMemberRoles: migrated (0.9319s) =================================== |
79 | |
80 | == DropMembersRoleId: migrating ============================================== |
81 | -- remove_column(:members, :role_id) |
82 | -> 0.1164s |
83 | == DropMembersRoleId: migrated (0.1165s) ===================================== |
84 | |
85 | == FixMessagesStickyNull: migrating ========================================== |
86 | == FixMessagesStickyNull: migrated (0.0077s) ================================= |
87 | |
88 | == PopulateUsersType: migrating ============================================== |
89 | == PopulateUsersType: migrated (0.0162s) ===================================== |
90 | |
91 | == CreateGroupsUsers: migrating ============================================== |
92 | -- create_table(:groups_users, {:id=>false}) |
93 | -> 0.0659s |
94 | -- add_index(:groups_users, [:group_id, :user_id], {:unique=>true, :name=>:groups_users_ids}) |
95 | -> 0.0916s |
96 | == CreateGroupsUsers: migrated (0.1578s) ===================================== |
97 | |
98 | == AddMemberRolesInheritedFrom: migrating ==================================== |
99 | -- add_column(:member_roles, :inherited_from, :integer) |
100 | -> 0.0995s |
101 | == AddMemberRolesInheritedFrom: migrated (0.0996s) =========================== |
102 | |
103 | == FixUsersCustomValues: migrating =========================================== |
104 | == FixUsersCustomValues: migrated (0.0025s) ================================== |
105 | |
106 | == AddMissingIndexesToWorkflows: migrating =================================== |
107 | -- add_index(:workflows, :old_status_id) |
108 | -> 0.1247s |
109 | -- add_index(:workflows, :role_id) |
110 | -> 0.1836s |
111 | -- add_index(:workflows, :new_status_id) |
112 | -> 0.1256s |
113 | == AddMissingIndexesToWorkflows: migrated (0.4343s) ========================== |
114 | |
115 | == AddMissingIndexesToCustomFieldsProjects: migrating ======================== |
116 | -- add_index(:custom_fields_projects, [:custom_field_id, :project_id]) |
117 | -> 0.0995s |
118 | == AddMissingIndexesToCustomFieldsProjects: migrated (0.0996s) =============== |
119 | |
120 | == AddMissingIndexesToMessages: migrating ==================================== |
121 | -- add_index(:messages, :last_reply_id) |
122 | -> 0.1163s |
123 | -- add_index(:messages, :author_id) |
124 | -> 0.1169s |
125 | == AddMissingIndexesToMessages: migrated (0.2334s) =========================== |
126 | |
127 | == AddMissingIndexesToRepositories: migrating ================================ |
128 | -- add_index(:repositories, :project_id) |
129 | -> 0.1078s |
130 | == AddMissingIndexesToRepositories: migrated (0.1080s) ======================= |
131 | |
132 | == AddMissingIndexesToComments: migrating ==================================== |
133 | -- add_index(:comments, [:commented_id, :commented_type]) |
134 | -> 0.1078s |
135 | -- add_index(:comments, :author_id) |
136 | -> 0.1000s |
137 | == AddMissingIndexesToComments: migrated (0.2080s) =========================== |
138 | |
139 | == AddMissingIndexesToEnumerations: migrating ================================ |
140 | -- add_index(:enumerations, [:id, :type]) |
141 | -> 0.1495s |
142 | == AddMissingIndexesToEnumerations: migrated (0.1496s) ======================= |
143 | |
144 | == AddMissingIndexesToWikiPages: migrating =================================== |
145 | -- add_index(:wiki_pages, :wiki_id) |
146 | -> 0.1162s |
147 | -- add_index(:wiki_pages, :parent_id) |
148 | -> 0.1086s |
149 | == AddMissingIndexesToWikiPages: migrated (0.2250s) ========================== |
150 | |
151 | == AddMissingIndexesToWatchers: migrating ==================================== |
152 | -- add_index(:watchers, :user_id) |
153 | -> 0.1867s |
154 | -- add_index(:watchers, [:watchable_id, :watchable_type]) |
155 | -> 0.2283s |
156 | == AddMissingIndexesToWatchers: migrated (0.4152s) =========================== |
157 | |
158 | == AddMissingIndexesToAuthSources: migrating ================================= |
159 | -- add_index(:auth_sources, [:id, :type]) |
160 | -> 0.1036s |
161 | == AddMissingIndexesToAuthSources: migrated (0.1038s) ======================== |
162 | |
163 | == AddMissingIndexesToDocuments: migrating =================================== |
164 | -- add_index(:documents, :category_id) |
165 | -> 0.1203s |
166 | == AddMissingIndexesToDocuments: migrated (0.1204s) ========================== |
167 | |
168 | == AddMissingIndexesToTokens: migrating ====================================== |
169 | -- add_index(:tokens, :user_id) |
170 | -> 0.1579s |
171 | == AddMissingIndexesToTokens: migrated (0.1580s) ============================= |
172 | |
173 | == AddMissingIndexesToChangesets: migrating ================================== |
174 | -- add_index(:changesets, :user_id) |
175 | -> 0.1116s |
176 | -- add_index(:changesets, :repository_id) |
177 | -> 0.1083s |
178 | == AddMissingIndexesToChangesets: migrated (0.2200s) ========================= |
179 | |
180 | == AddMissingIndexesToIssueCategories: migrating ============================= |
181 | -- add_index(:issue_categories, :assigned_to_id) |
182 | -> 0.1076s |
183 | == AddMissingIndexesToIssueCategories: migrated (0.1077s) ==================== |
184 | |
185 | == AddMissingIndexesToMemberRoles: migrating ================================= |
186 | -- add_index(:member_roles, :member_id) |
187 | -> 0.0994s |
188 | -- add_index(:member_roles, :role_id) |
189 | -> 0.1082s |
190 | == AddMissingIndexesToMemberRoles: migrated (0.2078s) ======================== |
191 | |
192 | == AddMissingIndexesToBoards: migrating ====================================== |
193 | -- add_index(:boards, :last_message_id) |
194 | -> 0.1046s |
195 | == AddMissingIndexesToBoards: migrated (0.1047s) ============================= |
196 | |
197 | == AddMissingIndexesToUserPreferences: migrating ============================= |
198 | -- add_index(:user_preferences, :user_id) |
199 | -> 0.1078s |
200 | == AddMissingIndexesToUserPreferences: migrated (0.1079s) ==================== |
201 | |
202 | == AddMissingIndexesToIssues: migrating ====================================== |
203 | -- add_index(:issues, :status_id) |
204 | -> 0.1715s |
205 | -- add_index(:issues, :category_id) |
206 | -> 0.1940s |
207 | -- add_index(:issues, :assigned_to_id) |
208 | -> 0.1369s |
209 | -- add_index(:issues, :fixed_version_id) |
210 | -> 0.1535s |
211 | -- add_index(:issues, :tracker_id) |
212 | -> 0.1616s |
213 | -- add_index(:issues, :priority_id) |
214 | -> 0.1629s |
215 | -- add_index(:issues, :author_id) |
216 | -> 0.1785s |
217 | == AddMissingIndexesToIssues: migrated (1.1596s) ============================= |
218 | |
219 | == AddMissingIndexesToMembers: migrating ===================================== |
220 | -- add_index(:members, :user_id) |
221 | -> 0.1161s |
222 | -- add_index(:members, :project_id) |
223 | -> 0.1084s |
224 | == AddMissingIndexesToMembers: migrated (0.2247s) ============================ |
225 | |
226 | == AddMissingIndexesToCustomFields: migrating ================================ |
227 | -- add_index(:custom_fields, [:id, :type]) |
228 | -> 0.0994s |
229 | == AddMissingIndexesToCustomFields: migrated (0.0996s) ======================= |
230 | |
231 | == AddMissingIndexesToQueries: migrating ===================================== |
232 | -- add_index(:queries, :project_id) |
233 | -> 0.0993s |
234 | -- add_index(:queries, :user_id) |
235 | -> 0.1000s |
236 | == AddMissingIndexesToQueries: migrated (0.1995s) ============================ |
237 | |
238 | == AddMissingIndexesToTimeEntries: migrating ================================= |
239 | -- add_index(:time_entries, :activity_id) |
240 | -> 0.0994s |
241 | -- add_index(:time_entries, :user_id) |
242 | -> 0.1334s |
243 | == AddMissingIndexesToTimeEntries: migrated (0.2331s) ======================== |
244 | |
245 | == AddMissingIndexesToNews: migrating ======================================== |
246 | -- add_index(:news, :author_id) |
247 | -> 0.1535s |
248 | == AddMissingIndexesToNews: migrated (0.1536s) =============================== |
249 | |
250 | == AddMissingIndexesToUsers: migrating ======================================= |
251 | -- add_index(:users, [:id, :type]) |
252 | -> 0.1205s |
253 | -- add_index(:users, :auth_source_id) |
254 | -> 0.1084s |
255 | == AddMissingIndexesToUsers: migrated (0.2291s) ============================== |
256 | |
257 | == AddMissingIndexesToAttachments: migrating ================================= |
258 | -- add_index(:attachments, [:container_id, :container_type]) |
259 | -> 0.1167s |
260 | -- add_index(:attachments, :author_id) |
261 | -> 0.1257s |
262 | == AddMissingIndexesToAttachments: migrated (0.2427s) ======================== |
263 | |
264 | == AddMissingIndexesToWikiContents: migrating ================================ |
265 | -- add_index(:wiki_contents, :author_id) |
266 | -> 0.1399s |
267 | == AddMissingIndexesToWikiContents: migrated (0.1400s) ======================= |
268 | |
269 | == AddMissingIndexesToCustomValues: migrating ================================ |
270 | -- add_index(:custom_values, :custom_field_id) |
271 | -> 0.0993s |
272 | == AddMissingIndexesToCustomValues: migrated (0.0994s) ======================= |
273 | |
274 | == AddMissingIndexesToJournals: migrating ==================================== |
275 | -- add_index(:journals, :user_id) |
276 | -> 0.2225s |
277 | -- add_index(:journals, :journalized_id) |
278 | -> 0.2636s |
279 | == AddMissingIndexesToJournals: migrated (0.4863s) =========================== |
280 | |
281 | == AddMissingIndexesToIssueRelations: migrating ============================== |
282 | -- add_index(:issue_relations, :issue_from_id) |
283 | -> 0.1028s |
284 | -- add_index(:issue_relations, :issue_to_id) |
285 | -> 0.1083s |
286 | == AddMissingIndexesToIssueRelations: migrated (0.2112s) ===================== |
287 | |
288 | == AddMissingIndexesToWikiRedirects: migrating =============================== |
289 | -- add_index(:wiki_redirects, :wiki_id) |
290 | -> 0.1079s |
291 | == AddMissingIndexesToWikiRedirects: migrated (0.1080s) ====================== |
292 | |
293 | == AddMissingIndexesToCustomFieldsTrackers: migrating ======================== |
294 | -- add_index(:custom_fields_trackers, [:custom_field_id, :tracker_id]) |
295 | -> 0.0992s |
296 | == AddMissingIndexesToCustomFieldsTrackers: migrated (0.0993s) =============== |
297 | |
298 | == AddActivityIndexes: migrating ============================================= |
299 | -- add_index(:journals, :created_on) |
300 | -> 0.7744s |
301 | -- add_index(:changesets, :committed_on) |
302 | -> 0.1247s |
303 | -- add_index(:wiki_content_versions, :updated_on) |
304 | -> 0.6233s |
305 | -- add_index(:messages, :created_on) |
306 | -> 0.1249s |
307 | -- add_index(:issues, :created_on) |
308 | -> 0.1288s |
309 | -- add_index(:news, :created_on) |
310 | -> 0.0917s |
311 | -- add_index(:attachments, :created_on) |
312 | -> 0.1087s |
313 | -- add_index(:documents, :created_on) |
314 | -> 0.0917s |
315 | -- add_index(:time_entries, :created_on) |
316 | -> 0.0833s |
317 | == AddActivityIndexes: migrated (2.1526s) ==================================== |
318 | |
319 | == AddVersionsStatus: migrating ============================================== |
320 | -- add_column(:versions, :status, :string, {:default=>"open"}) |
321 | -> 0.1325s |
322 | == AddVersionsStatus: migrated (0.1407s) ===================================== |
323 | |
324 | == AddViewIssuesPermission: migrating ======================================== |
325 | == AddViewIssuesPermission: migrated (0.0743s) =============================== |
326 | |
327 | == AddDefaultDoneRatioToIssueStatus: migrating =============================== |
328 | -- add_column(:issue_statuses, :default_done_ratio, :integer) |
329 | -> 0.0993s |
330 | == AddDefaultDoneRatioToIssueStatus: migrated (0.0994s) ====================== |
331 | |
332 | == AddVersionsSharing: migrating ============================================= |
333 | -- add_column(:versions, :sharing, :string, {:null=>false, :default=>"none"}) |
334 | -> 0.0994s |
335 | -- add_index(:versions, :sharing) |
336 | -> 0.1332s |
337 | == AddVersionsSharing: migrated (0.2328s) ==================================== |
338 | |
339 | == AddLftAndRgtIndexesToProjects: migrating ================================== |
340 | -- add_index(:projects, :lft) |
341 | -> 0.1077s |
342 | -- add_index(:projects, :rgt) |
343 | -> 0.1166s |
344 | == AddLftAndRgtIndexesToProjects: migrated (0.2245s) ========================= |
345 | |
346 | == AddIndexToSettingsName: migrating ========================================= |
347 | -- add_index(:settings, :name) |
348 | -> 0.1328s |
349 | == AddIndexToSettingsName: migrated (0.1329s) ================================ |
350 | |
351 | == AddIndexesToIssueStatus: migrating ======================================== |
352 | -- add_index(:issue_statuses, :position) |
353 | -> 0.0994s |
354 | -- add_index(:issue_statuses, :is_closed) |
355 | -> 0.1751s |
356 | -- add_index(:issue_statuses, :is_default) |
357 | -> 0.1000s |
358 | == AddIndexesToIssueStatus: migrated (0.3748s) =============================== |
359 | |
360 | == RemoveEnumerationsOpt: migrating ========================================== |
361 | -- remove_column(:enumerations, :opt) |
362 | -> 0.0994s |
363 | == RemoveEnumerationsOpt: migrated (0.0995s) ================================= |
364 | |
365 | == ChangeWikiContentsTextLimit: migrating ==================================== |
366 | -- change_column(:wiki_contents, :text, :text, {:limit=>16777216}) |
367 | -> 0.4020s |
368 | -- change_column(:wiki_content_versions, :data, :binary, {:limit=>16777216}) |
369 | -> 1.3896s |
370 | == ChangeWikiContentsTextLimit: migrated (1.7998s) =========================== |
371 | |
372 | == ChangeUsersMailNotificationToString: migrating ============================ |
373 | -- rename_column(:users, :mail_notification, :mail_notification_bool) |
374 | -> 0.1159s |
375 | -- add_column(:users, :mail_notification, :string, {:null=>false, :default=>""}) |
376 | -> 0.1001s |
377 | -- remove_column(:users, :mail_notification_bool) |
378 | -> 0.1003s |
379 | == ChangeUsersMailNotificationToString: migrated (0.4334s) =================== |
380 | |
381 | == UpdateMailNotificationValues: migrating =================================== |
382 | == UpdateMailNotificationValues: migrated (0.0000s) ========================== |
383 | |
384 | == AddIndexOnChangesetsScmid: migrating ====================================== |
385 | -- add_index(:changesets, [:repository_id, :scmid], {:name=>:changesets_repos_scmid}) |
386 | -> 0.1161s |
387 | == AddIndexOnChangesetsScmid: migrated (0.1163s) ============================= |
388 | |
389 | == AddIssuesNestedSetsColumns: migrating ===================================== |
390 | -- add_column(:issues, :parent_id, :integer, {:default=>nil}) |
391 | -> 0.1446s |
392 | -- add_column(:issues, :root_id, :integer, {:default=>nil}) |
393 | -> 0.2381s |
394 | -- add_column(:issues, :lft, :integer, {:default=>nil}) |
395 | -> 0.1286s |
396 | -- add_column(:issues, :rgt, :integer, {:default=>nil}) |
397 | -> 0.1548s |
398 | == AddIssuesNestedSetsColumns: migrated (0.7028s) ============================ |
399 | |
400 | == AddIndexOnIssuesNestedSet: migrating ====================================== |
401 | -- add_index(:issues, [:root_id, :lft, :rgt]) |
402 | -> 0.1642s |
403 | == AddIndexOnIssuesNestedSet: migrated (0.1643s) ============================= |
404 | |
405 | == ChangeChangesPathLengthLimit: migrating =================================== |
406 | -- change_column(:changes, :path, :text, {:null=>true, :default=>nil}) |
407 | -> 0.0993s |
408 | -- change_column(:changes, :path, :text, {:null=>false}) |
409 | -> 0.0998s |
410 | -- change_column(:changes, :from_path, :text) |
411 | -> 0.1082s |
412 | == ChangeChangesPathLengthLimit: migrated (0.3076s) ========================== |
413 | |
414 | == PrepareJournalsForActsAsJournalized: migrating ============================ |
415 | -- change_table(:journals) |
416 | -> 2.8805s |
417 | == PrepareJournalsForActsAsJournalized: migrated (2.8809s) =================== |
418 | |
419 | == UpdateJournalsForActsAsJournalized: migrating ============================= |
420 | -- Updating existing Journals... |
421 | -> 46.5184s |
422 | -- change_table(:journals) |
423 | -> 0.2060s |
424 | == UpdateJournalsForActsAsJournalized: migrated (46.7247s) =================== |
425 | |
426 | == BuildInitialJournalsForActsAsJournalized: migrating ======================= |
427 | -- Building initial journals for Message |
428 | rake aborted! |
429 | An error has occurred, all later migrations canceled: |
430 | |
431 | Mysql::Error: Unknown column 'members.role_id' in 'field list': SELECT `members`.`id` AS t0_r0, `members`.`user_id` AS t0_r1, `members`.`project_id` AS t0_r2, `members`.`role_id` AS t0_r3, `members`.`created_on` AS t0_r4, `members`.`mail_notification` AS t0_r5, `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_bool` 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, `users`.`mail_notification` AS t1_r16, `roles`.`id` AS t2_r0, `roles`.`name` AS t2_r1, `roles`.`position` AS t2_r2, `roles`.`assignable` AS t2_r3, `roles`.`builtin` AS t2_r4, `roles`.`permissions` AS t2_r5 FROM `members` LEFT OUTER JOIN `users` ON `users`.id = `members`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) 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`.project_id = 14 AND (users.type='User' AND users.status=1)) |
432 | |
433 | Tasks: TOP => db:migrate |
434 | (See full trace by running task with --trace) |