arkhitech / redmine_leaves

A simple plugin for user leaves management. It allows user to check-in and check-out for attendance marking. Leave is marked for any user that does not check-in by the specified time. Administrator can define leave types via the administrative interface for the plugin
MIT License
15 stars 6 forks source link

open user_time_checks 500 error #76

Open radist opened 7 years ago

radist commented 7 years ago
I, [2017-07-31T10:50:48.413636 #24214]  INFO -- : Started GET "/user_time_checks" for 95.174.100.253 at 2017-07-31 10:50:48 +0300
I, [2017-07-31T10:50:48.415192 #24214]  INFO -- : Processing by UserTimeChecksController#index as HTML
I, [2017-07-31T10:50:48.486753 #24214]  INFO -- :   Current user: radist (id=4)
I, [2017-07-31T10:50:48.523855 #24214]  INFO -- :   Rendered plugins/redmine_leaves/app/views/user_time_checks/_time_check_grid.html.erb (31.3ms)
I, [2017-07-31T10:50:48.524239 #24214]  INFO -- :   Rendered plugins/redmine_leaves/app/views/user_time_checks/index.html.erb within layouts/base (34.4ms)
I, [2017-07-31T10:50:48.524614 #24214]  INFO -- : Completed 500 Internal Server Error in 109ms (ActiveRecord: 68.4ms)
F, [2017-07-31T10:50:48.526872 #24214] FATAL -- : 
ActionView::Template::Error (PG::SyntaxError: ERROR:  syntax error at or near "AS"
LINE 1: ...all, user_time_checks.id AS user_time_checks_id,  AS  FROM "...
                                                             ^
: SELECT COUNT(*) AS count_all, user_time_checks.id AS user_time_checks_id,  AS  FROM "user_time_checks" LEFT JOIN time_entries on DATE(check_in_time) <= spent_on AND DATE(check_out_time) >= spent_on WHERE ((check_in_time >  '2017-01-31 10:50:48.488421')) GROUP BY user_time_checks.id):
    1: 
    2: <%=define_grid @time_check_grid, hide_submit_button: true, hide_reset_button: true, hide_csv_button: false do |e|
    3: 
    4: 
    5:   e.column name: l(:field_user_id), html: {style: 'text-align: center'}, 
  plugins/redmine_leaves/app/views/user_time_checks/_time_check_grid.html.erb:2:in `_4a267eb4916d9dc955530c2652a075f5'
  plugins/redmine_leaves/app/views/user_time_checks/index.html.erb:27:in `_b30d6f5391f81eb952f644ef457db5d3'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Environment: Redmine version 3.3.1.stable Ruby version 2.3.3-p222 (2016-11-21) [x86_64-linux] Rails version 4.2.7.1 Environment production Database adapter PostgreSQL SCM: Git 2.7.4 Filesystem
Redmine plugins: a_common_libs 2.3.2 additionals 2.0.0 autowatch 0.2.0 clipboard_image_paste 1.10 collapsed_journals 0.0.3 custom_menu 1.7.4 issue_hot_buttons 0.4.4 periodictask 3.1.1 progressive_projects_list 3.0.1 projects_show 0.0.3 redmine__select2 1.1.0 redmine_agile 1.4.1 redmine_attach_by_url 1.0.2 redmine_bitbucket 1.0.0 redmine_chat_telegram 1.6.1 redmine_checklists 3.1.5 redmine_ckeditor 1.1.4 redmine_codebutton 0.1.0 redmine_contacts 4.0.4 redmine_contacts_helpdesk 3.0.1 redmine_contacts_invoices 4.1.1 redmine_custom_css 0.1.6 redmine_custom_workflows 0.1.6 redmine_dashboard 2.7.1 redmine_default_assign 0.6 redmine_digest 1.1.0 redmine_editauthor 0.11.0 redmine_email_images 0.2.0 redmine_email_logs 0.0.1 redmine_finance 2.1.0 redmine_gist 0.1.0 redmine_gitlab_hook 0.1.3 redmine_impersonate 0.10.0 redmine_intouch 0.6.1 redmine_issue_completion 0.0.2 redmine_issue_favicon 0.0.1 redmine_issue_history_filter 0.0.1 redmine_issue_templates 0.1.3 redmine_jstoolbar_ext 0.2.1 redmine_jstoolbar_ext_images 0.3.1 redmine_keyboard_shortcuts 0.0.1 redmine_knowledgebase 3.2.1 redmine_leaves 0.1.0 redmine_lightbox2 0.3.1 redmine_login_audit 0.3.1 redmine_macros 0.0.1 redmine_mail_reminder 3.0.0.0001 redmine_mentions 0.0.1 redmine_move_comments 0.0.2 redmine_my_page 0.1.10 redmine_one_issue_in_process_only 0.0.4 redmine_people 1.2.0 redmine_percent_done 1.1.0 redmine_project_alias_2 1.0.2 redmine_recurring_tasks 0.0.2 redmine_scheduling_poll 2.0.0 redmine_shared_api 0.0.2 redmine_sidekiq 2.1.0 redmine_silencer 0.4.1 redmine_slack 0.2 redmine_spent_time 3.1.2 redmine_spent_time_curve 0.0.1 redmine_tags 3.1.1 redmine_telegram_common 0.0.15 redmine_theme_changer 0.2.0 redmine_webhook 0.0.2 redmine_workflow_hidden_fields 0.3.0 sidebar_hide 0.0.7 subtask_list_columns 0.0.3 ttm 0.2.0 unread_issues 2.1.0 vault 0.3.0