Home > redmine 500 > redmine 500 error issues

Redmine 500 Error Issues

some of my project issues when clicked show me a 500 internal error. Looking at the logs I see this messages 0.3/app/views/issues/_action_menu.html.erb:6) Rendered issues/_action_menu.html.erb (5.4ms) Rendered issues/show.html.erb within layouts/base (11.4ms)Completed 500 Internal Server Error in 341ms ActionView::Template::Error (Mysql::Error: Column 'lft' in order clause is ambiguous: SELECT `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1, `issues`.`project_id` AS t0_r2, `issues`.`subject` AS t0_r3, `issues`.`description` AS t0_r4, `issues`.`due_date` AS t0_r5, `issues`.`category_id` AS t0_r6, `issues`.`status_id` AS t0_r7, `issues`.`assigned_to_id` AS t0_r8, `issues`.`priority_id` AS t0_r9, `issues`.`fixed_version_id` AS t0_r10, `issues`.`author_id` AS t0_r11, `issues`.`lock_version` AS t0_r12, `issues`.`created_on` AS t0_r13, `issues`.`updated_on` AS t0_r14, `issues`.`start_date` AS t0_r15, `issues`.`done_ratio` AS t0_r16, `issues`.`estimated_hours` AS t0_r17, `issues`.`parent_id` AS t0_r18, `issues`.`root_id` AS t0_r19, `issues`.`lft` AS t0_r20, `issues`.`rgt` AS t0_r21, `issues`.`is_private` AS t0_r22, `issues`.`position` AS t0_r23, `issues`.`remaining_hours` AS t0_r24, `issues`.`story_points` AS t0_r25, `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 FROM `issues` LEFT OUTER JOIN `projects` ON `projects`.`id` = `issues`.`project_id` WHERE `issues`.`root_id` = 223 AND (`issues`.`lft` <= 14 AND `issues`.`rgt` >= 15) AND (`issues`.id != 230) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) ORDER BY `lft`): 22: <%= avatar(@issue.author, :size => "50") > 23: 24:

25: <= render_issue_subject_with_tree(@issue) > 26: 27:

28: <= authoring @issue.created_on, @issue.author %>. app/helpers/issues_helper.rb:6

have recently imported an postgresql database into my new redmine from an older server. Now everything came up ok etc. I can edit successfully previously created issues that were imported in. However what I cannot do is create new ones. I get a 500 server error when I do and when I look at the production.log I get the following dump ActiveRecord::StatementInvalid (PG::NotNullViolation: ERROR: null value in column "position" violates not-null constraintDETAIL: Failing row contains (2897, 11, 128, http://www.redmine.org/boards/2/topics/32178 eee, eee, null, null, 1, 51, 4, null, 51, 0, 2014-07-09 15:24:54.454104, 2014-07-09 15:24:54.454104, 2014-07-09, 0, null, null, null, 1, 2, f,$: INSERT INTO "issues" ("assigned_to_id", "author_id", "category_id", "closed_on", "created_on", "description", "done_ratio", "due_date", "estimated_hours", "fixed_version_id", "is_private$ app/models/issue.rb:165:in `create_or_update' app/controllers/issues_controller.rb:150:in `create' However I am fairly new to all this stuff so I dont know what that means. And I couldnt find http://www.redmine.org/boards/2/topics/43207 much on google pertaining to it. I was wondering if any of you kind souls might have an incite in to what my issue might be? Thanks Kindly Paul Replies (3) RE: Unable to create issues - Get 500 internal error - Added by Rupesh Helwade over 2 years ago AS the log suggests, the Null constraint is violated which is not allowing the application to insert new values. You should change this constraint on "issues" table for columns where the Null values are being inserted. RE: Unable to create issues - Get 500 internal error - Added by Paul Graham over 2 years ago Thankyou for the answer How would I go about that? Would you know? Thanks Paul RE: Unable to create issues - Get 500 internal error - Added by Rupesh Helwade over 2 years ago http://stackoverflow.com/questions/5273717/drop-constraint-by-name-in-postgresql Hope this link helps. YOu need to go to the potgres sql command prompt and run this command.YOu may have used it while importing your old data. (1-3/3) Loading... Powered by Redmine © 2006-2014 Jean-Philippe Lang

Translation patches Defect #2177 redMine 500 error Added by sunsun sunsjun almost 8 years ago. Updated over 6 years ago. Status:ClosedStart date:2008-11-13Priority:NormalDue date:Assignee:-% Done:0%Category:-Target version:- Resolution:Invalid Affected redmine 500 version: Description redMine 500 error Internal errorAn error occurred on the page you were trying to access.If you continue to experience problems please contact your redMine administrator for assistance. An redmine 500 error error occurred on the page you were trying to access. If you continue to experience problems please contact your redMine administrator for assistance ActionView::TemplateError (undefined method `length' for #) on line #22 of repositories/_dir_list_content.rhtml: 19: <%= distance_of_time_in_words(entry.lastrev.time, Time.now) if entry.lastrev && entry.lastrev.time %> 20: <%=h(entry.lastrev.author.to_s.split('<').first) if entry.lastrev %> 21: <% changeset = @project.repository.changesets.find_by_revision(entry.lastrev.identifier) if entry.lastrev && entry.lastrev.identifier %> 22: <%=h truncate(changeset.comments, 50) unless changeset.nil? %> 23: 24: <% end %> vendor/rails/actionpack/lib/action_view/helpers/text_helper.rb:50:in `truncate' app/views/repositories/_dir_list_content.rhtml:22:in `_run_erb_47app47views47repositories47_dir_list_content46rhtml' app/views/repositories/_dir_list_content.rhtml:1:in `each' app/views/repositories/_dir_list_content.rhtml:1:in `_run_erb_47app47views47repositories47_dir_list_content46rhtml' vendor/rails/actionpack/lib/action_view/base.rb:637:in `send' vendor/rails/actionpack/lib/action_view/base.rb:637:in `compile_and_render_template' vendor/rails/actionpack/lib/action_view/base.rb:365:in `render_template'

Related content

redmine 500 error log
Redmine Error Log p errors in a redmine install It started trying to archive a project but now users can't even log in anymore Only the first admin user can login My production log tells me no errors bash- tail apps redmine log production log lockfile lib lockfile rb in new' lockfile lib lockfile rb in Lockfile' vendor plugins redmine-gitosis app models gitosis observer rb in update repositories' vendor plugins redmine-gitosis app models gitosis observer rb in after save' opt redmine ruby lib ruby observer rb in notify observers' opt redmine ruby lib ruby observer rb in each' opt redmine

redmine 500 error repository
Redmine Error Repository p Translation patches Defect Subversion Internal Server Error when browsing a repository Added by Anthony C over years ago Updated about years ago Status ReopenedStart date - - Priority NormalDue date Assignee - Done Category SCMTarget version - Resolution Affected version Description I've added a subversion repository to one of our projects When I go to the repository tab to browse the repository I get a Internal Server Error The production log contains no entry at all for the page access The strangest part is that another repository on another server works perfectly Both the working and

redmine 500 internal server error repository
Redmine Internal Server Error Repository p Translation patches Defect Subversion Internal Server Error when browsing a repository Added by Anthony C over years ago Updated about years ago Status ReopenedStart date - - Priority NormalDue date Assignee - Done Category SCMTarget version - Resolution Affected version Description I've added a subversion repository to one of our projects When I go to the repository tab to browse the repository I get a Internal Server Error The production log contains no entry at all for the page access The strangest part is that another repository on another server works perfectly Both the

redmine 500 error debug
Redmine Error Debug p ago I'm using -stable from svn I've configured everything as outlined in the installation guide Everything runs beautifully when started in WEBrick Running in Apache however yields a error that appears to be echo'd by Redmine not Apache's default I'm using Ruby Enterprise Edition on Ubuntu Here's my setup Ruby version i -linux RubyGems version Rails version Active Record version Action Pack version Active Resource version Action Mailer version Active Support version Application root usr share redmine redmine- Environment production Database adapter mysql Database schema version Here is the production log output FAILSAFE Tue Jan -

redmine 500 error login
Redmine Error Login p production log messages here http pastebin com Br sdGGk It only seems to happen when I login I have recently run a security update on Apache Ubuntu updated Any ideas EDIT I should mention I triedrake tmp cache clearrake tmp sessions clear and restarted Apache I'm using Passenger but this did not help Replies RE Error When Trying to Login - Added by Ron Adams over years ago It seems to be resolved now but I didn't really do anything other than another reload of Apache to fix an unrelated problem RE Error When Trying to

redmine 500 error after install
Redmine Error After Install p Ruby Gem Rails and then Redmine on my Redhat Linux Enterprise server I'm struggling to get redmine to run correctly I posted in another thread and received advice recommending the installation of mongrel which I tried If I clear cookies in my browser and load the page the initial page displays perfectly Clicking on any page returns the error if I clear my cookies I can view the inital page again but the pattern repeats I can view any page and then clicking a link returns another error Thanks in advance for any help Here's

redmine 500 error new issue
Redmine Error New Issue p Translation patches Defect Error when create a new issue in V Added by Mr DTTH almost years ago Updated almost years ago Status ClosedStart date Priority NormalDue date Assignee - Done Category IssuesTarget version - Resolution Invalid Affected version Description When I create a new issue it throw error Rails Redmine Started POST projects myos issues for at - - Processing by IssuesController create as HTML Parameters utf authenticity token ehVu qmPlS H PLVh ZRJ i kq k y OSJxxlLYsw issue tracker id subject Task Title description Content for task status id priority id assigned

redmine 500 error nomethoderror
Redmine Error Nomethoderror p years ago Hello I am running Redmine stable Environment Redmine version stable Ruby version amd -freebsd Rails version Environment production Database adapter MySQLRedmine plugins no plugin installed I'm testing redmine out so I've created a test project with a dummy task in it and see how redmine is displaying it But when I'm trying to access Gantt tab I'm encountering a - Internal error Started GET projects newconsole issues gantt for at Fri Aug Processing by GanttsController show as HTML Parameters project id newconsole Completed Internal Server Error in ms NoMethodError undefined method -' for true

redmine 500 internal server error svn
Redmine Internal Server Error Svn p Translation patches Defect Subversion Internal Server Error when browsing a repository Added by Anthony C over years ago Updated about years ago Status ReopenedStart date - - Priority NormalDue date Assignee - Done Category SCMTarget version - Resolution Affected version Description I've added a subversion repository to one of our projects When I go to the repository tab to browse the repository I get a Internal Server Error The production log contains no entry at all for the page access The strangest part is that another repository on another server works perfectly Both the