redmine_knowledgebase icon indicating copy to clipboard operation
redmine_knowledgebase copied to clipboard

Published 20 hours ago • verified publisher icon alexbevi

Tag-Table already in use

Open ElPato-999 opened this issue 8 years ago • 21 comments

Hi!

I have a problem installing the redmine_knowledgebase module on my redmine installation, because obviously there's already a "tag" table on that DB server. Is there a way to use prefixes on tables to minimize compatibility issues?

ElPato-999 avatar Feb 24 '16 17:02 ElPato-999

I too have a problem. Just made sure (as good as possible) that my plugins are using redmine-acts-as-taggable-on...

Somehow migration failes...

/home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.5/lib/action_dispatch/http/mime_type.rb:163: warning: already initialized constant Mime::VCF /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/actionpack-4.2.5/lib/action_dispatch/http/mime_type.rb:163: warning: previous definition of VCF was here ** Invoke redmine:plugins (first_time) ** Execute redmine:plugins ** Invoke redmine:plugins:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute redmine:plugins:migrate Migrating redmine_knowledgebase (Knowledgebase)... == 20130513154700 AddTagsAndTaggings: migrating =============================== rake aborted! StandardError: An error has occurred, all later migrations canceled:

A plugin is already using the "tags" or "taggings" tables, and the structure of the table does not match the structure expected by redmine_knowledgebase. /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:76:in assert_schema_match!' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:64:inok_to_go_up?' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:15:in up' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:611:inexec_migration' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:592:in block (2 levels) in migrate' /usr/lib/ruby/2.1.0/benchmark.rb:279:inmeasure' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:591:in block in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:590:in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:768:inmigrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:1046:inddl_transaction' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:997:in execute_migration_in_transaction' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:959:inblock in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:in each' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:inmigrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:823:in up' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:801:inmigrate' /home/redmine/redmine/lib/redmine/plugin.rb:481:in migrate_plugin' /home/redmine/redmine/lib/redmine/plugin.rb:453:inmigrate' /home/redmine/redmine/lib/redmine/plugin.rb:464:in migrate' /home/redmine/redmine/lib/tasks/redmine.rake:127:inblock (3 levels) in <top (required)>' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:in call' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:inblock in execute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:in each' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:inexecute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:179:in block in invoke_with_call_chain' /usr/lib/ruby/2.1.0/monitor.rb:211:inmon_synchronize' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:172:in invoke_with_call_chain' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:165:ininvoke' /home/redmine/redmine/lib/tasks/redmine.rake:52:in block (2 levels) in <top (required)>' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:incall' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:in block in execute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:ineach' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:in execute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:179:inblock in invoke_with_call_chain' /usr/lib/ruby/2.1.0/monitor.rb:211:in mon_synchronize' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:172:ininvoke_with_call_chain' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:165:in invoke' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:150:ininvoke_task' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:106:in block (2 levels) in top_level' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:106:ineach' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:106:in block in top_level' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:115:inrun_with_threads' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:100:in top_level' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:78:inblock in run' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:176:in standard_exception_handling' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:75:inrun' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/bin/rake:33:in <top (required)>' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bin/rake:23:inload' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bin/rake:23:in <main>' RedmineActsAsTaggableOn::Migration::SchemaMismatchError: A plugin is already using the "tags" or "taggings" tables, and the structure of the table does not match the structure expected by redmine_knowledgebase. /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:76:inassert_schema_match!' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:64:in ok_to_go_up?' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:15:inup' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:611:in exec_migration' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:592:inblock (2 levels) in migrate' /usr/lib/ruby/2.1.0/benchmark.rb:279:in measure' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:591:inblock in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in with_connection' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:590:inmigrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:768:in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:998:inblock in execute_migration_in_transaction' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:1046:in ddl_transaction' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:997:inexecute_migration_in_transaction' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:959:in block in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:ineach' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:in migrate' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:823:inup' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/activerecord-4.2.5/lib/active_record/migration.rb:801:in migrate' /home/redmine/redmine/lib/redmine/plugin.rb:481:inmigrate_plugin' /home/redmine/redmine/lib/redmine/plugin.rb:453:in migrate' /home/redmine/redmine/lib/redmine/plugin.rb:464:inmigrate' /home/redmine/redmine/lib/tasks/redmine.rake:127:in block (3 levels) in <top (required)>' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:incall' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:in block in execute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:ineach' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:in execute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:179:inblock in invoke_with_call_chain' /usr/lib/ruby/2.1.0/monitor.rb:211:in mon_synchronize' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:172:ininvoke_with_call_chain' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:165:in invoke' /home/redmine/redmine/lib/tasks/redmine.rake:52:inblock (2 levels) in <top (required)>' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:in call' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:240:inblock in execute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:in each' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:235:inexecute' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:179:in block in invoke_with_call_chain' /usr/lib/ruby/2.1.0/monitor.rb:211:inmon_synchronize' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:172:in invoke_with_call_chain' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/task.rb:165:ininvoke' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:150:in invoke_task' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:106:inblock (2 levels) in top_level' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:106:in each' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:106:inblock in top_level' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:115:in run_with_threads' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:100:intop_level' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:78:in block in run' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:176:instandard_exception_handling' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/lib/rake/application.rb:75:in run' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/gems/rake-10.5.0/bin/rake:33:in<top (required)>' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bin/rake:23:in load' /home/redmine/redmine/vendor/bundle/ruby/2.1.0/bin/rake:23:in

' Tasks: TOP => redmine:plugins:migrate

What can I do to solve this issue?

rheggen avatar Feb 25 '16 20:02 rheggen

Okay, after some recherche I found out that there's some mismatch... The expected structure for taggings table is ['tag_id', 'integer'], ['taggable_id', 'integer'], ['taggable_type', 'string'], ['tagger_id', 'integer'], ['tagger_type', 'string'], ['context', 'string'],

Currently in my redmine installation there is the following structure: +----+--------+-------------+---------------+---------------------+ | id | tag_id | taggable_id | taggable_type | created_at | +----+--------+-------------+---------------+---------------------+

How can I fix that? Is it a problem if I just add tagger_id and tagger_type as nullable columns in the existing table?

The tags table looks compatible... it's expecting one column with the name "name" and type "string" which is present in the DB as that...

rheggen avatar Feb 25 '16 21:02 rheggen

After fixing the tables (taggings) and indexes the migrate.rb script runnes without having any errors... So, tried to edit tags within the existing plugin -> works fine... After trying to add a kb-article there's the following error within my production.log:

Completed 500 Internal Server Error in 111ms (ActiveRecord: 63.6ms)
ActiveRecord::UnknownAttributeError (unknown attribute 'context' for ActsAsTaggableOn::Tagging.):

Please, does anyone know how to work-around that?

rheggen avatar Feb 25 '16 22:02 rheggen

Same problem here.

redmine@project:~/redmine$ rake redmine:plugins:migrate NAME=redmine_knowledgebase RAILS_ENV=production --trace ** Invoke redmine:plugins:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute redmine:plugins:migrate Migrating redmine_knowledgebase (Knowledgebase)... == 20100210212009 CreateCategories: migrating ================================= -- create_table(:kb_categories) -> 0.0037s == 20100210212009 CreateCategories: migrated (0.0038s) ========================

== 20100211210218 AddParentIdToCategories: migrating ========================== -- add_column(:kb_categories, :parent_id, :int) -> 0.0046s == 20100211210218 AddParentIdToCategories: migrated (0.0047s) =================

== 20100211212704 CreateArticles: migrating =================================== -- create_table(:kb_articles) -> 0.0031s == 20100211212704 CreateArticles: migrated (0.0033s) ==========================

== 20100213145708 AddAuthorToArticle: migrating =============================== -- add_column(:kb_articles, :author_id, :int, {:default=>0, :null=>false}) -> 0.0041s == 20100213145708 AddAuthorToArticle: migrated (0.0042s) ======================

== 20100213201848 AddViewingTables: migrating ================================= == 20100213201848 AddViewingTables: migrated (0.0248s) ========================

== 20100216000133 AddNestedSetBoundriesToCategory: migrating ================== -- add_column(:kb_categories, :lft, :int) -> 0.0037s -- add_column(:kb_categories, :rgt, :int) -> 0.0035s == 20100216000133 AddNestedSetBoundriesToCategory: migrated (0.0074s) =========

== 20100317201659 AddRatingsToArticles: migrating ============================= == 20100317201659 AddRatingsToArticles: migrated (0.0109s) ====================

== 20100329103527 AddCommentsCountToArticles: migrating ======================= -- add_column(:kb_articles, :comments_count, :int) -> 0.0037s == 20100329103527 AddCommentsCountToArticles: migrated (0.0038s) ==============

== 20110131145123 AddProjectIdToArticles: migrating =========================== -- add_column(:kb_articles, :project_id, :int, {:default=>0}) -> 0.0036s == 20110131145123 AddProjectIdToArticles: migrated (0.0037s) ==================

== 20121005075010 AddUpdaterToArticle: migrating ============================== -- add_column(:kb_articles, :updater_id, :int, {:default=>0, :null=>false}) -> 0.0038s == 20121005075010 AddUpdaterToArticle: migrated (0.0039s) =====================

== 20121030102100 AddProjectIdToCategories: migrating ========================= -- add_column(:kb_categories, :project_id, :int, {:default=>0}) -> 0.0035s == 20121030102100 AddProjectIdToCategories: migrated (0.0036s) ================

== 20121205100143 AddVersioning: migrating ==================================== -- add_column(:kb_articles, :version_comments, :string, {:limit=>255, :default=>""}) -> 0.0035s -- add_index("kb_article_versions", :kb_article_id, {:name=>:kb_article_versions_kbaid}) -> 0.0110s -- add_index("kb_article_versions", :updated_at, {:name=>:index_kb_article_versions_on_updated_at}) -> 0.0081s == 20121205100143 AddVersioning: migrated (0.1349s) ===========================

== 20130513154700 AddTagsAndTaggings: migrating =============================== rake aborted! StandardError: An error has occurred, all later migrations canceled:

A plugin is already using the "tags" or "taggings" tables, and the structure of the table does not match the structure expected by redmine_knowledgebase. /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:76:in assert_schema_match!' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:64:inok_to_go_up?' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:15:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:611:inexec_migration' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:592:in block (2 levels) in migrate' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/benchmark.rb:288:inmeasure' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:591:in block in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:590:in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:768:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:1046:inddl_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:997:in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:959:inblock in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:823:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:801:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:481:in migrate_plugin' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:453:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:464:in migrate' /opt/redmine/redmine-3.2/lib/tasks/redmine.rake:127:inblock (3 levels) in <top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:in call' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:inblock in execute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:inexecute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:179:in block in invoke_with_call_chain' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/monitor.rb:211:inmon_synchronize' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:172:in invoke_with_call_chain' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:165:ininvoke' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:150:in invoke_task' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock (2 levels) in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:115:in run_with_threads' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:100:intop_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:78:in block in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:176:instandard_exception_handling' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:75:in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/bin/rake:33:in<top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in load' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in

' RedmineActsAsTaggableOn::Migration::SchemaMismatchError: A plugin is already using the "tags" or "taggings" tables, and the structure of the table does not match the structure expected by redmine_knowledgebase. /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:76:in assert_schema_match!' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:64:inok_to_go_up?' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:15:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:611:inexec_migration' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:592:in block (2 levels) in migrate' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/benchmark.rb:288:inmeasure' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:591:in block in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:590:in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:768:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:1046:inddl_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:997:in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:959:inblock in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:823:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:801:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:481:in migrate_plugin' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:453:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:464:in migrate' /opt/redmine/redmine-3.2/lib/tasks/redmine.rake:127:inblock (3 levels) in <top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:in call' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:inblock in execute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:inexecute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:179:in block in invoke_with_call_chain' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/monitor.rb:211:inmon_synchronize' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:172:in invoke_with_call_chain' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:165:ininvoke' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:150:in invoke_task' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock (2 levels) in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:115:in run_with_threads' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:100:intop_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:78:in block in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:176:instandard_exception_handling' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:75:in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/bin/rake:33:in<top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in load' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in
' Tasks: TOP => redmine:plugins:migrate

scott-mackenzie avatar Jun 12 '16 03:06 scott-mackenzie

@scott-mackenzie @ElPato-999 @UncleBen96 this is an issue with Redmine plugins as tagging is a common feature ...

I'm open to suggestions on how to better handle this though

alexbevi avatar Jun 23 '16 02:06 alexbevi

@scott-mackenzie @ElPato-999 @UncleBen96 @alexbevi Me too. I hope fix this problem.

HeuJung avatar Jun 24 '16 00:06 HeuJung

I am not sure how best to handle it, but what about an append to the naming convention to ensure no conflict with other plugins? kb_ <-- something like that?

scott-mackenzie avatar Jun 26 '16 20:06 scott-mackenzie

PS: I have tried release 3.2 (same issue).

scott-mackenzie avatar Jun 26 '16 20:06 scott-mackenzie

Log below:

Migrating redmine_knowledgebase (Knowledgebase)... == 20130513154700 AddTagsAndTaggings: migrating =============================== rake aborted! StandardError: An error has occurred, all later migrations canceled:

A plugin is already using the "tags" or "taggings" tables, and the structure of the table does not match the structure expected by redmine_knowledgebase. /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:76:in assert_schema_match!' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:64:inok_to_go_up?' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:15:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:611:inexec_migration' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:592:in block (2 levels) in migrate' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/benchmark.rb:288:inmeasure' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:591:in block in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:590:in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:768:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:1046:inddl_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:997:in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:959:inblock in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:823:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:801:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:481:in migrate_plugin' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:453:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:464:in migrate' /opt/redmine/redmine-3.2/lib/tasks/redmine.rake:127:inblock (3 levels) in <top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:in call' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:inblock in execute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:inexecute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:179:in block in invoke_with_call_chain' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/monitor.rb:211:inmon_synchronize' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:172:in invoke_with_call_chain' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:165:ininvoke' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:150:in invoke_task' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock (2 levels) in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:115:in run_with_threads' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:100:intop_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:78:in block in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:176:instandard_exception_handling' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:75:in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/bin/rake:33:in<top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in load' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in

' RedmineActsAsTaggableOn::Migration::SchemaMismatchError: A plugin is already using the "tags" or "taggings" tables, and the structure of the table does not match the structure expected by redmine_knowledgebase. /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:76:in assert_schema_match!' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:64:inok_to_go_up?' /opt/redmine/.rvm/gems/ruby-2.2.1/bundler/gems/redmine_acts_as_taggable_on-a939baeb9fe2/lib/redmine_acts_as_taggable_on/migration.rb:15:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:611:inexec_migration' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:592:in block (2 levels) in migrate' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/benchmark.rb:288:inmeasure' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:591:in block in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:inwith_connection' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:590:in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:768:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:998:in block in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:1046:inddl_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:997:in execute_migration_in_transaction' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:959:inblock in migrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:955:inmigrate' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:823:in up' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/activerecord-4.2.5/lib/active_record/migration.rb:801:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:481:in migrate_plugin' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:453:inmigrate' /opt/redmine/redmine-3.2/lib/redmine/plugin.rb:464:in migrate' /opt/redmine/redmine-3.2/lib/tasks/redmine.rake:127:inblock (3 levels) in <top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:in call' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:240:inblock in execute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:235:inexecute' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:179:in block in invoke_with_call_chain' /opt/redmine/.rvm/rubies/ruby-2.2.1/lib/ruby/2.2.0/monitor.rb:211:inmon_synchronize' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:172:in invoke_with_call_chain' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/task.rb:165:ininvoke' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:150:in invoke_task' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock (2 levels) in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:in each' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:106:inblock in top_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:115:in run_with_threads' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:100:intop_level' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:78:in block in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:176:instandard_exception_handling' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/lib/rake/application.rb:75:in run' /opt/redmine/.rvm/gems/ruby-2.2.1/gems/rake-10.5.0/bin/rake:33:in<top (required)>' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in load' /opt/redmine/.rvm/gems/ruby-2.2.1/bin/rake:23:in
' Tasks: TOP => redmine:plugins:migrate

scott-mackenzie avatar Jun 26 '16 20:06 scott-mackenzie

Okay, I haven't written any solution back then.

Solution: The error message shows what's going wrong in detail: it misses needed columns in the DB. Add those columns (as nullable) and it will work fine! (just have a look what table-structure is needed). I haven't had any interoperability problems between any plugins since then. Just add the missing columns to that table and it will work fine. I've done that by logging into the mysql DB as a client and added those with sql-statements ("ALTER TABLE....").

Additional Architecture Thoughts: Ad adding naming-conventions: after thinking 'bout that back then I'm not a fan of this solution because with having Tags within one table gives you the ability to search within one table for all tagged content (if this feature will be implemented anyways). Adding naming-conventions would force such a "seach-plugin" to select over multiple tables within this DB - so one "search-plugin" need to know all tag tables, which furthermore would recude it's scalability.

But it would be fine if the migration-script will take advantage of that - THIS defect should be solved. Which brings me to the issue: there should be one central tagging-module which the knowledgebase should depend on.

rheggen avatar Jun 26 '16 21:06 rheggen

same issue here

bluenevus avatar Sep 05 '16 20:09 bluenevus

Have you fixed it, bluenevus? You have to alter the affected table (there should be some columns missing) and everything should work fine

rheggen avatar Sep 06 '16 04:09 rheggen

So what I did was go into mysql Add a column called context Made it varchar 256 characters And it worked. Not sure why that column didn’t migrate on db:migrate but it worked

Vr, Frank

From: UncleBen96 [mailto:[email protected]] Sent: Tuesday, September 6, 2016 12:33 AM To: alexbevi/redmine_knowledgebase [email protected] Cc: Frank Tucker [email protected]; Comment [email protected] Subject: Re: [alexbevi/redmine_knowledgebase] Tag-Table already in use (#320)

Have you fixed it, bluenevus? You have to alter the affected table (there should be some columns missing) and everything should work fine

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/alexbevi/redmine_knowledgebase/issues/320#issuecomment-244847509, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ADgTox1ntr8no1ObO7SJwszKORqMywYTks5qnOzygaJpZM4Hh8bH.

bluenevus avatar Sep 06 '16 11:09 bluenevus

I’m having other problems. Its just missing a lot of tables. Everytime I put in a field or table manually, another one is missing. Uninstall e.g. bundle exec rake redmine:plugins:migrate NAME=plugin_name VERSION=0 RAILS_ENV=production and that errors out after it removes a few columns. So I delete the plugin completely and get a 500 error after restarting redmine. Then I reinstall the plugin, it errors out after adding a few columns. However, redmine doesn’t give me the 500 error but knowledgebase doesn’t work. I can add categories…just cant add an article because of missing tables. Can’t install them because they error out.

Any ideas?

Vr, Frank

From: UncleBen96 [mailto:[email protected]] Sent: Tuesday, September 6, 2016 12:33 AM To: alexbevi/redmine_knowledgebase [email protected] Cc: Frank Tucker [email protected]; Comment [email protected] Subject: Re: [alexbevi/redmine_knowledgebase] Tag-Table already in use (#320)

Have you fixed it, bluenevus? You have to alter the affected table (there should be some columns missing) and everything should work fine

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/alexbevi/redmine_knowledgebase/issues/320#issuecomment-244847509, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ADgTox1ntr8no1ObO7SJwszKORqMywYTks5qnOzygaJpZM4Hh8bH.

bluenevus avatar Sep 06 '16 18:09 bluenevus

Have you added "tagger_id" and "context" with the appropriate types and as nullable to the table? For me that worked fine (having a redmine installation with running knowledgebase plugin)

rheggen avatar Sep 07 '16 05:09 rheggen

Completed 500 Internal Server Error in 15ms (ActiveRecord: 2.6ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Table 'redmine_production.viewings' doesn't exist: SHOW FULL FIELDS FROM viewings): plugins/redmine_knowledgebase/lib/acts_as_viewed.rb:179:in viewed_by?' plugins/redmine_knowledgebase/lib/acts_as_viewed.rb:157:inblock in view' plugins/redmine_knowledgebase/lib/acts_as_viewed.rb:156:in view' plugins/redmine_knowledgebase/app/controllers/articles_controller.rb:88:inshow' lib/redmine/sudo_mode.rb:63:in `sudo_mode'

Vr, Frank

From: UncleBen96 [mailto:[email protected]] Sent: Wednesday, September 7, 2016 1:33 AM To: alexbevi/redmine_knowledgebase [email protected] Cc: Frank Tucker [email protected]; Comment [email protected] Subject: Re: [alexbevi/redmine_knowledgebase] Tag-Table already in use (#320)

Have you added "tagger_id" and "context" with the appropriate types and as nullable to the table? For me that worked fine (having a redmine installation with running knowledgebase plugin)

— You are receiving this because you commented. Reply to this email directly, view it on GitHubhttps://github.com/alexbevi/redmine_knowledgebase/issues/320#issuecomment-245179585, or mute the threadhttps://github.com/notifications/unsubscribe-auth/ADgTo1tUYioMfaUwW_NRlNys350EKpofks5qnkyIgaJpZM4Hh8bH.

bluenevus avatar Sep 07 '16 12:09 bluenevus

Same problem here bur solved with @bluenevus solutions. Add a "context" column Varchar(256) to "taggings" table and it seem work... but then when add an article... Error 500

aledelgo avatar Nov 18 '16 10:11 aledelgo

try it

  • Execute the following sql
DROP TABLE `taggings`;
DROP TABLE `tags`;

CREATE TABLE `taggings` (`id` int(11) auto_increment PRIMARY KEY, `tag_id` int(11), `taggable_id` int(11), `taggable_type` varchar(255), `tagger_id` int(11), `tagger_type` varchar(255), `context` varchar(128), `created_at` datetime) ENGINE=InnoDB;
CREATE TABLE `tags` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(255)) ENGINE=InnoDB;
CREATE UNIQUE INDEX `index_tags_on_name`  ON `tags` (`name`) ;
  • Install it
git clone git://github.com/alexbevi/redmine_knowledgebase.git plugins/redmine_knowledgebase
bundle install
rake redmine:plugins:migrate NAME=redmine_knowledgebase

my env

  • Redmine 3.2.5.stable

pinpikokun avatar Jun 30 '17 12:06 pinpikokun

Hello there,

@pinpikokun : I don't understand why this solution is for exactly ? Having a tagging system especially for this plugin ? (and have other plugin that also have a tagging system, like RedmineCRM plugins, on the same redmine installation) Or something else ?

Cheers,

-- Léo.

pousterlus avatar Jul 10 '17 14:07 pousterlus

This problem occurs when using Redmine_tags at the same time.

The function of Redmine_tags is expected to be incorporated into Redmine 4.1. http://www.redmine.org/issues/1448#note-115

If this problem is not solved, the knowledgebase plugin will be unavailable in Redmine 4.1 and later. (Apart from Rails 5 compatibility)

The knowledgebase plug-in has been used by many people in the last 8 years.

I hope that Redmine-core developers, Redmine-plugin developers and Redmine users will be able to cooperate and efficiently perform the necessary work.

y503unavailable avatar Sep 05 '18 14:09 y503unavailable

There is a comment over on the Redmine forums (http://www.redmine.org/issues/1448#note-125) about this that may offer a solution. We'll need to test this patch first to see if it works as expected.

alexbevi avatar Sep 09 '18 14:09 alexbevi