PiRSquared17 / redmine-dmsf

Automatically exported from code.google.com/p/redmine-dmsf
0 stars 0 forks source link

Activity option gives an error while dmsf plugin is installed with Chiliproject #186

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
1. Install dmsf plugin in chiliproject 2.5.0
2. Activate dmsf plugin in project 
3. In the above project click activity tab.

Output should show issue activities in project.

I get:
"Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your ChiliProject 
administrator for assistance.

If you are the ChiliProject administrator, check your log files for details 
about the error."

I use DMSF version from source repositury and Chiliproject 2.5.0. 

In the chiliprojhct log there is:
"Processing ActivitiesController#index (for 192.168.13.49 at 2011-12-10 
12:48:19) [GET]
  Parameters: {"action"=>"index", "id"=>"et", "controller"=>"activities"}

ActiveRecord::StatementInvalid (Mysql::Error: Unknown table 
'dmsf_file_revisions': SELECT dmsf_file_revisions.* FROM `journals`  INNER JOIN 
dmsf_files ON dmsf_file_revisions.dmsf_file_id = dmsf_files.id INNER JOIN 
projects ON dmsf_files.project_id = projects.id WHERE (dmsf_files.deleted = 0) 
AND (1=1 AND (dmsf_file_revisions.updated_at BETWEEN '2011-11-11' AND 
'2011-12-11') AND ((projects.id = 165 OR (projects.lft > 26 AND projects.rgt < 
27)) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM 
enabled_modules em WHERE em.name='dmsf')))) AND ( (`journals`.`type` = 
'DmsfFileRevisionJournal' ) ) ):
  lib/redmine/activity/fetcher.rb:83:in `events'
  lib/redmine/activity/fetcher.rb:82:in `each'
  lib/redmine/activity/fetcher.rb:82:in `events'
  lib/redmine/activity/fetcher.rb:81:in `each'
  lib/redmine/activity/fetcher.rb:81:in `events'
  app/controllers/activities_controller.rb:38:in `index'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /usr/share/chiliproject/public/500.html (500 Internal Server Error)"

Original issue reported on code.google.com by pafcio...@gmail.com on 10 Dec 2011 at 11:50

GoogleCodeExporter commented 9 years ago
This seems like db tables wasn't correctly created. Have you performed 
db:migrate:plugins rake task? If you do, please check that table 
dmsf_file_revisions exists in database

Original comment by vit.jo...@gmail.com on 10 Dec 2011 at 7:47

GoogleCodeExporter commented 9 years ago
Well, I did db:migrate:plugins rake task and it finished ok.
And the table dmsf_file_revisions exists in database.
There are also another dmsf tables in the database:
| dmsf_file_locks                     |
| dmsf_file_revision_accesses         |
| dmsf_file_revisions                 |
| dmsf_files                          |
| dmsf_folders                        |

Original comment by pafcio...@gmail.com on 11 Dec 2011 at 9:22

GoogleCodeExporter commented 9 years ago
I changed Chiliproject from 2.5.0 to a clean 2.6.0 in a meanwhile.

I installed latest revision of DMSF plugin from svn.

Now when I click activity tab I get an internal error still.

But the error application log is different now:
"Processing ActivitiesController#index (for 192.168.13.49 at 2012-01-23 
06:26:20) [GET]
  Parameters: {"action"=>"index", "id"=>"test", "controller"=>"activities"}

NoMethodError (undefined method `journal_class_name' for Object:Class):
  lib/redmine/activity/fetcher.rb:83:in `events'
  lib/redmine/activity/fetcher.rb:82:in `each'
  lib/redmine/activity/fetcher.rb:82:in `events'
  lib/redmine/activity/fetcher.rb:81:in `each'
  lib/redmine/activity/fetcher.rb:81:in `events'
  app/controllers/activities_controller.rb:38:in `index'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /usr/share/chiliproject/public/500.html (500 Internal Server Error)

Processing ActivitiesController#index (for 192.168.13.49 at 2012-01-23 
06:26:20) [GET]
  Parameters: {"action"=>"index", "id"=>"test", "controller"=>"activities"}

NoMethodError (undefined method `journal_class_name' for Object:Class):
  lib/redmine/activity/fetcher.rb:83:in `events'
  lib/redmine/activity/fetcher.rb:82:in `each'
  lib/redmine/activity/fetcher.rb:82:in `events'
  lib/redmine/activity/fetcher.rb:81:in `each'
  lib/redmine/activity/fetcher.rb:81:in `events'
  app/controllers/activities_controller.rb:38:in `index'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
  /usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
  /usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
  /usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
  /usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:23:in `start'
  /usr/lib/ruby/1.8/webrick/server.rb:82:in `start'

Rendering /usr/share/chiliproject/public/500.html (500 Internal Server Error)"

Original comment by pafcio...@gmail.com on 23 Jan 2012 at 5:27