New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error on searching by name / URL #13

Closed
Yopii opened this Issue Oct 21, 2017 · 3 comments

Comments

Projects
None yet
2 participants
@Yopii

Yopii commented Oct 21, 2017

Hello,

Your plugin responds perfectly to my need.

However, I get an error when searching for a key by name or URL.

Started GET "/projects/project/keys?utf8=%E2%9C%93&query=PostgreSQL&search_fild=name&commit=Mettre+%C3%A0+jour" for xxx.xxx.xxx.xxx at 2017-10-21 18:18:52 +0200
Processing by KeysController#index as HTML
Parameters: {"utf8"=>"✓", "query"=>"PostgreSQL", "search_fild"=>"name", "commit"=>"Mettre à jour", "project_id"=>"project"}
Current user: xxxxx (id=5)
Completed 500 Internal Server Error in 15ms (ActiveRecord: 7.9ms)

ActiveRecord::StatementInvalid (PG::UndefinedFunction: ERREUR: l'opérateur n'existe pas : character varying LINE 1: ...) FROM "keys" WHERE "keys"."project_id" = $1 AND (name LIK... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. : SELECT COUNT(*) FROM "keys" WHERE "keys"."project_id" = $1 AND (nameLIKE '%PostgreSQL%')): plugins/vault/app/controllers/keys_controller.rb:55:inindex'
lib/redmine/sudo_mode.rb:63:in sudo_mode'

I was able to find a temporary solution to test it by deleting the characters " ` " in the file 'app / controllers / keys_controller.rb'.

You will find below the configuration of my Redmine.

Environment:
Redmine version 3.3.4.stable.16775
Ruby version 2.3.4-p301 (2017-03-30) [x86_64-linux]
Rails version 4.2.7.1
Environment production
Database adapter PostgreSQL
SCM:
Subversion 1.9.3
Git 2.7.4
Filesystem
Redmine plugins:
clipboard_image_paste 1.12
redmine_agile 1.4.5
redmine_banner 0.1.2
redmine_checklists 3.1.10
redmine_drawio 0.8.0
redmine_editor_preview_tab 0.1.5
redmine_lightbox2 0.3.5
vault 0.3.3

Thx

@noshutdown-ru-user

This comment has been minimized.

Member

noshutdown-ru-user commented Nov 3, 2017

we working on it, soon it should be fixed, couple of days

@Yopii

This comment has been minimized.

Yopii commented Nov 3, 2017

Perfect ! Take your time ;)
Thx

noshutdown-ru-user added a commit that referenced this issue Nov 6, 2017

@noshutdown-ru-user

This comment has been minimized.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment