search

xelkano / redmine_xapian

This plugin allows searches across attachments with xapian search engine
GNU General Public License v2.0
53 stars 26 forks source link

Problems with Installation #43

Closed githubrs closed 11 years ago

githubrs commented 11 years ago

Hello together! I hope somebody can help me with my problem. This is my environment:

Debian 7.1

Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Redmine plugins: extended_top_menu 0.0.1

So now to the problem: I tried to install the xapian-plugin and followed the documentation, but it doesn´t work. I installed the xapian-omega and the libxapian-ruby packages and ran the following commands:

apt-get install unzip antiword ghostscript catdoc xpdf libwpd-tools libwps-tools gzip unrtf apt-get install uuid-dev cd /var/www/redmine bundle Then I extracted the downloaded .zip to /plugins cd /usr/local/share/redmine chmod 777 -R plugins bundle install --without development test rake redmine:plugins:migrate RAILS_ENV="production" /etc/init.d/apache2 restart

After those steps i can see the plugin in the information:

Redmine plugins: extended_top_menu 0.0.1 redmine_xapian 1.6.0

And I added this to the cronjob:

/10 * * * * omindex -s english -U / --db /var/www/xapian-index/english /usr/local/share/redmine/files /10 * * * * omindex -s german -U / --db /var/www/xapian-index/german /usr/local/share/redmine/files

When I search files I can find them by name but not by contents. Can somebody tell me how I have to install/configure it to find also files by the content?

Thanks

xelkano commented 11 years ago

can you post the output of "bundle show" command?

githubrs commented 11 years ago

At first thank you for the fast reply. This is the output of "bundle show":

bundle show

Gems included by the bundle:

xelkano commented 11 years ago

gems seems to be OK. you can try this command to test if xapian database is populated correctly

quest -d /var/www/xapian-index/english 'string_to_search'

tell me if you get some hits.

2013/6/26 githubrs notifications@github.com

At first thank you for the fast reply. This is the output of "bundle show": bundle show

Gems included by the bundle:

  • actionmailer (3.2.13)
  • actionpack (3.2.13)
  • activemodel (3.2.13)
  • activerecord (3.2.13)
  • activerecord-tableless (1.0.2)
  • activeresource (3.2.13)
  • activesupport (3.2.13)
  • arel (3.0.2)
  • builder (3.0.0)
  • bundler (1.3.5)
  • coderay (1.0.9)
  • erubis (2.7.0)
  • hike (1.2.3)
  • i18n (0.6.1)
  • journey (1.0.4)
  • jquery-rails (2.0.3)
  • json (1.8.0)
  • mail (2.5.4)
  • mime-types (1.23)
  • multi_json (1.7.6)
  • net-ldap (0.3.1)
  • pg (0.15.1)
  • polyglot (0.3.3)
  • rack (1.4.5)
  • rack-cache (1.2)
  • rack-openid (1.3.1)
  • rack-ssl (1.3.3)
  • rack-test (0.6.2)
  • rails (3.2.13)
  • railties (3.2.13)
  • rake (10.0.4)
  • rdoc (3.12.2)
  • rmagick (2.13.2)
  • ruby-openid (2.1.8)
  • sprockets (2.2.2)
  • thor (0.18.1)
  • tilt (1.4.1)
  • treetop (1.4.14)
  • tzinfo (0.3.37)
  • will_paginate (3.0.4)
  • xapian-ruby (1.2.15.1)

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20031311 .

githubrs commented 11 years ago

OK now it seems to work a little bit. I can find now files also by the content. I installed it the same way I write above again to test it and now it seems to find files also by the content. Thank you till here.

But now there are a few other problems:

  1. If I want to configure the plugin in Administration->Plugins->Xapian search plugin "Configure", i get " 404

The page you were trying to access doesn't exist or has been removed.

Back " back. I think maybe I can solve the problem by moving /redmine_xapian-msater/app/views/settings/_redmine_xapian_settings.erb to redmine-2.3/app/views/settings/

  1. I think it's the same issue: https://github.com/xelkano/redmine_xapian/issues/40

I can also only view the first files although I can find more than 100 files.

Tomorrow I will try to solve my first problem and I think it should work. I hope you can help me with the second issue.

Greets

githubrs commented 11 years ago

Hello! The first problem I solved. I did it like i wrote above:

mv plugins/redmine_xapian-master/app/views/settings/_redmine_xapian_settings.erb app/views/settings/

Now it works and i can configure the plugin in Administration->Plugins->Xapian search plugin "Configure".

Now to problem #40 I made some screenshots to show you what's going wrong. This is a search before i installed the plugin: without_plugin_marked

This is a search after i installed the plugin: with_plugin_marked There is no possibility to watch all results. It's the same when i search only files or issues.

I hope you can imagine the problem now better.

githubrs commented 11 years ago

This is the entry in the redmine log-file:

Started GET "/redmine/search?utf8=%E2%9C%93&q=test&scope=all&all_words=&all_words=1&titles_only=&issues=1&news=1&documents=1&changesets=1&wiki_pages=1&messages=1&projects=1&attachments=1&submit=Submit" for ::1 at 2013-06-28 11:01:26 +0100 Processing by SearchController#index as HTML Parameters: {"utf8"=>"✓", "q"=>"test", "scope"=>"all", "all_words"=>"1", "titles_only"=>"", "issues"=>"1", "news"=>"1", "documents"=>"1", "changesets"=>"1", "wiki_pages"=>"1", "messages"=>"1", "projects"=>"1", "attachments"=>"1", "submit"=>"Submit"} Current user: admin (id=1) ERROR: xapian database cannot be open #<IOError: DatabaseOpeningError: Couldn't stat '/var/tmp/english'> Rendered search/index.html.erb within layouts/base (46.2ms) Completed 200 OK in 165ms (Views: 45.8ms | ActiveRecord: 82.7ms)

xelkano commented 11 years ago

check if the webserver has correct permissions in /var/www/xapian-index/* for reading

2013/6/28 githubrs notifications@github.com

This is the entry in the redmine log-file:

Started GET "/redmine/search?utf8=%E2%9C%93&q=test&scope=all&all_words=&all_words=1&titles_only=&issues=1&news=1&documents=1&changesets=1&wiki_pages=1&messages=1&projects=1&attachments=1&submit=Submit" for ::1 at 2013-06-28 11:01:26 +0100 Processing by SearchController#index as HTML Parameters: {"utf8"=>"✓", "q"=>"test", "scope"=>"all", "all_words"=>"1", "titles_only"=>"", "issues"=>"1", "news"=>"1", "documents"=>"1", "changesets"=>"1", "wiki_pages"=>"1", "messages"=>"1", "projects"=>"1", "attachments"=>"1", "submit"=>"Submit"} Current user: admin (id=1) ERROR: xapian database cannot be open # Rendered search/index.html.erb within layouts/base (46.2ms) Completed 200 OK in 165ms (Views: 45.8ms | ActiveRecord: 82.7ms)

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20180023 .

githubrs commented 11 years ago

the permissions are correct. i also ran chmod 777 -R /var/www/xapian-index so it has definitely the right permissions.

xelkano commented 11 years ago

Attach log fille with debug enabled. To enable debug edit file REDMINE_ROOT/config/additional_environment.rb and add the following line:

config.log_level = :debug

Do the same test and post the log file.

2013/7/2 githubrs notifications@github.com

the permissions are correct. i also ran chmod 777 -R /var/www/xapian-index so it has definitely the right permissions.

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20330803 .

githubrs commented 11 years ago

I hope that's the thing you want:

Started GET "/redmine/search?utf8=%E2%9C%93&q=test&scope=all&all_words=&all_words=1&titles_only=&issues=1&news=1&documents=1&changesets=1&wiki_pages=1&messages=1&projects=1&attachments=1&submit=Submit" for ::1 at 2013-07-02 09:13:07 +0100 Processing by SearchController#index as HTML Parameters: {"utf8"=>"✓", "q"=>"test", "scope"=>"all", "all_words"=>"1", "titles_only"=>"", "issues"=>"1", "news"=>"1", "documents"=>"1", "changesets"=>"1", "wiki_pages"=>"1", "messages"=>"1", "projects"=>"1", "attachments"=>"1", "submit"=>"Submit"}  (0.7ms) SELECT MAX("settings"."updated_on") AS max_id FROM "settings" User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = 1 AND "users"."id" = $1 LIMIT 1 [["id", 1]] Current user: admin (id=1) DEBUG: params[:user_stem_lang]nil"english" DEBUG: params[:user_stem_strategy]nil"STEM_SOME" DEBUG: scope ["issues", "news", "documents", "changesets", "wiki_pages", "messages", "projects", "attachments"] DEBUG: element: "issues"  (0.4ms) SELECT "custom_fields"."id" FROM "custom_fields" WHERE "custom_fields"."type" = 'IssueCustomField' AND "custom_fields"."searchable" = 't'  (1.7ms) SELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) SQL (1.3ms) SELECT DISTINCT "issues".id, issues.id AS alias_0 FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) ORDER BY issues.id DESC LIMIT 11 SQL (2.8ms) 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"."closed_on" AS t0_r23, "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, "projects"."inherit_members" AS t1_r12, "journals"."id" AS t2_r0, "journals"."journalized_id" AS t2_r1, "journals"."journalized_type" AS t2_r2, "journals"."user_id" AS t2_r3, "journals"."notes" AS t2_r4, "journals"."created_on" AS t2_r5, "journals"."private_notes" AS t2_r6 FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE "issues"."id" IN (30, 29, 28, 26, 25, 24, 23, 22, 21, 20, 19) AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) ORDER BY issues.id DESC DEBUG: element: "news"  (0.8ms) SELECT COUNT(DISTINCT "news"."id") FROM "news" LEFT OUTER JOIN "projects" ON "projects"."id" = "news"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(summary) LIKE '%test%') OR (LOWER(news.description) LIKE '%test%'))) SQL (1.4ms) SELECT "news"."id" AS t0_r0, "news"."project_id" AS t0_r1, "news"."title" AS t0_r2, "news"."summary" AS t0_r3, "news"."description" AS t0_r4, "news"."author_id" AS t0_r5, "news"."created_on" AS t0_r6, "news"."comments_count" AS t0_r7, "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, "projects"."inherit_members" AS t1_r12 FROM "news" LEFT OUTER JOIN "projects" ON "projects"."id" = "news"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(summary) LIKE '%test%') OR (LOWER(news.description) LIKE '%test%'))) ORDER BY news.created_on DESC LIMIT 11 DEBUG: element: "documents"  (0.7ms) SELECT COUNT(DISTINCT "documents"."id") FROM "documents" LEFT OUTER JOIN "projects" ON "projects"."id" = "documents"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(documents.description) LIKE '%test%'))) SQL (0.6ms) SELECT "documents"."id" AS t0_r0, "documents"."project_id" AS t0_r1, "documents"."category_id" AS t0_r2, "documents"."title" AS t0_r3, "documents"."description" AS t0_r4, "documents"."created_on" AS t0_r5, "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, "projects"."inherit_members" AS t1_r12 FROM "documents" LEFT OUTER JOIN "projects" ON "projects"."id" = "documents"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(documents.description) LIKE '%test%'))) ORDER BY documents.created_on DESC LIMIT 11 DEBUG: element: "changesets"  (0.6ms) SELECT COUNT(DISTINCT "changesets"."id") FROM "changesets" LEFT OUTER JOIN "repositories" ON "repositories"."id" = "changesets"."repository_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "repositories"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (((LOWER(comments) LIKE '%test%'))) SQL (2.5ms) SELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "repositories"."id" AS t1_r0, "repositories"."project_id" AS t1_r1, "repositories"."url" AS t1_r2, "repositories"."login" AS t1_r3, "repositories"."password" AS t1_r4, "repositories"."root_url" AS t1_r5, "repositories"."type" AS t1_r6, "repositories"."path_encoding" AS t1_r7, "repositories"."log_encoding" AS t1_r8, "repositories"."extra_info" AS t1_r9, "repositories"."identifier" AS t1_r10, "repositories"."is_default" AS t1_r11, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12 FROM "changesets" LEFT OUTER JOIN "repositories" ON "repositories"."id" = "changesets"."repository_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "repositories"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (((LOWER(comments) LIKE '%test%'))) ORDER BY committed_on DESC LIMIT 11 DEBUG: element: "wiki_pages"  (1.2ms) SELECT COUNT(DISTINCT "wiki_pages"."id") FROM "wiki_pages" LEFT OUTER JOIN "wikis" ON "wikis"."id" = "wiki_pages"."wiki_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "wikis"."project_id" LEFT OUTER JOIN "wiki_contents" ON "wiki_contents"."page_id" = "wiki_pages"."id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(wiki_contents.text) LIKE '%test%'))) SQL (1.5ms) SELECT "wiki_pages"."id" AS t0_r0, "wiki_pages"."wiki_id" AS t0_r1, "wiki_pages"."title" AS t0_r2, "wiki_pages"."created_on" AS t0_r3, "wiki_pages"."protected" AS t0_r4, "wiki_pages"."parent_id" AS t0_r5, "wikis"."id" AS t1_r0, "wikis"."project_id" AS t1_r1, "wikis"."start_page" AS t1_r2, "wikis"."status" AS t1_r3, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12, "wiki_contents"."id" AS t3_r0, "wiki_contents"."page_id" AS t3_r1, "wiki_contents"."author_id" AS t3_r2, "wiki_contents"."text" AS t3_r3, "wiki_contents"."comments" AS t3_r4, "wiki_contents"."updated_on" AS t3_r5, "wiki_contents"."version" AS t3_r6 FROM "wiki_pages" LEFT OUTER JOIN "wikis" ON "wikis"."id" = "wiki_pages"."wiki_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "wikis"."project_id" LEFT OUTER JOIN "wiki_contents" ON "wiki_contents"."page_id" = "wiki_pages"."id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(wiki_contents.text) LIKE '%test%'))) ORDER BY wiki_pages.created_on DESC LIMIT 11 DEBUG: element: "messages"  (0.8ms) SELECT COUNT(DISTINCT "messages"."id") FROM "messages" LEFT OUTER JOIN "boards" ON "boards"."id" = "messages"."board_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "boards"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(content) LIKE '%test%'))) SQL (1.9ms) SELECT "messages"."id" AS t0_r0, "messages"."board_id" AS t0_r1, "messages"."parent_id" AS t0_r2, "messages"."subject" AS t0_r3, "messages"."content" AS t0_r4, "messages"."author_id" AS t0_r5, "messages"."replies_count" AS t0_r6, "messages"."last_reply_id" AS t0_r7, "messages"."created_on" AS t0_r8, "messages"."updated_on" AS t0_r9, "messages"."locked" AS t0_r10, "messages"."sticky" AS t0_r11, "boards"."id" AS t1_r0, "boards"."project_id" AS t1_r1, "boards"."name" AS t1_r2, "boards"."description" AS t1_r3, "boards"."position" AS t1_r4, "boards"."topics_count" AS t1_r5, "boards"."messages_count" AS t1_r6, "boards"."last_message_id" AS t1_r7, "boards"."parent_id" AS t1_r8, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12 FROM "messages" LEFT OUTER JOIN "boards" ON "boards"."id" = "messages"."board_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "boards"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(content) LIKE '%test%'))) ORDER BY messages.created_on DESC LIMIT 11 DEBUG: element: "projects"  (0.3ms) SELECT "custom_fields"."id" FROM "custom_fields" WHERE "custom_fields"."type" = 'ProjectCustomField' AND "customfields"."searchable" = 't'  (0.2ms) SELECT COUNT() FROM "projects" WHERE (projects.status <> 9) AND (((LOWER(name) LIKE '%test%') OR (LOWER(identifier) LIKE '%test%') OR (LOWER(description) LIKE '%test%'))) Project Load (0.4ms) SELECT "projects"._ FROM "projects" WHERE (projects.status <> 9) AND (((LOWER(name) LIKE '%test%') OR (LOWER(identifier) LIKE '%test%') OR (LOWER(description) LIKE '%test%'))) ORDER BY projects.createdon DESC LIMIT 11 DEBUG: element: "attachments"  (1.3ms) SELECT COUNT() FROM "attachments" INNER JOIN documents ON documents.id=container_id INNER JOIN projects ON documents.project_id=projects.id WHERE "attachments"."container_type" = 'Document' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='documents')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (1.0ms) SELECT "attachments". FROM "attachments" INNER JOIN documents ON documents.id=container_id INNER JOIN projects ON documents.project_id=projects.id WHERE "attachments"."container_type" = 'Document' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (2.3ms) SELECT COUNT() FROM "attachments" INNER JOIN issues ON issues.id=container_id INNER JOIN projects ON issues.project_id = projects.id AND projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking') WHERE "attachments"."container_type" = 'Issue' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issuetracking')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (3.5ms) SELECT "attachments". FROM "attachments" INNER JOIN issues ON issues.id=container_id INNER JOIN projects ON issues.project_id = projects.id AND projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking') WHERE "attachments"."container_type" = 'Issue' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (0.9ms) SELECT COUNT() FROM "attachments" INNER JOIN messages ON messages.id=container_id INNER JOIN boards ON boards.id=messages.board_id INNER JOIN projects ON boards.project_id=projects.id WHERE "attachments"."container_type" = 'Message' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='boards')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (1.8ms) SELECT "attachments". FROM "attachments" INNER JOIN messages ON messages.id=container_id INNER JOIN boards ON boards.id=messages.board_id INNER JOIN projects ON boards.project_id=projects.id WHERE "attachments"."container_type" = 'Message' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (1.3ms) SELECT COUNT() FROM "attachments" INNER JOIN wiki_pages ON wiki_pages.id=container_id INNER JOIN wikis ON wikis.id=wiki_pages.wiki_id INNER JOIN projects ON wikis.project_id=projects.id WHERE "attachments"."container_type" = 'WikiPage' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='wiki')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (1.5ms) SELECT "attachments". FROM "attachments" INNER JOIN wiki_pages ON wiki_pages.id=container_id INNER JOIN wikis ON wikis.id=wiki_pages.wiki_id INNER JOIN projects ON wikis.project_id=projects.id WHERE "attachments"."container_type" = 'WikiPage' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (0.9ms) SELECT COUNT() FROM "attachments" INNER JOIN versions ON versions.id=container_id INNER JOIN projects ON versions.project_id=projects.id WHERE "attachments"."container_type" = 'Version' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='files')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (0.9ms) SELECT "attachments". FROM "attachments" INNER JOIN versions ON versions.id=container_id INNER JOIN projects ON versions.project_id=projects.id WHERE "attachments"."container_type" = 'Version' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='files')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.created_on DESC LIMIT 11 DEBUG: call xapian search service for "Attachment" DEBUG: global settings dump{"enable"=>"true", "index_database"=>"/var/tmp", "stemming_lang"=>"english", "stemming_strategy"=>"STEM_SOME", "stem_on_search"=>"false", "stem_langs"=>["english", "spanish", "german"]} DEBUG: user_stem_lang: "english" DEBUG: user_stem_strategy: "STEM_SOME" DEBUG: databasepath: /var/tmp/english ERROR: xapian database cannot be open #<IOError: DatabaseOpeningError: Couldn't stat '/var/tmp/english'> DEBUG: call xapian search service for "Attachment" completed  (0.8ms) SELECT COUNT(DISTINCT "members"."id") FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9) IssueStatus Load (0.6ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 4 LIMIT 1 Tracker Load (0.3ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 UserPreference Load (0.4ms) SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 1 LIMIT 1 IssueStatus Load (0.3ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1 CACHE (0.0ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 Issue Load (4.3ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1 Project Load (1.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 IssueStatus Load (0.9ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 5 LIMIT 1 Tracker Load (0.3ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 1 LIMIT 1 Issue Load (0.8ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 28 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 IssueStatus Load (0.5ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 1 LIMIT 1 Issue Load (0.5ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1 CACHE (0.0ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 1 LIMIT 1 CACHE (0.0ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1 CACHE (0.0ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 Rendered search/index.html.erb within layouts/base (67.0ms) SQL (2.1ms) SELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "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, "projects"."inherit_members" AS t1_r12, "roles"."id" AS t2_r0, "roles"."name" AS t2_r1, "roles"."position" AS t2_r2, "roles"."assignable" AS t2_r3, "roles"."builtin" AS t2_r4, "roles"."permissions" AS t2_r5, "roles"."issues_visibility" AS t2_r6 FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9) ORDER BY projects.name Completed 200 OK in 241ms (Views: 147.8ms | ActiveRecord: 48.9ms)

xelkano commented 11 years ago

Ok, this is the problem:

DEBUG: databasepath: /var/tmp/english

this path is the default path, but it does not exist, you have to set your database path in plugin settings to /var/www/xapian-index, set it and save. Then, it should work.

2013/7/2 githubrs notifications@github.com

I hope that's the thing you want:

Started GET "/redmine/search?utf8=%E2%9C%93&q=test&scope=all&all_words=&all_words=1&titles_only=&issues=1&news=1&documents=1&changesets=1&wiki_pages=1&messages=1&projects=1&attachments=1&submit=Submit" for ::1 at 2013-07-02 09:13:07 +0100

Processing by SearchController#index as HTML Parameters: {"utf8"=>"✓", "q"=>"test", "scope"=>"all", "all_words"=>"1", "titles_only"=>"", "issues"=>"1", "news"=>"1", "documents"=>"1", "changesets"=>"1", "wiki_pages"=>"1", "messages"=>"1", "projects"=>"1", "attachments"=>"1", "submit"=>"Submit"} [1m[35m (0.7ms)[0m SELECT MAX("settings"."updated_on") AS max_id FROM "settings" [1m[36mUser Load (0.5ms)[0m [1mSELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = 1 AND "users"."id" = $1 LIMIT 1[0m [["id", 1]] Current user: admin (id=1) DEBUG: params[:user_stem_lang]nil"english" DEBUG: params[:user_stem_strategy]nil"STEM_SOME" DEBUG: scope ["issues", "news", "documents", "changesets", "wiki_pages", "messages", "projects", "attachments"] DEBUG: element: "issues" [1m[35m (0.4ms)[0m SELECT "custom_fields"."id" FROM "custom_fields" WHERE "custom_fields"."type" = 'IssueCustomField' AND "custom_fields"."searchable" = 't' [1m[36m (1.7ms)[0m [1mSELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%')))[0m [1m[35mSQL (1.3ms)[0m SELECT DISTINCT "issues".id, issues.id AS alias_0 FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) ORDER BY issues.idDESC LIMIT 11 [1m[36mSQL (2.8ms)[0m [1mSELECT "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"."closed_on" AS t0_r23, "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, "projects"."inherit_members" AS t1_r12, "journals"."id" AS t2_r0, "journals"."journalized_id" AS t2_r1, "journals"."journalized_type" AS t2_r2, "journals"."user_id" AS t2_r3, "journals"."notes" AS t2_r4, "journals"."created_on" AS t2_r5, "journals"."private_notes" AS t2_r6 FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE "issues"."id" IN (30, 29, 28, 26, 25, 24, 23, 22, 21, 20, 19) AND (projects.status <> 9 AND projects.idIN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) ORDER BY issues.id DESC[0m DEBUG: element: "news" [1m[35m (0.8ms)[0m SELECT COUNT(DISTINCT "news"."id") FROM "news" LEFT OUTER JOIN "projects" ON "projects"."id" = "news"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(summary) LIKE '%test%') OR (LOWER(news.description) LIKE '%test%'))) [1m[36mSQL (1.4ms)[0m [1mSELECT "news"."id" AS t0_r0, "news"."project_id" AS t0_r1, "news"."title" AS t0_r2, "news"."summary" AS t0_r3, "news"."description" AS t0_r4, "news"."author_id" AS t0_r5, "news"."created_on" AS t0_r6, "news"."comments_count" AS t0_r7, "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, "projects"."inherit_members" AS t1_r12 FROM "news" LEFT OUTER JOIN "projects" ON "projects"."id" = "news"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(summary) LIKE '%test%') OR (LOWER(news.description) LIKE '%test%'))) ORDER BY news.created_on DESC LIMIT 11[0m DEBUG: element: "documents" [1m[35m (0.7ms)[0m SELECT COUNT(DISTINCT "documents"."id") FROM "documents" LEFT OUTER JOIN "projects" ON "projects"."id" = "documents"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(documents.description) LIKE '%test%'))) [1m[36mSQL (0.6ms)[0m [1mSELECT "documents"."id" AS t0_r0, "documents"."project_id" AS t0_r1, "documents"."category_id" AS t0_r2, "documents"."title" AS t0_r3, "documents"."description" AS t0_r4, "documents"."created_on" AS t0_r5, "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, "projects"."inherit_members" AS t1_r12 FROM "documents" LEFT OUTER JOIN "projects" ON "projects"."id" = "documents"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(documents.description) LIKE '%test%'))) ORDER BY documents.created_on DESC LIMIT 11[0m DEBUG: element: "changesets" [1m[35m (0.6ms)[0m SELECT COUNT(DISTINCT "changesets"."id") FROM "changesets" LEFT OUTER JOIN "repositories" ON "repositories"."id" = "changesets"."repository_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "repositories"."project_id" WHERE (projects.status <> 9 AND projects.idIN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (((LOWER(comments) LIKE '%test%'))) [1m[36mSQL (2.5ms)[0m [1mSELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "repositories"."id" AS t1_r0, "repositories"."project_id" AS t1_r1, "repositories"."url" AS t1_r2, "repositories"."login" AS t1_r3, "repositories"."password" AS t1_r4, "repositories"."root_url" AS t1_r5, "repositories"."type" AS t1_r6, "repositories"."path_encoding" AS t1_r7, "repositories"."log_encoding" AS t1_r8, "repositories"."extra_info" AS t1_r9, "repositories"."identifier" AS t1_r10, "repositories"."is_default" AS t1_r11, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12 FROM "changesets" LEFT OUTER JOIN "repositories" ON "repositories"."id" = "changesets"."repository_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "repositories"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (((LOWER(comments) LIKE '%test%'))) ORDER BY committed_on DESC LIMIT 11[0m DEBUG: element: "wiki_pages" [1m[35m (1.2ms)[0m SELECT COUNT(DISTINCT "wiki_pages"."id") FROM "wiki_pages" LEFT OUTER JOIN "wikis" ON "wikis"."id" = "wiki_pages"."wiki_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "wikis"."project_id" LEFT OUTER JOIN "wiki_contents" ON "wiki_contents"."page_id" = "wiki_pages"."id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(wiki_contents.text) LIKE '%test%'))) [1m[36mSQL (1.5ms)[0m [1mSELECT "wiki_pages"."id" AS t0_r0, "wiki_pages"."wiki_id" AS t0_r1, "wiki_pages"."title" AS t0_r2, "wiki_pages"."created_on" AS t0_r3, "wiki_pages"."protected" AS t0_r4, "wiki_pages"."parent_id" AS t0_r5, "wikis"."id" AS t1_r0, "wikis"."project_id" AS t1_r1, "wikis"."start_page" AS t1_r2, "wikis"."status" AS t1_r3, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12, "wiki_contents"."id" AS t3_r0, "wiki_contents"."page_id" AS t3_r1, "wiki_contents"."author_id" AS t3_r2, "wiki_contents"."text" AS t3_r3, "wiki_contents"."comments" AS t3_r4, "wiki_contents"."updated_on" AS t3_r5, "wiki_contents"."version" AS t3_r6 FROM "wiki_pages" LEFT OUTER JOIN "wikis" ON "wikis"."id" = "wiki_pages"."wiki_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "wikis"."project_id" LEFT OUTER JOIN "wiki_contents" ON "wiki_contents"."page_id" = "wiki_pages"."id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(wiki_contents.text) LIKE '%test%'))) ORDER BY wiki_pages.created_on DESC LIMIT 11[0m DEBUG: element: "messages" [1m[35m (0.8ms)[0m SELECT COUNT(DISTINCT "messages"."id") FROM "messages" LEFT OUTER JOIN "boards" ON "boards"."id" = "messages"."board_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "boards"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(content) LIKE '%test%'))) [1m[36mSQL (1.9ms)[0m [1mSELECT "messages"."id" AS t0_r0, "messages"."board_id" AS t0_r1, "messages"."parent_id" AS t0_r2, "messages"."subject" AS t0_r3, "messages"."content" AS t0_r4, "messages"."author_id" AS t0_r5, "messages"."replies_count" AS t0_r6, "messages"."last_reply_id" AS t0_r7, "messages"."created_on" AS t0_r8, "messages"."updated_on" AS t0_r9, "messages"."locked" AS t0_r10, "messages"."sticky" AS t0_r11, "boards"."id" AS t1_r0, "boards"."project_id" AS t1_r1, "boards"."name" AS t1_r2, "boards"."description" AS t1_r3, "boards"."position" AS t1_r4, "boards"."topics_count" AS t1_r5, "boards"."messages_count" AS t1_r6, "boards"."last_message_id" AS t1_r7, "boards"."parent_id" AS t1_r8, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12 FROM "messages" LEFT OUTER JOIN "boards" ON "boards"."id" = "messages"."board_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "boards"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(content) LIKE '%test%'))) ORDER BY messages.created_on DESC LIMIT 11[0m DEBUG: element: "projects" [1m[35m (0.3ms)[0m SELECT "custom_fields"."id" FROM "custom_fields" WHERE "custom_fields"."type" = 'ProjectCustomField' AND "customfields"."searchable" = 't' [1m[36m (0.2ms)[0m [1mSELECT COUNT() FROM "projects" WHERE (projects.status <> 9) AND (((LOWER(name) LIKE '%test%') OR (LOWER(identifier) LIKE '%test%') OR (LOWER(description) LIKE '%test%')))[0m [1m[35mProject Load (0.4ms)[0m SELECT "projects"._ FROM "projects" WHERE (projects.status <> 9) AND (((LOWER(name) LIKE '%test%') OR (LOWER(identifier) LIKE '%test%') OR (LOWER(description) LIKE '%test%'))) ORDER BY projects.createdon DESC LIMIT 11 DEBUG: element: "attachments" [1m[36m (1.3ms)[0m [1mSELECT COUNT() FROM "attachments" INNER JOIN documents ON documents.id=container_id INNER JOIN projects ON documents.project_id=projects.id WHERE "attachments"."container_type" = 'Document' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='documents')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%')))[0m [1m[35mAttachment Load (1.0ms)[0m SELECT "attachments". FROM "attachments" INNER JOIN documents ON documents.id=container_id INNER JOIN projects ON documents.project_id=projects.id WHERE "attachments"."container_type" = 'Document' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11 [1m[36m (2.3ms)[0m [1mSELECT COUNT() FROM "attachments" INNER JOIN issues ON issues.id=container_id INNER JOIN projects ON issues.project_id = projects.id AND projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking') WHERE "attachments"."container_type" = 'Issue' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issuetracking')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%')))[0m [1m[35mAttachment Load (3.5ms)[0m SELECT "attachments". FROM "attachments" INNER JOIN issues ON issues.id=container_id INNER JOIN projects ON issues.project_id = projects.id AND projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking') WHERE "attachments"."container_type" = 'Issue' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11 [1m[36m (0.9ms)[0m [1mSELECT COUNT() FROM "attachments" INNER JOIN messages ON messages.id=container_id INNER JOIN boards ON boards.id=messages.board_id INNER JOIN projects ON boards.project_id=projects.id WHERE "attachments"."container_type" = 'Message' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='boards')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%')))[0m [1m[35mAttachment Load (1.8ms)[0m SELECT "attachments". FROM "attachments" INNER JOIN messages ON messages.id=container_id INNER JOIN boards ON boards.id=messages.board_id INNER JOIN projects ON boards.project_id=projects.id WHERE "attachments"."container_type" = 'Message' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11 [1m[36m (1.3ms)[0m [1mSELECT COUNT() FROM "attachments" INNER JOIN wiki_pages ON wiki_pages.id=container_id INNER JOIN wikis ON wikis.id=wiki_pages.wiki_id INNER JOIN projects ON wikis.project_id=projects.id WHERE "attachments"."container_type" = 'WikiPage' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='wiki')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%')))[0m [1m[35mAttachment Load (1.5ms)[0m SELECT "attachments". FROM "attachments" INNER JOIN wiki_pages ON wiki_pages.id=container_id INNER JOIN wikis ON wikis.id=wiki_pages.wiki_id INNER JOIN projects ON wikis.project_id=projects.id WHERE "attachments"."container_type" = 'WikiPage' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11 [1m[36m (0.9ms)[0m [1mSELECT COUNT() FROM "attachments" INNER JOIN versions ON versions.id=container_id INNER JOIN projects ON versions.project_id=projects.id WHERE "attachments"."container_type" = 'Version' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='files')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%')))[0m [1m[35mAttachment Load (0.9ms)[0m SELECT "attachments". FROM "attachments" INNER JOIN versions ON versions.id=container_id INNER JOIN projects ON versions.project_id=projects.id WHERE "attachments"."container_type" = 'Version' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='files')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.created_on DESC LIMIT 11 DEBUG: call xapian search service for "Attachment" DEBUG: global settings dump{"enable"=>"true", "index_database"=>"/var/tmp", "stemming_lang"=>"english", "stemming_strategy"=>"STEM_SOME", "stem_on_search"=>"false", "stem_langs"=>["english", "spanish", "german"]} DEBUG: user_stem_lang: "english" DEBUG: user_stem_strategy: "STEM_SOME" DEBUG: databasepath: /var/tmp/english

ERROR: xapian database cannot be open # DEBUG: call xapian search service for "Attachment" completed [1m[36m (0.8ms)[0m [1mSELECT COUNT(DISTINCT "members"."id") FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9)[0m [1m[35mIssueStatus Load (0.6ms)[0m SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 4 LIMIT 1 [1m[36mTracker Load (0.3ms)[0m [1mSELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1[0m [1m[35mUserPreference Load (0.4ms)[0m SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 1 LIMIT 1 [1m[36mIssueStatus Load (0.3ms)[0m [1mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 [1m[36mIssue Load (4.3ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1[0m [1m[35mProject Load (1.5ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 [1m[36mIssueStatus Load (0.9ms)[0m [1mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 5 LIMIT 1[0m [1m[35mTracker Load (0.3ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 1 LIMIT 1 [1m[36mIssue Load (0.8ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 28 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 [1m[36mIssueStatus Load (0.5ms)[0m [1mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 3 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 1 LIMIT 1 [1m[36mIssue Load (0.5ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 1 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 Rendered search/index.html.erb within layouts/base (67.0ms) [1m[36mSQL (2.1ms)[0m [1mSELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "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, "projects"."inherit_members" AS t1_r12, "roles"."id" AS t2_r0, "roles"."name" AS t2_r1, "roles"."position" AS t2_r2, "roles"."assignable" AS t2_r3, "roles"."builtin" AS t2_r4, "roles"."permissions" AS t2_r5, "roles"."issues_visibility" AS t2_r6 FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9) ORDER BY projects.name[0m Completed 200 OK in 241ms (Views: 147.8ms | ActiveRecord: 48.9ms)

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20332502 .

githubrs commented 11 years ago

The error in the log is gone, but unfortunately it doesn#t work. There is still no 'next' button. This is the new log. It's quite long:

Started GET "/redmine/search?utf8=%E2%9C%93&q=test&scope=all&all_words=&all_words=1&titles_only=&issues=1&news=1&documents=1&changesets=1&wiki_pages=1&messages=1&projects=1&attachments=1&submit=Submit" for ::1 at 2013-07-02 09:50:44 +0100 Processing by SearchController#index as HTML Parameters: {"utf8"=>"✓", "q"=>"test", "scope"=>"all", "all_words"=>"1", "titles_only"=>"", "issues"=>"1", "news"=>"1", "documents"=>"1", "changesets"=>"1", "wiki_pages"=>"1", "messages"=>"1", "projects"=>"1", "attachments"=>"1", "submit"=>"Submit"}  (3.2ms) SELECT MAX("settings"."updated_on") AS max_id FROM "settings" User Load (0.9ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."status" = 1 AND "users"."id" = $1 LIMIT 1 [["id", 1]] Current user: admin (id=1) DEBUG: params[:user_stem_lang]nil"english" DEBUG: params[:user_stem_strategy]nil"STEM_SOME" DEBUG: scope ["issues", "news", "documents", "changesets", "wiki_pages", "messages", "projects", "attachments"] DEBUG: element: "issues"  (0.7ms) SELECT "custom_fields"."id" FROM "custom_fields" WHERE "custom_fields"."type" = 'IssueCustomField' AND "custom_fields"."searchable" = 't'  (1.9ms) SELECT COUNT(DISTINCT "issues"."id") FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) SQL (1.6ms) SELECT DISTINCT "issues".id, issues.id AS alias_0 FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) ORDER BY issues.id DESC LIMIT 11 SQL (3.2ms) 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"."closed_on" AS t0_r23, "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, "projects"."inherit_members" AS t1_r12, "journals"."id" AS t2_r0, "journals"."journalized_id" AS t2_r1, "journals"."journalized_type" AS t2_r2, "journals"."user_id" AS t2_r3, "journals"."notes" AS t2_r4, "journals"."created_on" AS t2_r5, "journals"."private_notes" AS t2_r6 FROM "issues" LEFT OUTER JOIN "projects" ON "projects"."id" = "issues"."project_id" LEFT OUTER JOIN "journals" ON "journals"."journalized_id" = "issues"."id" AND (journals.private_notes = 'f' OR (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) AND "journals"."journalized_type" = 'Issue' WHERE "issues"."id" IN (30, 29, 28, 26, 25, 24, 23, 22, 21, 20, 19) AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(issues.description) LIKE '%test%') OR (LOWER(journals.notes) LIKE '%test%'))) ORDER BY issues.id DESC DEBUG: element: "news"  (0.8ms) SELECT COUNT(DISTINCT "news"."id") FROM "news" LEFT OUTER JOIN "projects" ON "projects"."id" = "news"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(summary) LIKE '%test%') OR (LOWER(news.description) LIKE '%test%'))) SQL (0.7ms) SELECT "news"."id" AS t0_r0, "news"."project_id" AS t0_r1, "news"."title" AS t0_r2, "news"."summary" AS t0_r3, "news"."description" AS t0_r4, "news"."author_id" AS t0_r5, "news"."created_on" AS t0_r6, "news"."comments_count" AS t0_r7, "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, "projects"."inherit_members" AS t1_r12 FROM "news" LEFT OUTER JOIN "projects" ON "projects"."id" = "news"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(summary) LIKE '%test%') OR (LOWER(news.description) LIKE '%test%'))) ORDER BY news.created_on DESC LIMIT 11 DEBUG: element: "documents"  (0.6ms) SELECT COUNT(DISTINCT "documents"."id") FROM "documents" LEFT OUTER JOIN "projects" ON "projects"."id" = "documents"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(documents.description) LIKE '%test%'))) SQL (0.7ms) SELECT "documents"."id" AS t0_r0, "documents"."project_id" AS t0_r1, "documents"."category_id" AS t0_r2, "documents"."title" AS t0_r3, "documents"."description" AS t0_r4, "documents"."created_on" AS t0_r5, "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, "projects"."inherit_members" AS t1_r12 FROM "documents" LEFT OUTER JOIN "projects" ON "projects"."id" = "documents"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(documents.description) LIKE '%test%'))) ORDER BY documents.created_on DESC LIMIT 11 DEBUG: element: "changesets"  (0.7ms) SELECT COUNT(DISTINCT "changesets"."id") FROM "changesets" LEFT OUTER JOIN "repositories" ON "repositories"."id" = "changesets"."repository_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "repositories"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (((LOWER(comments) LIKE '%test%'))) SQL (1.1ms) SELECT "changesets"."id" AS t0_r0, "changesets"."repository_id" AS t0_r1, "changesets"."revision" AS t0_r2, "changesets"."committer" AS t0_r3, "changesets"."committed_on" AS t0_r4, "changesets"."comments" AS t0_r5, "changesets"."commit_date" AS t0_r6, "changesets"."scmid" AS t0_r7, "changesets"."user_id" AS t0_r8, "repositories"."id" AS t1_r0, "repositories"."project_id" AS t1_r1, "repositories"."url" AS t1_r2, "repositories"."login" AS t1_r3, "repositories"."password" AS t1_r4, "repositories"."root_url" AS t1_r5, "repositories"."type" AS t1_r6, "repositories"."path_encoding" AS t1_r7, "repositories"."log_encoding" AS t1_r8, "repositories"."extra_info" AS t1_r9, "repositories"."identifier" AS t1_r10, "repositories"."is_default" AS t1_r11, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12 FROM "changesets" LEFT OUTER JOIN "repositories" ON "repositories"."id" = "changesets"."repository_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "repositories"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='repository')) AND (((LOWER(comments) LIKE '%test%'))) ORDER BY committed_on DESC LIMIT 11 DEBUG: element: "wiki_pages"  (0.9ms) SELECT COUNT(DISTINCT "wiki_pages"."id") FROM "wiki_pages" LEFT OUTER JOIN "wikis" ON "wikis"."id" = "wiki_pages"."wiki_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "wikis"."project_id" LEFT OUTER JOIN "wiki_contents" ON "wiki_contents"."page_id" = "wiki_pages"."id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(wiki_contents.text) LIKE '%test%'))) SQL (1.2ms) SELECT "wiki_pages"."id" AS t0_r0, "wiki_pages"."wiki_id" AS t0_r1, "wiki_pages"."title" AS t0_r2, "wiki_pages"."created_on" AS t0_r3, "wiki_pages"."protected" AS t0_r4, "wiki_pages"."parent_id" AS t0_r5, "wikis"."id" AS t1_r0, "wikis"."project_id" AS t1_r1, "wikis"."start_page" AS t1_r2, "wikis"."status" AS t1_r3, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12, "wiki_contents"."id" AS t3_r0, "wiki_contents"."page_id" AS t3_r1, "wiki_contents"."author_id" AS t3_r2, "wiki_contents"."text" AS t3_r3, "wiki_contents"."comments" AS t3_r4, "wiki_contents"."updated_on" AS t3_r5, "wiki_contents"."version" AS t3_r6 FROM "wiki_pages" LEFT OUTER JOIN "wikis" ON "wikis"."id" = "wiki_pages"."wiki_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "wikis"."project_id" LEFT OUTER JOIN "wiki_contents" ON "wiki_contents"."page_id" = "wiki_pages"."id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(title) LIKE '%test%') OR (LOWER(wiki_contents.text) LIKE '%test%'))) ORDER BY wiki_pages.created_on DESC LIMIT 11 DEBUG: element: "messages"  (1.6ms) SELECT COUNT(DISTINCT "messages"."id") FROM "messages" LEFT OUTER JOIN "boards" ON "boards"."id" = "messages"."board_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "boards"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(content) LIKE '%test%'))) SQL (0.9ms) SELECT "messages"."id" AS t0_r0, "messages"."board_id" AS t0_r1, "messages"."parent_id" AS t0_r2, "messages"."subject" AS t0_r3, "messages"."content" AS t0_r4, "messages"."author_id" AS t0_r5, "messages"."replies_count" AS t0_r6, "messages"."last_reply_id" AS t0_r7, "messages"."created_on" AS t0_r8, "messages"."updated_on" AS t0_r9, "messages"."locked" AS t0_r10, "messages"."sticky" AS t0_r11, "boards"."id" AS t1_r0, "boards"."project_id" AS t1_r1, "boards"."name" AS t1_r2, "boards"."description" AS t1_r3, "boards"."position" AS t1_r4, "boards"."topics_count" AS t1_r5, "boards"."messages_count" AS t1_r6, "boards"."last_message_id" AS t1_r7, "boards"."parent_id" AS t1_r8, "projects"."id" AS t2_r0, "projects"."name" AS t2_r1, "projects"."description" AS t2_r2, "projects"."homepage" AS t2_r3, "projects"."is_public" AS t2_r4, "projects"."parent_id" AS t2_r5, "projects"."created_on" AS t2_r6, "projects"."updated_on" AS t2_r7, "projects"."identifier" AS t2_r8, "projects"."status" AS t2_r9, "projects"."lft" AS t2_r10, "projects"."rgt" AS t2_r11, "projects"."inherit_members" AS t2_r12 FROM "messages" LEFT OUTER JOIN "boards" ON "boards"."id" = "messages"."board_id" LEFT OUTER JOIN "projects" ON "projects"."id" = "boards"."project_id" WHERE (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(subject) LIKE '%test%') OR (LOWER(content) LIKE '%test%'))) ORDER BY messages.created_on DESC LIMIT 11 DEBUG: element: "projects"  (0.2ms) SELECT "custom_fields"."id" FROM "custom_fields" WHERE "custom_fields"."type" = 'ProjectCustomField' AND "customfields"."searchable" = 't'  (0.4ms) SELECT COUNT() FROM "projects" WHERE (projects.status <> 9) AND (((LOWER(name) LIKE '%test%') OR (LOWER(identifier) LIKE '%test%') OR (LOWER(description) LIKE '%test%'))) Project Load (0.4ms) SELECT "projects"._ FROM "projects" WHERE (projects.status <> 9) AND (((LOWER(name) LIKE '%test%') OR (LOWER(identifier) LIKE '%test%') OR (LOWER(description) LIKE '%test%'))) ORDER BY projects.createdon DESC LIMIT 11 DEBUG: element: "attachments"  (1.2ms) SELECT COUNT() FROM "attachments" INNER JOIN documents ON documents.id=container_id INNER JOIN projects ON documents.project_id=projects.id WHERE "attachments"."container_type" = 'Document' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='documents')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (1.0ms) SELECT "attachments". FROM "attachments" INNER JOIN documents ON documents.id=container_id INNER JOIN projects ON documents.project_id=projects.id WHERE "attachments"."container_type" = 'Document' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='documents')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (2.5ms) SELECT COUNT() FROM "attachments" INNER JOIN issues ON issues.id=container_id INNER JOIN projects ON issues.project_id = projects.id AND projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking') WHERE "attachments"."container_type" = 'Issue' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issuetracking')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (2.2ms) SELECT "attachments". FROM "attachments" INNER JOIN issues ON issues.id=container_id INNER JOIN projects ON issues.project_id = projects.id AND projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking') WHERE "attachments"."container_type" = 'Issue' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (1.3ms) SELECT COUNT() FROM "attachments" INNER JOIN messages ON messages.id=container_id INNER JOIN boards ON boards.id=messages.board_id INNER JOIN projects ON boards.project_id=projects.id WHERE "attachments"."container_type" = 'Message' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='boards')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (0.9ms) SELECT "attachments". FROM "attachments" INNER JOIN messages ON messages.id=container_id INNER JOIN boards ON boards.id=messages.board_id INNER JOIN projects ON boards.project_id=projects.id WHERE "attachments"."container_type" = 'Message' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='boards')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (0.9ms) SELECT COUNT() FROM "attachments" INNER JOIN wiki_pages ON wiki_pages.id=container_id INNER JOIN wikis ON wikis.id=wiki_pages.wiki_id INNER JOIN projects ON wikis.project_id=projects.id WHERE "attachments"."container_type" = 'WikiPage' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='wiki')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (0.9ms) SELECT "attachments". FROM "attachments" INNER JOIN wiki_pages ON wiki_pages.id=container_id INNER JOIN wikis ON wikis.id=wiki_pages.wiki_id INNER JOIN projects ON wikis.project_id=projects.id WHERE "attachments"."container_type" = 'WikiPage' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='wiki')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.createdon DESC LIMIT 11  (0.9ms) SELECT COUNT() FROM "attachments" INNER JOIN versions ON versions.id=container_id INNER JOIN projects ON versions.project_id=projects.id WHERE "attachments"."container_type" = 'Version' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabledmodules em WHERE em.name='files')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) Attachment Load (0.8ms) SELECT "attachments". FROM "attachments" INNER JOIN versions ON versions.id=container_id INNER JOIN projects ON versions.project_id=projects.id WHERE "attachments"."container_type" = 'Version' AND (projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='files')) AND (((LOWER(attachments.filename) LIKE '%test%') OR (LOWER(attachments.description) LIKE '%test%'))) ORDER BY attachments.created_on DESC LIMIT 11 DEBUG: call xapian search service for "Attachment" DEBUG: global settings dump{"enable"=>"true", "index_database"=>"/var/www/xapian-index", "stem_on_search"=>"false", "stemming_lang"=>"english", "stem_langs"=>["english", "german", "spanish"], "stemming_strategy"=>"STEM_SOME"} DEBUG: user_stem_lang: "english" DEBUG: user_stem_strategy: "STEM_SOME" DEBUG: databasepath: /var/www/xapian-index/english DEBUG query_string is: test DEBUG: Parsed query is: Xapian::Query(Ztest:(pos=1)) DEBUG: Matches 1-46:

DEBUG: m: "url=/2013/06/130627091507_HowTo_Redmine_Installation_with_Database-Restore.html\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/html\nmodtime=1372320907\nsize=2870" DEBUG: dochash not nil.. 2013/06/130627091507_HowTo_Redmine_Installation_with_Database-Restore.html DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091507_HowTo_Redmine_Installation_with_Database-Restore.html' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:15:07 UTC +00:00 Issue Load (0.5ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 Project Load (0.3ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 82, container_id: 19, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.ht...", disk_filename: "130627091507_HowTo_Redmine_Installation_with_Databa...", filesize: 2870, content_type: nil, digest: "17aebf1e726d09b78045920eb0e44268", downloads: 0, author_id: 5, created_on: "2013-06-27 08:15:07", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. EnabledModule Load (0.3ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092616_HowTo_Redmine_Installation_with_Database-Restore.txt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/plain\nmodtime=1372321576\nsize=2143" DEBUG: dochash not nil.. 2013/06/130627092616_HowTo_Redmine_Installation_with_Database-Restore.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.7ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092616_HowTo_Redmine_Installation_with_Database-Restore.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:26:16 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 Project Load (0.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 137, container_id: 30, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.tx...", disk_filename: "130627092616_HowTo_Redmine_Installation_with_Databa...", filesize: 2143, content_type: nil, digest: "a6d2f1e990727fc729865d1e9b4447e6", downloads: 0, author_id: 4, created_on: "2013-06-27 08:26:16", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. EnabledModule Load (0.4ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091838_HowTo_Redmine_Installation_with_Database-Restore.docx\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.openxmlformats-officedocument.wordprocessingml.document\nmodtime=1372321118\nsize=4506" DEBUG: dochash not nil.. 2013/06/130627091838_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.8ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091838_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:18:38 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 23 LIMIT 1 Project Load (0.3ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 DEBUG: attach project#<Project id: 2, name: "Project Apple", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:16", updated_on: "2013-06-27 07:47:16", identifier: "project-apple", status: 1, lft: 1, rgt: 2, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 97, container_id: 23, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627091838_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 6, created_on: "2013-06-27 08:18:38", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. EnabledModule Load (0.3ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 2 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 23 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 2 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 2 DEBUG: project id: 2 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091644_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321004\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627091644_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091644_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:16:44 UTC +00:00 Issue Load (0.3ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 Project Load (0.2ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 95, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627091644_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 5, created_on: "2013-06-27 08:16:44", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. EnabledModule Load (0.3ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090504_HowTo_Redmine_Installation_with_Database-Restore.docx\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.openxmlformats-officedocument.wordprocessingml.document\nmodtime=1372320304\nsize=4506" DEBUG: dochash not nil.. 2013/06/130627090504_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090504_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:05:04 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 7 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 18, container_id: 7, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627090504_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 3, created_on: "2013-06-27 08:05:04", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 7 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092339_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321419\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092339_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.7ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092339_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:23:39 UTC +00:00 Issue Load (0.3ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 28 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 120, container_id: 28, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092339_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:23:39", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 28 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (2.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091352_HowTo_Redmine_Installation_with_Database-Restore.txt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/plain\nmodtime=1372320832\nsize=2143" DEBUG: dochash not nil.. 2013/06/130627091352_HowTo_Redmine_Installation_with_Database-Restore.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091352_HowTo_Redmine_Installation_with_Database-Restore.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:13:52 UTC +00:00 Issue Load (0.3ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 73, container_id: 17, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.tx...", disk_filename: "130627091352_HowTo_Redmine_Installation_with_Databa...", filesize: 2143, content_type: nil, digest: "a6d2f1e990727fc729865d1e9b4447e6", downloads: 0, author_id: 5, created_on: "2013-06-27 08:13:52", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090423_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320263\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627090423_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090423_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:04:23 UTC +00:00 Issue Load (0.8ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 6 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 13, container_id: 6, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627090423_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 3, created_on: "2013-06-27 08:04:23", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 6 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092336_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321416\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092336_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092336_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:23:36 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 28 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 118, container_id: 28, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092336_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:23:36", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 28 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090606_HowTo_Redmine_Installation_with_Database-Restore.txt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/plain\nmodtime=1372320366\nsize=2143" DEBUG: dochash not nil.. 2013/06/130627090606_HowTo_Redmine_Installation_with_Database-Restore.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090606_HowTo_Redmine_Installation_with_Database-Restore.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:06:06 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 8 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 28, container_id: 8, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.tx...", disk_filename: "130627090606_HowTo_Redmine_Installation_with_Databa...", filesize: 2143, content_type: nil, digest: "a6d2f1e990727fc729865d1e9b4447e6", downloads: 0, author_id: 3, created_on: "2013-06-27 08:06:06", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 8 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092222_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321342\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092222_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092222_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:22:22 UTC +00:00 Issue Load (0.3ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 110, container_id: 26, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092222_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:22:22", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092149_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321309\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092149_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092149_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:21:49 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 104, container_id: 25, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092149_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:21:49", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092147_HowTo_Redmine_Installation_with_Database-Restore.docx\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.openxmlformats-officedocument.wordprocessingml.document\nmodtime=1372321307\nsize=4506" DEBUG: dochash not nil.. 2013/06/130627092147_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (5.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092147_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:21:47 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 103, container_id: 25, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627092147_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 4, created_on: "2013-06-27 08:21:47", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092609_HowTo_Redmine_Installation_with_Database-Restore.html\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/html\nmodtime=1372321569\nsize=2870" DEBUG: dochash not nil.. 2013/06/130627092609_HowTo_Redmine_Installation_with_Database-Restore.html DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092609_HowTo_Redmine_Installation_with_Database-Restore.html' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:26:09 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 134, container_id: 30, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.ht...", disk_filename: "130627092609_HowTo_Redmine_Installation_with_Databa...", filesize: 2870, content_type: nil, digest: "17aebf1e726d09b78045920eb0e44268", downloads: 0, author_id: 4, created_on: "2013-06-27 08:26:09", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092249_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321369\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092249_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092249_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:22:49 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 114, container_id: 26, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092249_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:22:49", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 26 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090724_HowTo_Redmine_Installation_with_Database-Restore.html\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/html\nmodtime=1372320444\nsize=2870" DEBUG: dochash not nil.. 2013/06/130627090724_HowTo_Redmine_Installation_with_Database-Restore.html DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090724_HowTo_Redmine_Installation_with_Database-Restore.html' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:07:24 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 31, container_id: 10, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.ht...", disk_filename: "130627090724_HowTo_Redmine_Installation_with_Databa...", filesize: 2870, content_type: nil, digest: "17aebf1e726d09b78045920eb0e44268", downloads: 0, author_id: 3, created_on: "2013-06-27 08:07:24", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091354_HowTo_Redmine_Installation_with_Database-Restore.pdf\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version Ruby version Rails version Environment Database adapter 2.3.1.stable 1.9.3 (x86_64-linux) 3.2.13 production PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/pdf\nmodtime=1372320834\nsize=25273" DEBUG: dochash not nil.. 2013/06/130627091354_HowTo_Redmine_Installation_with_Database-Restore.pdf DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (5.3ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" =

githubrs commented 11 years ago

DEBUG: dochash not nil.. 2013/06/130627092606_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092606_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:26:06 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 133, container_id: 30, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627092606_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 4, created_on: "2013-06-27 08:26:06", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091519_HowTo_Redmine_Installation_with_Database-Restore.docx\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.openxmlformats-officedocument.wordprocessingml.document\nmodtime=1372320919\nsize=4506" DEBUG: dochash not nil.. 2013/06/130627091519_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091519_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:15:19 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 88, container_id: 19, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627091519_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 5, created_on: "2013-06-27 08:15:19", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090908_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372320548\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627090908_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.2ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090908_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:08 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 53, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627090908_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 3, created_on: "2013-06-27 08:09:08", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092152_HowTo_Redmine_Installation_with_Database-Restore.html\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/html\nmodtime=1372321312\nsize=2870" DEBUG: dochash not nil.. 2013/06/130627092152_HowTo_Redmine_Installation_with_Database-Restore.html DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.7ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092152_HowTo_Redmine_Installation_with_Database-Restore.html' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:21:52 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 106, container_id: 25, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.ht...", disk_filename: "130627092152_HowTo_Redmine_Installation_with_Databa...", filesize: 2870, content_type: nil, digest: "17aebf1e726d09b78045920eb0e44268", downloads: 0, author_id: 4, created_on: "2013-06-27 08:21:52", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090910_HowTo_Redmine_Installation_with_Database-Restore.pdf\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version Ruby version Rails version Environment Database adapter 2.3.1.stable 1.9.3 (x86_64-linux) 3.2.13 production PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/pdf\nmodtime=1372320550\nsize=25273" DEBUG: dochash not nil.. 2013/06/130627090910_HowTo_Redmine_Installation_with_Database-Restore.pdf DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.7ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090910_HowTo_Redmine_Installation_with_Database-Restore.pdf' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:10 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 54, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.pd...", disk_filename: "130627090910_HowTo_Redmine_Installation_with_Databa...", filesize: 25273, content_type: nil, digest: "fef20000cf71a436fe6eb41055c7f75d", downloads: 0, author_id: 3, created_on: "2013-06-27 08:09:10", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090905_HowTo_Redmine_Installation_with_Database-Restore.html\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/html\nmodtime=1372320545\nsize=2870" DEBUG: dochash not nil.. 2013/06/130627090905_HowTo_Redmine_Installation_with_Database-Restore.html DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090905_HowTo_Redmine_Installation_with_Database-Restore.html' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:05 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 52, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.ht...", disk_filename: "130627090905_HowTo_Redmine_Installation_with_Databa...", filesize: 2870, content_type: nil, digest: "17aebf1e726d09b78045920eb0e44268", downloads: 0, author_id: 3, created_on: "2013-06-27 08:09:05", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090728_HowTo_Redmine_Installation_with_Database-Restore.pdf\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version Ruby version Rails version Environment Database adapter 2.3.1.stable 1.9.3 (x86_64-linux) 3.2.13 production PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/pdf\nmodtime=1372320448\nsize=25273" DEBUG: dochash not nil.. 2013/06/130627090728_HowTo_Redmine_Installation_with_Database-Restore.pdf DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.7ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090728_HowTo_Redmine_Installation_with_Database-Restore.pdf' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:07:28 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 34, container_id: 10, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.pd...", disk_filename: "130627090728_HowTo_Redmine_Installation_with_Databa...", filesize: 25273, content_type: nil, digest: "fef20000cf71a436fe6eb41055c7f75d", downloads: 0, author_id: 3, created_on: "2013-06-27 08:07:28", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091350_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320830\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627091350_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091350_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:13:50 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 72, container_id: 17, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627091350_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 5, created_on: "2013-06-27 08:13:50", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091343_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320823\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627091343_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.3ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091343_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:13:43 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 68, container_id: 17, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627091343_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 5, created_on: "2013-06-27 08:13:43", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091345_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372320825\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627091345_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091345_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:13:45 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 69, container_id: 17, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627091345_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 5, created_on: "2013-06-27 08:13:45", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092451_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372321491\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627092451_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092451_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:24:51 UTC +00:00 Issue Load (1.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 127, container_id: 29, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627092451_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 4, created_on: "2013-06-27 08:24:51", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090425_HowTo_Redmine_Installation_with_Database-Restore.docx\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.openxmlformats-officedocument.wordprocessingml.document\nmodtime=1372320265\nsize=4506" DEBUG: dochash not nil.. 2013/06/130627090425_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090425_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:04:25 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 6 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 14, container_id: 6, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627090425_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 3, created_on: "2013-06-27 08:04:25", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 6 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.4ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092157_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321317\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092157_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (4.1ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092157_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:21:57 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 109, container_id: 25, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092157_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:21:57", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 25 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090415_HowTo_Redmine_Installation_with_Database-Restore.html\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/html\nmodtime=1372320255\nsize=2870" DEBUG: dochash not nil.. 2013/06/130627090415_HowTo_Redmine_Installation_with_Database-Restore.html DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090415_HowTo_Redmine_Installation_with_Database-Restore.html' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:04:15 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 6 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 9, container_id: 6, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.ht...", disk_filename: "130627090415_HowTo_Redmine_Installation_with_Databa...", filesize: 2870, content_type: nil, digest: "17aebf1e726d09b78045920eb0e44268", downloads: 0, author_id: 3, created_on: "2013-06-27 08:04:15", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 6 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092604_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372321564\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627092604_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092604_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:26:04 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 132, container_id: 30, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627092604_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 4, created_on: "2013-06-27 08:26:04", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091421_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372320861\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627091421_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091421_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:14:21 UTC +00:00 Issue Load (0.4ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 18 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 75, container_id: 18, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627091421_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 5, created_on: "2013-06-27 08:14:21", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 18 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090912_HowTo_Redmine_Installation_with_Database-Restore.txt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/plain\nmodtime=1372320552\nsize=2143" DEBUG: dochash not nil.. 2013/06/130627090912_HowTo_Redmine_Installation_with_Database-Restore.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090912_HowTo_Redmine_Installation_with_Database-Restore.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:12 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 55, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.tx...", disk_filename: "130627090912_HowTo_Redmine_Installation_with_Databa...", filesize: 2143, content_type: nil, digest: "a6d2f1e990727fc729865d1e9b4447e6", downloads: 0, author_id: 3, created_on: "2013-06-27 08:09:12", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092611_HowTo_Redmine_Installation_with_Database-Restore.odt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.oasis.opendocument.text\nmodtime=1372321571\nsize=21786" DEBUG: dochash not nil.. 2013/06/130627092611_HowTo_Redmine_Installation_with_Database-Restore.odt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092611_HowTo_Redmine_Installation_with_Database-Restore.odt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:26:11 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 135, container_id: 30, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.od...", disk_filename: "130627092611_HowTo_Redmine_Installation_with_Databa...", filesize: 21786, content_type: nil, digest: "bc2397df5a0ca9fda088554bca087e4d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:26:11", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092443_HowTo_Redmine_Installation_with_Database-Restore.txt\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=text/plain\nmodtime=1372321483\nsize=2143" DEBUG: dochash not nil.. 2013/06/130627092443_HowTo_Redmine_Installation_with_Database-Restore.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.1ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092443_HowTo_Redmine_Installation_with_Database-Restore.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:24:43 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 125, container_id: 29, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.tx...", disk_filename: "130627092443_HowTo_Redmine_Installation_with_Databa...", filesize: 2143, content_type: nil, digest: "a6d2f1e990727fc729865d1e9b4447e6", downloads: 0, author_id: 4, created_on: "2013-06-27 08:24:43", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090610_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320370\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627090610_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.0ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090610_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:06:10 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 8 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 30, container_id: 8, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627090610_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 3, created_on: "2013-06-27 08:06:10", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 8 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627092614_HowTo_Redmine_Installation_with_Database-Restore.pdf\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version Ruby version Rails version Environment Database adapter 2.3.1.stable 1.9.3 (x86_64-linux) 3.2.13 production PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/pdf\nmodtime=1372321574\nsize=25273" DEBUG: dochash not nil.. 2013/06/130627092614_HowTo_Redmine_Installation_with_Database-Restore.pdf DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627092614_HowTo_Redmine_Installation_with_Database-Restore.pdf' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:26:14 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 DEBUG: attach project#<Project id: 4, name: "Project Banana", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:09", updated_on: "2013-06-27 07:48:09", identifier: "project-banana", status: 1, lft: 3, rgt: 4, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 136, container_id: 30, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.pd...", disk_filename: "130627092614_HowTo_Redmine_Installation_with_Databa...", filesize: 25273, content_type: nil, digest: "fef20000cf71a436fe6eb41055c7f75d", downloads: 0, author_id: 4, created_on: "2013-06-27 08:26:14", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 30 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 4 DEBUG: project id: 4 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090903_HowTo_Redmine_Installation_with_Database-Restore.docx\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/vnd.openxmlformats-officedocument.wordprocessingml.document\nmodtime=1372320543\nsize=4506" DEBUG: dochash not nil.. 2013/06/130627090903_HowTo_Redmine_Installation_with_Database-Restore.docx DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (1.8ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090903_HowTo_Redmine_Installation_with_Database-Restore.docx' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:03 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 51, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627090903_HowTo_Redmine_Installation_with_Databa...", filesize: 4506, content_type: nil, digest: "2fb398b0946af43276d9ce9bf8b22d80", downloads: 0, author_id: 3, created_on: "2013-06-27 08:09:03", description: "", disk_directory: "2013/06">

githubrs commented 11 years ago

DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091521_HowTo_Redmine_Installation_with_Database-Restore.pdf\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version Ruby version Rails version Environment Database adapter 2.3.1.stable 1.9.3 (x86_64-linux) 3.2.13 production PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/pdf\nmodtime=1372320921\nsize=25273" DEBUG: dochash not nil.. 2013/06/130627091521_HowTo_Redmine_Installation_with_Database-Restore.pdf DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091521_HowTo_Redmine_Installation_with_Database-Restore.pdf' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:15:21 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 89, container_id: 19, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.pd...", disk_filename: "130627091521_HowTo_Redmine_Installation_with_Databa...", filesize: 25273, content_type: nil, digest: "fef20000cf71a436fe6eb41055c7f75d", downloads: 0, author_id: 5, created_on: "2013-06-27 08:15:21", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090901_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320541\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627090901_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.6ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090901_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:01 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 50, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627090901_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 3, created_on: "2013-06-27 08:09:01", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.3ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091339_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320819\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627091339_HowTo_Redmine_Installation_with_Database-Restore.doc DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091339_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:13:39 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project#<Project id: 5, name: "Project Raspberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:48:36", updated_on: "2013-06-27 07:48:36", identifier: "project-raspberry", status: 1, lft: 5, rgt: 6, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 65, container_id: 17, container_type: "Issue", filename: "HowTo_Redmine_Installation_with_Database-Restore.do...", disk_filename: "130627091339_HowTo_Redmine_Installation_with_Databa...", filesize: 14848, content_type: nil, digest: "348998200393385ee2ea03404273c196", downloads: 0, author_id: 5, created_on: "2013-06-27 08:13:39", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091126_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320686\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627091126_HowTo_Redmine_Installation.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.5ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091126_HowTo_Redmine_Installation.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:11:26 UTC +00:00 Issue Load (0.3ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 14 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 60, container_id: 14, container_type: "Issue", filename: "HowTo_Redmine_Installation.txt", disk_filename: "130627091126_HowTo_Redmine_Installation.txt", filesize: 2016, content_type: nil, digest: "8537291591343927737898d48fec60c9", downloads: 0, author_id: 5, created_on: "2013-06-27 08:11:26", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 14 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090740_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320460\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627090740_HowTo_Redmine_Installation.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090740_HowTo_Redmine_Installation.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:07:40 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 40, container_id: 10, container_type: "Issue", filename: "HowTo_Redmine_Installation.txt", disk_filename: "130627090740_HowTo_Redmine_Installation.txt", filesize: 2016, content_type: nil, digest: "8537291591343927737898d48fec60c9", downloads: 0, author_id: 3, created_on: "2013-06-27 08:07:40", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090859_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320539\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627090859_HowTo_Redmine_Installation.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090859_HowTo_Redmine_Installation.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:08:59 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 49, container_id: 12, container_type: "Issue", filename: "HowTo_Redmine_Installation.txt", disk_filename: "130627090859_HowTo_Redmine_Installation.txt", filesize: 2016, content_type: nil, digest: "8537291591343927737898d48fec60c9", downloads: 0, author_id: 3, created_on: "2013-06-27 08:08:59", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090725_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320445\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627090725_HowTo_Redmine_Installation.txt DEBUG: limit_conditions 11 DEBUG: searching for attachments Attachment Load (0.4ms) SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090725_HowTo_Redmine_Installation.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:07:25 UTC +00:00 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project#<Project id: 3, name: "Project Strawberry", description: "", homepage: "", is_public: true, parent_id: nil, created_on: "2013-06-27 07:47:44", updated_on: "2013-06-27 07:47:54", identifier: "project-strawberry", status: 1, lft: 7, rgt: 8, inherit_members: false> DEBUG: docattach not nil..: #<Attachment id: 32, container_id: 10, container_type: "Issue", filename: "HowTo_Redmine_Installation.txt", disk_filename: "130627090725_HowTo_Redmine_Installation.txt", filesize: 2016, content_type: nil, digest: "8537291591343927737898d48fec60c9", downloads: 0, author_id: 3, created_on: "2013-06-27 08:07:25", description: "", disk_directory: "2013/06"> DEBUG: adding attach.. CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: xapian searched DEBUG: call xapian search service for "Attachment" completed  (1.0ms) SELECT COUNT(DISTINCT "members"."id") FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9) IssueStatus Load (0.5ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 4 LIMIT 1 Tracker Load (0.2ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 UserPreference Load (0.6ms) SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 1 LIMIT 1 IssueStatus Load (0.4ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1 CACHE (0.0ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 CACHE (0.0ms) SELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1 CACHE (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 Rendered search/index.html.erb within layouts/base (25.0ms) SQL (4.3ms) SELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "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, "projects"."inherit_members" AS t1_r12, "roles"."id" AS t2_r0, "roles"."name" AS t2_r1, "roles"."position" AS t2_r2, "roles"."assignable" AS t2_r3, "roles"."builtin" AS t2_r4, "roles"."permissions" AS t2_r5, "roles"."issues_visibility" AS t2_r6 FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9) ORDER BY projects.name Completed 200 OK in 907ms (Views: 145.3ms | ActiveRecord: 99.0ms)

xelkano commented 11 years ago

It seems that the plugin is not correctly installed. In your case the rendered view for search results is the redmine default view, you can see it in the last line of the log:

Rendered search/index.html.erb

But the correct one is the following:

plugins/redmine_xapian/app/views/search/index.html.erb

do the following and try again:

cd /var/www/redmine/plugins

rm -rf redmine_xapian

git clone https://github.com/xelkano/redmine_xapian.git

webserver restart

2013/7/2 githubrs notifications@github.com

DEBUG: adding attach.. [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3[0m DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091521_HowTo_Redmine_Installation_with_Database-Restore.pdf\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version Ruby version Rails version Environment Database adapter 2.3.1.stable 1.9.3 (x86_64-linux) 3.2.13 production PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/pdf\nmodtime=1372320921\nsize=25273" DEBUG: dochash not nil.. 2013/06/130627091521_HowTo_Redmine_Installation_with_Database-Restore.pdf

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[35mAttachment Load (0.4ms)[0m SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091521_HowTo_Redmine_Installation_with_Database-Restore.pdf' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:15:21 UTC +00:00

[1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5[0m [1m[35mCACHE (0.0ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 19 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090901_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320541\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627090901_HowTo_Redmine_Installation_with_Database-Restore.doc

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[36mAttachment Load (0.6ms)[0m [1mSELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090901_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1[0m DEBUG: attach event_datetimeThu, 27 Jun 2013 08:09:01 UTC +00:00

[1m[35mCACHE (0.0ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1[0m DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1[0m [1m[35mCACHE (0.3ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1

[1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3[0m DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091339_HowTo_Redmine_Installation_with_Database-Restore.doc\nsample=built and tested at 2013/06/06 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL Download Redmine: https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded tar-file to ./Downloads Select the favored Database-Backup from the NAS-Server --> extract the database_dump.tar to ./Documents as su: export http_proxy=http://user:pwd@proxy-emea.rsint.net:80 apt-get update ...\ntype=application/msword\nmodtime=1372320819\nsize=14848" DEBUG: dochash not nil.. 2013/06/130627091339_HowTo_Redmine_Installation_with_Database-Restore.doc

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[35mAttachment Load (0.5ms)[0m SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091339_HowTo_Redmine_Installation_with_Database-Restore.doc' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:13:39 UTC +00:00

[1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1 DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5[0m [1m[35mCACHE (0.0ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 17 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 5 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 5 DEBUG: project id: 5 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627091126_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user: pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320686\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627091126_HowTo_Redmine_Installation.txt

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[36mAttachment Load (0.5ms)[0m [1mSELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627091126_HowTo_Redmine_Installation.txt' LIMIT 1[0m DEBUG: attach event_datetimeThu, 27 Jun 2013 08:11:26 UTC +00:00 [1m[35mIssue Load (0.3ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 14 LIMIT 1

[1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1[0m DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 14 LIMIT 1[0m

[1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3[0m DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090740_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user: pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320460\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627090740_HowTo_Redmine_Installation.txt

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[35mAttachment Load (0.4ms)[0m SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090740_HowTo_Redmine_Installation.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:07:40 UTC +00:00

[1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3[0m [1m[35mCACHE (0.0ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090859_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user: pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320539\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627090859_HowTo_Redmine_Installation.txt

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[36mAttachment Load (0.4ms)[0m [1mSELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090859_HowTo_Redmine_Installation.txt' LIMIT 1[0m DEBUG: attach event_datetimeThu, 27 Jun 2013 08:08:59 UTC +00:00

[1m[35mCACHE (0.0ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1[0m DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 12 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3[0m DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: m: "url=/2013/06/130627090725_HowTo_Redmine_Installation.txt\nsample=built at 2013/05/16 # cat /etc/debian_version 7.0 Environment: Redmine version 2.3.1.stable Ruby version 1.9.3 (x86_64-linux) Rails version 3.2.13 Environment production Database adapter PostgreSQL --> Download Redmine https://github.com/redmine/redmine/tree/2.3-stable --> Extract downloaded zip as su: useradd redmine passwd redmine export http_proxy=http://user: pwd@proxy-emea.rsint.net:80 apt-get update apt-get install ruby-full apache2 rubygems libruby libapache2-mod-passenger postgresql libpq-dev ...\ntype=text/plain\nmodtime=1372320445\nsize=2016" DEBUG: dochash not nil.. 2013/06/130627090725_HowTo_Redmine_Installation.txt

DEBUG: limit_conditions 11 DEBUG: searching for attachments [1m[35mAttachment Load (0.4ms)[0m SELECT "attachments".* FROM "attachments" WHERE "attachments"."disk_filename" = '130627090725_HowTo_Redmine_Installation.txt' LIMIT 1 DEBUG: attach event_datetimeThu, 27 Jun 2013 08:07:25 UTC +00:00

[1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1 DEBUG: attach project# DEBUG: docattach not nil..: # DEBUG: adding attach.. [1m[36mCACHE (0.0ms)[0m [1mSELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3[0m [1m[35mCACHE (0.0ms)[0m SELECT "issues".* FROM "issues" WHERE "issues"."id" = 10 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "projects".* FROM "projects" WHERE "projects"."id" = 3 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT name FROM "enabled_modules" WHERE "enabled_modules"."project_id" = 3 DEBUG: project id: 3 DEBUG: projects to search: nil DEBUG: xapian searched DEBUG: call xapian search service for "Attachment" completed [1m[36m (1.0ms)[0m [1mSELECT COUNT(DISTINCT "members"."id") FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9)[0m [1m[35mIssueStatus Load (0.5ms)[0m SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 4 LIMIT 1 [1m[36mTracker Load (0.2ms)[0m [1mSELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1[0m [1m[35mUserPreference Load (0.6ms)[0m SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = 1 LIMIT 1 [1m[36mIssueStatus Load (0.4ms)[0m [1mSELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = 1 LIMIT 1[0m [1m[35mCACHE (0.0ms)[0m SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = 3 LIMIT 1 [1m[36mCACHE (0.0ms)[0m [1mSELECT "issues".* FROM "issues" WHERE "issues"."id" = 29 LIMIT 1[0m

[1m[35mCACHE (0.0ms)[0m SELECT "projects".* FROM "projects" WHERE "projects"."id" = 4 LIMIT 1 Rendered search/index.html.erb within layouts/base (25.0ms) [1m[36mSQL (4.3ms)[0m [1mSELECT "members"."id" AS t0_r0, "members"."user_id" AS t0_r1, "members"."project_id" AS t0_r2, "members"."created_on" AS t0_r3, "members"."mail_notification" AS t0_r4, "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, "projects"."inherit_members" AS t1_r12, "roles"."id" AS t2_r0, "roles"."name" AS t2_r1, "roles"."position" AS t2_r2, "roles"."assignable" AS t2_r3, "roles"."builtin" AS t2_r4, "roles"."permissions" AS t2_r5, "roles"."issues_visibility" AS t2_r6 FROM "members" LEFT OUTER JOIN "projects" ON "projects"."id" = "members"."project_id" LEFT OUTER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" LEFT OUTER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."user_id" = 1 AND (projects.status<>9) ORDER BY projects.name[0m Completed 200 OK in 907ms (Views: 145.3ms | ActiveRecord: 99.0ms)

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20334326 .

githubrs commented 11 years ago

i changed into my redmine plugin directory (/usr/local/share/redmine/plugins) then i removed the old redmine_xapian_master folder. then i downloaded the zip (git makes problems on my system) and extracted it to /usr/local/share/redmine/plugins/redmine_xapian and i restarted webserver. Now i can't see the plugin in Administration->Plugins I think i have to run also rake redmine:plugins:migrate RAILS_ENV="production" to migrate the plugin into redmine.

githubrs commented 11 years ago

PS: i downloaded the master branch

githubrs commented 11 years ago

Problem solved! It was the same problem like that with the settings I wrote above. You have to copy search.index.html to the standard views folder. Then it should work.

mv plugins/redmine_xapian-master/app/views/search.index.html.erb app/views/search/

xelkano commented 11 years ago

Yes, this should work, but the issue is not soved, these views must be rendered Ok in their original locations. The plugin's views must overwrite redmine default views without doing this change.

2013/7/4 githubrs notifications@github.com

Problem solved! It was the same problem like that with the settings I wrote above. You have to copy search.index.html to the standard views folder. Then it should work.

mv plugins/redmine_xapian-master/app/views/search.index.html.erb app/views/search/

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20471870 .

githubrs commented 11 years ago

Ok I understand. What do you think what's the purpose that it doesn't render the files in the plugins folder. Best regards

xelkano notifications@github.com schrieb:

Yes, this should work, but the issue is not soved, these views must be rendered Ok in their original locations. The plugin's views must overwrite redmine default views without doing this change.

2013/7/4 githubrs notifications@github.com

Problem solved! It was the same problem like that with the settings I wrote above. You have to copy search.index.html to the standard views folder. Then it should work.

mv plugins/redmine_xapian-master/app/views/search.index.html.erb app/views/search/

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20471870 .

Reply to this email directly or view it on GitHub: https://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20472407

githubrs commented 11 years ago

It seems that it still not works how it should. Now I get all the results(for example 426 results), but I can only change between a few sites. So I can browse in the results but there are still not all shown. Have you an answer how I can install it right?

Thank you

githubrs commented 11 years ago

Here's an example to imagine it: example

There are 26 hit but i can view only 12 of them. When the plugin is not installed i can watch all 26 hits. I compared it with an redmine without the plugin and the 12 hits are the first 12 of the 26. I don't know wheter there is an relationship between that stuff.

xelkano commented 11 years ago

This view, from your screenshot is not my plugin view. Can you test the plugin alone without any other plugins?

2013/7/5 githubrs notifications@github.com

Here's an example to imagine it: [image: example]https://f.cloud.github.com/assets/4726540/753471/36d5a9d0-e569-11e2-8700-082027743dd2.png

There are 26 hit but i can view only 12 of them. When the plugin is not installed i can watch all 26 hits. I compared it with an redmine without the plugin and the 12 hits are the first 12 of the 26. I don't know wheter there is an relationship between that stuff.

— Reply to this email directly or view it on GitHubhttps://github.com/xelkano/redmine_xapian/issues/43#issuecomment-20515370 .

githubrs commented 11 years ago

OK i will test it and report it

githubrs commented 11 years ago

same result with no other plugins: screenshot from 2013-07-10 14 23 54

githubrs commented 11 years ago

Now the views are rendered without moving them to the app/views/search/ I don't know what the problem was but now it works. Now the only thing is the incorrect pagination. But for that I open an other issue.