Redmine

and i try this solution: http://www.redmine.org/boards/2/topics/52931
but i dont know how to unset shell envinronment variable $VERSION on debian.

You can easily unset the variable with the command

unset VERSION

Hi,

I have the same problem on Debian 9.4, but my variable "VERSION" is not set.

what do you think of this stackoverflow question ? is it appropriate ?

Update: After investigations, the initial error (in step: rake db:migrate) that cause this problem seems to be in database initialization (see #23586 and issue #54308)

JL

I get the error on Debian 9.4/MariaDB:

== 28 CreateWikiPages: migrating ==============================================
-- create_table(:wiki_pages)
   -> 0.0098s
-- add_index(:wiki_pages, [:wiki_id, :title], {:name=>:wiki_pages_wiki_id_title})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:

Mysql2::Error: Specified key was too long; max key length is 767 bytes: CREATE  INDEX `wiki_pages_wiki_id_title`  ON `wiki_pages` (`wiki_id`, `title`)

Only if I create the database with:

CREATE DATABASE redmine CHARACTER SET utf8mb4;

It works fine if I create the database with:

CREATE DATABASE redmine CHARACTER SET utf8;

This worked for me #23586-8 :
nano config/initializers/ar_innodb_row_format.rb

ActiveSupport.on_load :active_record do
    module ActiveRecord::ConnectionAdapters
        class AbstractMysqlAdapter
            def create_table_with_innodb_row_format(table_name, options = {})
                table_options = options.reverse_merge(:options => 'ENGINE=InnoDB ROW_FORMAT=DYNAMIC')
                create_table_without_innodb_row_format(table_name, table_options) do |td|
                    yield td if block_given?
                end
            end
            alias_method_chain :create_table, :innodb_row_format
        end
    end
end

Changed my.conf:

nano /etc/mysql/mariadb.conf.d/50-server.cnf

Adding to it:

innodb_large_prefix = 1
innodb_file_format = barracuda
innodb_file_per_table = 1

I just found other way:

rake db:migrate RAILS_ENV=production

And it's work!

https://www.mobdro.guide/