Project

General

Profile

Problem Install App_Timecheets

Added by Dark Sark over 10 years ago

Hello

After installing app_space and watcher_group, i try to install app_timsesheet. When i migrate with "rake redmine:plugins:migrate RAILS_ENV=production", i have an error in database which abort migrating (look screenshot

Please help ;)

Sans titre.png (44.2 KB) Sans titre.png error install

Replies (2)

RE: Problem Install App_Timecheets - Added by Martin Denizet (redmine.org team member) over 10 years ago

Which DB engine are you using?
I suggest you report that on the plugin's Github.
Cheers,

RE: Problem Install App_Timecheets - Added by Dark Sark over 10 years ago

Thanks for your response. I find the problem. This plugin is not compatible with Postgres, but i solved problem.

You can modify file in plugins/redmine_app_timesheets/db/migrate/005_revert_time_entries_in_timesheet.rb

Replace line 5 (TimeEntry.joins ...) by
sql = "UPDATE time_entries SET fixed_version_id = issues.fixed_version_id FROM issues WHERE time_entries.id IN ( SELECT time_entries.id FROM time_entries INNER JOIN issues ON issues.id = time_entries.issue_id WHERE time_entries.in_timesheet = 't' AND (time_entries.fixed_version_id is NULL));"
connection.update(sql)

it's work !

    (1-2/2)