Redmine 1.3.0 Error when accessing Temps Passé Global
Added by Craig Efrein over 12 years ago
Hello,
When I click on Proejcts, then on the Temps Passé Global, I get this error in the production log.
ActiveRecord::StatementInvalid (Mysql::Error: Incorrect key file for table '/tmp/#sql_bd9_0.MYI'; try to repair it: SELECT `time_entries`.`id` AS t0_r0, `time_entries`.`project_id` AS t0_r1, `time_entries`.`user_id` AS t0_r2, `time_entries`.`issue_id` AS t0_r3, `time_entries`.`hours` AS t0_r4, `time_entries`.`comments` AS t0_r5, `time_entries`.`activity_id` AS t0_r6, `time_entries`.`spent_on` AS t0_r7, `time_entries`.`tyear` AS t0_r8, `time_entries`.`tmonth` AS t0_r9, `time_entries`.`tweek` AS t0_r10, `time_entries`.`created_on` AS t0_r11, `time_entries`.`updated_on` AS t0_r12, `projects`.`id` AS t1_r0, `projects`.`name` AS t1_r1, `projects`.`description` AS t1_r2, `projects`.`homepage` AS t1_r3, `projects`.`is_public` AS t1_r4, `projects`.`parent_id` AS t1_r5, `projects`.`created_on` AS t1_r6, `projects`.`updated_on` AS t1_r7, `projects`.`identifier` AS t1_r8, `projects`.`status` AS t1_r9, `projects`.`lft` AS t1_r10, `projects`.`rgt` AS t1_r11, `enumerations`.`id` AS t2_r0, `enumerations`.`name` AS t2_r1, `enumerations`.`position` AS t2_r2, `enumerations`.`is_default` AS t2_r3, `enumerations`.`type` AS t2_r4, `enumerations`.`active` AS t2_r5, `enumerations`.`project_id` AS t2_r6, `enumerations`.`parent_id` AS t2_r7, `users`.`id` AS t3_r0, `users`.`login` AS t3_r1, `users`.`hashed_password` AS t3_r2, `users`.`firstname` AS t3_r3, `users`.`lastname` AS t3_r4, `users`.`mail` AS t3_r5, `users`.`admin` AS t3_r6, `users`.`status` AS t3_r7, `users`.`last_login_on` AS t3_r8, `users`.`language` AS t3_r9, `users`.`auth_source_id` AS t3_r10, `users`.`created_on` AS t3_r11, `users`.`updated_on` AS t3_r12, `users`.`type` AS t3_r13, `users`.`identity_url` AS t3_r14, `users`.`mail_notification` AS t3_r15, `users`.`salt` AS t3_r16, `issues`.`id` AS t4_r0, `issues`.`tracker_id` AS t4_r1, `issues`.`project_id` AS t4_r2, `issues`.`subject` AS t4_r3, `issues`.`description` AS t4_r4, `issues`.`due_date` AS t4_r5, `issues`.`category_id` AS t4_r6, `issues`.`status_id` AS t4_r7, `issues`.`assigned_to_id` AS t4_r8, `issues`.`priority_id` AS t4_r9, `issues`.`fixed_version_id` AS t4_r10, `issues`.`author_id` AS t4_r11, `issues`.`lock_version` AS t4_r12, `issues`.`created_on` AS t4_r13, `issues`.`updated_on` AS t4_r14, `issues`.`start_date` AS t4_r15, `issues`.`done_ratio` AS t4_r16, `issues`.`estimated_hours` AS t4_r17, `issues`.`parent_id` AS t4_r18, `issues`.`root_id` AS t4_r19, `issues`.`lft` AS t4_r20, `issues`.`rgt` AS t4_r21, `issues`.`is_private` AS t4_r22, `trackers`.`id` AS t5_r0, `trackers`.`name` AS t5_r1, `trackers`.`is_in_chlog` AS t5_r2, `trackers`.`position` AS t5_r3, `trackers`.`is_in_roadmap` AS t5_r4 FROM `time_entries` LEFT OUTER JOIN `projects` ON `projects`.id = `time_entries`.project_id LEFT OUTER JOIN `enumerations` ON `enumerations`.id = `time_entries`.activity_id AND (`enumerations`.`type` = 'TimeEntryActivity' ) LEFT OUTER JOIN `users` ON `users`.id = `time_entries`.user_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `issues` ON `issues`.id = `time_entries`.issue_id LEFT OUTER JOIN `trackers` ON `trackers`.id = `issues`.tracker_id WHERE (1=1 AND (spent_on BETWEEN '2009-05-25' AND '2011-12-14')) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='time_tracking')) ORDER BY spent_on DESC LIMIT 0, 50): app/controllers/timelog_controller.rb:59:in `index' app/controllers/timelog_controller.rb:54:in `index' public/dispatch.fcgi:24 Rendering /opt/redmine/public/500.html (500 Internal Server Error)
I have optimized the table time_entries but still get the same error
Replies (1)
RE: Redmine 1.3.0 Error when accessing Temps Passé Global
-
Added by Craig Efrein over 12 years ago
Never mind, I didn't have enough space in /tmp