-- 일감정보 조회
SELECT x.*
FROM bitnami_redmine.issues x
WHERE id = 22
;
-- 사용자 정의 항목 관리
SELECT x.* FROM bitnami_redmine.custom_fields x
-- 사용자 정의 항목 조회(사용자정의항목 ID 참조 : custom_field_id)
SELECT id, customized_type, customized_id, custom_field_id, value
FROM bitnami_redmine.custom_values
WHERE customized_id=22 and custom_field_id=5
;
-- 키값이 아닌 일감, 사용자 정의 항목 정보 중복여부 확인
select customized_id, custom_field_id, COUNT(*)
FROM bitnami_redmine.custom_values
group by customized_id, custom_field_id
having count(*) >0
;
-- 수정쿼리 : 일감(22)기준 시작, 종료일 수정 / 일감(22)기준 사용자정의항목 수정
UPDATE issues SET due_date='2024-08-20', start_date='2024-08-14' WHERE id=22;
UPDATE custom_values SET value='사용자정의값수정' WHERE customized_id=22 AND custom_field_id=5;
[Thu Aug 31 21:58:33.018393 2023] [ssl:warn] [pid 19064:tid 444] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name [Thu Aug 31 21:58:33.068371 2023] [ssl:warn] [pid 19064:tid 444] AH01909: localhost:443:0 server certificate does NOT include an ID which matches the server name [Thu Aug 31 21:58:33.086154 2023] [mpm_winnt:notice] [pid 19064:tid 444] AH00455: Apache/2.4.52 (Win64) OpenSSL/1.1.1m PHP/7.4.28 configured -- resuming normal operations [Thu Aug 31 21:58:33.086154 2023] [mpm_winnt:notice] [pid 19064:tid 444] AH00456: Apache Lounge VC15 Server built: Dec 23 2021 11:00:40 [Thu Aug 31 21:58:33.086154 2023] [core:notice] [pid 19064:tid 444] AH00094: Command line: 'D:\\jkSpace\\redmine\\redmine-4.2.4-0\\apache2\\bin\\httpd.exe -d D:/jkSpace/redmine/redmine-4.2.4-0/apache2 -f D:\\jkSpace\\redmine\\redmine-4.2.4-0\\apache2\\conf\\httpd.conf' [Thu Aug 31 21:58:33.091358 2023] [mpm_winnt:notice] [pid 19064:tid 444] AH00418: Parent: Created child process 17280
Download plugins and unpack them into redmine/apps/redmine/htdocs/plugins folder.
Open an explorer and go to the folder where redmine is now installed. Find the script use_redmine.bat and run it with double click. New window with command line will be opened.
It that new window enter the next commands
cd apps\redmine\htdocsbundle install --without development test --no-deployment
bundle exec rake redmine:plugins RAILS_ENV=production
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>bundle install --without development test --no-deployment
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem vcard (~> 0.2.8) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem simplecov (~> 0.9.1) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Using rake 12.0.0
Using i18n 0.7.0
Using json 1.8.3
Using minitest 5.10.1
Using thread_safe 0.3.5
Using tzinfo 1.2.2
Using activesupport 4.2.7.1
Using builder 3.2.2
Using erubis 2.7.0
Using mini_portile2 2.1.0
Using nokogiri 1.7.0.1
Using rails-deprecated_sanitizer 1.0.3
Using rails-dom-testing 1.0.8
Using loofah 2.0.3
Using rails-html-sanitizer 1.0.3
Using actionview 4.2.7.1
Using rack 1.6.5
Using rack-test 0.6.3
Using actionpack 4.2.7.1
Using globalid 0.3.7
Using activejob 4.2.7.1
Using mime-types-data 3.2016.0521
Using mime-types 3.1
Using mail 2.6.4
Using actionmailer 4.2.7.1
Using actionpack-action_caching 1.1.1
Using actionpack-xml_parser 1.0.2
Using activemodel 4.2.7.1
Using arel 6.0.4
Using activerecord 4.2.7.1
Using public_suffix 2.0.5
Using addressable 2.5.0
Using coderay 1.1.1
Using concurrent-ruby 1.0.4
Using css_parser 1.4.7
Using daemons 1.2.4
Using eventmachine 1.0.3
Using tilt 2.0.6
Using haml 4.0.7
Using sexp_processor 4.8.0
Using ruby_parser 3.8.4
Using html2haml 2.1.0
Using thor 0.19.4
Using railties 4.2.7.1
Using haml-rails 0.9.0
Using htmlentities 4.3.1
Using jquery-rails 3.1.4
Using liquid 2.6.3
Using mimemagic 0.3.2
Using mysql2 0.4.2
Using net-ldap 0.12.1
Using protected_attributes 1.1.3
Using ruby-openid 2.3.0
Using rack-openid 1.4.2
Using bundler 1.9.6
Using sprockets 3.7.1
Using sprockets-rails 3.2.0
Using rails 4.2.7.1
Using rbpdf-font 1.19.0
Using rbpdf 1.19.0
Using redcarpet 3.3.4
Using redmine_crm 0.0.23
Using request_store 1.0.5
Using require_patch 0.1.0
Using rmagick 2.15.4
Using roadie 3.2.1
Using roadie-rails 1.1.1
Using ruby-ole 1.2.12
Using rubyzip 1.2.0
Using sass 3.4.23
Using spreadsheet 0.6.9
Using thin 1.6.1
Using tzinfo-data 1.2016.6
Using vcard 0.2.15
Using zip-zip 0.3
Using write_xlsx 0.83.0
Updating files in vendor/cache
Bundle complete! 50 Gemfile dependencies, 76 gems now installed.
Gems in the groups development and test were not installed.
Use `bundle show [gemname]` to see where a bundled gem is installed.
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>bundle exec rake redmine:plugins:migrate RAILS_ENV=production
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem vcard (~> 0.2.8) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem simplecov (~> 0.9.1) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
DL is deprecated, please use Fiddle
Migrating clipboard_image_paste (Clipboard image paste)...
Migrating progressive_projects_list (Progressive Projects List plugin)...
Migrating redmine_agile (Redmine Agile plugin (Light version))...
Migrating redmine_checklists (Redmine Checklists plugin (Light version))...
Migrating redmine_cms (Redmine CMS plugin)...
Migrating redmine_code_review (Redmine Code Review plugin)...
Migrating redmine_contacts (Redmine CRM plugin (Light version))...
Migrating redmine_favorite_projects (Redmine Favorite Projects plugin)...
Migrating redmine_issues_tree (Redmine Issues Tree plugin)...
Migrating redmine_monitoring_controlling (Redmine (Monitoring & Controlling | Monitoramento & Controle))...
Migrating redmine_people (Redmine People plugin (Light version))...
Migrating redmine_questions (Redmine Q&A plugin)...
Migrating redmine_spent_time (Redmine Spent Time plugin)...
Migrating redmine_xlsx_format_issue_exporter (Redmine XLSX format issue exporter)...
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>
오류 발생 사례
[플러그인 설치 중 발생하는 오류유형]
[오류1] - path 지정을 하지 않은경우
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs\plugins>bundle exec rake redmine:plugins NAME=redmine_graphs RAILS_ENV=production
'bundle'은(는) 내부 또는 외부 명령, 실행할 수 있는 프로그램, 또는
배치 파일이 아닙니다.
[오류2] - bundle exec 을 앞에 추가해야하는 경우
D:\88_Svr\Bitnami\redmine-3.3.2-0>rake redmine:plugins:migrate RAILS_ENV=production
rake aborted!
No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb, Rakefile.rb)
(See full trace by running task with --trace)
[오류3] - htdocs 폴더로 이동하지 않은 경우
D:\88_Svr\Bitnami\redmine-3.3.2-0>bundle exec rake redmine:plugins:migrate RAILS_ENV=production
Could not locate Gemfile or .bundle/ directory
[오류4]
redmine-3.3.0-0 버전을 설치하면 subversion 저장소가 기본 설정되어 있으나,
플러그인 추가시 오류 발생
[오류5] - redmine_issues_from_excel-master.zip 플러그인 설치 오류 - rubyzip 버전 오류
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>bundle install --without development test --no-deployment
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem vcard (~> 0.2.8) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem simplecov (~> 0.9.1) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Fetching gem metadata from http://rubygems.org/...........
Fetching version metadata from http://rubygems.org/...
Fetching dependency metadata from http://rubygems.org/..
Fetching gem metadata from http://rubygems.org/...........
Fetching gem metadata from https://rubygems.org/...........
Fetching version metadata from http://rubygems.org/...
Fetching version metadata from https://rubygems.org/...
Fetching dependency metadata from http://rubygems.org/..
Fetching dependency metadata from https://rubygems.org/..
You have requested:
rubyzip < 1.0.0
The bundle currently has rubyzip locked at 1.2.0.
Try running `bundle update rubyzip`
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>bundle update rubyzip
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem vcard (~> 0.2.8) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem simplecov (~> 0.9.1) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Fetching gem metadata from http://rubygems.org/...........
Fetching version metadata from http://rubygems.org/...
Fetching dependency metadata from http://rubygems.org/..
Fetching gem metadata from http://rubygems.org/...........
Fetching gem metadata from https://rubygems.org/...........
Fetching version metadata from http://rubygems.org/...
Fetching version metadata from https://rubygems.org/...
Fetching dependency metadata from http://rubygems.org/..
Fetching dependency metadata from https://rubygems.org/..
Resolving dependencies......
Bundler could not find compatible versions for gem "rubyzip":
In Gemfile:
write_xlsx (>= 0) ruby depends on
rubyzip (>= 1.0.0) ruby
write_xlsx (>= 0) ruby depends on
rubyzip (>= 1.0.0) x86-mingw32
write_xlsx (>= 0) ruby depends on
rubyzip (>= 1.0.0) ruby
write_xlsx (>= 0) ruby depends on
rubyzip (>= 1.0.0) x86-mingw32
selenium-webdriver (~> 2.53.4) x86-mingw32 depends on
rubyzip (~> 1.0) ruby
selenium-webdriver (~> 2.53.4) x86-mingw32 depends on
rubyzip (~> 1.0) x86-mingw32
rubyzip (< 1.0.0) ruby
rubyzip (< 1.0.0) x86-mingw32
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>bundle exec rake redmine:plugins:migrate RAILS_ENV=production
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem vcard (~> 0.2.8) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem simplecov (~> 0.9.1) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Could not find gem 'roo (>= 0) x86-mingw32' in any of the gem sources listed in your Gemfile or installed on this machine.
Run `bundle install` to install missing gems.
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>bundle install --without development test --no-deployment
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
The source :rubygems is deprecated because HTTP requests are insecure.
Please change your source to 'https://rubygems.org' if possible, or 'http://rubygems.org' if not.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem vcard (~> 0.2.8) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Your Gemfile lists the gem redmine_crm (>= 0) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Warning: this Gemfile contains multiple primary sources. Using `source` more than once without a block is a security risk, and may result in installing unexpected gems. To resolve this warning, use a block to indicate which gems should come from the secondary source. To upgrade this warning to an error, run `bundle config disable_multisource true`.
Your Gemfile lists the gem simplecov (~> 0.9.1) more than once.
You should probably keep only one of them.
While it's not a problem now, it could cause errors if you change the version of just one of them later.
Fetching gem metadata from http://rubygems.org/...........
Fetching version metadata from http://rubygems.org/...
Fetching dependency metadata from http://rubygems.org/..
Fetching gem metadata from http://rubygems.org/...........
Fetching gem metadata from https://rubygems.org/...........
Fetching version metadata from http://rubygems.org/...
Fetching version metadata from https://rubygems.org/...
Fetching dependency metadata from http://rubygems.org/..
Fetching dependency metadata from https://rubygems.org/..
You have requested:
rubyzip < 1.0.0
The bundle currently has rubyzip locked at 1.2.0.
Try running `bundle update rubyzip`
D:\88_Svr\Bitnami\redmine-3.3.2-0\apps\redmine\htdocs>
추가.
버전 문제로 막혔던 subversion 오류를 해결했다.
https://www.visualsvn.com/server/download/
여기서 visualsvn server를 다운받아서 설치만 하면 된다.
* 주의 (포트는 가급적 80 포트를 피하자)
아.. 끝.
# 추가 플러그인
http://www.redmine.org/plugins/mega_calendar
- https://github.com/berti92/mega_calendar
> local 파일이 없어서 en.yml 을 기준으로 ko.yml 파일을 만들어준다.
(로컬 yml 파일 중 어떤것이 적용되는지 테스트결과가 명확하지 않아서
en.yml, ko.yml을 모두 한글로 작성하여 구동하니 한글로 잘 보임. - 발테스트)
> 버그 : 상단에 추가된 메뉴의 엑션이 sub_path값이 지정되지 않아서 오류가 난다.
apps\redmine\htdocs\plugins\mega_calendar\init.rb 에 지정되 sub_path 값을 수정해준다.
redmine_agile-1_4_2-light.zip
ko.yml