issue_templates table does not exists #285
Comments
|
Thank you for contributing to Redmine Issue Templates plugin!' first issue |
|
Hi, @mihainicu Is the above log is the result of
This message tells that first and second migration has already done, such as create tables named issue_templates. Let me confirm, have you already tried to install my plugin before? If you can access and select database for Redmine, try this command: If there are any records shown like this and there is no table named 'issue_templates', your installation has been incomplete state. So, you should better to uninstall task first, and retry the migration. If you have not created any template records yet, and hope to uninstall and re-install this plugin, please see README. Uninstall: Re-install Related: |
|
@mihainicu How is the situation? |
|
Hi, Indeed, the schema_migrations table returns the following value: +---------------------------+ but the command to uninstall it fails with: rake db:migrate_plugins NAME=redmine_issue_templates VERSION=0 RAILS_ENV=production --trace Mysql2::Error: Table 'redmine2.issue_templates' doesn't exist: SHOW KEYS FROM Caused by: Caused by: Tasks: TOP => db:migrate_plugins => redmine:plugins:migrate I will create a new instance of redmine and see if the same issue is returned. |
Did you also re-create database? If you can't uninstall with rails redmine:plugins:migrate task, you can uninstall the plugin manually with deleting records from schema_migrations table. Then, try to run plugin install task. bundle exec rake redmine:plugins:migrate NAME=redmine_issue_templates RAILS_ENV=production --trace |
|
@mihainicu How is your situation? |
|
Hi,
Sorry for the late reply, I thought I sent you an update on this.
Everything works fine now after I adjusted the information schema.
Thanks for your help! Much appreciated
Regards,
Mihai
…On Sat, Oct 19, 2019, 14:49 Akiko Takano ***@***.***> wrote:
@mihainicu <https:/mihainicu> How is your situation?
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
<#285?email_source=notifications&email_token=ACOUGGCSV5X23UDDK3NFSLLQPLX5PA5CNFSM4I4WBLK2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEBXNQSQ#issuecomment-544135242>,
or unsubscribe
<https:/notifications/unsubscribe-auth/ACOUGGEJDGJ2JPOV5VPP6M3QPLX5PANCNFSM4I4WBLKQ>
.
|
|
@mihainicu Nice to hear that! Regards, |
This is a template to report bug related to redmine issue templates plugin.
You can fill in any format, free style in case report features or questions.
Summary
I installed the plugin and used
bundle exec rake redmine:plugins:migrate RAILS_ENV=production --trace
but I receive that table issue_templates is not present
Description
Environment
These informations are greatly helpful to support quickly.
You can get these informations from Redmine's information page.
(E.g. http://example.com/admin/info)
Redmine version
4.0.4
Installed plugins
redmine_lightbox2
redmine_issue_dynamic_edit
additionals
redmine_checklists
Ruby version
2.6.3p62
OS Platform
CentOS 7
Database (MariaDB, MySQL, PostgreSQL) and its version
Mariadb 10.4
Rails Env
Rails 5.2.3
Visual Proof / Screenshot
When reporting an application error, post the error stack trace that
you should find in the log file (eg. log/production.log).
Screen shot would be also helpful.
Expected Results
Actual Results
Caused by:
'Mysql2::Error: Table 'redmine2.issue_templates' doesn't exist
/home/redmine/gems/ruby-2.6.3/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:in
_query' /home/redmine/gems/ruby-2.6.3/gems/mysql2-0.5.2/lib/mysql2/client.rb:131:inblock in query'/home/redmine/gems/ruby-2.6.3/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:in
handle_interrupt' /home/redmine/gems/ruby-2.6.3/gems/mysql2-0.5.2/lib/mysql2/client.rb:130:inquery'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:187:in
block (2 levels) in execute' /home/redmine/gems/ruby-2.6.3/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:48:inblock in permit_concurrent_loads'/home/redmine/gems/ruby-2.6.3/gems/activesupport-5.2.3/lib/active_support/concurrency/share_lock.rb:187:in
yield_shares' /home/redmine/gems/ruby-2.6.3/gems/activesupport-5.2.3/lib/active_support/dependencies/interlock.rb:47:inpermit_concurrent_loads'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:186:in
block in execute' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:581:inblock (2 levels) in log'/home/redmine/rubies/ruby-2.6.3/lib/ruby/2.6.0/monitor.rb:230:in
mon_synchronize' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:580:inblock in log'/home/redmine/gems/ruby-2.6.3/gems/activesupport-5.2.3/lib/active_support/notifications/instrumenter.rb:23:in
instrument' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:571:inlog'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract_mysql_adapter.rb:185:in
execute' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/mysql/database_statements.rb:28:inexecute'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/schema_statements.rb:581:in
add_column' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:871:inblock in method_missing'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in
block in say_with_time' /home/redmine/rubies/ruby-2.6.3/lib/ruby/2.6.0/benchmark.rb:293:inmeasure'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:840:in
say_with_time' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:860:inmethod_missing'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration/compatibility.rb:108:in
add_column' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:604:inmethod_missing'/home/redmine/plugins/redmine_issue_templates/db/migrate/0003_add_issue_title_to_issue_templates.rb:3:in
up' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:777:inup'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:817:in
exec_migration' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:798:inblock (2 levels) in migrate'/home/redmine/rubies/ruby-2.6.3/lib/ruby/2.6.0/benchmark.rb:293:in
measure' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:797:inblock in migrate'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/connection_adapters/abstract/connection_pool.rb:416:in
with_connection' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:796:inmigrate'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:977:in
migrate' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1292:inblock in execute_migration_in_transaction'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1345:in
ddl_transaction' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1291:inexecute_migration_in_transaction'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1263:in
block in migrate_without_lock' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:ineach'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1262:in
migrate_without_lock' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:inblock in migrate'/home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1363:in
with_advisory_lock' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1210:inmigrate'/home/redmine/lib/redmine/plugin.rb:510:in
up' /home/redmine/gems/ruby-2.6.3/gems/activerecord-5.2.3/lib/active_record/migration.rb:1011:inmigrate'/home/redmine/lib/redmine/plugin.rb:542:in
migrate_plugin' /home/redmine/lib/redmine/plugin.rb:483:inmigrate'/home/redmine/lib/redmine/plugin.rb:497:in
block in migrate' /home/redmine/lib/redmine/plugin.rb:496:ineach'/home/redmine/lib/redmine/plugin.rb:496:in
migrate' /home/redmine/lib/tasks/redmine.rake:135:inblock (3 levels) in <top (required)>'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/task.rb:273:in
block in execute' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/task.rb:273:ineach'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/task.rb:273:in
execute' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/task.rb:214:inblock in invoke_with_call_chain'/home/redmine/rubies/ruby-2.6.3/lib/ruby/2.6.0/monitor.rb:230:in
mon_synchronize' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/task.rb:194:ininvoke_with_call_chain'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/task.rb:183:in
invoke' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:160:ininvoke_task'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:116:in
block (2 levels) in top_level' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:116:ineach'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:116:in
block in top_level' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:125:inrun_with_threads'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:110:in
top_level' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:83:inblock in run'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:186:in
standard_exception_handling' /home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/lib/rake/application.rb:80:inrun'/home/redmine/gems/ruby-2.6.3/gems/rake-12.3.3/exe/rake:27:in
<top (required)>' /home/redmine/gems/ruby-2.6.3/bin/rake:23:inload'/home/redmine/gems/ruby-2.6.3/bin/rake:23:in
<main>' /home/redmine/gems/ruby-2.6.3/bin/ruby_executable_hooks:24:ineval'/home/redmine/gems/ruby-2.6.3/bin/ruby_executable_hooks:24:in `
Workaround
Please let me know if you have any workaround.
The text was updated successfully, but these errors were encountered: